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

That sounds very very good. If you want to, I can wrap
this in an sqld interface and provide it as a sqlid driver.

--Hans


Jon Zeppieri schreef:
> 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
>> >
>>
> _________________________________________________
>  For list-related administrative tasks:
>  http://list.cs.brown.edu/mailman/listinfo/plt-scheme
>
>