Using Python and Connecting to MySQL remotely WITHOUT MySQL installedon local computer

T

Tim Harig

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.
 
S

Steve Holden

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
 
T

Tim Harig

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.

One of the advantages to using the MySQL supplied library is that if the
line protocol changes the connector automatically inherits the work already
done by MySQL for the price of a stable API (yes, I am aware that the MySQL
API *has* changed through the years). That could be very relevant in the
near future as the probject settles its stable forks.
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.

That still looks like alpha code. Would you be willing to make a statement
as to its stability?
 
S

Steve Holden

One of the advantages to using the MySQL supplied library is that if the
line protocol changes the connector automatically inherits the work already
done by MySQL for the price of a stable API (yes, I am aware that the MySQL
API *has* changed through the years). That could be very relevant in the
near future as the probject settles its stable forks.


That still looks like alpha code. Would you be willing to make a statement
as to its stability?

No, that was purely an example. I am, however, using MySQL Connector/Python

https://launchpad.net/myconnpy

in a series of commercial Python 3 classes.

regards
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,733
Messages
2,569,440
Members
44,830
Latest member
ZADIva7383

Latest Threads

Top