From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id qOy1GRkC6mZEDgEA62LTzQ:P1 (envelope-from ) for ; Tue, 17 Sep 2024 22:26:33 +0000 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1.migadu.com with LMTPS id qOy1GRkC6mZEDgEA62LTzQ (envelope-from ) for ; Wed, 18 Sep 2024 00:26:33 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=alphapapa.net header.s=dreamhost header.b=Fis611JH; dmarc=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; arc=pass ("mailchannels.net:s=arc-2022:i=1") ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1726611993; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=3qhKEiH/+SOe5bsIl9zHVUkElyCx41pbLK1oWHK+OJk=; b=rgNqEBHKY3dTm/Sh33WhLQQAg5o5hnF/gzpbxsD1OsoHm+qT2/upD/5bg32o/VHQCAXWBU d0LztqviEDxEayrMZ8H35MpETcvGaPu1V/yZtPIZ+xhZXsCbpH0GoNq/4ttiymzArZkdro bBiYZ/pPk+S0D9XYxmd4O7ZdSsQwKGDyHAVJTswcDBXR5pN6peQ3C7elvnUgYswx2JEhja lKhpUfU5afzyOeTgl1StFjevf88NKQzyH9ZY9/vNE4ykjo5pjGIc2JRVgsAJrBJOB20bdc f7FECva1AnaXC4c5MG4CAb7TgjovAJ6BTMl0oBMZqaQBlMOzGxMGpNrlT1pyiQ== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1726611993; a=rsa-sha256; cv=pass; b=fN3WbOBXcIMKAItYSQ69cDtOa1ZiLshjbqg/OlQ3HjKgogK9ieFOIW1pXs5pljy2lr8UUL bTpjrKiyZMRNIYNx4uwEMVyxA4KuYyg4i5hZArASQeZLJBgRt5tj/SfUNWTSTZFD1Dvw/o wpfhRQENHhwCobN2T+YsI0hc0K89FW/j6EhtbIQUyzThAZu2vT14XLBIf/sPRHWk+g8G0L mVWlKGr/a5P8CuE7hzpgzhx9sxDPhlBC+vi/qSlHZZYFd0kXYjD5fxC103VFm+6NQxnGzq NiNBOxk7KbXP4tBkVpzS/yU278sshqnakTcPp7Fyx4Un+xUpkqtrnO9Cuj4eUg== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=alphapapa.net header.s=dreamhost header.b=Fis611JH; dmarc=none; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; arc=pass ("mailchannels.net:s=arc-2022:i=1") Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 4E770743E7 for ; Wed, 18 Sep 2024 00:26:33 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1sqgdP-0006sa-7d; Tue, 17 Sep 2024 18:25:23 -0400 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 1sqgdM-0006s0-RU; Tue, 17 Sep 2024 18:25:20 -0400 Received: from dormouse.ash.relay.mailchannels.net ([23.83.222.50]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sqgdK-0000Wf-RM; Tue, 17 Sep 2024 18:25:20 -0400 X-Sender-Id: dreamhost|x-authsender|adam@alphapapa.net Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 488FC4E3144; Tue, 17 Sep 2024 22:25:14 +0000 (UTC) Received: from pdx1-sub0-mail-a229.dreamhost.com (trex-7.trex.outbound.svc.cluster.local [100.96.74.186]) (Authenticated sender: dreamhost) by relay.mailchannels.net (Postfix) with ESMTPA id DAF764E312D; Tue, 17 Sep 2024 22:25:13 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1726611913; a=rsa-sha256; cv=none; b=VR3BSh8Y5e/qpUBBQodQr5rgdKHhWol810PBqQ3l6HNogc6CIocVigEd1hGz9A4mPzpJOT DUXRB7ICqploIQYHZEGJphxvOp3g8eZqj2OoayksunWbyc4TOXSw2MNDaEQSUdftx609A0 qgEMpIQGi9erZ+sNx0ljHI2m8G6r44pyjbgCQv8gk8Estmdu+KGAyOx+GqNvbhWP9IKEzw B9MNvCHFPExnB/5Xpc0O//nl8z7LIZC5CuPFe8d6qUl315zv+3LJQvWa+NShk4u36tQqfz AkTgay8G9+Z3e39lgXfHpgw3VR0IAAazrKnB8UJBEZOA6BZYYT6LZEn907FirA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1726611913; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:dkim-signature; bh=3qhKEiH/+SOe5bsIl9zHVUkElyCx41pbLK1oWHK+OJk=; b=Gt9wolb2KemUHmdfuKeOv5o/VTUKQg+VepXkbiSZI0CXNIavy/2BjTD7lGjqdbitIuLwoT ikxzI0XR/2H75/SPIBQBx+6gWjFqnH09wKDFKrLEmvkLw7g+84Aqcg9g7V9V2oDlq/IhGE XK6/5xr/1UMzn/ELua9qFxwvw2nOlDJe+PJBY+hdwH0HnyBm4yHbNeSkrUhW9W/xnmguRN EQv2/ioew8DJcHftoHWkaQbx5i2HRCq8RP3JFp4obvajfHQALwBGDj8Z37YVjncn1xkrsp iWSM+7yeYabeG/5iHgycRAxXqMhY9h4qh5rPIu+uUhk+koF7Xi1CyssHEFU52g== ARC-Authentication-Results: i=1; rspamd-5b46bcd97f-s2rjn; auth=pass smtp.auth=dreamhost smtp.mailfrom=adam@alphapapa.net X-Sender-Id: dreamhost|x-authsender|adam@alphapapa.net X-MC-Relay: Neutral X-MailChannels-SenderId: dreamhost|x-authsender|adam@alphapapa.net X-MailChannels-Auth-Id: dreamhost X-Obese-Keen: 195c7cc6304b1ee9_1726611914106_3505068282 X-MC-Loop-Signature: 1726611914106:811402685 X-MC-Ingress-Time: 1726611914106 Received: from pdx1-sub0-mail-a229.dreamhost.com (pop.dreamhost.com [64.90.62.162]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.96.74.186 (trex/7.0.2); Tue, 17 Sep 2024 22:25:14 +0000 Received: from [10.66.203.89] (unknown [91.193.232.98]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: adam@alphapapa.net) by pdx1-sub0-mail-a229.dreamhost.com (Postfix) with ESMTPSA id 4X7bvF2b6YzDb; Tue, 17 Sep 2024 15:25:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=alphapapa.net; s=dreamhost; t=1726611913; bh=3qhKEiH/+SOe5bsIl9zHVUkElyCx41pbLK1oWHK+OJk=; h=Date:Subject:To:Cc:From:Content-Type:Content-Transfer-Encoding; b=Fis611JHYIqyNZugscP0R90kRfvDgMO68KHyIfRwAMvrqILcRAYEz9sHiORQ0nxLT S7/2OeJE8M+bB3YE/wo6/orQ0O2v9A3kRhUy0NIKAXMMdB3Th/7XD/1nAZxeNoNTjy 6yNFLKQHBjn9K8KU0KjWVcoZlit3wwHudfPw4JVlHEk3Uhy4KIFSFNsKdN3yUa2XRm RNtxUiqKOp1GWwFxKGYONwRp27j+d/jzyhLRxaeqgj7yI9btbeqLpoTzdANqHOmXv2 NnsM0JYMyrbefAy1TkyvVJdf5wLEbw0vnfiIhA0Mpz/3caoCn77mKfj+Mw0P7wd7Ni Ak9J1QotMeefw== Message-ID: <1a69c5fb-4069-45c8-b37b-4d54ef88b92d@alphapapa.net> Date: Tue, 17 Sep 2024 17:25:12 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: packages submissions : ob-sql-session and org-blog To: Phil Estival Cc: emacs-devel@gnu.org, Org Mode List References: Content-Language: en-US From: Adam Porter In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Received-SPF: neutral client-ip=23.83.222.50; envelope-from=adam@alphapapa.net; helo=dormouse.ash.relay.mailchannels.net X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.3 / 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, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H4=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_NEUTRAL=0.779 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -4.81 X-Spam-Score: -4.81 X-Migadu-Scanner: mx13.migadu.com X-Migadu-Queue-Id: 4E770743E7 X-TUID: vLGrcShh5BDL Hi Phil, On 9/17/24 05:00, Phil Estival wrote: >> Also, for org-sql-session (which sounds very useful), it would be good >> to compare and contrast it with the package it's meant to supersede. > > The following comparison was added to the readme file. > > ob-sql-mode : > - is very simple : forward the sql source through `sql-redirect' > - has a test suite > - but gives clunky output > - no :results table > - sql client shell commands messes up output > - prompt again for connection parameters when restarting a session > > ob-sql-session : > - handle large results > - has :results tables > - accept header variables (:var) > - accept sql client shell commands > - keep login parameters > - prompt only for blank connection parameters > - can use `with-environment-variables' > - provide some more tests > >> since it's meant to integrate with org-babel, it might be good to >> discuss its inclusion on the Org mailing list also. To be clear, this makes 3 implementations of SQL support for Org Babel that I know of: 1. The built-in Org Babel SQL support, aka ob-sql, documented at 2. ob-sql-mode, hosted at , which advertises itself as "an alternative backend for Org-Babel SQL SRC blocks that uses sql-mode to evaluate the query instead of Org-Babel's built-in SQL backends." 3. Your new ob-sql-session library. You've mentioned how your library compares to ob-sql-mode, but how does it compare to the built-in ob-sql library? Thanks, Adam