[Tutor] Re: Data storage, SQL?

[Alan Gauld]

> ...So,  trying to get this straight - if I were going to use SQLite,
> what would I actually download from
http://www.sqlite.org/sqlite.html
> ?

Well, I haven't usd it yet but I think you need(for Windoze)

1) The Sqllite executable OR the DLL
2) The pysqlite library to interface between Pyhon DBI
   and SQLIte

and probably
3) SQLIte Explorer for a civilised SQL IDE environment

> Also, would Gadfly be easier, being native Python?

Gadfly might be easier to accomplish the task but the
knowledge would be less transferrable IMHO

The effort of learning SQL is fairly minimal (at least
to get up to basic speed) but the benefits are immense.
I strongly recommend taking the extra time to learn SQL
and SQLite looks like a fairly easy way in - it doesn't
have power user features like Oracle, Interbase,
PostGres etc, but almost all you learn in it will
transfer to those heavier weight DBs later if you
need it.

Thanks for reminding me about SQLite Sandip, I've been
meaning to try it for ages and your post was the
incentive to download it... It looks promising and
I will probably use it for my tutorial, whenever I
get round to it!

Alan G
Author of the Learn to Program web tutor
http://www.freenetpages.co.uk/hp/alan.gauld