maintainer-feedback requested: [Bug 297345] databases/py-sqlite3: Cannot load extensions

From: <bugzilla-noreply_at_freebsd.org>
Date: Sat, 08 Aug 2026 00:55:17 UTC
Bugzilla Automation <bugzilla@FreeBSD.org> has asked freebsd-python (Nobody)
<python@FreeBSD.org> for maintainer-feedback:
Bug 297345: databases/py-sqlite3: Cannot load extensions
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=297345



--- Description ---
I was playing with this port and I found it doesn't allow loading sqlite
extension .so files.  This is easily verifiable even without an extension by
the following snippet throwing exceptions:

    import sqlite3
    conn = sqlite3.connect(":memory:")
    conn.enable_load_extension(True)

Looking at the port I found that nothing was setting the C macro
PY_SQLITE_ENABLE_LOAD_EXTENSION.  This is normally set by the python configure
script, which gets bypassed for this port.

I was able to fix it in my own use with the attached patch.