Description

erlend-aasland

opened on Jun 16, 2023

Issue body actions

(Also posted on Discord.)

In January 2021 (mid 3.10 development), Sergey Fodoseev and I raised the compile time (and runtime) SQLite version requirements for the sqlite3 standard library extension module to SQLite 3.7.15 (2012-12-12) or newer (commit cf0b239). That enabled us to clean up the code by getting rid of a lot of preprocessor conditionals and other version specific workarounds.

For Python 3.13 (to be released October 2024), I'll raise the version requirements to either SQLite 3.8.11.1 (2015-07-29), 3.14.2 (2016-09-12), or 3.15.2 (2016-11-28). Preferably the latter.

AFAICS on DistroWatch, we should be fine with any of those SQLite versions, for all major distros¹.

Major clean-ups:

• For SQlite 3.8.11.1, I can remove a lot of conditional code related to CTEs and deterministic functions.
• For SQLite 3.14.2 I no longer need to implement two different variants of the trace callback.
• For SQLite 3.15.2, I can remove special handling for legacy deterministic user function behaviour.

Linked PRs

• gh-105875: Require SQLite 3.15.2 or newer #105876
• gh-105875: amend sqlite3 docstring wrt. SQLite requirement #129599
• [3.13] gh-105875: amend sqlite3 docstring wrt. SQLite requirement (GH-129599) #129602

Footnotes

1. RHEL-7.9 ships with SQLite 3.7.17 but is EOL in June 2024. ↩

Reacted by sunmy2019 and Donghee Na

Activity

1. erlend-aasland

   added this to sqlite3 issueson May 21, 2022
2. erlend-aasland

   self-assigned this

   on Jun 16, 2023
3. erlend-aasland

   converted this from a draft issue on Jun 16, 2023
4. erlend-aasland

   added

   topic-sqlite3

   3.13only security fixesonly security fixes

   on Jun 16, 2023
5. erlend-aasland

   changed the title [-]Bump SQLite required version[/-] [+]Bump required SQLite version to 3.15.2[/+] on Jun 16, 2023
6. erlend-aasland

   added a commit that references this issue on Jun 16, 2023

   pythongh-105875: Require SQLite 3.15.2 or newer

   f1a6cd4
7. erlend-aasland

   linked a pull request that will close this issuegh-105875: Require SQLite 3.15.2 or newer #105876on Jun 16, 2023
8. corona10 commented on Jun 17, 2023

   

   corona10

   on Jun 17, 2023

   Member

   More actions

   cc @ned-deily

   Will it be okay to macOS too?
   (From my local environment it looks okay)
9. erlend-aasland commented on Jun 17, 2023

   

   erlend-aasland

   on Jun 17, 2023

   ContributorAuthor

   More actions

   Will it be okay to macOS too?

   (From my local environment it looks okay)

   We bundle SQLite for macOS installers, so it is not a problem.
10. corona10 commented on Jun 17, 2023

    

    corona10

    on Jun 17, 2023

    Member

    More actions

    We bundle SQLite for macOS installers, so it is not a problem.

    Thanks!
11. erlend-aasland

    closed this as completedin #105876on Jun 18, 2023
12. github-project-automation

    moved this from In Progress to Done in sqlite3 issueson Jun 18, 2023
13. erlend-aasland

    added a commit that references this issue on Jun 18, 2023

    gh-105875: Require SQLite 3.15.2 or newer (#105876)

    6849acb
14. vstinner

    added a commit that references this issue on Aug 29, 2023

    Document Python build requirements

    76cfe6f
15. erlend-aasland

    added 2 commits that reference this issue on Feb 2, 2025

    pythongh-105875: amend sqlite3 docstring wrt. SQLite requirement

    b69e22d

    gh-105875: amend sqlite3 docstring wrt. SQLite requirement (#129599)

    ecd2f84
16. miss-islington

    added a commit that references this issue on Feb 2, 2025

    pythongh-105875: amend sqlite3 docstring wrt. SQLite requirement (pyt…

    28afa38
17. erlend-aasland

    added a commit that references this issue on Feb 2, 2025

    [3.13] gh-105875: amend sqlite3 docstring wrt. SQLite requirement (GH…

    d75e9a0
18. srinivasreddy

    added a commit that references this issue on Feb 7, 2025

    pythongh-105875: amend sqlite3 docstring wrt. SQLite requirement (pyt…

    5b1d192

Issue actions