Re: [pysqlite] sqlite 3.6.6.1

Roger Binns <[email protected]> Sun, 23 Nov 2008 00:30:34 -0800
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris Spencer wrote:
> There was a new release of sqlite yesterday (3.6.6.1), which resolves
> an issue with database corruption during rollbacks.
> 
> I was wondering if there was a plan to fast-track the next release of
> pysqlite to incorporate this new version?

You don't need pysqlite updated, just the SQLite library it uses.  On
Unix like systems, just update your SQLite installation as appropriate
and then rebuild pysqlite.

On Windows, if you were using the binaries from
http://oss.itsystementwicklung.de/download/pysqlite/2.5/2.5.0 or the
win32_fts subdirectory then you will find that they are using SQLite
3.6.2 and 3.6.1 respectively.

The SQLite bug was introduced in SQLite 3.6.4 so you won't be affected.

> I only ask because I'm now scared to use my database. :)

You'll be fine.  Did you lose sleep over all these as well?

http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption

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

iEUEARECAAYFAkkpFKcACgkQmOOfHg372QQUpACY/S3TOEOiiJtJ1OSYD4/tOeH1
4QCgyrv3phfhg7ZgU7DbWgTQmx3Lr/4=
=+zxc
-----END PGP SIGNATURE-----