[Zope-dev] SQLite as a Light DB component for Zope and Python

Mon, 01 Apr 2002 17:54:34 -0800

--Boundary_(ID_xP172gFTb7yRSax8jBGMWw)
Content-type: multipart/alternative; x-avg-checked=avg-ok-316F626F;
 boundary="Boundary_(ID_FxygewVuxsjTQWz7X60cDA)"

--Boundary_(ID_FxygewVuxsjTQWz7X60cDA)
Content-type: text/plain; x-avg-checked=avg-ok-316F626F; charset=us-ascii;
 format=flowed
Content-transfer-encoding: 7BIT

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 
<http://www.hwaci.com/sw/sqlite/index.html>SQLite: An SQL Database Engine 
In A C Library. 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, <mailto:drh@hwaci.com>D. Richard <mailto:drh@hwaci.com>Hipp, 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 supported.

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) <http://torahteacher.com/>torahteacher.com

--Boundary_(ID_FxygewVuxsjTQWz7X60cDA)
Content-type: text/html; x-avg-checked=avg-ok-316F626F; charset=us-ascii
Content-transfer-encoding: 7BIT

<html>
I have noticed on the DB lists lately some concern about the future of
Gadfly.&nbsp; I have been investigating a marvelous little open-source,
no copyright, SQL engine called
<a href="http://www.hwaci.com/sw/sqlite/index.html">SQLite: An SQL
Database Engine In A C Library</a>.&nbsp; 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).&nbsp; 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.&nbsp; I'm proposing SQLite as that
engine.&nbsp; 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, <a href="mailto:drh@hwaci.com">D. Richard
</a><a href="mailto:drh@hwaci.com">Hipp</a>, is a computer science Ph.D.
who knows his stuff.&nbsp; This is not green software, it is well
designed and tested.&nbsp; It was first released in May 2000 and is very
actively updated and supported. 
Thanks for listening. 
Bill Trenker 
Internet Applications Developer 
Kelowna, BC, Canada 
 
<x-sigsep></x-sigsep>
&quot;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.&quot; (Psalm 19:8, 1John
5:3)&nbsp;&nbsp;&nbsp;
<a href="http://torahteacher.com/">torahteacher.com 
</a></html>

--Boundary_(ID_FxygewVuxsjTQWz7X60cDA)--

--Boundary_(ID_xP172gFTb7yRSax8jBGMWw)
Content-type: text/plain; charset=us-ascii; x-avg=cert;
 x-avg-checked=avg-ok-316F626F
Content-transfer-encoding: 7BIT
Content-disposition: inline

---
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

--Boundary_(ID_xP172gFTb7yRSax8jBGMWw)--