From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Eric Schulte" Subject: Re: [babel] Tables to DB Date: Thu, 03 Dec 2009 08:43:15 -0700 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NGDqF-0001lc-Aw for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 10:43:39 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1NGDqA-0001eZ-Bh for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 10:43:38 -0500 Received: from [199.232.76.173] (port=51576 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NGDqA-0001eE-3Y for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 10:43:34 -0500 Received: from mail-pz0-f193.google.com ([209.85.222.193]:55844) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1NGDq9-00031S-NJ for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 10:43:33 -0500 Received: by pzk31 with SMTP id 31so1359471pzk.28 for ; Thu, 03 Dec 2009 07:43:32 -0800 (PST) In-Reply-To: (andrea's message of "Thu, 03 Dec 2009 15:11:56 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: andrea Cc: emacs-orgmode@gnu.org Org-babel has support for SQL, so I presume that you could use that as a somewhat manual way to dump org-mode tables into sql tables. Also, if you have a python tool which you are using for interaction with sql tables, it may be easiest to use org-babel to convert your org-mode tables into python arrays, then let python handle the rest of the integration. Best -- Eric andrea writes: > Org tables are great but for visualization and querying maybe databases > are better, for example sqlite for small amounts of data is very nice > and powerful. > > I found this > http://orgmode.org/worg/org-tutorials/multitarget-tables.php which I > haven't tried yet but looks nice. > > I would like to have an automatic way to automatically fill some > database tables from orgmode tables, done maybe automatically when the > file is saved. > So the hook should: > - check for tables with #+ORGTBL line above > - store the data on the right sqlite table > > Rewrite completely the table every time is not a big problem since the > amount of data is really not big. > > Given that I will be able to do nice things with python-sqlite and also > finally replace this > http://alexandria.rubyforge.org/ > for book management > > Anyone is already doing something like that? > > > > _______________________________________________ > Emacs-orgmode mailing list > Please use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode