Connecting MySQL and Python

Geert Vanderkelen (Sun Microsystems)
Average rating: ***..
(3.00, 2 ratings)

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 tomorrow’s Python v3.x. We’ll dive into MySQLdb, its strong history, its present. We’ll 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. We’ll 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 we’ll 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 what’s going to be possible with Python v3.x and MySQL v5.1 or greater.

Photo of Geert Vanderkelen

Geert Vanderkelen

Sun Microsystems

Geert Vanderkelen is a member of the MySQL Support Team at Sun Microsystems. He is based in Germany and has worked for MySQL AB since April, 2005.

Before joining MySQL he worked as developer, DBA and SysAdmin for various companies in Belgium and Germany.

Today Geert specializes in MySQL Cluster and works together with colleagues around the world to ensure continued support for both customers and community. He’s also the maintainer of Sun’s MySQL Connector/Python.

Comments on this page are now closed.

Comments

Picture of Mark J. Levitt
Mark J. Levitt
04/22/2010 9:59am PDT

Billy, the slides are up. See the link above (or this one).

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/22/2010 6:37am PDT

Video for this presentation is at www.youtube.com/watch?v=O9t...

Billy Earney
04/14/2010 1:28pm PDT

could you post your presentation slides?

Thanks!

Billy Earney
04/14/2010 1:26pm PDT

Wonderful session about Python and MySQL. I look forward to downloading your code and testing it out. Maybe even contribute a little. :)

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.