Changes between Version 36 and Version 37 of SupportedDatabaseVersions

Timestamp:

Jan 28, 2025, 8:57:52 AM (3 days ago)

Author:

Sage Abdullah

Comment:

Clarified our policy for the minimum supported SQLite version.

SupportedDatabaseVersions

@@ -3 +3 @@
 == SQLite
 
-The SQLite version that ships with the Windows and OS X installers are:
-
+The SQLite version that ships with the Windows and macOS installers are:
 * Python 3.5 - 3.8.11
 * Python 3.6 - 3.14.2
@@ -11 +10 @@
 * Python 3.9 - 3.34.0
 * Python 3.10 - 3.35.4
-
-Generally, the minimum supported SQlite version is the one that's shipped with the oldest supported Python version. For example, Django 2.1 supports Python 3.5 and later, so the minimum supported SQLite version is 3.8.11.
+* Python 3.11 - 3.45.1
+* Python 3.12 - 3.45.3
+* Python 3.13 - 3.45.3
 
 Search the [https://docs.python.org/3/whatsnew/changelog.html Python Changelog] for "SQLite" to find entries like "Update Windows build and OS X installers to use SQLite 3.14.2."
+
+To find the exact SQLite version, search for "sqlite" in the installer files for [https://github.com/python/cpython/blob/main/PCbuild/get_externals.bat Windows] and [https://github.com/python/cpython/blob/main/Mac/BuildScript/build-installer.py macOS] in the CPython repository. Use the branch/tag selector to specify the Python version.
+
+The SQLite version that ships with [https://sources.debian.org/src/sqlite3/ Debian] and [https://git.launchpad.net/ubuntu/+source/sqlite3/ Ubuntu] are:
+* Debian 11 (bullseye): 3.34.1
+* Debian 12 (bookworm): 3.40.1
+* Ubuntu 20.04 (focal): 3.31.1
+* Ubuntu 22.04 (jammy): 3.37.2
+* Ubuntu 24.04 (noble): 3.45.1
+
+Generally, Django's minimum supported SQLite version is based on the minimum of the versions found in the oldest supported Python, Debian, and Ubuntu. This usually spans a period of 5 years after the SQLite release. In addition, we also evaluate the benefits (such as new features or code cleanups) before dropping support of older SQLite versions. See [https://code.djangoproject.com/query?summary=~Drop+support+for+SQLite past tickets] for reference on how we bump our minimum supported SQLite version.
+
 
 == PostgreSQL