Re: [Chicken-users] Generic RDBMS Interface [Was: Re: Creating Windows GUI App]

[Matt Welland]

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 <address@hidden> wrote:
> 2011/3/31 Stephen Eilert <address@hidden>:
>> On Thu, Mar 31, 2011 at 1:46 PM, Thomas Chust <address@hidden> 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
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/chicken-users
>