?
=?ISO-8859-1?Q?Gerhard_H=E4ring?=
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
pysqlite 2.2.0 released
=======================
I'm pleased to announce the availability of pysqlite 2.2.0. This is a major
release with a few new features and much refactored code for improved
robustness.
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.3 and Python 2.4 are available.
=======
CHANGES
=======
Less dependencies
=================
pysqlite 2.2.0 can now be built against any SQLite version >= 3.0.8. It will
use the transfer_bindings() API call for efficient recompiling of statements,
but it will also work when this API call is not available (SQLite versions <
3.2.2).
pysqlite no longer needs setuptools by default. The setup.py file was split
into a traditional setup.py that only uses distutils, and a extended_setup.py
with more features, that depends on setuptools.
General code improvements
=========================
Additional error checking was added in many places. This resulted from a code
review done by Neil Norwitz in the process of adding pysqlite to Python 2.5.
Thanks, Neil!
Collations
==========
pysqlite now supports collations.
See http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-and-using-collations
Bugs fixed
==========
- - Fixed bug #149 (pragma user_version crashes pysqlite).
Minor API additions
===================
- - Implemented total_changes: a new total_changes attribute of connection
objects shows how many rows were modified since the connection was opened.
- - Nonstandard, but convenient behaviour: cursor.execute* now return the Cursor
object instead of None.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFEMtbpdIO4ozGCH14RAmZHAKCbKfra2zXqwin5hit+ux/c6TxDXQCdEDad
UqdIdnq8Lz7wOOh75D+A/7U=
=RBa2
-----END PGP SIGNATURE-----
Hash: SHA1
pysqlite 2.2.0 released
=======================
I'm pleased to announce the availability of pysqlite 2.2.0. This is a major
release with a few new features and much refactored code for improved
robustness.
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.3 and Python 2.4 are available.
=======
CHANGES
=======
Less dependencies
=================
pysqlite 2.2.0 can now be built against any SQLite version >= 3.0.8. It will
use the transfer_bindings() API call for efficient recompiling of statements,
but it will also work when this API call is not available (SQLite versions <
3.2.2).
pysqlite no longer needs setuptools by default. The setup.py file was split
into a traditional setup.py that only uses distutils, and a extended_setup.py
with more features, that depends on setuptools.
General code improvements
=========================
Additional error checking was added in many places. This resulted from a code
review done by Neil Norwitz in the process of adding pysqlite to Python 2.5.
Thanks, Neil!
Collations
==========
pysqlite now supports collations.
See http://initd.org/pub/software/pysqlite/doc/usage-guide.html#creating-and-using-collations
Bugs fixed
==========
- - Fixed bug #149 (pragma user_version crashes pysqlite).
Minor API additions
===================
- - Implemented total_changes: a new total_changes attribute of connection
objects shows how many rows were modified since the connection was opened.
- - Nonstandard, but convenient behaviour: cursor.execute* now return the Cursor
object instead of None.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFEMtbpdIO4ozGCH14RAmZHAKCbKfra2zXqwin5hit+ux/c6TxDXQCdEDad
UqdIdnq8Lz7wOOh75D+A/7U=
=RBa2
-----END PGP SIGNATURE-----