[Chicken-users] Seed thought: perl/ruby dbi equivalent for scheme/chicken?

[Matthew Welland]

First off, my heartfelt thanks to the mysql, sqlite(3) and postgresql egg 
authors. Without the sqlite3 and postgresql eggs I would be stuck on ruby 
or perl. Thank you!

Perl, Ruby and Bigloo have available a single SQL interface for accessing 
SQL db's. It is called DBI in Perl and Ruby and the RDBMS library for 
Bigloo. The documentation for the Bigloo interface can be found here: 

http://bigloo-lib.sourceforge.net/bigloo-lib_6.html

Has a similar approach for chicken been discussed or worked on? I was 
thinking of building a primitive wrapper to achieve something like this. My 
thought was to choose a subset of the sqlite3 api (my favorite) and 
implement wrappers to postgresql (and perhaps one day mysql). I'm stopped 
by the lack of calling with placeholders in the existing postgresql driver. 
Parsing the queries to implement:

(sqlite3:exec (db <sqlite3:database>) (sql <string>) . params) 

Where the sql includes simple parameters such as:

(sqlite3:exec db "INSERT INTO foo(name,address) VALUES(?,?)" "bob" "NY")

Would be fairly easy but would that be enough to cover most usage or would 
this break down quickly? Does anyone else see such a wrapper as being 
useful?

Thanks,

Matt
--