From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Lynn Winebarger Newsgroups: gmane.emacs.devel Subject: built-in sqlite support in 29 - still time for changes? Date: Tue, 21 Mar 2023 09:18:16 -0400 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="5346"; mail-complaints-to="usenet@ciao.gmane.io" To: emacs-devel Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Tue Mar 21 14:19:18 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 1pebtW-0001FQ-5q for ged-emacs-devel@m.gmane-mx.org; Tue, 21 Mar 2023 14:19:18 +0100 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pebsn-0007gb-2x; Tue, 21 Mar 2023 09:18:33 -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 1pebsl-0007gQ-1o for emacs-devel@gnu.org; Tue, 21 Mar 2023 09:18:31 -0400 Original-Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1pebsj-0005n4-Ct for emacs-devel@gnu.org; Tue, 21 Mar 2023 09:18:30 -0400 Original-Received: by mail-pj1-x102e.google.com with SMTP id p13-20020a17090a284d00b0023d2e945aebso1728995pjf.0 for ; Tue, 21 Mar 2023 06:18:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1679404707; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=8gpe3pyu3m73UNKdvPsC3FZzqJjt5WAcsQkSLLNlUPE=; b=OPXqKdUgE9kG+TQ9WFGR9aeTXZ8i68U1+tdaqAsH1upM7INDkH/oJSLjhFgf+NLQfl 9FZg0Qof8BtvALbQShFUweytZrD8DOsyuzgy0K/NpfTMZxFgcv0MRLit30RqGxtBF97f os0qxY5DN3QS4uoqgguMw/59CfqNXFVMAa86ML1a72jBKoEOqB1E4jJBAyWr+3dGL5wu aROg63rQjEFon2mh65iKWVCc74DxZbZCmP0Tz1J0n4MU/bqPRX+NHAA+0fY/XsMpld8F 0/mfzGDNrS2iNp6diimDDHPql+r786YDTR8B4ix8xtFmsoiUZK6+6vMkMTS9DD5wXhNU bCFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679404707; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=8gpe3pyu3m73UNKdvPsC3FZzqJjt5WAcsQkSLLNlUPE=; b=7abLqlE3XrRNBXVOVyHgDByOjHD7KgsJOjCGV568BzeZ6iFRfqE8WT9+WDtfHYTF0p TD7Bo58tiZRYxDBzrVNULLLWvK/SIkLpZnWF9/vvyKYnatWefH7+4u0f7lLJFehvsCSe nsSJ23Z44PipJ+9U/AgoKviUmzrSPTH8djOV5PdYZ2UM3fBfbfqENr1qG8uieTJUBWBq zJimBgHwZzaIX8aUpxj4QSQD3075DJ9e0O4q1HFnzOdR9v3fKJ9RzcTEP4bPw0+9N+5b tfHBvovy6oZnJDJqGgtDxqzcquYnxAdk1N3d3wfTHFJ+JIyt9tcCyXMlTeJ4WLhFy4eA hhWw== X-Gm-Message-State: AO0yUKX8Fn8Oq68Y/A7JIsMh4ebLv7bZsgSrDpUUeF+6i/ecKSFmuYmr qFPIBoU1HBXh9nLXVXzNIKQBTAZ0M7uyu4aGz8T5cnJ7ssQ= X-Google-Smtp-Source: AK7set8itP0YVSK1Z6oy2TDeEwNVnnN7fEmRZvnklIPmWt+emzkppsdktC61ovEm2bikF2+V328TB9Oqkne7Xfiwr1k= X-Received: by 2002:a17:902:f541:b0:1a1:d106:e911 with SMTP id h1-20020a170902f54100b001a1d106e911mr858443plf.9.1679404707288; Tue, 21 Mar 2023 06:18:27 -0700 (PDT) Received-SPF: pass client-ip=2607:f8b0:4864:20::102e; envelope-from=owinebar@gmail.com; helo=mail-pj1-x102e.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 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:304646 Archived-At: I'm curious if there is time or appetite for the following changes to built-in sqlite support for emacs 29, before any code becomes dependent on the current implementation. * Can rows be returned as arrays rather than lists for consistency with emacsql programming conventions? * Can (or should) sqlite-mode be derived from tabulated list mode instead of directly from special? * Can we add at least one additional primitive type for tables (corresponding to a prepared sqlite statement) so a database connection can have multiple outstanding queries? Or have one query use the result of an existing query result? * Is the current code mature enough to document properly, or is that being delayed until the implementation is more mature? Lynn