Re: package submission : ob-sql-session

[Phil Estival]

* [2024-10-20 14:34] Ihor Radchenko:
> Phil Estival <pe@7d.nz> writes:
>
> > > > 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
> Have you considered integrating it into ob-sql itself?
> If not, what are the obstacles?
Hello Ihor,

yes I have. It grows ob-sql by approximately 300 lines.
There are rooms for improvements.
https://github.com/flintforge/ob-sql-session/blob/main/ob-sql.el

Current status :
- added support of :sessions to ob-sql.el, by merging ob-sql-session.el
- restored support for sqlite (even if there is ob-sqlite.el)
- added composite types for options
- moved options from org-babel to a new group org-babel-sql

TODO :
- use `org-babel-prep-session'
- verify headers and columns options
- check use and storage of :dbconnection
- minimize writings of temporary files
- Tests

Cheers,

Phil