https://github.com/python/cpython/commit/20e6c2fc7c174342214d561845419c4030f8638f
commit: 20e6c2fc7c174342214d561845419c4030f8638f
branch: main
author: Stan Ulbrych <[email protected]>
committer: StanFromIreland <[email protected]>
date: 2026-08-19T10:44:02+01:00
summary:
gh-152023: Update Android and Windows builds to SQLite 3.53.4 (#155101)
files:
A Misc/NEWS.d/next/Build/2026-08-02-12-00-01.gh-issue-152023.pT7dKb.rst
A Misc/NEWS.d/next/Windows/2026-08-02-12-00-00.gh-issue-152023.wXn4Qs.rst
M Misc/externals.spdx.json
M PCbuild/get_externals.bat
M PCbuild/python.props
M PCbuild/readme.txt
M PCbuild/sqlite3.vcxproj
M Platforms/Android/__main__.py
diff --git
a/Misc/NEWS.d/next/Build/2026-08-02-12-00-01.gh-issue-152023.pT7dKb.rst
b/Misc/NEWS.d/next/Build/2026-08-02-12-00-01.gh-issue-152023.pT7dKb.rst
new file mode 100644
index 000000000000000..4d81c66d163a7c2
--- /dev/null
+++ b/Misc/NEWS.d/next/Build/2026-08-02-12-00-01.gh-issue-152023.pT7dKb.rst
@@ -0,0 +1,2 @@
+Update Android builds to SQLite 3.53.4. Additionally, enable the ``median()``
+and ``percentile()`` functions.
diff --git
a/Misc/NEWS.d/next/Windows/2026-08-02-12-00-00.gh-issue-152023.wXn4Qs.rst
b/Misc/NEWS.d/next/Windows/2026-08-02-12-00-00.gh-issue-152023.wXn4Qs.rst
new file mode 100644
index 000000000000000..9e12f2d22173f56
--- /dev/null
+++ b/Misc/NEWS.d/next/Windows/2026-08-02-12-00-00.gh-issue-152023.wXn4Qs.rst
@@ -0,0 +1,2 @@
+Update Windows builds to SQLite 3.53.4. Additionally, enable the ``median()``
+and ``percentile()`` functions.
diff --git a/Misc/externals.spdx.json b/Misc/externals.spdx.json
index cdacaf6f5869531..0e1d7aeca16bf9a 100644
--- a/Misc/externals.spdx.json
+++ b/Misc/externals.spdx.json
@@ -91,21 +91,21 @@
"checksums": [
{
"algorithm": "SHA256",
- "checksumValue":
"53f8711811090cc4d9ffc624c360f81e7b409763b145ab2e948998f1a0d6a612"
+ "checksumValue":
"acc27a72ca7745781bb902269370303e778736a090585cc13acd2ea9ab785666"
}
],
- "downloadLocation":
"https://github.com/python/cpython-source-deps/archive/refs/tags/sqlite-3.53.2.0.tar.gz";,
+ "downloadLocation":
"https://github.com/python/cpython-source-deps/archive/refs/tags/sqlite-3.53.4.0.tar.gz";,
"externalRefs": [
{
"referenceCategory": "SECURITY",
- "referenceLocator": "cpe:2.3:a:sqlite:sqlite:3.53.2.0:*:*:*:*:*:*:*",
+ "referenceLocator": "cpe:2.3:a:sqlite:sqlite:3.53.4.0:*:*:*:*:*:*:*",
"referenceType": "cpe23Type"
}
],
"licenseConcluded": "NOASSERTION",
"name": "sqlite",
"primaryPackagePurpose": "SOURCE",
- "versionInfo": "3.53.2.0"
+ "versionInfo": "3.53.4.0"
},
{
"SPDXID": "SPDXRef-PACKAGE-tcl",
diff --git a/PCbuild/get_externals.bat b/PCbuild/get_externals.bat
index 6bedd21299a73e9..b2984f3de7fe52d 100644
--- a/PCbuild/get_externals.bat
+++ b/PCbuild/get_externals.bat
@@ -56,7 +56,7 @@ set libraries=%libraries%
bzip2-1.0.8
if NOT "%IncludeLibffiSrc%"=="false" set libraries=%libraries% libffi-3.4.4
if NOT "%IncludeSSLSrc%"=="false" set libraries=%libraries% openssl-3.5.7
set libraries=%libraries% mpdecimal-4.0.0
-set libraries=%libraries% sqlite-3.53.2.0
+set libraries=%libraries% sqlite-3.53.4.0
if NOT "%IncludeTkinterSrc%"=="false" set libraries=%libraries% tcl-9.0.4.0
if NOT "%IncludeTkinterSrc%"=="false" set libraries=%libraries% tk-9.0.4.1
set libraries=%libraries% xz-5.8.1.1
diff --git a/PCbuild/python.props b/PCbuild/python.props
index 8d931bba28a389a..ee9aff599c753f4 100644
--- a/PCbuild/python.props
+++ b/PCbuild/python.props
@@ -98,7 +98,7 @@
<Import Project="$(ExternalProps)" Condition="$(ExternalProps) != '' and
Exists('$(ExternalProps)')" />
<PropertyGroup>
- <sqlite3Dir Condition="$(sqlite3Dir) ==
''">$(ExternalsDir)sqlite-3.53.2.0\</sqlite3Dir>
+ <sqlite3Dir Condition="$(sqlite3Dir) ==
''">$(ExternalsDir)sqlite-3.53.4.0\</sqlite3Dir>
<bz2Dir Condition="$(bz2Dir) == ''">$(ExternalsDir)bzip2-1.0.8\</bz2Dir>
<lzmaDir Condition="$(lzmaDir) == ''">$(ExternalsDir)xz-5.8.1.1\</lzmaDir>
<libffiDir Condition="$(libffiDir) ==
''">$(ExternalsDir)libffi-3.4.4\</libffiDir>
diff --git a/PCbuild/readme.txt b/PCbuild/readme.txt
index 7751bdeb1a3077b..d54c0ed3e3c6333 100644
--- a/PCbuild/readme.txt
+++ b/PCbuild/readme.txt
@@ -234,7 +234,7 @@ _ssl
again when building.
_sqlite3
- Wraps SQLite 3.53.2, which is itself built by sqlite3.vcxproj
+ Wraps SQLite 3.53.4, which is itself built by sqlite3.vcxproj
Homepage:
https://www.sqlite.org/
diff --git a/PCbuild/sqlite3.vcxproj b/PCbuild/sqlite3.vcxproj
index f12ec348b37e297..0673e03a59fc1e1 100644
--- a/PCbuild/sqlite3.vcxproj
+++ b/PCbuild/sqlite3.vcxproj
@@ -98,7 +98,7 @@
<ItemDefinitionGroup>
<ClCompile>
<AdditionalIncludeDirectories>$(sqlite3Dir);%(AdditionalIncludeDirectories)</AdditionalIncludeDirectories>
-
<PreprocessorDefinitions>SQLITE_ENABLE_MATH_FUNCTIONS;SQLITE_ENABLE_FTS4;SQLITE_ENABLE_FTS5;SQLITE_ENABLE_RTREE;SQLITE_OMIT_AUTOINIT;SQLITE_API=__declspec(dllexport);%(PreprocessorDefinitions)</PreprocessorDefinitions>
+
<PreprocessorDefinitions>SQLITE_ENABLE_MATH_FUNCTIONS;SQLITE_ENABLE_FTS4;SQLITE_ENABLE_FTS5;SQLITE_ENABLE_PERCENTILE;SQLITE_ENABLE_RTREE;SQLITE_OMIT_AUTOINIT;SQLITE_API=__declspec(dllexport);%(PreprocessorDefinitions)</PreprocessorDefinitions>
<WarningLevel>Level1</WarningLevel>
<AdditionalOptions Condition="$(PlatformToolset) ==
'ClangCL'">%(AdditionalOptions) -Wno-unused</AdditionalOptions>
</ClCompile>
diff --git a/Platforms/Android/__main__.py b/Platforms/Android/__main__.py
index 7c4bf9f390741cb..22123ef5e7fbaae 100755
--- a/Platforms/Android/__main__.py
+++ b/Platforms/Android/__main__.py
@@ -225,7 +225,7 @@ def unpack_deps(host, prefix_dir, cache_dir):
"bzip2-1.0.8-3",
"libffi-3.4.4-3",
"openssl-3.5.7-0",
- "sqlite-3.53.2-0",
+ "sqlite-3.53.4-0",
"xz-5.4.6-1",
"zstd-1.5.7-2"
]:
_______________________________________________
Python-checkins mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://mail.python.org/mailman3//lists/python-checkins.python.org
Member address: [email protected]
