3 databases in 3 days hga@xxxxxx (30 Sep 2019 00:36 UTC)
Support for Scheme standards and implementations Lassi Kortela (30 Sep 2019 08:11 UTC)
Re: Support for Scheme standards and implementations hga@xxxxxx (30 Sep 2019 11:25 UTC)
Scheme implementations and portability Lassi Kortela (30 Sep 2019 13:14 UTC)
Re: Scheme implementations and portability John Cowan (30 Sep 2019 19:27 UTC)
Scheme implementations, portability, FFIs Lassi Kortela (30 Sep 2019 21:16 UTC)
Re: Scheme implementations, portability, FFIs John Cowan (30 Sep 2019 22:10 UTC)
JDBC Lassi Kortela (30 Sep 2019 13:15 UTC)
Re: JDBC hga@xxxxxx (30 Sep 2019 13:24 UTC)
Re: JDBC and subprocess protocol Lassi Kortela (30 Sep 2019 14:29 UTC)
Re: JDBC and subprocess protocol hga@xxxxxx (30 Sep 2019 15:16 UTC)
Re: JDBC and subprocess protocol Lassi Kortela (30 Sep 2019 15:47 UTC)
Re: JDBC and subprocess protocol Lassi Kortela (30 Sep 2019 15:55 UTC)
Re: JDBC John Cowan (30 Sep 2019 15:10 UTC)
Re: JDBC Lassi Kortela (30 Sep 2019 15:26 UTC)
Re: JDBC Lassi Kortela (30 Sep 2019 15:34 UTC)
sdbi design in detail and MariaDB CONNECT hga@xxxxxx (30 Sep 2019 16:14 UTC)
Re: sdbi design in detail and MariaDB CONNECT Lassi Kortela (30 Sep 2019 16:28 UTC)
Re: sdbi design in detail and MariaDB CONNECT John Cowan (30 Sep 2019 20:25 UTC)
Re: JDBC John Cowan (30 Sep 2019 16:44 UTC)
Re: JDBC Lassi Kortela (30 Sep 2019 20:52 UTC)
Re: JDBC Alaric Snell-Pym (01 Oct 2019 09:26 UTC)
Re: JDBC hga@xxxxxx (01 Oct 2019 09:55 UTC)
Re: JDBC Alaric Snell-Pym (01 Oct 2019 11:09 UTC)

Support for Scheme standards and implementations Lassi Kortela 30 Sep 2019 08:11 UTC

Great work!

> Thanks to Alex Shinn and his sqlite3 Snow library, and his Chibi Scheme, getting the project up and running separate from a fork of Chibi Scheme took only a day, including creating a couple of cut down from it and customized Gnu Makefiles: https://github.com/Schemepersist/sdbi-chibi

Did you need to patch Chibi, or do the current libraries work with stock
Chibi and its FFI?

> Thanks to Takashi Kato for his PostgreSQL wire (net) protocol Snow package, that required no changes at all, except for renaming the locations (e.g. (sdbi connector net postgresql), or (sdbi connector ffi sqlite3)). I was already up on the learning curve to set up PostgreSQL, create a database, etc., so it and Sqlite3 have complete tests to create a table, insert a row, retrieve it, and drop the table.

Takashi maintains a very neat Scheme implementation, Sagittarius, that
nobody talks about for some reason. It's the only Scheme besides Larceny
that supports both R6RS and R7RS! He's a very responsive maintainer too.
Göran said that he "sometimes fixes bugs before you're back from your
tea break" and I have a similar experience. It would be nice to return
the favor by implementing the DB API for it. R6RS<->R7RS portability is
a personal interest mine, so if you can ensure the implementation runs
solidly on R7RS I can do some porting work to R6RS.

Another project by him: <https://github.com/ktakashi/r6rs-pffi>. A
portable FFI for many R6RS implementations. Haven't tried this yet but
some impressive Schemers like it.

Seems the Postgres library is based on SRFI 106: Basic socket interface
and has ready wrappers for Chibi and Gauche.

> Thanks to Apache Cassandra, and DataStax, Inc. for making it absolutely frictionless to install both the database and the latter's C API, which includes a bunch of placed in the public domain example programs, a total class act. And again thanks to Alex Shinn for his marvelous Chibi Scheme FFI, and examples of how to hack around it not handling const arguments or returns in the sqlite3 Snow library. Not long ago I got finished executing the statement "SELECT release_version FROM system.local" from the simple.c example, and got the valid string value for the single row and named column return.

We get more signal :)