Python: enable loadable SQLite extension support

Python: enable loadable SQLite extension support

[Martin Carpenter]

Hi,

Can I please request that the Python 3 package be compiled with "
--enable-loadable-sqlite-extensions"?

I'm trying to use a Python 3 app (datasette) to load an SQLite
extension but it fails with:

AttributeError: 'sqlite3.Connection' object has no attribute
'enable_load_extension'

The Python docs say that --enable-loadable-sqlite-extensions should be
passed at build to enable this (new for 3.6) . See:

 * 
https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.enable_load_extension
 * 
https://docs.python.org/3/using/configure.html#cmdoption-enable-loadable-sqlite-extensions


The shipped sqlite3 supports extensions (".load ext.so" works).
Python's sysconfig module shows that Python 3.9.10 on Cygwin does not
have this feature enabled:

>>> import sysconfig
>>> list(filter(lambda x: 'enable' in x,
sysconfig.get_config_vars('CONFIG_ARGS')[0].split(' ')))
["'--enable-shared'", "'--enable-ipv6'"]


For comparison, Python 3.8.10 on Ubuntu 20.04:

>>> list(filter(lambda x: 'enable' in x,
sysconfig.get_config_vars('CONFIG_ARGS')[0].split(' ')))
["'--enable-shared'", "'--enable-ipv6'", "'--enable-loadable-sqlite-
extensions'"]


Equivalent issue from NixOS for reference: 
https://github.com/NixOS/nixpkgs/issues/66526


Thanks,

Martin.

Re: Python: enable loadable SQLite extension support

[Marco Atzeri]

On 28.10.2022 17:45, Martin Carpenter wrote:
> Hi,
> 
> Can I please request that the Python 3 package be compiled with "
> --enable-loadable-sqlite-extensions"?
> 
> I'm trying to use a Python 3 app (datasette) to load an SQLite
> extension but it fails with:
> 
> AttributeError: 'sqlite3.Connection' object has no attribute
> 'enable_load_extension'
> 
> The Python docs say that --enable-loadable-sqlite-extensions should be
> passed at build to enable this (new for 3.6) . See:
> 
>   *
> https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.enable_load_extension
>   *
> https://docs.python.org/3/using/configure.html#cmdoption-enable-loadable-sqlite-extensions
> 

Hi Martin,
sorry I missed your request.

next packages for 3.8, 3.9 (currently under build) and future 3.11 will
include this feature

Regards
Marco