|
From: | Marc Ihm |
Subject: | Re: [O] WISH: SQL on org-mode tables |
Date: | Tue, 20 Aug 2013 21:08:59 +0200 |
User-agent: | Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130801 Thunderbird/17.0.8 |
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. 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
[Prev in Thread] | Current Thread | [Next in Thread] |