Free Development software downloads. MySQL Connectivity With Python. One of the cool things about Python is that, as an object-oriented language, it forces developers to think in terms of abstraction and code modularization when writing code, and thereby results in cleaner, better-packaged applications.
However, packaging your code into functions is just the beginning; Python also allows you to create collections of shared code fragments, or "modules", which may be imported and used by any Python program. Powerful, flexible and very interesting, modules can be one of the most potent weapons in a Python developer's arsenal...so long as they're used correctly. Over the course of this article, I'll be exploring one of Python's more useful modules, the MySQLdb module.
This MySQLdb module allows developers to connect their Python code up to a MySQL database server, execute SQL commands on it, and massage the resulting data set into a useful and usable format...and it comes in very handy when you're developing database-driven Python applications. MySQLdb User's Guide. If you want to write applications which are portable across databases, use MySQLdb, and avoid using this module directly.
_mysql provides an interface which mostly implements the MySQL C API. For more information, see the MySQL documentation. The documentation for this module is intentionally weak because you probably should use the higher-level MySQLdb module.