Jacob Kruger wrote: > Busy now building a sort of MySQL admin interface, and installed > MySQL-python-1.2.3.win32-py2.7.exe, and see it includes both the basic > mysql module, as well as something called MySQLdb which is some sort > of a wrapper or something, but anyway. > > Anyway, was just wondering if there are specific ways it would be > better to connect to a MySQL database/server, and if there are > commonly used examples out there, since didn't seem to find any off > hand, and this is starting to come together, but, just wondering..?
MySQLdb is a basic but functional database connector. It is specific to MySQL. Personally, I prefer "oursql" because it is a little more refined, but both will get the job done Both will work in either Windows or Linux. The ADODB API is a more general; it uses a database driver that gets installed in the operating system, so the API is the same for any database server it supports, and it supports a lot of them. However, it is Windows only (as far as I know). Virtually all Python database APIs have the same basic model. You call a single "connect" function to get a database object. You ask that object for a "cursor". You call the cursor's "execute" method to run an SQL query. Then you use methods like "fetchone" and "fetchall" to retrieve the records one by one. -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32