On 2009-08-08, at 12:18, Abdulaziz Ghuloum wrote:
I was about to write a somewhat minimal SQLite interface for Ikarus
when I decided
to ask the obvious question. Has anyone got one that they might be
willing to share?
I don't think there is one currently, but I would like to use
it if it exists. As a matter of fact, I was going to do it
except that I felt uneasy about hardcoding constant values
(like #define'd cpp constants, enum values, etc) ...
Dale Smith very kindly sent me some code that looks very useful, and
I'm planning on
building it up to suit what I need, which includes prepared statements
and (I hope)
user-defined functions.
I too find hardcoding magic numbers repulsive, but am planning to do
it the easy and
lazy way, namely by writing an awk hack that reads sqlite.h and spits
out the corresponding
Scheme code. I'm using awk because it's available just about
everywhere; using irregex
puts at least a compile-time dependency on a Scheme library that not
everyone will have (though
presumably sqlite.h will only change relatively slowly.
I hope to have something very basic within a week, and then might add
various bits of
functionality as they are needed.
-- v
