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