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]

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

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

[Roy Smith]

In article <kfxGk.3925$Ws1....@nlpi064.nbdc.sbc.com>,
Carsten Haese <carste...@gmail.com> wrote:

> 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-python-mysql/tree/master/pymysql

Awesome, thanks!

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

[Tino Wildenhain]

Hi,

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? :-)

Just wondering...

Tino

[James Mills]

On Tue, Oct 7, 2008 at 2:12 PM, Tino Wildenhain <ti...@wildenhain.de> wrote:
> 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.

[Gerhard Häring]

James Mills wrote:
> On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <r...@panix.com> wrote:

> 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 <mailman.2087.1223353...@python.org>,
"James Mills" <prol...@shortcircuit.net.au> wrote:

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

Gerhard Häring wrote:
> James Mills wrote:
>> On Tue, Oct 7, 2008 at 9:15 AM, Roy Smith <r...@panix.com> wrote:

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