GNU bug report logs - #69716
[PATCH] gnu: python-3.12: Enable loadable sqlite extensions.

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 69716 in the body.
You can then email your comments to 69716 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Felix Gruber <felgru <at> posteo.net>
To: guix-patches <at> gnu.org
Cc: Felix Gruber <felgru <at> posteo.net>
Subject: [PATCH] gnu: python-3.12: Enable loadable sqlite extensions.
Date: Sun, 10 Mar 2024 21:22:44 +0000

This change makes it possible to load sqlite extensions with

import sqlite3
con = sqlite3.connect(":memory:")
con.enable_load_extension(True)
con.load_extension(path_to_extension)

* gnu/packages/python.scm (python-3.12)[arguments]: Add
--enable-loadable-sqlite-extensions to configure-flags.

Change-Id: I4fb0a5482c96a12a71c88bc48fffc4c3abe78544
---
 gnu/packages/python.scm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/gnu/packages/python.scm b/gnu/packages/python.scm
index 12a5148cb1..e7df4d86ce 100644
--- a/gnu/packages/python.scm
+++ b/gnu/packages/python.scm
@@ -633,6 +633,7 @@ (define-public python-3.12
                                "--with-computed-gotos" ;main interpreter loop optimization
                                "--enable-unicode=ucs4"
                                "--without-static-libpython"
+                               "--enable-loadable-sqlite-extensions"
 
                                ;; FIXME: These flags makes Python significantly faster,
                                ;; but leads to non-reproducible binaries.

base-commit: c7836393be4d134861d652b2fcf09cf4e68275ca
-- 
2.43.0

Message #8 received at 69716 <at> debbugs.gnu.org (full text, mbox):

From: Lars-Dominik Braun <lars <at> 6xq.net>
To: Felix Gruber <felgru <at> posteo.net>
Cc: 69716 <at> debbugs.gnu.org, Munyoki Kilyungi <me <at> bonfacemunyoki.com>,
 Sharlatan Hellseher <sharlatanus <at> gmail.com>, jgart <jgart <at> dismail.de>,
 Marius Bakke <marius <at> gnu.org>
Subject: Re: [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite
 extensions.
Date: Sat, 30 Mar 2024 17:10:18 +0100

Hi,

> This change makes it possible to load sqlite extensions with

what is the use-case for this? Do we have any loadable extensions for
SQLite packaged?

Lars

Message #11 received at 69716 <at> debbugs.gnu.org (full text, mbox):

From: Felix Gruber <felgru <at> posteo.net>
To: Lars-Dominik Braun <lars <at> 6xq.net>
Cc: 69716 <at> debbugs.gnu.org, Munyoki Kilyungi <me <at> bonfacemunyoki.com>,
 Sharlatan Hellseher <sharlatanus <at> gmail.com>, jgart <jgart <at> dismail.de>,
 Marius Bakke <marius <at> gnu.org>
Subject: Re: [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite
 extensions.
Date: Sat, 30 Mar 2024 22:16:06 +0000

Hi Lars,

On 3/30/24 5:10 PM, Lars-Dominik Braun wrote:
>> This change makes it possible to load sqlite extensions with
> 
> what is the use-case for this? Do we have any loadable extensions for
> SQLite packaged?

I'm interested in loading the spatialite extension [1] for working with 
geographical data in sqlite. Spatialite is already packaged in guix 
under the name libspatialite.

[1]: https://www.gaia-gis.it/fossil/libspatialite/index

In the end, I want to use spatialite in datasette (which is also 
packaged in guix) to explore geographical datasets [2,3].

[2]: https://datasette.io/for/geospatial
[3]: https://datasette.io/tutorials/spatialite

I don't know if we have any other loadable sqlite extensions packaged in 
guix, apart from libspatialite.

Kind regards,
Felix

Message #16 received at 69716-done <at> debbugs.gnu.org (full text, mbox):

From: Lars-Dominik Braun <lars <at> 6xq.net>
To: Felix Gruber <felgru <at> posteo.net>
Cc: 69716-done <at> debbugs.gnu.org, Munyoki Kilyungi <me <at> bonfacemunyoki.com>,
 Sharlatan Hellseher <sharlatanus <at> gmail.com>, jgart <jgart <at> dismail.de>,
 Marius Bakke <marius <at> gnu.org>
Subject: Re: [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite
 extensions.
Date: Fri, 26 Apr 2024 08:53:45 +0200

Hi,

> I'm interested in loading the spatialite extension [1] for working with 
> geographical data in sqlite. Spatialite is already packaged in guix 
> under the name libspatialite.

seems to work. Pushed as 4caf26a4f5708f490c62f46ab68527f6fcc54295.

Lars

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.