From unknown Wed Jun 18 23:05:17 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#69716 <69716@debbugs.gnu.org> To: bug#69716 <69716@debbugs.gnu.org> Subject: Status: [PATCH] gnu: python-3.12: Enable loadable sqlite extensions. Reply-To: bug#69716 <69716@debbugs.gnu.org> Date: Thu, 19 Jun 2025 06:05:17 +0000 retitle 69716 [PATCH] gnu: python-3.12: Enable loadable sqlite extensions. reassign 69716 guix-patches submitter 69716 Felix Gruber severity 69716 normal tag 69716 patch thanks From debbugs-submit-bounces@debbugs.gnu.org Sun Mar 10 17:23:36 2024 Received: (at submit) by debbugs.gnu.org; 10 Mar 2024 21:23:36 +0000 Received: from localhost ([127.0.0.1]:38096 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rjQds-0005V7-Cq for submit@debbugs.gnu.org; Sun, 10 Mar 2024 17:23:36 -0400 Received: from lists.gnu.org ([209.51.188.17]:32896) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rjQdp-0005Ux-OR for submit@debbugs.gnu.org; Sun, 10 Mar 2024 17:23:34 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rjQdG-0006kh-HG for guix-patches@gnu.org; Sun, 10 Mar 2024 17:22:58 -0400 Received: from mout01.posteo.de ([185.67.36.65]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rjQdE-0005TW-F9 for guix-patches@gnu.org; Sun, 10 Mar 2024 17:22:58 -0400 Received: from submission (posteo.de [185.67.36.169]) by mout01.posteo.de (Postfix) with ESMTPS id C8407240027 for ; Sun, 10 Mar 2024 22:22:51 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1710105771; bh=RMpwpk4hL+koNw0bKVBhlbiG1J804PofVDvoWn8/654=; h=From:To:Cc:Subject:Date:Message-ID:MIME-Version: Content-Transfer-Encoding:From; b=M6G4itaDdql1HsPjHOL8sYwBIUUJnuROJQuABTiTmbXUkSYU8+StDUQxj6fuRRFH8 pII2G6mXW2s3VsICmv8Y0NfDTRBdeZZSsHaSMLfTH4c29doVyDArzqqWnlx1z1nbY/ kKnsexyGvBixcAW6TnbUCWFiefBrXza+/KjRtQ07GcPn6NxxZjAq+oj4cgBFZfO2Ui c+QB5zW+3NE0jaNtmEFne5g2Frsz610MoeorP20lZzz0E0QkLGuk2fFxvvKbMeIaeh 48eMapc7rfdWmROctOt+1hGy8f+/dig2BcccOnSQX5xUtZniRKoZCxpqEApi6oR2x/ 2NL8qEpGBwVYA== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4TtCYR0d88z6twh; Sun, 10 Mar 2024 22:22:50 +0100 (CET) From: Felix Gruber To: guix-patches@gnu.org Subject: [PATCH] gnu: python-3.12: Enable loadable sqlite extensions. Date: Sun, 10 Mar 2024 21:22:44 +0000 Message-ID: <10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net> MIME-Version: 1.0 X-Debbugs-Cc: Lars-Dominik Braun , Marius Bakke , Munyoki Kilyungi , Sharlatan Hellseher , jgart Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=185.67.36.65; envelope-from=felgru@posteo.net; helo=mout01.posteo.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.3 (-) X-Debbugs-Envelope-To: submit Cc: Felix Gruber X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.3 (--) 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 From debbugs-submit-bounces@debbugs.gnu.org Sat Mar 30 12:10:36 2024 Received: (at 69716) by debbugs.gnu.org; 30 Mar 2024 16:10:36 +0000 Received: from localhost ([127.0.0.1]:46066 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rqbHw-0008Gi-11 for submit@debbugs.gnu.org; Sat, 30 Mar 2024 12:10:36 -0400 Received: from mout-p-102.mailbox.org ([80.241.56.152]:41446) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rqbHs-0008GQ-Oo for 69716@debbugs.gnu.org; Sat, 30 Mar 2024 12:10:34 -0400 Received: from smtp2.mailbox.org (smtp2.mailbox.org [IPv6:2001:67c:2050:b231:465::2]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-p-102.mailbox.org (Postfix) with ESMTPS id 4V6Mgg1R84z9sn6; Sat, 30 Mar 2024 17:10:23 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=6xq.net; s=MBO0001; t=1711815023; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=C4kCO5I4XNjhKDkmuZyF+S4a9AskCAMxmf7OgsIv+L4=; b=vgd8SoXpTNgg+wnP9YO5/r7defyPRF1IxrHldtPOWRNBDp2CLaXLykojoptiEI6hkn4w0C liyGjNLQ7ppWoU/eoPC0UpmiyZ++1SPw+67U3v8mHBax6vNRwmX8Pkw8RBlXOJ07aFaxz0 st80WiRzJ9mKefcHWEDt7qsVMazaIIpeWiKYkl8Xtxz9JHftns0lCrnJtqjVbzPypvDD7p mUAcuLi4AiWZgi6jIpaBmVkp03bC6SvxS8/YACDbVlDi05r0xWvOHC04qVFjjfexxZfysZ +FgigjcEv3jxbPmEGqrEqS5DXRLHKyMnj90/KPGFEUjO5gf5XXzL3ox+qiQVVA== Date: Sat, 30 Mar 2024 17:10:18 +0100 From: Lars-Dominik Braun To: Felix Gruber Subject: Re: [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions. Message-ID: References: <10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net> X-Rspamd-Queue-Id: 4V6Mgg1R84z9sn6 X-Spam-Score: -0.7 (/) X-Debbugs-Envelope-To: 69716 Cc: 69716@debbugs.gnu.org, Munyoki Kilyungi , Sharlatan Hellseher , jgart , Marius Bakke X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) 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 From debbugs-submit-bounces@debbugs.gnu.org Sat Mar 30 18:16:27 2024 Received: (at 69716) by debbugs.gnu.org; 30 Mar 2024 22:16:27 +0000 Received: from localhost ([127.0.0.1]:46278 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rqgzz-00020p-4M for submit@debbugs.gnu.org; Sat, 30 Mar 2024 18:16:27 -0400 Received: from mout01.posteo.de ([185.67.36.65]:57911) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rqgzv-00020a-O9 for 69716@debbugs.gnu.org; Sat, 30 Mar 2024 18:16:25 -0400 Received: from submission (posteo.de [185.67.36.169]) by mout01.posteo.de (Postfix) with ESMTPS id F18F5240027 for <69716@debbugs.gnu.org>; Sat, 30 Mar 2024 23:16:15 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1711836976; bh=ixSHg3ekV5fr21PNBbl2LEc0ygwM/7yZtPOCG3Wqd5w=; h=Message-ID:Date:MIME-Version:Subject:To:Cc:From:Content-Type: Content-Transfer-Encoding:From; b=PcchiXvb57gSM5n+RJGUX6jRpDndWqJNwjn6+87sxkHrDo8NOtAEKyvIAVOeQXB3a +tvmJOExI+B3PAtg2mXduMAAnZSF3Hk8dbVnInDRu60mWUwox6imofEUbo1dOJ6vvC h+HoMqUJzVukx8G3hk6Yx0ddUb4yWlhV0rJszkdwGDX/NCQxgOk0rZBuFtf512nBTn I7SklmiSA7afM9yZSZzXOCBhEdZS3myRrzW71b5UB0T5Lh/gtU3fb/iNbbcy77tCJz 9EuGBpMADYSNY+z+m5WTqQ2mDXOnGo5iGqqCcw4kWss4BuyIhn3ZpFFCcSS7HRAQDg 46HQEuBqKyV+A== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4V6Wnp390sz9rxB; Sat, 30 Mar 2024 23:16:14 +0100 (CET) Message-ID: Date: Sat, 30 Mar 2024 22:16:06 +0000 MIME-Version: 1.0 Subject: Re: [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions. To: Lars-Dominik Braun References: <10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net> Content-Language: en-US From: Felix Gruber In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 69716 Cc: 69716@debbugs.gnu.org, Munyoki Kilyungi , Sharlatan Hellseher , jgart , Marius Bakke X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) 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 From debbugs-submit-bounces@debbugs.gnu.org Fri Apr 26 02:54:20 2024 Received: (at 69716-done) by debbugs.gnu.org; 26 Apr 2024 06:54:21 +0000 Received: from localhost ([127.0.0.1]:33666 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1s0FTO-0000Xk-6T for submit@debbugs.gnu.org; Fri, 26 Apr 2024 02:54:20 -0400 Received: from mout-p-201.mailbox.org ([2001:67c:2050:0:465::201]:43036) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1s0FTK-0000Vj-4Q for 69716-done@debbugs.gnu.org; Fri, 26 Apr 2024 02:54:16 -0400 Received: from smtp1.mailbox.org (smtp1.mailbox.org [10.196.197.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-p-201.mailbox.org (Postfix) with ESMTPS id 4VQk303jYPz9sQH; Fri, 26 Apr 2024 08:53:48 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=6xq.net; s=MBO0001; t=1714114428; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=/6r2um0klA+vEQkbdAPeiXJsI0m3f+Ji+6u45+gCrF4=; b=j3dOSRLndVlML3fDwNs6dqmsaQFbgAv60DptKljwIn4arO7k0LsV+6fb8zwvYMiibWtPDC 3Jfs9Us0qvkt/FHwazoRku96BLXqco1RJVAhse7mktp1XevNs8SmeMXe7Z+XZqtX3mtQ8E MDhRrTdEHOB67qPKc7bLMZOe6JDNKmYB8uN0Wms4dhrjRc5Y6wAT/NZKhaX9Oyj4kiekZs ew1PAm0bvFLEWYV++6X6nN9RbTQxc7coyvzoVzVFbvR8jxPtoWQjmWyvGXUVDAKZ4ovcEd xuF7cVdaYlcH4lvxwPtUZrcEZQOD7P58Wzk95rpe8YruLmPLPaovKIaWQi8AOQ== Date: Fri, 26 Apr 2024 08:53:45 +0200 From: Lars-Dominik Braun To: Felix Gruber Subject: Re: [bug#69716] [PATCH] gnu: python-3.12: Enable loadable sqlite extensions. Message-ID: References: <10bb4eeb00197f5f02a1d88368e004ba17541612.1710105764.git.felgru@posteo.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Spam-Score: -0.7 (/) X-Debbugs-Envelope-To: 69716-done Cc: 69716-done@debbugs.gnu.org, Munyoki Kilyungi , Sharlatan Hellseher , jgart , Marius Bakke X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) 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 From unknown Wed Jun 18 23:05:17 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Fri, 24 May 2024 11:24:05 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator