469,568 Members | 1,375 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

Pure Python interface to MySQL?

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.
Oct 6 '08 #1
8 1389
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"
Oct 6 '08 #2
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
Oct 6 '08 #3
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 :-)
Oct 7 '08 #4
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"
Oct 7 '08 #5
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

Oct 7 '08 #6
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 :-(
Oct 7 '08 #7
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
Oct 7 '08 #8
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

Oct 7 '08 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Ravi | last post: by
6 posts views Thread by Michael Foord | last post: by
51 posts views Thread by Noam Raphael | last post: by
10 posts views Thread by callmebill | last post: by
13 posts views Thread by Chris Seymour | last post: by
13 posts views Thread by Steven Bethard | last post: by
6 posts views Thread by Miguel Guedes | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.