From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Tomas Hlavaty Newsgroups: gmane.emacs.devel Subject: Re: [NonGNU ELPA] New package: sqlite3 Date: Tue, 21 Mar 2023 22:00:56 +0100 Message-ID: <87y1npbz07.fsf@logand.com> References: <87cz5o6csk.fsf@bernoul.li> <87mt4swxsw.fsf@posteo.net> <875ybd7mbh.fsf@bernoul.li> <87y1nzb95o.fsf@posteo.net> <87y1nq5pkz.fsf@posteo.net> <87ttye5mcw.fsf@posteo.net> <87mt46nj00.fsf@posteo.net> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="31863"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Jonas Bernoulli , emacs-devel@gnu.org To: Philip Kaludercic , Lynn Winebarger Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Mar 21 22:01:56 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 1pej7D-00085V-UU for ged-emacs-devel@m.gmane-mx.org; Tue, 21 Mar 2023 22:01:55 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pej6M-00045B-UP; Tue, 21 Mar 2023 17:01:02 -0400 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 1pej6L-00044t-F7 for emacs-devel@gnu.org; Tue, 21 Mar 2023 17:01:01 -0400 Original-Received: from logand.com ([37.48.87.44]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pej6K-0004th-4D for emacs-devel@gnu.org; Tue, 21 Mar 2023 17:01:01 -0400 Original-Received: by logand.com (Postfix, from userid 1001) id 168E319E638; Tue, 21 Mar 2023 22:00:58 +0100 (CET) X-Mailer: emacs 28.1 (via feedmail 11-beta-1 I) In-Reply-To: <87mt46nj00.fsf@posteo.net> Received-SPF: pass client-ip=37.48.87.44; envelope-from=tom@logand.com; helo=logand.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-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-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.devel:304685 Archived-At: On Tue 21 Mar 2023 at 16:53, Philip Kaludercic wrote: > I really, really have no idea what you are getting at. As in "ok, but > what is your intent in explaining this?". > > Are you trying to propose that Emacs circumvents the SQLite API (that as > far as I see uses strings) by constructing statement objects manually? The idea is that one should not concatenate strings by hand but one should write the query as sexp (likely build that cons tree using quote or backquote). That cons tree should then be converted to string by a lisp function. Only after that should the string be passed to sqlite. sexp (cons tree) -> string -> sqlite