[DB-SIG] which free database to use (and a few other questions)

[Anthony Baxter]

>>> Jeremy Hylton wrote
> I'm also curious about the state of the Python modules for each of
> these databases.  The miniSQL module doesn't conform to the DB API.
> Is this a problem?  It looks like it would be easy enough to use the
> mSQL C library to implement an extension module.  (But the fact that
> it looks pretty easy makes we wonder why no one else has?  Perhaps
> there are some problems with mSQL...)

I did the original mSQL interface back in the dim dark days of mSQL 0.x.

In the last couple of years, I've had no reason at all to use it, so I
haven't DB-SIG'd the API. In the intervening time, at least a couple of
other people have released enhanced versions of the mSQL module, but 
the original API is still there. I'd _love_ for someone to take the
msql C API and write a new interface that's DB-SIG compliant - I still
get mail asking about the mSQL module.

As far as mSQL vs. mySQL; well, we use mySQL internally for anything
where we can't use the Oracle databases - we used to use mSQL 1.x, but
it's a total and utter Pig From Hell when your data gets up past 1
megabyte or so. Bambi has made a lot of improvements to 2.x, and I'm
sure it's much better. (I have to say that, in case Bambi reads this and
hits me next time he's in our Melbourne office :)
 
Try both, see what works for you. If you wrote a DB-SIG compliant mSQL
interface first, swapping between them would be easy. :)

Anthony

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________