[plt-scheme] Re: MySQL driver over via MySQL protocol

I realize that wasn't exactly clear...

I was referring to a mysql driver that is implemented completely in
plt-scheme and communicates via the mysql network prototcol, rather
than by wrapping the native C drivers.  Information:

1) It implements the latest version of the mysql network protocol.  It
does *not* implement earlier versions.

2) The driver comes with a SHA-1 implementation in scheme (which could
be useful on its own).

3) It will not communicate over SSL (but that shouldn't be difficult to add).

4) SQL date/datetime/time type handling could be a lot better.

5) In general, mapping types between SQL and PLT needs improvement and
added flexibility.

6) The driver is implemented as a module (mysql), providing the
following interface:

Parameters
 - (current-connection)

Procedures
 - (connect host port user password db)
 - (query sql #:optional (return-insert-id #f) #:key (connection
(current-connection)))
 - (prepare sql #:key (connection (current-connection)))
 - (execute stmt vals #:optional (return-insert-id #f))
 - (close obj)
 - (begin-transaction #:key (connection (current-connection)))
 - (commit #:key (connection (current-connection)))
 - (rollback #:key (connection (current-connection)))
 - (next-row result)
 - (next-row/list result)
 - (next-row/alist result)
 - (fetch-rows result)
 - (fetch-rows/list result)
 - (fetch-rows/alist result)

-Jon



On 2/5/07, Jon Zeppieri <zeppieri at gmail.com> wrote:
> I actually wrote one awhile back.  It doesn't conform to Hans's sqlid
> interface, and it's definitely a bit rough, but you might be
> interested.
>
> I don't feel that it's quite ready for Planet distribution, but I'd be
> happy to make a tarball available somewhere if there's interest.
>
> -Jon
>
>
> On 2/5/07, Matthias Felleisen <matthias at ccs.neu.edu> wrote:
> > Even if, a driver for PLT Scheme would be great.
> >
> > On Feb 5, 2007, at 11:22 AM, David Van Horn wrote:
> >
> > > Hans Oesterholt-Dijkema wrote:
> > >> Dear All,
> > >> I've started to develop a driver for sqlid, sqld-mysql on
> > >> schematics.sourceforge.net.
> > >> Is anyone interested to join in this effort?
> > >
> > > Are you aware of Eric Knauel's work on Myscsh?
> > >
> > > David
> > >
> > > _________________________________________________
> > >  For list-related administrative tasks:
> > >  http://list.cs.brown.edu/mailman/listinfo/plt-scheme
> >
> > _________________________________________________
> >   For list-related administrative tasks:
> >   http://list.cs.brown.edu/mailman/listinfo/plt-scheme
> >
>