MySQL with Python

[Roy Smith]

In article <mailman.2233.1350328857.27098.python-list at python.org>,
 Dennis Lee Bieber <wlfraed at ix.netcom.com> wrote:

> For routine database /access/ (that is, someone has created the
> database user account that will be used), MySQLdb is the Python adapter
> to connect to the server. For using THAT, you basically need to know SQL
> (MySQL's flavor in particular), along with understanding the DB-API 2
> specification (PEP-249) with the MySQLdb documentation (which explains
> any limitations or specifics; see http://mysql-python.sourceforge.net/ )

Another possibility is to use some sort of ORM (Object Relational 
Mapper), which provides an abstraction layer on top of the raw SQL 
layer.  Two examples are SQLAlchemy (http://www.sqlalchemy.org/) and 
Django (https://www.djangoproject.com/).

A thread on Stack Overflow (http://stackoverflow.com/questions/53428) 
mentions some additional Python ORMs you might want to explore.