Pure Python interface to MySQL?

[Roy Smith]

Does there exist a pure Python version of a MySQL module? I've got a data
logging application that needs to run on a whole bunch of OSs, ranging from
Windows to a dozen different unix flavors on all sorts of hardware.

Portability is much more important than performance for this application.
We're only inserting a few hundred records a day from each system, but the
ability to quickly deploy to anywhere I've already got Python running is
key.

 

[James Mills]

Does there exist a pure Python version of a MySQL module? I've got a data
logging application that needs to run on a whole bunch of OSs, ranging from
Windows to a dozen different unix flavors on all sorts of hardware.

Portability is much more important than performance for this application.
We're only inserting a few hundred records a day from each system, but the
ability to quickly deploy to anywhere I've already got Python running is
key.

My solution (tm):

You could implement a proxy server/client
sub-system that you could use to chuck MySQL
statements at the server which would in-turn
use the Python DB-API (mysql-python) module.
This way you would only have to maintain
_one_ instance of the mysql-python module
on the server.

cheers
James

 

[Carsten Haese]

Does there exist a pure Python version of a MySQL module?

A quick google search turns up this:

http://github.com/mopemope/pure-python-mysql/tree/master/pymysql

I've never used it, though, so I have no idea whether it works or how
well it works.

HTH,

 

[Roy Smith]

A quick google search turns up this:

http://github.com/mopemope/pure-python-mysql/tree/master/pymysql

Awesome, thanks!

You have better searching skills than I do, apparently

 

[James Mills]

Will you be asking for a pure python implementation of mysql
in the next question? Why not use the proxy approach (for
example via xmlrpc) as suggested by James or just spill to
a file?

You could for example use an alternative database:
* buzhug
* ZODB
* Durus
* Or any of: pickle, shelve, XML, or flat file.

All mentioned above are pure-python.
I am maintaining a more up-to-date version of
buzhug in my development brnaches if you're
interested.

cheers
James

 

[Gerhard Häring]

Does there exist a pure Python version of a MySQL module? I've got a data
logging application that needs to run on a whole bunch of OSs, ranging from
Windows to a dozen different unix flavors on all sorts of hardware.

Portability is much more important than performance for this application.
We're only inserting a few hundred records a day from each system, but the
ability to quickly deploy to anywhere I've already got Python running is
key.

My solution (tm):

You could implement a proxy server/client
sub-system [...]

Or instead of reinventing the wheel, you could use SQLRelay
(http://sqlrelay.sourceforge.net/), which has a pure-Python DB-API module.

-- Gerhard

 

[Roy Smith]

You could for example use an alternative database:
* buzhug
* ZODB
* Durus
* Or any of: pickle, shelve, XML, or flat file.

Unfortunately, I don't own the database, just the clients that have to
insert records into it :-(

 

[Skip Montanaro]

http://github.com/mopemope/pure-python-mysql/tree/master/pymysql

I've never used it, though, so I have no idea whether it works or how
well it works.

On the project's home page I noticed:

pymysql is Pure Perl MySQL driver.

pymysql is the Python DB API-2.0 interface.

support MySQL versions 4.1-5.1

Hopefully the code is more robust than the author's proofreading. ;-)

Skip

 

[Gerhard Häring]

Does there exist a pure Python version of a MySQL module? I've got a
data
logging application that needs to run on a whole bunch of OSs,
ranging from
Windows to a dozen different unix flavors on all sorts of hardware.

Portability is much more important than performance for this
application.
We're only inserting a few hundred records a day from each system,
but the
ability to quickly deploy to anywhere I've already got Python running is
key.

My solution (tm):

You could implement a proxy server/client
sub-system [...]

Or instead of reinventing the wheel, you could use SQLRelay
(http://sqlrelay.sourceforge.net/), which has a pure-Python DB-API module.

Unfortunately, the Python interface for SQLRelay seems to include parts
written in C. What a pity.

-- Gerhard