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)
|
sdbi supports "databases" with text query languages that return rectangular results
hga@xxxxxx
(01 Oct 2019 12:22 UTC)
|
Re: sdbi supports "databases" with text query languages that return rectangular results
John Cowan
(01 Oct 2019 16:10 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 :)