From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.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 yIPvCjQB1mObhAEAbAwnHQ (envelope-from ) for ; Sun, 29 Jan 2023 06:16:36 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id kLbvCjQB1mMa+gAA9RJhRA (envelope-from ) for ; Sun, 29 Jan 2023 06:16:36 +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 E64A11436A for ; Sun, 29 Jan 2023 06:16:34 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pM02d-0007I7-9N; Sun, 29 Jan 2023 00:15:47 -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 1pM02Y-0007HU-OH for emacs-orgmode@gnu.org; Sun, 29 Jan 2023 00:15:42 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pM02X-0004P3-2E; Sun, 29 Jan 2023 00:15:41 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=Date:References:Subject:In-Reply-To:To:From: mime-version; bh=clbxyj3bydDyDT7/ENmYerzzLqpDwsnGznwCzBpzmfw=; b=aof7/7ePSXYd coLlzNs9+H5ImAFJe7FOJ6LpKiB8ifHjox4+U0mv7MJnpikKguT5VkXtcDcgteBs7Wrtxwvhge4Qq SeBZnJ9ZBae83nOjJrjxpTEMeBtsw7V6Hi5NtajxBot+GSb/iH4TLRCpRs6lI3fohc0IeSQtk/kld MrfWbLdiIj2MbDRYgr6sAhBKyT4+v2jt4dGKCLpxds2M59nB92kfOBnyvCPrcV5vnvWwbMfF675XI 4xTLcB/jLG+k9geGGo1zEkn5xM6v0U8+jSruWgv61iqpxRg6hXa9AXXTQC9gMgKSXsBPNLG8Af2AN 8WX7VrlYOuN6tt149vuFvA==; Received: from rms by fencepost.gnu.org with local (Exim 4.90_1) (envelope-from ) id 1pM02W-0002nM-QV; Sun, 29 Jan 2023 00:15:40 -0500 Content-Type: text/plain; charset=Utf-8 From: Richard Stallman To: Jean Louis Cc: yantar92@posteo.net, emacs-orgmode@gnu.org In-Reply-To: (message from Jean Louis on Wed, 25 Jan 2023 14:51:24 +0300) Subject: Re: Supporting non-free SQL clients in ob-sql (was: [PATCH] ob-sql: Add support for Athena) References: <874jsqbvfq.fsf@kraus.my> <87358an35i.fsf@localhost> <63c5b8db.170a0220.e466f.2573@mx.google.com> <87o7qxmr6y.fsf@kraus.my> <87fsc9iifs.fsf@localhost> Message-Id: Date: Sun, 29 Jan 2023 00:15:40 -0500 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: , Reply-To: rms@gnu.org 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-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1674969395; h=from:from:sender:sender:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc: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=clbxyj3bydDyDT7/ENmYerzzLqpDwsnGznwCzBpzmfw=; b=hCAbP0Ik4BflJWQcigG6BGn/A1FCtJKgg9XwAcamOiipzqHbVtmdbGX+43T8h3FZcvjANh UjPEZZ3ukwbtgLUjmudmfIMeb6NIs1wmXMTeOIZAH1oc1q0aaj2ljmI4cPvtFENinTzPjO FtoTVkgup4qrP0wnZA/NyyaQzRG8zViaL63v2Clg7rmhcem6Vqqz3Ggbz9zdToNhvebthM 6eCe7BYoBubvngkwEkbN9+tbuChkNLQbT6GBDzmUC3HUyD5DEppzzlR7Rd6mMix8ZBjNN2 +eZfwGOwltk3n5XGGOZJBoZQZuf4XMvYIF3T9GcJgPEx3UtpWZQc9iyOKciurg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gnu.org header.s=fencepost-gnu-org header.b="aof7/7eP"; dmarc=pass (policy=none) header.from=gnu.org; 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-Seal: i=1; s=key1; d=yhetil.org; t=1674969395; a=rsa-sha256; cv=none; b=Spd61Lkk1UCZtI2gAi4c4Kh++6SdjzguS3TBJq1rs3VOxMFSivDmnqy9N8itm+Ncdx+zXL sYqnsQikbqWf44iZplhfjCsB6hVYeCeLlSPJ2TO4zu025gqjHkp9dWbAC9qfGq3GqsU4jz kDp/OpT4WOz4+fWsg/pq04mOAMQqup2xneIm2okH7b0lV27uieUogbSy3A0wlMwIAWA9UW jnbmFngZH80NPhaM+330AZW4l57bn0fhsnlJC0OoAkSHm80zJaEMVwZnqKx/0XBnWmI5ji apso2SLFhOr7uBsjztmAE6wEmktnxTU19mFKbmPIKAoiolZJktyKICW4utOMhA== X-Spam-Score: -5.55 X-Migadu-Spam-Score: -5.55 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gnu.org header.s=fencepost-gnu-org header.b="aof7/7eP"; dmarc=pass (policy=none) header.from=gnu.org; 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" X-Migadu-Queue-Id: E64A11436A X-Migadu-Scanner: scn1.migadu.com X-TUID: 9nEoAapTg0OW [[[ 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. ]]] > > 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? > It is program that runs in a subprocess. > > c. A server running SaaSS? > Theoretically it could be as access may be network based. > But according to my knowledge this product is proprietary and may be > downloaded and run on users' computer or network computers. Any nonfree program that users can install to run in a subprocess, they can easily arrange to communicate with through sockets over the net. Thus, supporting a case of (b) implies supporting also the scenarion (c). So, if our rules say that (b) is ok in a certain case, we need not worry separately about (c). > > 2. How does Emacs communicate with that thing? > > a. By function calls within a process? > Yes. Based on the details you gave, I think we are miscommunicating. You're saying that a Lisp program communicates with the Oracle database through calls to other Lisp packages -- but that doesn't address this question. Those other Lisp packages are free and running inside Emacs. This question is how Emacs communicates with the Oracle database program. > (defcustom sql-oracle-program "sqlplus" > "Command to start sqlplus by Oracle. If it uses comint mode, it is talking with that program through a pty or pipe. So the answer is c. > > b. Via shared memory? > > c. Via a pty or pipe? > > d. Via sockets? But this text from a doc string makes me concerned > On Windows, \"sqlplus\" usually starts the sqlplus \"GUI\". In order > to start the sqlplus console, use \"plus33\" or something similar. > You will find the file in your Orant\\bin directory." because it isn't clear. It is sketchy. An expert on running that database on Windows might understand it, but someone who only knows about Emacs can't even try. How does sql.el communicate with sqlplus on Windows? -- Dr Richard Stallman (https://stallman.org) Chief GNUisance of the GNU Project (https://gnu.org) Founder, Free Software Foundation (https://fsf.org) Internet Hall-of-Famer (https://internethalloffame.org)