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-- From mboxrd@z Thu Jan 1 00:00:00 1970 From: Marc Ihm Subject: Re: WISH: SQL on org-mode tables Date: Tue, 20 Aug 2013 21:08:59 +0200 Message-ID: <5213BECB.9090204@ihm.name> References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:57890) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) 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 ) 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 ) id 1VBrIi-0000uv-Qp for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 15:09:08 -0400 In-Reply-To: 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: =?ISO-8859-1?Q?=22Johan_W=2E_Kl=FCwer=22?= 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 > From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Abrahamsen Subject: Re: WISH: SQL on org-mode tables Date: Wed, 21 Aug 2013 08:29:34 +0800 Message-ID: <87d2p76g41.fsf@ericabrahamsen.net> References: <5213BECB.9090204@ihm.name> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:43009) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VBwIT-0001IK-Bk for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 20:29:19 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VBwIK-0000AY-ER for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 20:29:13 -0400 Received: from plane.gmane.org ([80.91.229.3]:41837) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VBwIK-0000AG-80 for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 20:29:04 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1VBwII-000089-I4 for emacs-orgmode@gnu.org; Wed, 21 Aug 2013 02:29:02 +0200 Received: from 114.252.246.79 ([114.252.246.79]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 21 Aug 2013 02:29:02 +0200 Received: from eric by 114.252.246.79 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 21 Aug 2013 02:29:02 +0200 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 Marc Ihm writes: > 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 allow > 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üwer: >> 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. I tend to think that the solution here involves using the right tools for the right job. Not everything has to be in Org mode! (Though I feel a little hypocritical claiming that.) It works so well with external tools, why not use them? My rule of thumb is that once a table becomes more about _data storage_ than it does about _data display_ -- ie I'm unlikely to actually examine or export the table contents -- I try to put it in an external database, sqlite works just fine. Between orgtable-sqlinsert to go from org table to database, and babel to query the database, all the tools are there. Org is just "glue", which is something it does very well. Eric From mboxrd@z Thu Jan 1 00:00:00 1970 From: SAKURAI Masashi Subject: Re: WISH: SQL on org-mode tables Date: Wed, 21 Aug 2013 11:55:14 +0900 Message-ID: <201308210255.r7L2tEkN004876@ms-omx11.plus.so-net.ne.jp> References: Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=ISO-2022-JP-2 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40208) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VBya3-00021V-2S for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 22:55:36 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VByZx-0000Ft-Kk for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 22:55:30 -0400 Received: from ms-omx01.so-net.ne.jp ([202.238.84.151]:20628) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VByZx-0000F6-5T for emacs-orgmode@gnu.org; Tue, 20 Aug 2013 22:55:25 -0400 In-Reply-To: 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: johan.w.kluwer@gmail.com Cc: emacs-orgmode@gnu.org Hi, I wrote a full DB browser in Emacs, EDBI https://github.com/kiwanami/emacs-edbi. This program provides DB Query API (like Perl's DBI) and table layout framework. One can query any SQL and layout the results into a rigid table format. There is no document for API, please see the demo code. https://github.com/kiwanami/emacs-edbi/blob/master/edbi-demo.el I don't have a time to integrate it into org-mode, if someone would write the code, I think I can help a little. Regards -- SAKURAI, Masashi (family, given) m.sakurai@kiwanami.net At Sun, 18 Aug 2013 16:06:43 +0200, Johan W. Kl$(D+d(Bwer wrote: > > [1 ] > > [2 ] > 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 > > From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?ISO-8859-1?Q?Johan_W=2E_Kl=FCwer?= Subject: Re: WISH: SQL on org-mode tables Date: Wed, 21 Aug 2013 10:07:06 +0200 Message-ID: References: <201308210255.r7L2tEkN004876@ms-omx11.plus.so-net.ne.jp> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7b6d88c8ce169b04e470a824 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:46074) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VC4Ip-0007Yb-6V for emacs-orgmode@gnu.org; Wed, 21 Aug 2013 05:02:10 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VC3Rb-0002T8-6g for emacs-orgmode@gnu.org; Wed, 21 Aug 2013 04:07:17 -0400 Received: from mail-vc0-x22a.google.com ([2607:f8b0:400c:c03::22a]:49894) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VC3Rb-0002Sv-1Q for emacs-orgmode@gnu.org; Wed, 21 Aug 2013 04:07:07 -0400 Received: by mail-vc0-f170.google.com with SMTP id kw10so68395vcb.29 for ; Wed, 21 Aug 2013 01:07:06 -0700 (PDT) In-Reply-To: <201308210255.r7L2tEkN004876@ms-omx11.plus.so-net.ne.jp> 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: SAKURAI Masashi Cc: emacs-orgmode@gnu.org --047d7b6d88c8ce169b04e470a824 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I started using EDBI myself just last week, it's working really well so far= ! An EDBI--org combination would be amazing for database work. 2013/8/21 SAKURAI Masashi > Hi, > > I wrote a full DB browser in Emacs, EDBI > https://github.com/kiwanami/emacs-edbi. > > This program provides DB Query API (like Perl's DBI) and table layout > framework. > One can query any SQL and layout the results into a rigid table format. > There is no document for API, please see the demo code. > https://github.com/kiwanami/emacs-edbi/blob/master/edbi-demo.el > > I don't have a time to integrate it into org-mode, > if someone would write the code, I think I can help a little. > > > Regards > -- > SAKURAI, Masashi (family, given) > m.sakurai@kiwanami.net > > > At Sun, 18 Aug 2013 16:06:43 +0200, > Johan W. Kl=EF=BF=BD+dwer wrote: > > > > [1 ] > > > > [2 ] > > 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 > > > > > --047d7b6d88c8ce169b04e470a824 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I started using EDBI myself just last week, it's = working really well so far!

An EDBI--org combination would be = amazing for database work.


2013/8/21 SAKURAI Masashi <m.sakurai@kiwanami.net>
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex"> Hi,

I wrote a full DB browser in Emacs, EDBI https://github.com/kiwanami/emacs-edbi.

This program provides DB Query API (like Perl's DBI) and table layout f= ramework.
One can query any SQL and layout the results into a rigid table format.
There is no document for API, please see the demo code.
https://github.com/kiwanami/emacs-edbi/blob/master/edbi-= demo.el

I don't have a time to integrate it into org-mode,
if someone would write the code, I think I can help a little.


Regards
--
SAKURAI, Masashi (family, given)
m.sakurai@kiwanami.net


At Sun, 18 Aug 2013 16:06:43 +0200,
Johan W. Kl=EF=BF=BD+dwer wrote:
>
> [1 =C2=A0<text/plain; ISO-8859-1 (7bit)>]
>
> [2 =C2=A0<text/html; ISO-8859-1 (quoted-printable)>]
> I wish it were possible to exe= cute SQL on tables in org-mode buffers. Filtering rows and columns,
> joining values across named tables, and so forth could be done with SQ= L in the org-table SEND
> clauses.
>
> There's a script called csvsql that allows for executing SQL on co= mma- or tab-separated files from
> the command-line (using the H2 database engine): https://github.co= m/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
>
>

--047d7b6d88c8ce169b04e470a824--