Hi Phil,
On 9/17/24 05:00, Phil Estival wrote:
Also, for org-sql-session (which sounds very useful), it would be good
to compare and contrast it with the package it's meant to supersede.
The following comparison was added to the readme file.
ob-sql-mode :
- is very simple : forward the sql source through `sql-redirect'
- has a test suite
- but gives clunky output
- no :results table
- sql client shell commands messes up output
- prompt again for connection parameters when restarting a session
ob-sql-session :
- handle large results
- has :results tables
- accept header variables (:var)
- accept sql client shell commands
- keep login parameters
- prompt only for blank connection parameters
- can use `with-environment-variables'
- provide some more tests
since it's meant to integrate with org-babel, it might be good to
discuss its inclusion on the Org mailing list also.
To be clear, this makes 3 implementations of SQL support for Org Babel
that I know of:
1. The built-in Org Babel SQL support, aka ob-sql, documented at
<https://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sql.html>
2. ob-sql-mode, hosted at <https://github.com/nikclayton/ob-sql-mode>,
which advertises itself as "an alternative backend for Org-Babel SQL SRC
blocks that uses sql-mode to evaluate the query instead of Org-Babel's
built-in SQL backends."
3. Your new ob-sql-session library.
You've mentioned how your library compares to ob-sql-mode, but how does
it compare to the built-in ob-sql library?
Thanks,
Adam
