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 <andrea.crott...@gmail.com> 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 _______________________________________________ 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
