[pysqlite] APSW 3.6.6.2-r1 released

Roger Binns <[email protected]> Fri, 05 Dec 2008 14:52:35 -0800
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

APSW 3.6.6.2-r1 is now available.  Full documentation including change
history is available at http://apsw.googlecode.com/svn/publish/index.html

The project is hosted at http://code.google.com/p/apsw/ where you will
find downloads, source control system, bug tracker etc.

There was discussion a week ago on this list about tracing SQL execution
without having to change your source.  This is now available as part of
APSW.  The documentation shows help information and sample output:

http://apsw.googlecode.com/svn/publish/execution.html#apsw-trace

Windows binary download for Python 3.0 is available.

Various changes in data structures and containers to reduce code size.

Changed the code to handle SQLite errors to only use Python
functionality and no operating system functionality (thread local
storage). This also addresses issue 36 where Vista was not binary
compatible with XP. Thanks to Rudolf Gaertner for assistance in
detecting and diagnosing this issue.

Connections, cursors and blobs can be used by weak references.

You can now install Connection wide execution and row tracers.

The callbacks for execution and row tracers have a different signature
to include the cursor the execution or row happened on. This is a
backwards incompatible change. See tracing for details.

Due to popular demand, added Cursor.fetchall(). This is a longer way of
typing list(cursor).

Added attributes to the Connection class - filename, open_flags and
open_vfs. These let you track how the database was opened.

Revert to using older SQLite APIs in order to work around SQLite ticket
2158. (This also saves a little bit of SQLite memory usage). The user
visible effect was that you could get different exceptions and error
text depending on whether a query was already in the statement cache or
if you were multi-threading. As an example, if you have a query that
used an unknown collation then SQLite’s prepare returns SQLITE_ERROR
with error text about the bad collation. If a query had already been
prepared, the collation removed and then run the new SQLite routines are
returning SQLITE_SCHEMA and generic schema changed error text. Changing
user defined functions could also cause a previously correct query to
become invalid.

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

iEYEARECAAYFAkk5sK4ACgkQmOOfHg372QRHrwCfdJRViGQCsHj4SwF0MBmqyAWp
t3UAoLTyCtwVqDTu34X5NVx2nxJ9nhWV
=erk1
-----END PGP SIGNATURE-----
_______________________________________________
list-pysqlite mailing list
[email protected]
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite