Re: [python-win32] MySQL connection/admin tool
As new Python user, my discovery of the ADODBAPI package is very encouraging - is there any documentation other than that in the test cases? Regards - Nick -Original Message- From: python-win32-bounces+qgold.77=gmail@python.org [mailto:python-win32-bounces+qgold.77=gmail@python.org] On Behalf Of Vernon Cole Sent: November 25, 2011 9:32 AM To: Jacob Kruger Cc: python-win32@python.org 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 ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
Re: [python-win32] MySQL connection/admin tool
Will check it out. Thanks 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@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 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@python.org http://mail.python.org/mailman/listinfo/python-win32 ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
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 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@python.org > http://mail.python.org/mailman/listinfo/python-win32 > > ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
[python-win32] MySQL connection/admin tool
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@python.org http://mail.python.org/mailman/listinfo/python-win32