Gambit FFI implementation of minimal SQLite3 interface Lassi Kortela (31 Aug 2020 08:52 UTC)
Re: Gambit FFI implementation of minimal SQLite3 interface Lassi Kortela (02 Sep 2020 05:33 UTC)
Re: Gambit FFI implementation of minimal SQLite3 interface Lassi Kortela (02 Sep 2020 07:33 UTC)

Re: Gambit FFI implementation of minimal SQLite3 interface Lassi Kortela 02 Sep 2020 07:33 UTC

>> sqlite3_bind_parameter_name to get the names of those in use, and
>> sqlite3_bind_{int,double,text,blob,null} to set their values.
>
> Good. I'll implement that.

Implemented at <https://github.com/schemepersist/minimal-sqlite>. (I
moved the repo; it's now under the schemepersist organization.)

(sql-do/row-id
   db
   '("insert into config (name, value) values (@name, @value)"
     name "foo"
     value "bar"))

The symbols on the Scheme side could be '@name and '@value with the @
sign included in their names, since there is more than one syntax in
SQLite for passing them. But it ought to be OK if we mandate one
particular syntax?