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?