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