From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?ISO-8859-1?Q?Johan_W=2E_Kl=FCwer?= Subject: WISH: SQL on org-mode tables Date: Sun, 18 Aug 2013 16:06:43 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=089e0111ae345f32cb04e43955b0 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:52417) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VB3d7-00007o-1q for emacs-orgmode@gnu.org; Sun, 18 Aug 2013 10:06:56 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VB3cy-0006u5-5g for emacs-orgmode@gnu.org; Sun, 18 Aug 2013 10:06:52 -0400 Received: from mail-ve0-x22a.google.com ([2607:f8b0:400c:c01::22a]:40587) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VB3cy-0006tx-1Y for emacs-orgmode@gnu.org; Sun, 18 Aug 2013 10:06:44 -0400 Received: by mail-ve0-f170.google.com with SMTP id 15so2425539vea.15 for ; Sun, 18 Aug 2013 07:06:43 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: emacs-orgmode@gnu.org --089e0111ae345f32cb04e43955b0 Content-Type: text/plain; charset=ISO-8859-1 I wish it were possible to execute SQL on tables in org-mode buffers. Filtering rows and columns, joining values across named tables, and so forth 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 engine): https://github.com/jdurbin/durbinlib/wiki/csvsql. I'm thinking csvsql or similar could provide the query capability, and org-mode would take care of sending it org tables in tab separated format. That's my wish. Cheers Johan --089e0111ae345f32cb04e43955b0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I wish it were possible to execute SQL on tables in o= rg-mode buffers. Filtering rows and columns, joining values across named ta= bles, and so forth could be done with SQL in the org-table SEND clauses.
There's a script called csvsql that allows for executing SQL on com= ma- or tab-separated files from the command-line (using the H2 database eng= ine): https://= github.com/jdurbin/durbinlib/wiki/csvsql. I'm thinking csvsql or si= milar could provide the query capability, and org-mode would take care of s= ending it org tables in tab separated format.

That's my wish.

Cheers

Johan

--089e0111ae345f32cb04e43955b0--