[DB-SIG] mSQL interface

[Anthony Baxter]

>>> "M.-A. Lemburg" wrote
> John Lehmann wrote:
> > 
> > Actually I was going to look at wrapping the mySQL-api in swig and then
> > writing a db-sig conformant wrapper in python, as my C is rusty.  Is
> > this a stupid idea?
> 
> got that running with mxODBC. There's one quirk though, that makes
> a native interface interesting: the ODBC driver for mySQL expects
> string input for *all* types -- the conversion is done auto-
> matically by mxODBC (well, the next release of it), but it could
> cause the input data to be slightly inaccurate (e.g. for floats).

Eurgh. My original mSQL interface had the same... feature. It's a total
pain in the bottom after a while - I only did it initially because I was
lazy :)

FWIW, I'd advocate throwing out the existing code, and doing something
with SWIG to wrap both mSQL and mySQL. 

Anthony