Release Notes: pysqlite is now 2.5 times faster for DML statements. This pays off especially for bulk-loading data. pysqlite now recognizes if the database engine has done an implicit ROLLBACK and acts accordingly. Using custom mapping and sequence types in parameters works now.
Release Notes: This release plugs a nasty memory leak and improves compatibility with pre-3.3 SQLite releases.
Release Notes: The SQLite collation API was made available. The total_changes API call was wrapped. The code was made more robust in many places by adding additional error checking.
Release Notes: More checks have been added to make executescript() and the transparent statement caching more robust. An API misuse has been fixed so that pysqlite can be used with SQLite 3.3.3 and later. The function enable_shared_cache() has been added to use the shared cache available with SQLite 3.3.
Release Notes: A lot of work has gone into this release. Transparent statement caching has been added to avoid the compilation step for the most often used SQL statements. The Connection class has convenience shortcut methods to avoid the creation of often useless Cursor objects. Text data can now be returned as bytestrings or optimized Unicode in addition to plain Unicode strings. A new super-efficient way to access resultset columns by name as well as by index has been added.
Release Notes: A problem that could lead to crashes with long timeouts has been fixed. Leaks that occurred when a BEGIN, COMMIT, or ROLLBACK failed have been fixed. A function that checks whether a string is a complete SQL statement has been added.
Release Notes: This release takes care that sqlite3_finalize is not called twice. This seems to have led to the crashes in multithreaded applications that users saw. Concurrency has been improved. pysqlite now wakes up more often in case of a busy database. Calling the constructor of the (undocumented) Cache class with insufficient parameters no longer crashes Python. Other minor fixes and clarifications in the documentation.
Release Notes: The changes for prefetching in 2.0.2 were incomplete. A check that made sense before had to be removed, otherwise fetchone()/fetchmany()/fetchall() could raise ProgrammingErrors instead of returning None or an empty list if no more rows were available. Users of pysqlite 2.0.2 should definitely upgrade.
Release Notes: This release is the first one that can be compiled on MacOS X Tiger. It also fixes a few compilation warnings under GCC 4.0. Statements are now closed earlier, so it's now possible to COMMIT after SELECT without getting errors. The superfluous type objects in the DB-API interface were removed.
Release Notes: This version fixes a possible crash related to user-defined functions or aggregates getting out of scope.