[python-win32] MySQL connection/admin tool

[Jacob Kruger]

Ok, here seems to be quite a nice, sort of step-by-step bit of reference/tutorial material related to making use of MySQLdb, etc.:
http://www.kitebird.com/articles/pydbapi.html

Stay well

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

  ----- Original Message ----- 
  From: Vernon Cole 
  To: Jacob Kruger 
  Cc: python-win32 at python.org 
  Sent: Friday, November 25, 2011 7:32 PM
  Subject: Re: [python-win32] MySQL connection/admin tool


  Jacob:

  adodbapi provides an extended dbapi 2.0 (PEP 249) connection to many databases,  MySQL is one of the ones I test with regularly.  It is included in pywin32. Just "import adodbapi" to use it. (You do have to install the MySQL ODBC driver.)  The other packages you mention are MySQL specific, and may have more features specific to MySQL, I don't know ... I've never tried them.

  Examples of PEP 249 use can be found on Google search "python database api example".

  Examples of adodbapi use are in the "tests" folder under site_packages/adodbapi -- see also http://sourceforge.net/projects/adodbapi/

  good luck
  --
  Vernon


  On Fri, Nov 25, 2011 at 7:33 AM, Jacob Kruger <jacobk at mailzone.co.za> 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..?

    Stay well

    Jacob Kruger
    Blind Biker
    Skype: BlindZA
    '...fate had broken his body, but not his spirit...'


    _______________________________________________
    python-win32 mailing list
    python-win32 at python.org
    http://mail.python.org/mailman/listinfo/python-win32



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20111128/9765c520/attachment.html>