Ann: apsw 3.3.10-r1 (Another Python SQLite Wrapper)

Roger Binns rogerb at rogerbinns.com
Wed Jan 17 02:22:10 CET 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

APSW 3.3.10-r1 is now available.

Home page: http://www.rogerbinns.com/apsw.html

APSW provides an SQLite 3 wrapper that provides the thinnest layer over
SQLite 3 possible. Everything you can do from the C API to SQLite 3, you
can do from Python. Although APSW looks vaguely similar to the DBAPI, it
is not compliant with that API and instead works the way SQLite 3 does.

This release must be used with SQLite 3.3.10 or above

Notable changes since the last release:

* Even more test cases (you can't have too many!)

* Augmented stack traces giving more details when errors or exceptions occur

http://www.rogerbinns.com/apsw.html#augmentedstacktraces

* String/Unicode values work correctly if they have embedded NULL
characters (ie not truncated at the NULL).

* You can load SQLite shared library extensions.

* You can write virtual tables in Python

http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
http://www.rogerbinns.com/apsw.html#VirtualTables

* You must call close() on connections. You can also call close on
cursors, but it usually isn't necessary.

* All strings are returned as unicode

* Uses the sqlite3_prepare_v2 api which means SQLITE_SCHEMA no longer
occurs except when there is a permanent error

* Added a statement cache


Differences between APSW and PySqlite:

http://www.rogerbinns.com/apsw.html#pysqlitediffs

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

iD8DBQFFrXpCmOOfHg372QQRAmtsAJkBm7K1BFtojpe4AJRfIB94tniY6gCfRIrB
3q2yq/nkmJNcDCb8wcCPpSg=
=Su+i
-----END PGP SIGNATURE-----


More information about the Python-announce-list mailing list