Re: db interface (was Re: Scheme is too complicated)

["Peter C. Norton" <spacey@inch.com>]

On Sat, Oct 31, 1998 at 12:12:38PM -0800, Craig Brozefsky wrote:
> As far as connecting to a database, that's fairly straightforward and
> I don't think much can be done there, except maybe provide things
> like: (with-db-connect) and such to get rid of all the lame DB
> connection management headaches.

I agree with you here.  The basic SQL database structure is simple.  It
should be made easier then most vendors' interfaces.
 
> Actually, it would seem that sql generation is a almost a must, or at
> least some shortcuts should be provides so that either:

Yes.  You've uncovered my hidden agenda with guile having a database
interface: to create libraries of queries, commands, etc.  I want
templates for common tasks, functions that are associated with each other,
so instead of having to write sql you'd have a library of functions that
work on databases in general, which can be optimized for certian
databases, and which provide the functions to query a database in
scheme... or better yet from any language that you've linked libguile
into.
 
I'd really like to have something like nextstep's (or whatever it's
called now) database interface tool.  But I'd like to be able to link it
to any language.  

-- 
Peter C. Norton                      Time comes into it. / Say it.  Say it.
spacey@pobox.com                   | The Universe is made of stories,  
http://spacey.dyn.ml.org           | not of atoms. 
                                   |
                                     Muriel Rukeyser "The Speed of Darknesss"