Using Python and Connecting to MySQL remotely WITHOUT MySQL installed on local computer

Steve Holden steve at holdenweb.com
Wed Nov 17 21:24:22 EST 2010


On 11/17/2010 7:21 PM, Tim Harig wrote:
> On 2010-11-18, dave <davidreynon at gmail.com> wrote:
>> http://sourceforge.net/projects/mysql-python/
>>
>> Using this package, WITHOUT having MySQL installed on my Mac OS X, how
>> can I use python to connect to a remote MySQL server?
>>
>> All of the tutorials mention having to download MySQL!
> 
> You don't have to install all of MySQL, just the client libraries.  I would
> assume that almost every MySQL connector uses these libraries; but, you
> might see if the MySQL-ODBC connector will work without them.  It is a long
> shot.  Your last option would be to recreate your own connector without
> using the MySQL client libraries.  I am not really sure what the purpose of
> reinventing this wheel would be.

I believe that the coming trend is to implement the MySQL client
protocol directly in Python, thereby obviating the need for any MySQL
client installation on the machine hosting the Python code.

The pymysql project at http://code.google.com/p/pymysql/ is one such
solution, aimed at satisfying Python 3 users without the need to port
existing low-level client code.

As an irrelevance might I also add that the trend for built-in extension
modules is to require a reference implementation in Python to ease the
task of those wishing to port the language and get as much functionality
(albeit at some performance in cost) available as early in the porting
cycle as possible.

regards
 Steve
-- 
Steve Holden           +1 571 484 6266   +1 800 494 3119
PyCon 2011 Atlanta March 9-17       http://us.pycon.org/
See Python Video!       http://python.mirocommunity.org/
Holden Web LLC                 http://www.holdenweb.com/




More information about the Python-list mailing list