[DB-SIG] SQLite as a Light DB component for Zope and Python
Wed, 03 Apr 2002 09:07:33 +0200
I'm working with SQLite right now, I find it a very interesting product,
SQLite is tiny, fast,
I think it is fast at least as MySQL but SQLite has TRANSACTIONS and it
easy to install,
for now it needs a python interface based on DB-SIG.
IMO SQLite is a good candidate to replace Gadflay
William Trenker wrote:
> I have noticed on the DB lists lately some concern about the future of
> Gadfly. I have been investigating a marvelous little open-source, no
> copyright, SQL engine called SQLite: An SQL Database Engine In A C
> Library <http://www.hwaci.com/sw/sqlite/index.html> . I am quite
> experienced with Python, reasonably experienced with Zope but a
> greenhorn at extending Python yet I had a crude but working Python
> extension module for SQLite up and running in 2 days (most of that
> time figuring out the Python extension conventions). I think Python
> needs a lightweight SQL engine as a standard module, and I think this
> would be a good Zope product candidate as well. I'm proposing SQLite
> as that engine. Here is the developer's feature list, taken from the
> link given above:
> Implements a large subset of SQL92.
> A complete database (with multiple tables and indices) is stored in a
> single disk file.
> Atomic commit and rollback protect data integrity.
> Small memory footprint: less than 20K lines of C code.
> Four times faster than PostgreSQL. Twice as fast as SQLite 1.0.
> Very simple C/C++ interface requires the use of only three functions
> and one opaque structure.
> TCL bindings included.
> A TCL-based test suite provides near 100% code coverage.
> Self-contained: no external dependencies.
> Built and tested under Linux and Win2K.
> Sources are uncopyrighted. Use for any purpose.
> The SQLite source code is 35% comment. These comments are another
> important source of information.
> The author, D. Richard <mailto:firstname.lastname@example.org> Hipp
> <mailto:email@example.com> , is a computer science Ph.D. who knows his
> stuff. This is not green software, it is well designed and tested.
> It was first released in May 2000 and is very actively updated and
> Thanks for listening.
> Bill Trenker
> Internet Applications Developer
> Kelowna, BC, Canada
> "The commandments of the LORD are right, bringing joy to the heart.
> The commands of the LORD are clear, giving insight to life . . . For
> this is the love of God, that we keep His commandments. And His
> commandments are not burdensome." (Psalm 19:8, 1John 5:3)
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.343 / Virus Database: 190 - Release Date: 3/22/02