That is ironic. One of the things I was going to try to make available via the new egg system was my dbi egg (http://www.kiatoa.com/cgi-bin/fossils/opensrc/dir?ci=c7f1edfb8c6e036b&name=dbi). However anything Thomas puts together will be much, uh, fresher and faster :)
On Thu, Mar 31, 2011 at 4:05 PM, Thomas Chust <ch...@web.de> wrote: > 2011/3/31 Stephen Eilert <spedr...@gmail.com>: >> On Thu, Mar 31, 2011 at 1:46 PM, Thomas Chust <ch...@web.de> wrote: >>> [...] >>> However, there is currently no database-independent layer like >>> Perl's DBI module that provides a uniform API for all other >>> relational database drivers. >> >> Oh, that's been one of my pet peeves for a long time now. The closest >> we have is awful's $db procedure. >> [...] > > Hello, > > since I've already written a bunch of database abstraction code for my > pandora egg and other projects, I think I could create something > useful and simple relatively quickly. > > I'll have a try at developing a CHICKEN DBI egg at some point within > the next few weeks. > >> [...] >> I've toyed with the idea, but I am afraid I'm not knowledgeable enough >> about all RDBMS to come up with a decent API. Any suggestions? >> [...] > > My plan is to create an abstraction layer that is just powerful enough > to include not only a simple SQL interface but also a simple database > <-> record mapping facility. At the same time the API to implement > from the database driver side should remain quite basic and simple, > too. > > If the backend driver just provides the following operations that > should probably already be enough: > > * Open/close a database > * Prepare/finalize an SQL statement > * Execute a statement with parameters, passing any result rows to a > callback > * Escape an identifier for use in an SQL statement > * Generate a string suitable as a parameter placeholder in an SQL > statement > > I'll keep the list posted on any progress I make with this endeavour > ;-) > > Ciao, > Thomas > > > -- > When C++ is your hammer, every problem looks like your thumb. > > _______________________________________________ > Chicken-users mailing list > Chicken-users@nongnu.org > http://lists.nongnu.org/mailman/listinfo/chicken-users > _______________________________________________ Chicken-users mailing list Chicken-users@nongnu.org http://lists.nongnu.org/mailman/listinfo/chicken-users