[ANN] pysqlite 2.3.4 released

Gerhard Häring gh at ghaering.de
Tue Jun 19 16:33:55 CEST 2007

pysqlite 2.3.4 released

I'm pleased to announce the availability of pysqlite 2.3.4. This is a
bugfix release.

Go to http://pysqlite.org/ for downloads, online documentation and
reporting bugs.

What is pysqlite?

     pysqlite is a DB-API 2.0-compliant database interface for SQLite.

     SQLite is a relational database management system contained in a
     relatively small C library. It is a public domain project created
     by D. Richard Hipp.  Unlike the usual client-server paradigm, the
     SQLite engine is not a standalone process with which the program
     communicates, but is linked in and thus becomes an integral part
     of the program. The library implements most of SQL-92 standard,
     including transactions, triggers and most of complex queries.

     pysqlite makes this powerful embedded SQL engine available to
     Python programmers. It stays compatible with the Python database
     API specification 2.0 as much as possible, but also exposes most
     of SQLite's native API, so that it is for example possible to
     create user-defined SQL functions and aggregates in Python.

     If you need a relational database for your applications, or even
     small tools or helper scripts, pysqlite is often a good fit. It's
     easy to use, easy to deploy, and does not depend on any other
     Python libraries or platform libraries, except SQLite. SQLite
     itself is ported to most platforms you'd ever care about.

     It's often a good alternative to MySQL, the Microsoft JET engine
     or the MSDE, without having any of their license and deployment

pysqlite can be downloaded from http://pysqlite.org/ - Sources and
Windows binaries for Python 2.5, 2.4 and Python 2.3 are available.


- pysqlite is now easy_install-able.

- Under some circumstances it's was not possible to close the
   connection object. This happened if you still had cursor objects
   around with statements that were no longer in the cached statements
   pool. This was fixed by finalizing all statements that were created
   from the connection instead of only those that are still found in
   the connection pool.

- SQLite often does not report useful error messages when the
   stepped-on statement was not reset first. Now we make sure that's
   always the case.

- From Python core version: Patch by Tim Delany (missing DECREF). SF

- Merged missing corrections for sample code from Python core version.

- Allow the size parameter for fetchmany() for better DB-API

- Allow a static build of pysqlite using the SQLite amalgamation.
   Copy sqlite3.c and sqlite3.h into the pysqlite directory, then use

   $ python extended_setup.py build_static

   to build pysqlite.

   setuptools must be installed in order to use the extended_setup.py

- Applied patch from #184. This defers the implicit BEGINs/COMMITs and
   thus improves concurrency.

- Print a warning if somebody tries to run the pysqlite test suite
   from the pysqlite root directory and exit. In earlier versions, the
   user would get a hard to understand error message about a missing
   extension module instead.

More information about the Python-list mailing list