ANN: apsw 3.3.10-r1

Roger Binns <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----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


The APSW home page, bug tracking, source code repository and
documentation will be moving to initd.org shortly which is where
pysqlite is hosted.  This will provide one location for Python bindings
to SQLite.  I will also be placing my ctypes binding on the site.

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

iD8DBQFFp0LhmOOfHg372QQRAlj6AKCv2WH2Daqa28jz8vvcwBMo2Z57QACgkOg4
vyOAwM0AOXAWV4zMenqSpPI=
=YwaN
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.