From mboxrd@z Thu Jan  1 00:00:00 1970
From: Marc Ihm <marc@ihm.name>
Subject: Re: WISH: SQL on org-mode tables
Date: Tue, 20 Aug 2013 21:08:59 +0200
Message-ID: <5213BECB.9090204@ihm.name>
References: <CAC5XeFGb73CkWnJpF8CWuucuZcJsESV1vJR3wp=_PQKHitERwg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:57890)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <marc@ihm.name>) id 1VBrIo-0005iW-Qu
	for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 15:09:21 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <marc@ihm.name>) id 1VBrIj-0000wM-0s
	for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 15:09:14 -0400
Received: from smtp01.udag.de ([62.146.106.17]:32802)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <marc@ihm.name>) id 1VBrIi-0000uv-Qp
	for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 15:09:08 -0400
In-Reply-To: <CAC5XeFGb73CkWnJpF8CWuucuZcJsESV1vJR3wp=_PQKHitERwg@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: =?ISO-8859-1?Q?=22Johan_W=2E_Kl=FCwer=22?= <johan.w.kluwer@gmail.com>
Cc: emacs-orgmode@gnu.org

Yes, would like this too !
(But do not know, how to achieve this ...)

I think that simplifying the task of storing data in org-tables would all=
ow
many interesting org-applications to be implemented more easily.

And thanks for pointing at cvsql;
will have a look.

best regards,
Marc

Am 18.08.2013 16:06, schrieb Johan W. Kl=FCwer:
> I wish it were possible to execute SQL on tables in org-mode buffers. F=
iltering rows and columns, joining values across named tables, and so for=
th could be done with SQL in the org-table SEND clauses.
>
> There's a script called csvsql that allows for executing SQL on comma- =
or tab-separated files from the command-line (using the H2 database engin=
e): https://github.com/jdurbin/durbinlib/wiki/csvsql. I'm thinking csvsql=
 or similar could provide the query capability, and org-mode would take c=
are of sending it org tables in tab separated format.
>
> That's my wish.
>
> Cheers
>
> Johan
>