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