Message ID | 10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net |
---|---|
State | New |
Headers | show |
Series | [bug#69716] gnu: python-3.12: Enable loadable sqlite extensions. | expand |
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
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
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
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.