...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 ?
Also, would Gadfly be easier, being native Python? Regards, Liam Clarke On Sat, 12 Feb 2005 14:27:21 +0500, Sandip Bhattacharya <[EMAIL PROTECTED]> wrote: > On Fri, 11 Feb 2005 20:09:10 +1300, Liam Clarke wrote: > > > Hi, > > > > I'm looking to create a prog that will store disparate bits of info > > all linked together, i.e. address details for a person, transaction > > records, specific themes, and the ability to search by certain > > criteria, so I'm pretty sure I want a database. > > > > Can anyone recommend a useful database library for Python that's not > > too complex? > > Also, I keep hearing about SQL, would this be the best way to go? I > > don't know much about databases. > > You can take a look at sqlite > (http://www.sqlite.org/). It doesn't require a client > server setup, and offers you the same sql syntax for manipulating data on > it. > > Some amazing facts about this from the website: > > [...] > SQLite is a small C library that implements a self-contained, > embeddable, zero-configuration SQL database engine. Features include: > > * Transactions are atomic, consistent, isolated, and durable (ACID) > even after system crashes and power failures. > * Zero-configuration - no setup or administration needed. > * Implements most of SQL92. > * A complete database is stored in a single disk file. > * Database files can be freely shared between machines with > different byte orders. > * Supports databases up to 2 terabytes (2^41 bytes) in size. > * Sizes of strings and BLOBs limited only by available memory. > * Small code footprint: less than 30K lines of C code, less > than 250KB code space (gcc on i486) > * Faster than popular client/server database engines > for most common operations. > * Simple, easy to use API. > * Well-commented source code with over 95% test coverage. > * Self-contained: no external dependencies. > * Sources are in the public domain. Use for any purpose. > > The SQLite distribution comes with a standalone command-line access > program (sqlite) that can be used to administer an SQLite database and > which serves as an example of how to use the SQLite library. > > [...] > > - Sandip > > -- > Sandip Bhattacharya * Puroga Technologies * [EMAIL PROTECTED] > Work: http://www.puroga.com * Home/Blog: http://www.sandipb.net/blog > > PGP/GPG Signature: 51A4 6C57 4BC6 8C82 6A65 AE78 B1A1 2280 A129 0FF3 > > > _______________________________________________ > Tutor maillist - [email protected] > http://mail.python.org/mailman/listinfo/tutor > -- 'There is only one basic human right, and that is to do as you damn well please. And with it comes the only basic human duty, to take the consequences. _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
