Issue 33172: Update built-in version of SQLite3 (original) (raw)

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

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).