classification
Title: Update built-in version of SQLite3
Type: Stage: resolved
Components: Versions: Python 3.6
process
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 - https://www.sqlite.org/releaselog/3_7_17.html

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.
Thanks
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 python.org 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 setup.py for exact details on where the build looks for SQLite files).
History
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