* [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions.
@ 2024-03-10 21:22 Felix Gruber
2024-03-30 16:10 ` Lars-Dominik Braun
0 siblings, 1 reply; 4+ messages in thread
From: Felix Gruber @ 2024-03-10 21:22 UTC (permalink / raw)
To: 69716
Cc: Felix Gruber, Lars-Dominik Braun, Marius Bakke, Munyoki Kilyungi,
Sharlatan Hellseher, jgart
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
^ permalink raw reply related [flat|nested] 4+ messages in thread* [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions.
2024-03-10 21:22 [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions Felix Gruber
@ 2024-03-30 16:10 ` Lars-Dominik Braun
2024-03-30 22:16 ` Felix Gruber
0 siblings, 1 reply; 4+ messages in thread
From: Lars-Dominik Braun @ 2024-03-30 16:10 UTC (permalink / raw)
To: Felix Gruber
Cc: 69716, Munyoki Kilyungi, Sharlatan Hellseher, jgart, Marius Bakke
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
^ permalink raw reply [flat|nested] 4+ messages in thread
* [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions.
2024-03-30 16:10 ` Lars-Dominik Braun
@ 2024-03-30 22:16 ` Felix Gruber
2024-04-26 6:53 ` bug#69716: " Lars-Dominik Braun
0 siblings, 1 reply; 4+ messages in thread
From: Felix Gruber @ 2024-03-30 22:16 UTC (permalink / raw)
To: Lars-Dominik Braun
Cc: 69716, Munyoki Kilyungi, Sharlatan Hellseher, jgart, Marius Bakke
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
^ permalink raw reply [flat|nested] 4+ messages in thread
* bug#69716: [PATCH] gnu: python-3.12: Enable loadable sqlite extensions.
2024-03-30 22:16 ` Felix Gruber
@ 2024-04-26 6:53 ` Lars-Dominik Braun
0 siblings, 0 replies; 4+ messages in thread
From: Lars-Dominik Braun @ 2024-04-26 6:53 UTC (permalink / raw)
To: Felix Gruber
Cc: 69716-done, Munyoki Kilyungi, Sharlatan Hellseher, jgart,
Marius Bakke
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
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2024-04-26 6:55 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2024-03-10 21:22 [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions Felix Gruber
2024-03-30 16:10 ` Lars-Dominik Braun
2024-03-30 22:16 ` Felix Gruber
2024-04-26 6:53 ` bug#69716: " Lars-Dominik Braun
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/guix.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).