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 23:46:30 +0100 Message-ID: <87v8itbu49.fsf@logand.com> References: <87cz5o6csk.fsf@bernoul.li> <87mt4swxsw.fsf@posteo.net> <875ybd7mbh.fsf@bernoul.li> <87y1nzb95o.fsf@posteo.net> <87y1nq5pkz.fsf@posteo.net> <871qlhdefq.fsf@logand.com> <875yatn70c.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="33754"; mail-complaints-to="usenet@ciao.gmane.io" Cc: Lynn Winebarger , emacs-devel@gnu.org To: Philip Kaludercic Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Mar 21 23:47:27 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 1peklK-0008ag-Nx for ged-emacs-devel@m.gmane-mx.org; Tue, 21 Mar 2023 23:47:26 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pekkc-0001Br-8G; Tue, 21 Mar 2023 18:46:43 -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 1pekkW-0001Bc-L6 for emacs-devel@gnu.org; Tue, 21 Mar 2023 18:46:37 -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 1pekkV-0007iP-4v for emacs-devel@gnu.org; Tue, 21 Mar 2023 18:46:36 -0400 Original-Received: by logand.com (Postfix, from userid 1001) id C90CB19E638; Tue, 21 Mar 2023 23:46:31 +0100 (CET) X-Mailer: emacs 28.1 (via feedmail 11-beta-1 I) In-Reply-To: <875yatn70c.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:304686 Archived-At: On Tue 21 Mar 2023 at 21:12, Philip Kaludercic wrote: >>> To me the >>> advantage of something like `rx' is that I can insert comments and make >>> use of regular indentation. >> >> Those are cosmetic advantages. >> There are more profound advatages. > > In what way profound? For example, the Lisp environment provides many tools that understand and help with lisp code (jumping, help, autodoc, compilation, warnings, errors debugging etc). With strings, one cannot take advantage of any those. Another: making sure that things have the right structure, make sense to some extent and output is properly escaped. It is also much easier to process or transform such cons tree than process or transform a string with some kind of syntax. > Tomas Hlavaty writes: >> 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 > > I was under the impression that Lynn was advocating for avoiding the > usage any strings. In general this is nice and I'd use it if built-in, > but seeing as SQL is more readable than regular expressions I am not > under the impression that there is the same need for it. The point is that it is better to use an sexp based syntax than string based syntax in both cases, for sql and for regular expressions. This is a general idea, one can apply it to html, css, xml, pdf, docx, xlsx, ooxml etc. anywhere where one needs to output some kind of arbitrary (non-sexp based) syntax. The fact that in the end a string is passed to sqlite is not interesting. Interesting is that one writes sql not by concatenating strings but by building cons trees, similar to what one does when writing lisp code.