PROPOSED Add SQL functionality?
- State "PROPOSED" from ""
I happened to notice this on #emacs
<spcshpopr8r> hallo emacsers <spcshpopr8r> I have successfully, finally, got on board with org-babel and ess...earlier today, my head exploded [15:39] *** JayM (~jay@cpe-76-186-94-148.tx.res.rr.com) has quit: Ping timeout: 268 seconds *** CrustY (~klon@91.187.21.231) has quit: Read error: Connection reset by peer <spcshpopr8r> now I want to execute an arbitary bunch of sql against an oracle database and then feed the results to an R block *** CrustY (~klon@91.187.21.231) has joined channel #emacs [15:40] <jave> btw org vs planner? *** gnuvince (~vince@72.0.219.6) has quit: Ping timeout: 256 seconds *** kenshin (~kenshin@59.95.54.181) has quit: Quit: Ex-Chat <spcshpopr8r> I've looked a little bit at org-babel-sql.el and it seems pretty spartan...like it just wants to talk to a mysql database at the moment [15:41] *** gnuvince (~vince@72.0.219.6) has joined channel #emacs *** Colloguy (~flx@64.134.18.188) has joined channel #emacs <spcshpopr8r> anybody here got a simple solution to get org-babel (org-babel-sql that is) to talk to my li'l ol oracle databases?
Ideally there's a single sql-mode for emacs that we can interact with… it looks like sql-mode is the way to go. I'd say we add that as a requirement to org-babel-sql, and then start building up the integration with…
- start using sql-mode builtins for connection – which should extend us to other database engines
-
add more header arguments (
passwrd
,database
,username
, etc…) - support persistent sessions
- support returning query results as lists/tables
- support dropping lists/tables into insert statements