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-11-11 - Version 3.6.20-r1 is released. Major update is a virtual table providing access to CouchDB. Several other minor fixes mostly for the shell. Full list of changes
- 2009-10-16 - Version 3.6.19-r1 is released. An interactive shell you can use or inherit from into your own code, a fork checker, major updates to setup to be more consistent and fetch everything for you, asyncvfs integrated and many other small tweaks and fixes.
- 2009-09-12 - Version 3.6.18-r1 is released. License update (you can use any OSI license), speedtest can now do larger data and unicode, minor performance improvement.
- 2009-08-10 - Version 3.6.17-r1 is released. Updated tests, documentation and ensured Windows installer included FTS3
- 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.
- 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.
Help/Documentation
The latest documentation is at http://apsw.googlecode.com/svn/publish/index.html
Mailing lists/contacts
- Python SQLite discussion group.
- 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.
