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