From mboxrd@z Thu Jan 1 00:00:00 1970 From: andrea Subject: Tables to DB Date: Thu, 03 Dec 2009 15:11:56 +0100 Message-ID: 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 1NGCPy-0008LQ-LS for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 09:12:26 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1NGCPt-0008FQ-Md for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 09:12:25 -0500 Received: from [199.232.76.173] (port=45436 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NGCPt-0008FB-HN for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 09:12:21 -0500 Received: from lo.gmane.org ([80.91.229.12]:34518) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1NGCPt-00011u-BU for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 09:12:21 -0500 Received: from list by lo.gmane.org with local (Exim 4.50) id 1NGCPr-0004oU-8V for emacs-orgmode@gnu.org; Thu, 03 Dec 2009 15:12:19 +0100 Received: from 46-111.eduroam.rwth-aachen.de ([134.61.46.111]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 03 Dec 2009 15:12:19 +0100 Received: from andrea.crotti.0 by 46-111.eduroam.rwth-aachen.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 03 Dec 2009 15:12:19 +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: emacs-orgmode@gnu.org 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?