From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Po Lu Newsgroups: gmane.emacs.devel Subject: Re: master 3d38d1d: Add sqlite3 support to Emacs Date: Sat, 11 Dec 2021 15:04:35 +0800 Message-ID: <8735mz4o70.fsf@yahoo.com> References: <20211211035614.15517.53830@vcs0.savannah.gnu.org> <20211211035616.984DD20A0A@vcs0.savannah.gnu.org> <87ee6j4ty4.fsf@yahoo.com> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="14600"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.60 (gnu/linux) Cc: Lars Ingebrigtsen , emacs-devel@gnu.org, rms@gnu.org To: Stefan Kangas Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Sat Dec 11 08:06:50 2021 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 1mvwT4-0003by-Jo for ged-emacs-devel@m.gmane-mx.org; Sat, 11 Dec 2021 08:06:50 +0100 Original-Received: from localhost ([::1]:52672 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mvwT2-0002RF-HJ for ged-emacs-devel@m.gmane-mx.org; Sat, 11 Dec 2021 02:06:48 -0500 Original-Received: from eggs.gnu.org ([209.51.188.92]:49218) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mvwR9-0001dc-BA for emacs-devel@gnu.org; Sat, 11 Dec 2021 02:04:52 -0500 Original-Received: from sonic309-22.consmr.mail.ne1.yahoo.com ([66.163.184.148]:44034) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mvwR7-0004nN-3G for emacs-devel@gnu.org; Sat, 11 Dec 2021 02:04:51 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1639206287; bh=p/BOhWYWe2L9LJbnlDlCkDihg03HjfmPTWep9wbhRcU=; h=From:To:Cc:Subject:References:Date:In-Reply-To:From:Subject:Reply-To; b=rdZWZ2G4qfpX8s2BBecVjzxlVPmhIX/0RWqZm9a0IWEeSwVXC4MtSPttFsaSs2+hvHvqf+zPM/KkEnC0Xnk2lITz0EygsOWUwnWSonaZnsjTNAZl8es6IhgfyisQKsUFGW9dhgSSKmryEPVqyu5JuziuSBslnP9tZW3KD+h6xF+uQ+B6H+gzARsUAzPP+hDCpqSYuQAXKa55ajkFFgKDT3VMHr2+ZfWWI9MWbYWT0cUoFYXr+lFx6IIk9Uv/8/AO+l+TabLIzdygBdSakHZcB87O9PGQzG7ZQA/Nqkhbm4BltMtTEuoMs5EkWrSWihdlbFecE5Oe+AdjDlCkvMFcQg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1639206287; bh=FInP5wenZzK0zSEKiBk56ICeVFKTOHKEQRt1WTPKDAe=; h=X-Sonic-MF:From:To:Subject:Date:From:Subject; b=od6fAAdG72Stm6exXN4oDHc8eoyEd+mkFpnBP348qUCA3/pupOYipUjWtqwCSF38R5bkq1vDvo8IFm2Q+6cGvzlmJFFv5FNWNhDrhH0EKTPcRXCHZ+BMaqAlNTyxi/omskGQMh+JYUR2amLd8O1+ElsoUGK727283YL8fXmukDIH0PsGVWg561ReelZ60muLMOucv5kuZVySFl9B5g2NehJS644OoEpCYUtEw4WvhpUuqqWfrIOxyHvjJJXWH5vDfbq1VwHYzqDrRK+VvUMhpWk46g55cwymXMpV27s8UTL/SFULNARDvco3L2oYEWdREgO+sNy1TDD8JTJRtFfsvw== X-YMail-OSG: Oba3in8VM1nxEEDHaz7C6Z6ExIZEYhOoyibbRQeFdstOtLJZqw0PAnYO_.1QFzy XyXYM8K6DyQUmv7A0JCOE4croGfxbb3ml7knCHjnk0HcIHXpo0eahDRm_i0C.4IGdRWlRCPyyUZj bLBgGY7JLHQ6GMNBYoobOP.WsszGkeTwr47KiylxgbRBKByx6Wyj44mmtxSRjzj7dDre67Wl88OC .kOF0itZbRbzpHTMwmfzVat8.rXYEz7g5Nx6fqisFyeE2QHAFy6LeYAw26CCJjM.sm61Rpp.k4xL oCY1QSA3OOSUglIetzJF0EHohqgrvJ3CFkALieoxLuBt7K3XLYfGXcPH6qXrJ3RxM2DEjAAvipOw P1_3c2uzPC4VI_d.5sBHlckJ.33uTzsLpIhVL2tpV09vnrjrsZvie3U.otNsWhZ69CKtG9UJugEl RC5Y6N6tRqclN_xvLVdn6hO8dEbcqK4IuN8YLT2ObEoG4GC0ZAjC8Ej2KGBHRXIryaJljYOt8He6 rwNdVwfw59iG7RMiVq6KEQlHys0I8m3QgpW4bEYFIobw6AKz7f3rlGSqQpTQkaQLUlp716BMLM1P iX.Su9cn2ub6G_XJCIn6oTf78sTqI451Jqj7Lm64wrinOeb7crYDjcLpI_RACQiBG8.SIsGWvXZQ x654OK.wmaP6PXAdGiqtyp0AQONaNxrqW.slsjG1YBMb1XFXrOyq9gzt90HJEa94mm7iDqdaE3rX zzk5Jh7RoddP0yMMdtn7lTiVZXYx.0wH5GwD3vzZmWkhq0M2_yoi0CXKJQm8DeBM_d6iNAf9lv2f 7HL.FFUWEAPjRCLCuOwnAQaJoVdm0fFsCQTASadCZk X-Sonic-MF: Original-Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.ne1.yahoo.com with HTTP; Sat, 11 Dec 2021 07:04:47 +0000 Original-Received: by kubenode507.mail-prod1.omega.sg3.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID 9204697f87b7f7d24ea8f7d49d238335; Sat, 11 Dec 2021 07:04:41 +0000 (UTC) In-Reply-To: <87ee6j4ty4.fsf@yahoo.com> (Po Lu's message of "Sat, 11 Dec 2021 13:00:19 +0800") X-Mailer: WebService/1.1.19415 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Received-SPF: pass client-ip=66.163.184.148; envelope-from=luangruo@yahoo.com; helo=sonic309-22.consmr.mail.ne1.yahoo.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, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 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" Xref: news.gmane.io gmane.emacs.devel:281654 Archived-At: Po Lu writes: > BTW, this doesn't compile on macOS. It complains that > `sqlite3_load_extension' is missing. On a different note, SQLite3 extensions are linked dynamically, and they could be proprietary software. AFAIU, the SQLite3 developers even provide a few proprietary extensions themselves, including one for database encryption. So I think we should check that the .so file passed to `sqlite-load-extension' as the `module' argument contains a GPL compatibility symbol before allowing SQLite to load it, similar to what we do with Emacs modules. RMS or someone else in the FSF might want to make sure loading SQLite modules is okay from a legal perspective as well. I don't know the details, but we had legal problems with some SQLite modules at my organization. Hope this helped, thanks.