Build SQLite with SQLITE_ENABLE_PERCENTILE for Windows and CPython-3.15+

Feature or enhancement

Proposal:

For Windows, CPython-3.15 requires SQLite-3.53.2. Since 3.51.0, the aggregate functions median and 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.
Inserting SQLITE_ENABLE_PERCENTILE here might be everything needed.

Has this already been discussed elsewhere?

This is a minor feature, which does not need previous discussion elsewhere

Links to previous discussion of this feature:

I have not found previous discussions on this topic.

This 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.

Another 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).

Linked PRs

• gh-153867
• gh-153869
• gh-155101
• gh-156048
• gh-156446
• gh-156448

Commencez par PCbuild/sqlite3.vcxproj, au niveau des définitions de compilation de SQLite mentionnées dans l’issue, et examinez comment CPython active les extensions SQLite pour Windows. Vérifiez que la build Windows expose les fonctions médiane et percentile de SQLite à l’exécution, en vous appuyant sur les PRs liés pour comprendre l’implémentation et la validation actuelles.