Title: Update built-in version of SQLite3
Type: Stage: resolved
Components: Versions: Python 3.6
Status: closed Resolution: third party
Dependencies: Superseder:
Assigned To: Nosy List: jonathan-lp, ned.deily
Priority: normal Keywords:

Created on 2018-03-28 15:45 by jonathan-lp, last changed 2018-03-28 16:55 by ned.deily. This issue is now closed.

Messages (2)
msg314610 - (view) Author: Jonathan (jonathan-lp) Date: 2018-03-28 15:45
The current version of SQLite (in Python 3.6) is 3.7.17 which was released almost 5 years ago -

Given that user updating of the version of SQLite used by Python is something of a pain (and the process is different across platforms (*and* different again for virtual-envs across platforms)), can the built-in version please be updated to a more recent version? This will allow usage of new SQLite features and users can benefit from a lot of performance enhancements/optimisations too.

SQLite has excellent backwards compatibility, so except for any regressions (and they run over a hundred million tests per release to keep them to a minimum), any newer version will be backwards compatible with that version.
msg314614 - (view) Author: Ned Deily (ned.deily) * (Python committer) Date: 2018-03-28 16:55
Python source releases do not include SQLite: the build process links Python with a system-supplied SQLite library or some local copy supplied by the builder, depending on the platform and the build setters.  The pre-built versions of Python for Windows and macOS downloadable from do ship with their own versions of SQLite; currently both use version 3.21.0 with Python 3.6.4.  So, depending on what platform you are on and where you obtained your Python from, you may be able to upgrade SQLite through some system package update and, if the Python in-use dynamically links to it, you would be all set.  If you build Python yourself from source, you can also build your own version of SQLite and use it (see Python's top-level for exact details on where the build looks for SQLite files).
Date User Action Args
2018-03-28 16:55:46ned.deilysetstatus: open -> closed

nosy: + ned.deily
messages: + msg314614

resolution: third party
stage: resolved
2018-03-28 15:45:10jonathan-lpcreate