Repository navigation
Enable sqlite extensions in the Windows build #95656
Copy link
Copy link
Closed
Labels
OS-windowstopic-sqlite3type-bugAn unexpected behavior, bug, or errorAn unexpected behavior, bug, or error
Description
Activity
- addedtype-featureA feature request or enhancementA feature request or enhancement
on Aug 4, 2022 +1
I'll create a patch.
As I said on Discourse, I'd like to make it possible to enable extension loading via
sqlite3_db_config(), but that is out of scope for this issue.- linked a pull request that will close this issuegh-95656: Enable the sqlite3 load extension API in Windows build #95662
on Aug 4, 2022 - addedtype-bugAn unexpected behavior, bug, or errorAn unexpected behavior, bug, or errorand removedtype-featureA feature request or enhancementA feature request or enhancement
on Aug 4, 2022 Repeating #95662 (comment):
Aha... no backport to 3.10 is needed. I changed the
#ifdefguard in 3.11, while Christian and I were updatingconfigure.ac. So... this means I broke this for Windows builds in 3.11.FTR, broken in gh-29434.
- added a commit that references this issue
on Aug 4, 2022 lol, I'd forgotten that by installing 3.11b5, it was now my default, so when I checked and it wasn't working I assumed that was normal, rather than a 3.11 regression.
Thanks for fixing it, and sorry for misreporting it!
Reacted by Erlend E. Aasland
Metadata
Metadata
Assignees
Labels
OS-windowstopic-sqlite3type-bugAn unexpected behavior, bug, or errorAn unexpected behavior, bug, or error
Projects
- StatusShow more project fieldsDone
Feature or enhancement
Enable SQLite extension loading in the Windows build (in the sqlite DLL shipped with Python, and in the stdlib sqlite3 module).
Pitch
At the moment, sqlite extensions are disabled at compile time - see the note in the docs. On Windows, though:
So the reasons for not enabling extension loading don't really apply there, and conversely, people who want to use extensions cannot do so without limiting themselves to custom Python builds.
Previous discussion
See https://discuss.python.org/t/should-we-audit-enabling-loading-of-sqlite3-extensions-shared-libraries/8124/9