emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Richard Stallman <rms@gnu.org>
To: Jean Louis <bugs@gnu.support>
Cc: 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: Sun, 29 Jan 2023 00:15:40 -0500	[thread overview]
Message-ID: <E1pM02W-0002nM-QV@fencepost.gnu.org> (raw)
In-Reply-To: <Y9EXvJNY3G31p+2g@protected.localdomain> (message from Jean Louis on Wed, 25 Jan 2023 14:51:24 +0300)

[[[ 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)




  reply	other threads:[~2023-01-29  5:16 UTC|newest]

Thread overview: 33+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2023-01-16 10:48 [PATCH] ob-sql: Add support for Athena Daniel Kraus
2023-01-16 11:13 ` Ihor Radchenko
2023-01-16 11:52   ` Daniel Kraus
2023-01-16 20:50   ` Tim Cross
2023-01-17  9:42     ` Daniel Kraus
2023-01-17 10:06       ` Supporting non-free SQL clients in ob-sql (was: [PATCH] ob-sql: Add support for Athena) Ihor Radchenko
2023-01-17 11:38         ` Tim Cross
2023-01-23  4:23         ` Richard Stallman
2023-01-23  6:33           ` Jean Louis
2023-01-25  4:31             ` Richard Stallman
2023-01-25  7:57               ` Tim Cross
2023-01-25 12:35                 ` Ihor Radchenko
2023-01-25 14:05                   ` Tim Cross
2023-01-25 14:31                     ` Ihor Radchenko
2023-01-25 21:11                       ` Tim Cross
2023-02-26  2:59                       ` Richard Stallman
2023-01-28  4:45                     ` Richard Stallman
2023-01-30 14:51                       ` Ihor Radchenko
2023-01-28  4:43                 ` Richard Stallman
2023-01-25 11:51               ` Jean Louis
2023-01-29  5:15                 ` Richard Stallman [this message]
2023-01-23 12:45           ` Ihor Radchenko
2023-01-23 20:12             ` Tim Cross
2023-01-26  4:25               ` Richard Stallman
2023-01-26  6:59                 ` Supporting non-free SQL clients in ob-sql Loris Bennett
2023-01-26 10:22                 ` Supporting non-free SQL clients in ob-sql (was: [PATCH] ob-sql: Add support for Athena) Ihor Radchenko
2023-01-26 11:05                   ` Supporting non-free SQL clients in ob-sql Heinz Tuechler
2023-01-26 11:14                     ` Ihor Radchenko
2023-01-26 11:47                       ` Heinz Tuechler
2023-01-28  4:45                   ` Supporting non-free SQL clients in ob-sql (was: [PATCH] ob-sql: Add support for Athena) Richard Stallman
2023-01-29 14:21                     ` Ihor Radchenko
2023-02-04  5:15                       ` Richard Stallman
2023-01-26  4:26             ` Richard Stallman

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=E1pM02W-0002nM-QV@fencepost.gnu.org \
    --to=rms@gnu.org \
    --cc=bugs@gnu.support \
    --cc=emacs-orgmode@gnu.org \
    --cc=yantar92@posteo.net \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).