On Tue, Oct 1, 2019 at 12:42 PM <xxxxxx@ancell-ent.com> wrote:

With many thanks to https://www.thesaurus.com, an updated sdbi API: https://github.com/Schemepersist/sdbi-design/blob/master/apis/sdbi.txt

It is John's Simple SQL API with "sql-" replaced with "sdbi-", and the following changes:

New opaque data type, tech-stack, and that's not a good name for the stack of e.g. "subprocess jdbc db2", suggestions including replacing "stack" are solicited.

I like "rdbms", where "r" stands for "rectangular", or in the alternative just "dbms".

Here I made thunk optional, removing needless ceremony and a procedure call if you just want the result set.

(sdbi-get-result connection statement [thunk]) -> result-set or what thunk returns

Executes statement, and thunk supplied, passes it the result-set.

Everything following, which starts with (sdbi-read result-set) -> list, is unchanged except for the"sql-" -> "sdbi-" swap.

- Harold

I think that the blob API should be generalized to reading arrays and multisets somehow. In both cases the idea is that the content of a cell (row-column pair) may be too large to just return all at once.