On Friday, Apr 25, 2003, at 15:05 Europe/Amsterdam, Gerhard Haering
wrote:
> May I ask how you're using SQLite? Using PySQLite or with a custom
> wrapper? Do you have any experience with asynchronous access and
> sqlite? As a PySQLite developer, I'd be interested in feedback in this
> area.

Yes, I am using PySQLite, and very happy with it. Does all I need it
to, and with no surprises. I do straightforward select/insert type
stuff, nothing fancy, and with very modest data set sizes. Typical data
size is around 3MB of plaintext which I parse and insert into the
database in one go with a Python script, and then mostly read-only
access from there onwards.

I like the fact that PySQLite is so easy to install, and from there
onwards my database is a single file that I can copy around (and
without cross-platform issues). Development is on Mac OS X, deployment
on Linux.
To date it was used as an external method in Zope, but I am considering
doing a lot more in Quixote as it fits my brain better. The vastness of
Zope can be overwhelming.

Etienne Posthumus
Amsterdam, Nederland