[ANN] PySQLite 1.0

[Gerhard Haering]

=============================
Announcement for PySQLite 1.0
=============================

I'm pleased to announce that PySQLite has reached version 1.0 now.

What the heck is it?
  SQLite is a powerful embedded relational database engine. PySQLite makes it
available to Python developers via the Database API 2.0. If you want a
relational database, but not worry about installing a MySQL server, or
depending on a Microsoft JET engine, let alone their licensing and/or
cross-platform issues, (Py)SQLite is the solution for you.

This release features the following minor changes:

- "Fixed" bug #1039380. Now you can use subclasses of Unicode in your .execute()
  calls. It is consistent with the current API. The new API in PySQLite 2.0 will
  lose all this politically correct isinstance stuff, though.

- Added patch #989224: Build support for Darwin.

- Applied patch #992094: Don't start transaction on VACUUM or DETACH.

- Added note to docs about -DTHREADSAFE=1 being a good idea when compiling SQLite.


Future development
==================

PySQLite was built on SQLite 2.x, which is in maintenance-only mode now. The
same will go for PySQLite 1.0 from now on.

My development effort will concentrate on bringing SQLite3 to Python
developers, and creating a leightweight, DB-API conformant wrapper around it
that will have a better designed API than the old PySQLite. This API will be
more leightweight, strive for best performance, and be completely incompatible
with the old PySQLite.

At the same time, I will try to incrementally change the existing codebase, so
that it will compile against SQLite 3.x, and maybe try to convert it to the
vm-based API of SQLite instead of the callback-based one. This is for those
that have applications built around the old API.

Hamburg, 2004-10-05             Gerhard Häring