[ANN] pysqlite 2.3.5 released

Gerhard Häring gh at ghaering.de
Wed Jul 18 01:32:38 CEST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

pysqlite 2.3.5 released
=======================

I'm pleased to announce the availability of pysqlite 2.3.5. 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
     issues.

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

=======
CHANGES
=======

Ticket #203: Using mappings and sequences as parameters works now
too. I hope this doesn't encourage you to actually use that
"feature". It's actually possible to build a layer on top of the
DB-API instead of cramming everything into it.

Ticket #97: We now know about implicit ROLLBACKs that the SQLite
engine issued.  Removed paragraph in docs about ON CONFLICT ROLLBACK
not working. It works now.

Performance optimizations that pay off especially for mass DML
operations (inserts, updates, deletes). Performance here is on par
with apsw now. See
http://initd.org/tracker/pysqlite/wiki/PysqliteTwoBenchmarks for a
benchmark of all pysqlite 2.x releases so far. Last two:

    pysqlite 2.3.4
    average insert time: 7.037440 seconds
    average fetch time: 3.066811 seconds
    --------------------------------------------------
    pysqlite 2.3.5
    average insert time: 2.788332 seconds
    average fetch time: 3.095180 seconds
    --------------------------------------------------

- - A Python 2.3 compatibility fix in the test suite.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGnVGWdIO4ozGCH14RAkgQAKCTcumGWSTrQn+zK59kR2RUj29ZFACfcPVB
0WBUZOhw8ett2MPw+0qlPjw=
=d+mW
-----END PGP SIGNATURE-----



More information about the Python-list mailing list