Connecting MySQL and Python
Geert Vanderkelen (Sun Microsystems) speaks at the 2010 O'Reilly MySQL User Conference & Expo.
Slides - http://assets.en.oreilly.com/1/event/...
From the official conference description at http://en.oreilly.com/mysql2010/publi...
On the verge of Python v3.1 and MySQL v5.5 it is important to look into how developers are going to connect to their favorite DBMS in the future. For a long time MySQL for Python (i.e. MySQLdb) was the only solution, but now there are more. It is time to unleash the alternatives!
This talk will give an overview of how to connect to MySQL and which drivers are available today under Python v2.x, and tomorrows Python v3.x. Well dive into MySQLdb, its strong history, its present. Well go over OurSQL and various other community projects, as well as Sun Microsystems MySQL Connector/Python (maintained by the speaker).
Web frameworks like Django and Turbogears are working great with MySQL. Well look into them together with projects like SQLAlchemy and see how the various Python DB API drivers implementing MySQL can be used. Coding is important, but well try to keep the examples short and to the point.
This talk should be interesting for people never done anything in Python but are interested and want to know how to connect to MySQL. It should also be good for expert developers who want an overview of what is possible and whats going to be possible with Python v3.x and MySQL v5.1 or greater.