From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Adam Porter Newsgroups: gmane.emacs.devel,gmane.emacs.orgmode Subject: Re: packages submissions : ob-sql-session and org-blog Date: Tue, 17 Sep 2024 17:25:12 -0500 Message-ID: <1a69c5fb-4069-45c8-b37b-4d54ef88b92d@alphapapa.net> References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="15185"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mozilla Thunderbird Cc: emacs-devel@gnu.org, Org Mode List To: Phil Estival Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane-mx.org@gnu.org Wed Sep 18 00:26:28 2024 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 1sqgeR-0003kH-Fm for ged-emacs-devel@m.gmane-mx.org; Wed, 18 Sep 2024 00:26:27 +0200 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1sqgdP-0006sZ-85; Tue, 17 Sep 2024 18:25:23 -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 1sqgdM-0006s0-RU; Tue, 17 Sep 2024 18:25:20 -0400 Original-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 Original-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) Original-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 Original-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 Original-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== Content-Language: en-US In-Reply-To: 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-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:323705 gmane.emacs.orgmode:163342 Archived-At: 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