my new project, is this the right way?

[HoneyMonster]

On Mon, 14 Nov 2011 21:55:43 +1100, Chris Angelico wrote:

> On Mon, Nov 14, 2011 at 9:41 PM, Tracubik <affdfsdfdsfsd at b.com> wrote:
>> Hi all,
>> i'm developing a new program.
>> Mission: learn a bit of database management
> 
> If your goal is to learn about databasing, then I strongly recommend a
> real database engine.
> 
>> 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)
> 
> The complexity, in most cases, is a direct consequence of the job at
> hand. I recommend PostgreSQL generally, although I've never used it with
> Python and can't speak for the quality of the APIs.
> 
> The most important thing to consider is a separation of the back end
> (the "guts") from the front end (the "interface"). Since your goal is to
> explore databases, the guts of your code will basically just be working
> with the database (no heavy computation or anything). Make sure you can
> work with that, separately from your GUI. You may find it easier to
> dispense with GTK and just work through the console; you can always
> change later to make a pretty window.
> 
> If you've never worked with databases before, it may be best to skip
> Python altogether and explore the fundamentals of relational database
> engines. There's plenty of excellent tutorials on the web. Get to know
> how things are done generally, and you'll be able to figure out how
> things are done in Python.

I agree that given "Mission: learn a bit of database management", Python 
is not really relevant at this stage. I also entirely concur with your 
recommendation of PostgreSQL.

Just for information, PostgreSQL works very well indeed with Psycopg (a 
PostgreSQL adapter for Python), but for learning purposes straightforward 
PSQL is best to start with.