APSW stands for Another Python SQLite Wrapper.
About
APSW is a Python wrapper for the SQLite embedded relational database engine. In contrast to other wrappers such as pysqlite it 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.
News
- 2009-06-30 - Switched to Mercurial for source control. Still hosted here at GoogleCode.
- 2009-06-28 - Version 3.6.16-r1 is released. Trivial tweaks for compiler. Full list of changes
- 2009-06-17 - Version 3.6.15-r1 is released. Corrected return on reaching end of blob.
- 2009-05-26 - Version 3.6.14.2-r1 is released. Minor tweak.
- 2009-05-23 - Version 3.6.14.1-r1 is released. Minor tweaks.
- 2009-04-21 - Version 3.6.13-r1 is released. Added a constant plus trivial tweaks.
- 2009-02-18 - Version 3.6.11-r1 is released. Main change is support for the SQLite hot backup API.
- 2009-02-02 - Version 3.6.10-r1 is released. Various minor improvements such as context manager support (with statements).
- 2008-12-05 - Version 3.6.6.2-r1 is released. Various minor improvements.
- 2008-11-12 - Version 3.6.5-r1 is released. Major improvement is full support for using the same connection in multiple threads.
- 2008-10-10 - Version 3.6.3-r1 is released. The major improvement is support for writing your own VFS in Python.
- 2008-07-06 - Version 3.5.9-r2 is released. This release adds Python 3.0 compatibility
Help/Documentation
The latest documentation is at http://apsw.googlecode.com/svn/publish/index.html
Mailing lists/contacts
You can use the pysqlite mailing list (make sure to mention you are using apsw).
You can also email the author at rogerb@rogerbinns.com
Bugs
You can find existing and fixed bugs by clicking on Issues and using "New Ticket" to report previously unknown issues.
Downloads
Some Linux/BSD distros include APSW as a standard package (eg Debian - python-apsw, Gentoo - dev-python/apsw ). Typically they lag several versions behind both with APSW and SQLite. The APSW build instructions show how to make a single file for the extension that includes the SQLite library statically.
Click on the Downloads tab above to download source distribution, binary installers for Windows and copies of the help for offline use.
