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]

On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <ro*@panix.comwrote:

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

--
--
-- "Problems are solved by method"

[Carsten Haese]

Roy Smith wrote:

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

A quick google search turns up this:

http://github.com/mopemope/pure-pyth...master/pymysql

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

HTH,

--
Carsten Haese
http://informixdb.sourceforge.net

[Roy Smith]

In article <kf*****************@nlpi064.nbdc.sbc.com>,
Carsten Haese <ca***********@gmail.comwrote:

Roy Smith wrote:

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

A quick google search turns up this:

http://github.com/mopemope/pure-pyth...master/pymysql

Awesome, thanks!

You have better searching skills than I do, apparently :-)

[James Mills]

On Tue, Oct 7, 2008 at 2:12 PM, Tino Wildenhain <ti**@wildenhain.dewrote:

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

--
--
-- "Problems are solved by method"

[=?ISO-8859-1?Q?Gerhard_H=E4ring?=]

James Mills wrote:

On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <ro*@panix.comwrote:

>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]

In article <ma**************************************@python.o rg>,
"James Mills" <pr******@shortcircuit.net.auwrote:

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

[=?ISO-8859-1?Q?Gerhard_H=E4ring?=]

Gerhard Häring wrote:

James Mills wrote:

>On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <ro*@panix.comwrote:

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