From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Andrew Hyatt Newsgroups: gmane.emacs.devel Subject: Re: Add new sqlite extensions to allowlist Date: Tue, 07 Nov 2023 09:31:17 -0500 Message-ID: References: <469F1EC9-4A4F-4228-AC2F-AE4346E63DDD@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="20213"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Cc: emacs-devel@gnu.org To: Neo Dim Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Nov 07 15:32:21 2023 Return-path: Envelope-to: ged-emacs-devel@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1r0N7r-0004xH-El for ged-emacs-devel@m.gmane-mx.org; Tue, 07 Nov 2023 15:32:19 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1r0N75-0000i3-Ky; Tue, 07 Nov 2023 09:31:31 -0500 Original-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 1r0N6z-0000dt-JO for emacs-devel@gnu.org; Tue, 07 Nov 2023 09:31:25 -0500 Original-Received: from mail-vk1-xa30.google.com ([2607:f8b0:4864:20::a30]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1r0N6x-00012D-EC for emacs-devel@gnu.org; Tue, 07 Nov 2023 09:31:25 -0500 Original-Received: by mail-vk1-xa30.google.com with SMTP id 71dfb90a1353d-495d687b138so2218994e0c.3 for ; Tue, 07 Nov 2023 06:31:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699367479; x=1699972279; darn=gnu.org; h=content-transfer-encoding:mime-version:user-agent:message-id:date :references:in-reply-to:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to; bh=IlM34QS5BY7bDPldwA4h77uRnNhZ4aPKmQjHJqKupgQ=; b=AnEaDXB3lewwVjpuf86Q1EIHCjJaJ3nV7Ry/LdJgMYafH6Lq4DWuFmtkq62iQckUMw DMnrSKK/SkPiPS5MoxggnwRrmNwm1BCfnP984JihZZAzo/nFSya/t9MNsJzu6f5/D6+t vdY3o/ONjZBrYASkZA6A+uO07DvN/Y7jGKxbUjPiWHoXkFij1bnQs/BdQ2tcGE2/vN3/ d8ccqNUtYgVOlK+5vviF1IG9FXzZm/6PeFxToydjMm7lDFNk25H4sBVZubfqc7VNDJdt dCWD1lAz3cSWFdTCWadWd+5UYWjIcIMF0cxaYZoKthVEs4ObH+6ze8e4FE4vD2TKlmv4 o2yA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699367479; x=1699972279; h=content-transfer-encoding:mime-version:user-agent:message-id:date :references:in-reply-to:subject:cc:to:from:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=IlM34QS5BY7bDPldwA4h77uRnNhZ4aPKmQjHJqKupgQ=; b=YWasuVzf+6dTBLiIHkOM3XenFqgW8nyP7k2W4tkOzvafx/RNcsAMQk/muKMv5RY1Zn aOMcAahOmzJetMyz0xIjpG+3BrorMLT/0tvZmkPnPLtEI3RoKIwblmDL5jfxtFMbOQiI vSslbUMFrO2T1irh9qCGCdzIM9x4AQ1F/V/AY3OWLMydKReA/JbeRam2ztLJGjwFMSpE knuSbuJGjHRkVBMCzZoIenIRQu3isskR1xf3EnajO+9fcStjT6IzA5fMoi5JPjlWFX/O XuW/qXa8D4HHVU7E/1HdAZAwquC3sQeXU8Kx5NFb+3B2H0/CTsvwGJ0VoZNEuuKmVfBt xpXA== X-Gm-Message-State: AOJu0YwABGJx/BG5zYarG0fCMUNYksMdtPrb8TB5Id7cqIEkNjWJLnzY DedtKUFX3PMcKOvofPwE/VH+lT13+mU= X-Google-Smtp-Source: AGHT+IE0LO22L5tgoJpuJ9/O0+A26K9Jmcxw96/fMquvJSIZ/QzNdlZCBV5gPVGPJsH4AoR/iOoTKA== X-Received: by 2002:a1f:a807:0:b0:496:b3b7:5d4c with SMTP id r7-20020a1fa807000000b00496b3b75d4cmr20518211vke.16.1699367478883; Tue, 07 Nov 2023 06:31:18 -0800 (PST) Original-Received: from ahyatt-home.fios-router.home (pool-71-183-193-81.nycmny.fios.verizon.net. [71.183.193.81]) by smtp.gmail.com with ESMTPSA id cw12-20020ad44dcc000000b00670e7ae4964sm4398240qvb.91.2023.11.07.06.31.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 07 Nov 2023 06:31:18 -0800 (PST) In-Reply-To: <469F1EC9-4A4F-4228-AC2F-AE4346E63DDD@gmail.com> (Neo Dim's message of "Mon, 6 Nov 2023 22:13:32 +0700") Received-SPF: pass client-ip=2607:f8b0:4864:20::a30; envelope-from=ahyatt@gmail.com; helo=mail-vk1-xa30.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 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, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, 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-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.devel:312311 Archived-At: =20 On 6 November 2023 22:13, Neo Dim wrote:=20 Hi. I would like to use semantic search in one (or maybe=20 couple) of my new packages for emacs. In latest emacs there is=20 sqlite support, which is great. I would like to use it with=20 https://github.com/asg017/sqlite-vss extension. I checked it=20 out and see that vector0 and vss0 not in allowlist. Can we add=20 this extensions to allowlist? And can we use full path to=20 extension when call `sqlite-load-extension`? I don=E2=80=99t think=20 that this extensions will be system-wide. Agreed! I'd also like to use those extensions. In my ekg package=20 (https://github.com/ahyatt/ekg), I basically am doing vector=20 similarity computations in elisp, from data in a sqlite db, and=20 doing everything in elisp undoubtedly slower and more expensive.=20 Having a fast way to do this would be very nice. =20=20=20=20 Best regards, Sergey Kostyaev