[PATCH] gnu: python-3.12: Enable loadable sqlite extensions.

  • Done
  • quality assurance status badge
Details
2 participants
  • Felix Gruber
  • Lars-Dominik Braun
Owner
unassigned
Submitted by
Felix Gruber
Severity
normal

Debbugs page

F
F
Felix Gruber wrote on 10 Mar 14:22 -0700
(address . guix-patches@gnu.org)(name . Felix Gruber)(address . felgru@posteo.net)
10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net
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(+)

Toggle diff (16 lines)
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
L
L
Lars-Dominik Braun wrote on 30 Mar 09:10 -0700
(name . Felix Gruber)(address . felgru@posteo.net)
Zgg5alTmuHwpPI8h@noor.fritz.box
Hi,

Toggle quote (2 lines)
> 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
F
F
Felix Gruber wrote on 30 Mar 15:16 -0700
(name . Lars-Dominik Braun)(address . lars@6xq.net)
e204dd06-6c33-42c2-ba1f-97d09b7c47f3@posteo.net
Hi Lars,

On 3/30/24 5:10 PM, Lars-Dominik Braun wrote:
Toggle quote (5 lines)
>> 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.


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


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

Kind regards,
Felix
L
L
Lars-Dominik Braun wrote on 25 Apr 23:53 -0700
(name . Felix Gruber)(address . felgru@posteo.net)
ZitPeR5OgUQCCQ-J@noor.fritz.box
Hi,

Toggle quote (4 lines)
> 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
Closed
?
Your comment

This issue is archived.

To comment on this conversation send an email to 69716@patchwise.org

To respond to this issue using the mumi CLI, first switch to it
mumi current 69716
Then, you may apply the latest patchset in this issue (with sign off)
mumi am -- -s
Or, compose a reply to this issue
mumi compose
Or, send patches to this issue
mumi send-email *.patch