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