[Pythonmac-SIG] Database (SQL prefered) access on MacPython

[Bob Ippolito]

On Dec 2, 2005, at 9:43 AM, Schollnick, Benjamin wrote:

>> Python's Db API, of course. http://www.python.org/peps/pep-0249.html
>>
>> There are a lot of databases out there, and there's a Python
>> driver for most of them. http://www.python.org/topics/database/
>> I guess you'll find most help for MySQL, even if PostgreSQL
>> or something is better. If you don't need a db server,
>> perhaps try SQLite.
>
> When the heck did that come out?
>
> It's a nice step forward to standarding the Database modules that
> exist...

DB API 2.0 has been around for over 6 years (Apr 1999) and its  
predecessor is from 1996...

Every Python SQL database extension I've ever used has implemented  
it, except for the one or two that were explicitly designed not to  
implement it (e.g. to go way into db-specific land, or to implement  
asynchronous queries).

mxODBC is a DB-API 2.0 compliant extension for ODBC databases that  
works on OS X, but it requires a license for commercial use.

I'd also consider using something like SQLObject to abstract things a  
bit if I wasn't doing something that needed lots of performance  
tuning or DB specific enhancements.

-bob