This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

classification
Title: sqlite3 library outdated in Windows builds
Type: behavior Stage:
Components: Library (Lib), Windows Versions: Python 3.1, Python 2.6
process
Status: closed Resolution: out of date
Dependencies: Superseder:
Assigned To: Nosy List: Marko.Kohtala, brian.curtin
Priority: normal Keywords:

Created on 2010-05-28 11:24 by Marko.Kohtala, last changed 2022-04-11 14:57 by admin. This issue is now closed.

Messages (2)
msg106647 - (view) Author: Marko Kohtala (Marko.Kohtala) * Date: 2010-05-28 11:24
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.
msg106668 - (view) Author: Brian Curtin (brian.curtin) * (Python committer) Date: 2010-05-28 13:35
SQLite was upgraded to 3.6.21 about 4 months ago for 2.7 and 3.2.
History
Date User Action Args
2022-04-11 14:57:01adminsetgithub: 53088
2010-05-28 13:35:57brian.curtinsetstatus: open -> closed

nosy: + brian.curtin
messages: + msg106668

resolution: out of date
2010-05-28 11:24:06Marko.Kohtalacreate