[pysqlite] APSW 3.6.5-r1 released

Roger Binns <[email protected]> Wed, 12 Nov 2008 18:39:41 -0800
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

APSW 3.6.5-r1 is now available.  Full documentation including change
history is available at http://apsw.googlecode.com/svn/publish/index.html

APSW focuses on being a minimal layer over SQLite attempting just to
translate the complete SQLite API into Python. The documentation has a
section on the differences between APSW and pysqlite.

The major enhancement in this release is that you can safely use the
same connection in multiple threads.  (This was possible before but you
would get deadlocks in some situations and the SQLite API was changed in
3.6.5 to make it possible to retrieve errors in a threadsafe way.)

Detailed Changes - http://apsw.googlecode.com/svn/publish/changes.html

The distribution now includes a speedtest script. You can use this to
see how APSW performs relative to pysqlite, or to track performance
differences between SQLite versions. The underlying queries are derived
from SQLite?s speed test.

The statement cache was completely rewritten. It uses less memory and
scales significantly better.

It was possible to get a deadlock between the Python GIL and the SQLite
database mutex when using the same Connection across multiple threads.
Fixed by releasing the GIL in more places and added test that inspects
the source to verify GIL/mutex handling. Thanks to amicitas reporting
this as issue 31.

SQLite?s API has been extended in 3.6.5 so that errors can be retrieved
in a thread safe manner. APSW now uses this API.

As a consequence of the prior two changes it is now possible and safe to
use the same Connection across as many threads as you want concurrently.

Documentation is now done using Sphinx which was adopted by Python 2.6
and 3. This has allowed for richer documentation and more output formats
such as PDF and Windows CHM format. You can now find the documentation
online at http://apsw.googlecode.com/svn/publish/index.html or in the
doc/ subdirectory of the source or in CHM format at the download page
for offline use.

The binary distribution for Windows includes the full text search (FTS)
and Rtree extensions. See also Additional setup.py flags.

The source structure and files were reorganized to make it clearer where
things are implemented and to make automatic extraction of documentation
easier.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkkbk2gACgkQmOOfHg372QQfUACg1pN/gtqbIy81VeLWBfBHstJ8
UYMAn3VCeQ0bFijs0AK0j/30fJGgvwZv
=vpnw
-----END PGP SIGNATURE-----