Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!newsfeed.eweka.nl!eweka.nl!feeder3.eweka.nl!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Date: Sat, 26 Nov 2011 21:35:29 -0500
From: Dave Angel <d@davea.name>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.23) Gecko/20110922 Thunderbird/3.1.15
MIME-Version: 1.0
To: comp.lang.python@googlegroups.com
Subject: Re: my new project, is this the right way?
References: <4ec0f070$0$1378$4fafbaef@reader2.news.tin.it>	<581dab49-e6b0-4fea-915c-4a41fa887c3b@p7g2000pre.googlegroups.com> <11840843.114.1322350898307.JavaMail.geo-discussion-forums@prfi36>
In-Reply-To: <11840843.114.1322350898307.JavaMail.geo-discussion-forums@prfi36>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: python-list@python.org, 88888 Dihedral <dihedral88888@googlemail.com>
Precedence: list
Reply-To: d@davea.name
Newsgroups: comp.lang.python
Message-ID: <mailman.3067.1322361338.27778.python-list@python.org>
Lines: 52
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:16274

On 11/26/2011 06:41 PM, 88888 Dihedral wrote:
> On Saturday, November 26, 2011 1:01:34 AM UTC+8, rusi wrote:
>> On Nov 14, 3:41 pm, Tracubik<affdfs...@b.com>  wrote:
>>> Hi all,
>>> i'm developing a new program.
>>> Mission: learn a bit of database management
>>> Idea: create a simple, 1 window program that show me a db of movies i've
>>> seen with few (<10) fields (actors, name, year etc)
>>> technologies i'll use: python + gtk
>>> db: that's the question
>>>
>>> since i'm mostly a new-bye for as regard databases, my idea is to use
>>> sqlite at the beginning.
>>>
>>> Is that ok? any other db to start with? (pls don't say mysql or similar,
>>> they are too complex and i'll use this in a second step)
>>>
>>> is there any general tutorial of how to start developing a database? i
>>> mean a general guide to databases you can suggest to me?
>>> Thank you all
>>>
>>> MedeoTL
>>>
>>> P.s. since i have a ods sheet files (libreoffice calc), is there a way to
>>> easily convert it in a sqlite db? (maybe via csv)
>> To learn DBMS you need to learn sql
>> [Note sql is necessary but not sufficient for learning DBMS]
>> I recommend lightweight approaches to start with -- others have
>> mentioned access, libreoffice-base.
>> One more lightweight playpen is firefox plugin sqlite-manager
>>
>>> Is that ok? any other db to start with? (pls don't say mysql or similar,
>>> they are too complex and i'll use this in a second step)
>> Correct. First you must figure out how to structure data -- jargon is
>> normalization.
>> After that you can look at transactions, ACID, distribution and all
>> the other good stuff.
> If I have a fast hash library  that each hash function supports insertion and deletion and can be frozen to be stored into the file system if desired and retrieved lator . Can I use several hashes to replace a database that is slow and expensive?
>
If you're using Python, you already have a "fast hash" library, in the 
dictionary class.  And yes, if a problem doesn't need the full 
generality of a database, you may be able to implement it with 
dictionaries, and it may even be practical to store those dictionaries 
to disk for later retrieval.  However, there are quite a few reasons 
this may not be good enough.  To start with just two:   if there are 
multiple users of the database, and they have to be synched.  Or if you 
have to be safe from a program or a system crashing.

-- 

DaveA