René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Bump required SQLite version to 3.15.2","articleBody":"(Also [posted on Discord](https://discuss.python.org/t/bump-sqlite-minimum-version-requirement/27999?u=erlendaasland).)\r\n\r\nIn 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](https://sqlite.org/releaselog/3_7_15.html) (2012-12-12) or newer (commit cf0b23908cc902ac38cd83dd7ca5afdf89e1543b). That enabled us to clean up the code by getting rid of a lot of preprocessor conditionals and other version specific workarounds.\r\n\r\nFor Python 3.13 (to be released October 2024), I'll raise the version requirements to either SQLite [3.8.11.1](https://sqlite.org/releaselog/3_8_11_1.html) (2015-07-29), [3.14.2](https://sqlite.org/releaselog/3_14_2.html) (2016-09-12), or [3.15.2](https://sqlite.org/releaselog/3_15_2.html) (2016-11-28). Preferably the latter.\r\n\r\nAFAICS on [DistroWatch](https://distrowatch.com/dwres.php?resource=package-in-distro\u0026pkg=sqlite), we should be fine with any of those SQLite versions, for all major distros[^1].\r\n\r\nMajor clean-ups:\r\n- For SQlite 3.8.11.1, I can remove a lot of conditional code related to CTEs and deterministic functions.\r\n- For SQLite 3.14.2 I no longer need to implement two different variants of the trace callback.\r\n- For SQLite 3.15.2, I can remove special handling for legacy deterministic user function behaviour.\r\n\r\n\r\n[^1]: RHEL-7.9 ships with SQLite 3.7.17 but is EOL in June 2024.\r\n\r\n\u003c!-- gh-linked-prs --\u003e\r\n### Linked PRs\r\n* gh-105876\r\n* gh-129599\n* gh-129602\n\u003c!-- /gh-linked-prs --\u003e\r\n","author":{"url":"https://github.com/erlend-aasland","@type":"Person","name":"erlend-aasland"},"datePublished":"2023-06-16T21:32:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/105875/cpython/issues/105875"}