From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id MP7NHITk0GOMUQAAbAwnHQ (envelope-from ) for ; Wed, 25 Jan 2023 09:12:52 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id kL7VHITk0GOryQAAauVa8A (envelope-from ) for ; Wed, 25 Jan 2023 09:12:52 +0100 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 E04C5140CB for ; Wed, 25 Jan 2023 09:12:51 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pKass-0001Zk-94; Wed, 25 Jan 2023 03:11:54 -0500 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 1pKasa-0001YL-Vu for emacs-orgmode@gnu.org; Wed, 25 Jan 2023 03:11:38 -0500 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1pKasY-0001el-Rn; Wed, 25 Jan 2023 03:11:36 -0500 Received: by mail-pl1-x62d.google.com with SMTP id be8so4289377plb.7; Wed, 25 Jan 2023 00:11:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:in-reply-to:date:subject:cc:to:from:user-agent :references:message-id:from:to:cc:subject:date:message-id:reply-to; bh=c3EFG2qGItqMCOKZKPYQAIZMIXuGxnn9IpwXYp721tk=; b=Nh1qmm0HpOg4v+4MqpYz9GdamFcpaq6S9Bp07kvVaomzsGrvkg9Kj3O/nfROGa0bUe F2IdvT3Ijm2BUs0KlI1mj9NbmmvvXTdaTIEhFqZ0TQY4sZlrS+zDmhEbyC7vuJMHOqBc jE8Kzrvk11dxnasZ1YzcLWgJMQUEqA+kYz3N/Bg9JCi2jVxjxJAovpnpp7GMy+EJ+vQu sumYSdz28Fjdh60DU4OhCf/CYHDfm4CeuB3WZJW05OQ8i88k8jju27eGWAnagaeqpIQY UipaxnFO6N1OXCuFDX7avJh2haILyQJ1alNdAviypmMswGXTDULRbWP6GyZflGNJsznf dUyw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:in-reply-to:date:subject:cc:to:from:user-agent :references:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=c3EFG2qGItqMCOKZKPYQAIZMIXuGxnn9IpwXYp721tk=; b=H8gLeURxHVsRer2TeYzjJ6IX/fZ4t4m+Oyq36ZcJgTQcYetHfDrozVIaV/leOthqkl oqNxX+YaUIR6R2AEDb0Y/Bv13bhx6vNUbCfD6j0RlqIe/1fw664pehpgP/kSdVvkssIG sEuts9bgIWMKa4rSDjI5vZoJM7xHgqEGNUcNPrTzNo7pQIglbVLX7MeGuC7flbKkKjiH J8keRrbLEDIrVuB+RtVZYZEuD0zqtp05+Bi0d7pQEaM2vjkEK98tmDT4HtCzpy87aPZm 3a5aw3Z/rpq7CiKVZRkeqO5G+bP1HHVpJHLpybsNkDqMO4/biwWxEQApIsoHjxyokDia ia5w== X-Gm-Message-State: AFqh2kr1DSDUbHgPMirWYRSLpZ9oAZfrNwmzb6C61Mfdjm92Q4Y4g/6c D/UAOGeAjcOyN3DKmY3qOWhsGJvBKyDeSg== X-Google-Smtp-Source: AMrXdXv6Go4MQzCT5C1RQt9H0NwkTciB3kQ3IoQtTYPlaLtbrB8UNBbZ0TChOk6IoxfkkKBgX9rUpw== X-Received: by 2002:a17:902:c401:b0:194:dbd3:f571 with SMTP id k1-20020a170902c40100b00194dbd3f571mr27835165plk.35.1674634291810; Wed, 25 Jan 2023 00:11:31 -0800 (PST) Received: from dingbat (220-235-140-148.dyn.iinet.net.au. [220.235.140.148]) by smtp.gmail.com with ESMTPSA id h6-20020a170902748600b0019615a0d083sm2676877pll.210.2023.01.25.00.11.29 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Jan 2023 00:11:31 -0800 (PST) Message-ID: <63d0e433.170a0220.54a51.4c8f@mx.google.com> X-Google-Original-Message-ID: --text follows this line-- References: <874jsqbvfq.fsf@kraus.my> <87358an35i.fsf@localhost> <63c5b8db.170a0220.e466f.2573@mx.google.com> <87o7qxmr6y.fsf@kraus.my> <87fsc9iifs.fsf@localhost> User-agent: mu4e 1.9.16; emacs 29.0.60 From: Tim Cross To: rms@gnu.org Cc: Jean Louis , yantar92@posteo.net, emacs-orgmode@gnu.org Subject: Re: Supporting non-free SQL clients in ob-sql (was: [PATCH] ob-sql: Add support for Athena) Date: Wed, 25 Jan 2023 18:57:08 +1100 In-reply-to: MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=2607:f8b0:4864:20::62d; envelope-from=theophilusx@gmail.com; helo=mail-pl1-x62d.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-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 ARC-Seal: i=1; s=key1; d=yhetil.org; t=1674634371; a=rsa-sha256; cv=none; b=a9lmqJTpdRhPBZj+QWqE0XFhbS2SFuKu0jwCv0ELMQqRcfoMEhAmN3omo0lJhZIYSwzjLr tuIr97LcHECvZVONaO3MVR8kluyr+fcItWJ8SuYJnEN227M91AWmY4zwH/MGrEytBA/iSC /3OwsvuuxszaRwF9fcgDzRaEbgxmZi/ZLPF8ZJYxCHndW8Vadpb2RRDLWr3Tino3ioCQPU Jh2dMkDxrrOToXKusMfwTsR8t5qCOqZQH1qS31xpDu4fUeLUeV0D0Z/6IiyKeMdmofH2g7 MLoIhI2cGI10EoxBueKAHOnPMHvMxyrlGgi0PwcD3ONaYP3PFqKPTxFUazPVrg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1674634371; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=c3EFG2qGItqMCOKZKPYQAIZMIXuGxnn9IpwXYp721tk=; b=hoYlFuNfCgwazHLmB6/QnX/WfHytVIlKGmueyEOcEqXBJktq908hNHpOBlKs3CnUYdaR1X 7bCJwduHpxSzK0OWS91ZJ1gXtFQTQS5f6NbnD5fo96z0QcCdEygMBC8MAbhkTNygArVLIR p94MDQPN1Ko8VOexXEQRLzXJ+8WvSc2vvVPMr9kqJbfnJ1Yts4pZz1nQQvrQT+/dHY2d48 +k1DxCLlgPVyD+4clhfl8v+XRix6bRt+uZ9jLTHuJ6TyS6YdoBmbqiLk8BDVcqJ7H00B8o Ju7CZyilZuiu8EmUPwzdU5cmM9cuMe7ij/6iMm1iKyHMOCKDnmzXoEH/OkeZ2g== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=Nh1qmm0H; 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"; dmarc=pass (policy=none) header.from=gmail.com X-Migadu-Scanner: scn0.migadu.com X-Migadu-Spam-Score: -9.75 X-Spam-Score: -9.75 X-Migadu-Queue-Id: E04C5140CB Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=Nh1qmm0H; 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"; dmarc=pass (policy=none) header.from=gmail.com X-TUID: 2JAh6g32Qnxz Richard Stallman writes: > [[[ To any NSA and FBI agents reading my email: please consider ]]] > [[[ whether defending the US Constitution against all enemies, ]]] > [[[ foreign or domestic, requires you to follow Snowden's example. ]]] > > > > Would someone please tell me more concretely what kind of "support" > > > this is? > > > You can find interactive support in `sql' library, functions such as: > > > M-x sql-oracle > > > which supports proprietary Oracle Database: > > This raises two questions. > > 1. For this purpose, what kind of thing is "the Oracle Database"? > a. A library to link with? > b. A program to run in a subprocess? > c. A server running SaaSS? > None of the above! Richard, to be very clear, ob-sql is not adding any NEW interface to any external program. It is just using the Emacs built-in SQL library (Elisp), which has been part of Emacs for a long time (I was using it in late 90s to work with Oracle RDMS). It is this library that provides the 'support' for things like Oracle's RDMS. If you want more specific information, ask on emacs-devel. Org mode is just using this built-in library. The Oracle database is simply a relational database management system in the same way as Postgres, MySQL, Ingris, MS-Sql server etc. All of these have a CLI client and support connections via JDBC. The sql.el library provides specialised comint based interfaces which run the CLI to communicate with the RDMS. The closest of your 3 choices is b, as the build-in Emacs sql library executes the RDMS CLI in a sub-process comint buffer.