"Pure Python" MySQL module like Net::MySQL

07-20-03, 07:43 AM

Ravi

Hi,

I did some googling, and found that there doesn't seem to be a pure
python MySQL communication module. There is one for perl however,
Net::MySQL. I was wondering if there was a specific reason why something
similar hasn't been implemented in Python, a limitation of the language
or libraries perhaps? I briefly scanned through the perl source for
Net::MySQL, and there doesn't seem to be anything that couldn't be done
in Python, but I'm a fresh convert from perl land and I don't much
beyond the basics of Python yet.

Thanks,
Ravi

07-20-03, 11:23 AM

José María Mateos

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In comp.lang.python, Ravi (rxs141) wrote:
> I did some googling, and found that there doesn't seem to be a pure
> python MySQL communication module. There is one for perl however,

I think there's a MySQLdb package for Python that might fulfill
your needs.

Regards,

chema.

- --
Chema Mateos - RinzeWind | Take out the "-news" in my e-mail address
#debian-es irc.freenode.net | if replying. Message will be eaten by
Jabber ID - rinzewind AT jabber.org | /dev/null if you don't.
GPG-key: http://chema.homelinux.org/~chema/key.asc

07-20-03, 02:09 PM

Gerhard Häring

Ravi wrote:
> Hi,
>
> I did some googling, and found that there doesn't seem to be a pure
> python MySQL communication module. There is one for perl however,
> Net::MySQL.

Does it implement the MySQL wire protocol in pure Perl, without linking
to libmysql? Sure that's possible in Python.

> I was wondering if there was a specific reason why something
> similar hasn't been implemented in Python,

Nobody needed it badly enough.

> a limitation of the language or libraries perhaps?

No.

> I briefly scanned through the perl source for
> Net::MySQL, and there doesn't seem to be anything that couldn't be done
> in Python, but I'm a fresh convert from perl land and I don't much
> beyond the basics of Python yet.

Is there any particular reason why you'd need such a beast instead of
just using MySQLdb?

-- Gerhard

07-20-03, 07:50 PM

Ravi

Gerhard Häring wrote:
>
> Is there any particular reason why you'd need such a beast instead of
> just using MySQLdb?
>
I'm developing for cell phones/PDA's using Jython, because Java is
available. Yet, a proper C compiler is not, so libmysql cannot be
compiled. I will see if I can put a wrapper on the Java MySQL connector
to make it accessible in Jython.

Thanks for your help,

Ravi

07-20-03, 08:38 PM

Gerhard Häring

Ravi wrote:
> Gerhard Häring wrote:
> >
>
>> Is there any particular reason why you'd need such a beast instead of
>> just using MySQLdb?
>>
> I'm developing for cell phones/PDA's using Jython, because Java is
> available. Yet, a proper C compiler is not, so libmysql cannot be
> compiled. I will see if I can put a wrapper on the Java MySQL connector
> to make it accessible in Jython.

No need for that, just download zxJDBC :)

-- Gerhard

07-21-03, 03:42 PM

Skip Montanaro

I saw Paul's quote in John's reply. I've yet to see Paul's not. Hopefully
I'm not taking anything out of context.

Skip> libraries haven't been ported. On the other hand, the MySQL wire
Skip> protocol is probably not part of the official external interface,
Skip> so the author has to track changes to the protocol.

Paul> What the heck? If the wire protocol isn't part of the official
Paul> external interface, then how on earth are external applications
Paul> supposed to talk to the database?

By using the client library MySQL provides. As far as I can tell, the MySQL
wire protocol is not documented in the current version of the manual
(http://www.mysql.com/documentation/mysql/bychapter/). That suggests to me
that the protocol is not part of the external interface, and anyone
implementing it directly can't really complain if it changes.

Skip

07-21-03, 07:53 PM

Suchandra Thapa

Paul Rubin <> wrote:
> What the heck? If the wire protocol isn't part of the official
> external interface, then how on earth are external applications
> supposed to talk to the database? They certainly can't expect you to
> use black-box client libraries if they're at all serious about being
> in the same league with Oracle.

Actually, I think they do. With a change to a gpl licensed client library,
in mysql 4.x, I think mysql ab is trying to get more revenue from anyone using
the mysql database for commercial purposes. Forcing all access to the database
to go through their client libraries is one of the things that made this
possible.

Similar Threads
Looking for a pure python Mysql module Does anyone know of a package that can connect and query a mysql server that is platform independent and does not need to compile any extra c modules (IE a pure python...
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...
Install Python MySQL db module? Hi, how does properly install the Python MySQL db module for Mac OS X? I was only able to locate the Win32 modules. Thanks in advance, -Conrad
Weird gcc errors while installing "MySQL-python" module Hi guys, I´m experiencing weird error messages while installing MySQL-python with easy_install... I have no idea where the errors come from. Read the whole output at...
Seeking Python->mySQL OR module Hi, I'm looking for an object-relational layer, which can wrap a MySQL database into highly pythonic objects. There seem to be dozens of packages which provide some of...