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

2011-04-03 Thread Thomas Chust
2011/4/2 Thomas Chust ch...@web.de: [...] I'll stay in touch and I'll put any prototype code I produce into a publicly accessible version control repository :-) [...] Hello, my first prototype code is available at http://www.chust.org/fossils/dbi This has undergone only minimal testing,

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

2011-04-02 Thread Thomas Chust
2011/4/2 Matt Welland estifo...@gmail.com: - Original message - 2011/4/1 Jim Ursetto zbignie...@gmail.com: [...] Just use an alist. [...] Maybe less practical to enter on command lines, but probably more schemish, yes :-) How about a convinence function to convert the URI to an

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

2011-04-01 Thread Thomas Chust
2011/4/1 Matt Welland estifo...@gmail.com: 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=c7f1edfb8c6e036bname=dbi). However anything Thomas puts together will be much, uh,

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

2011-04-01 Thread Thomas Chust
2011/4/1 YC yinso.c...@gmail.com: [...] would you be interested in considering to look at my racket bzlib/dbi package on racket planet as a potential idea for interface?  I was looking to port it over to chicken but never got around to it due to other things.  it would be good to have

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

2011-04-01 Thread matt welland
On Fri, 2011-04-01 at 14:35 +0200, Thomas Chust wrote: [...] There will be one important architectural difference: I want to make the selection of the backend driver modular and dynamic so that adding a new driver never requires any changes in the DBI egg's code and ideally using the new

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

2011-04-01 Thread YC
Hi Thomas, On Fri, Apr 1, 2011 at 5:47 AM, Thomas Chust ch...@web.de wrote: There is at least one small point that I would want to do differently, though: In my opinion it has some value if the procedure establishing the database connection has a fixed signature and driver specific

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

2011-04-01 Thread Peter Bex
On Fri, Apr 01, 2011 at 12:29:40PM -0700, YC wrote: URI is definitely an interesting approach. I originally wanted to use a connection string like ODBC, but realized that since I am using DBI to be more than just for RDBMS (I have a memcached driver and a filepath driver) and the key/value

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

2011-04-01 Thread YC
On Fri, Apr 1, 2011 at 12:40 PM, Peter Bex peter@xs4all.nl wrote: On Fri, Apr 01, 2011 at 12:29:40PM -0700, YC wrote: URI is definitely an interesting approach. I originally wanted to use a connection string like ODBC, but realized that since I am using DBI to be more than just for

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

2011-04-01 Thread Jim Ursetto
On Apr 1, 2011, at 7:47 AM, Thomas Chust wrote: There is at least one small point that I would want to do differently, though: In my opinion it has some value if the procedure establishing the database connection has a fixed signature and driver specific information is encoded in a single

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

2011-04-01 Thread Thomas Chust
2011/4/1 Jim Ursetto zbignie...@gmail.com: On Apr 1, 2011, at 7:47 AM, Thomas Chust wrote: There is at least one small point that I would want to do differently, though: In my opinion it has some value if the procedure establishing the database connection has a fixed signature and driver

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

2011-04-01 Thread Thomas Chust
2011/4/1 YC yinso.c...@gmail.com: [...] The reason I did not use keyword arguments for query is that in racket keyword arguments needs to be quoted to pass through to the underlying driver, but chicken might not have that issue. Hello YC, this is not really true: While Racket doesn't pass

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

2011-04-01 Thread John Cowan
Thomas Chust scripsit: The alist approach I chose can feel unwieldy at times for sure if written manually, but nice when the alist is already formulated elsewhere (which occurs quite a bit in web code) to be passed in. That's a good point to keep in mind. An advantage of the alist

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

2011-04-01 Thread Matt Welland
- Original message - 2011/4/1 Jim Ursetto zbignie...@gmail.com: On Apr 1, 2011, at 7:47 AM, Thomas Chust wrote: There is at least one small point that I would want to do differently, though: In my opinion it has some value if the procedure establishing the database

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

2011-04-01 Thread YC
On Fri, Apr 1, 2011 at 5:17 PM, Thomas Chust ch...@web.de wrote: this is not really true: While Racket doesn't pass keyword arguments the same way as positional arguments for reasons of efficiency, it is still possible to programmatically create procedures that accept arbitrary sets of

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

2011-03-31 Thread Thomas Chust
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

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

2011-03-31 Thread 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=c7f1edfb8c6e036bname=dbi). However anything Thomas puts together will be much, uh, fresher and faster :) On Thu, Mar 31, 2011 at 4:05

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

2011-03-31 Thread YC
On Thu, Mar 31, 2011 at 4:05 PM, Thomas Chust ch...@web.de wrote: 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