New submission from Marko Kohtala marko.koht...@gmail.com:
The Windows builds seem to come with SQLite library version 3.5.9, as seen from
sqlite3.sqlite_version. This is from 2008-May-12.
I've been using the sqlite3 module, but keep running into bugs on Windows.
Replacing the DLLs\sqlite3.dll with a newer library (sqlite is going at version
3.6.23), seems to fix those problems.
One problem was locking failures when performing a lot of changes and
committing after each change. This happens within a single script accessing the
file, apparently locking himself out. I did not want users needing to patch
installed Python, so I got around that by removing the smaller commits and
making one huge commit at end.
Now I had a problem that ANALYZE does not result in good queries. Performing
ANALYZE with newer library speeded queries significantly. I do not know how to
get around that.
On Linux I see Python 2.6 using sqlite 3.6.x versions, so I'd expect the reason
for old library on Windows can not be incompatibility.
--
components: Library (Lib), Windows
messages: 106647
nosy: Marko.Kohtala
priority: normal
severity: normal
status: open
title: sqlite3 library outdated in Windows builds
type: behavior
versions: Python 2.6, Python 3.1
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8842
___
___
Python-bugs-list mailing list
Unsubscribe:
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com