René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Build SQLite with SQLITE_ENABLE_PERCENTILE for Windows and CPython-3.15+","articleBody":"# Feature or enhancement\n\n### Proposal:\n\nFor Windows, CPython-3.15 [requires SQLite-3.53.2](https://github.com/python/cpython/blob/bd39eea0dbb9dc9ec04144f34498eb4e8cc61b32/PCbuild/get_externals.bat#L59). Since 3.51.0, the aggregate functions [median](https://sqlite.org/lang_aggfunc.html#median) and [percentile](https://sqlite.org/lang_aggfunc.html#percentile) are part of SQLite's amalgamation. I believe that this means that they are found to be mature. To have them available at run-time, SQLite needs to be built with `SQLITE_ENABLE_PERCENTILE`. Python's PCBuild activates a few built-in extensions of SQLite, but not this one yet. \nInserting `SQLITE_ENABLE_PERCENTILE` [here](https://github.com/python/cpython/blob/bd39eea0dbb9dc9ec04144f34498eb4e8cc61b32/PCbuild/sqlite3.vcxproj#L101) might be everything needed.\n\n### Has this already been discussed elsewhere?\n\nThis is a minor feature, which does not need previous discussion elsewhere\n\n### Links to previous discussion of this feature:\n\nI have not found previous discussions on this topic. \n\n[This](https://github.com/python/cpython/issues/95656) discussion is about the ability to load SQLite extension modules at run-time, which is somehow related, as it can be used as an (inconvenient) fallback.\n\nAnother fallback is to implement these statistical functions in Python and bind them to a data base connection. This works, but is slower than having them built into SQLite (76s vs. 68s in my non-repesentative query).\n\n\u003c!-- gh-linked-prs -->\n### Linked PRs\n* gh-153867\n* gh-153869\n* gh-155101\n* gh-156048\n* gh-156446\n* gh-156448\n* gh-157863\n* gh-157864\n\u003c!-- /gh-linked-prs -->\n","author":{"url":"https://github.com/WKarel","@type":"Person","name":"WKarel"},"datePublished":"2026-06-23T18:05:55Z","url":"https://github.com/python/cpython/issues/152023"}