Python and MySQL

[Aquarius]

I appologize in advance for this strange (and possibly stupid)
question.

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionality?

[Alan Kennedy]

[Aquarius]

I appologize in advance for this strange (and possibly stupid)
question.

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionality?

Possibly not want you want to hear, but I'd strongly recommend to stop
wasting your time with a hosting company that doesn't support the
technologies you need.

Instead, try a hosting company that supports python: there are lots and lots

http://wiki.python.org/moin/PythonHosting

Life's too short to spend your time hacking around artificial barriers
to progress.

--
alan kennedy
------------------------------------------------------
email alan: http://xhaus.com/contact/alan

[Steve Holden]

Aquarius wrote:

I appologize in advance for this strange (and possibly stupid)
question.

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionality?

You'll definitely need something to call the database API functions, I
suspect.

You could do a *private* install of the module though, surely, on your
web host?

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/

[Magnus Lycka]

Aquarius wrote:

I appologize in advance for this strange (and possibly stupid)
question.

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionality?

I assume that MySQL clients talk to servers via sockets, and it should
be possible to write a python client that did that. It's probably some
work though, and it will probably piss MySQL AB off, since it means that
you could write MySQL client apps using whatever license you want
without paying them.

I wrote a prototype for such a client lib for PostgreSQL once, and it
was fairly simple, but the PostgreSQL docs have decent descriptions of
their protocol, while I assume MySQL hasn't since they want people to
use their client libs and pay for that. (If you read the client lib
source and translate that to Python, it should be considered a derivate,
and GPL applies. If you manage to get it to work without reading any
GPLed code, I guess you are entitled to use whatever license you want.)
Disclaimer: IANAL.

[Thomas Bartkus]

"Aquarius" <st**********@g mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

I appologize in advance for this strange (and possibly stupid)
question.

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionality?

Well, I'm looking at the source for the ever popular MySQLdb library. It
appears to be nothing but straight up Python source code. I see no reason
why you couldn't just take these modules and put them in your own private
directory. There is nothing secret here.

But

As others have already pointed out, after you go to this trouble, your
hosting provider will still suck! I'm sure you can you can get lot's of
suggestions for a suitable replacement.

Thomas Bartkus

[Steve Holden]

Thomas Bartkus wrote:

"Aquarius" <st**********@g mail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

I appologize in advance for this strange (and possibly stupid)
question.

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionality ?

Well, I'm looking at the source for the ever popular MySQLdb library. It
appears to be nothing but straight up Python source code. I see no reason
why you couldn't just take these modules and put them in your own private
directory. There is nothing secret here.

But

As others have already pointed out, after you go to this trouble, your
hosting provider will still suck! I'm sure you can you can get lot's of
suggestions for a suitable replacement.

I have a _mysql.c as a part of my distrbution of MySQLdb. Don't you?

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/

[Thomas Bartkus]

"Steve Holden" <st***@holdenwe b.com> wrote in message
news:ma******** *************** **************@ python.org...

Thomas Bartkus wrote:

Well, I'm looking at the source for the ever popular MySQLdb library. It
appears to be nothing but straight up Python source code. I see no reason

why you couldn't just take these modules and put them in your own private directory. There is nothing secret here.

I have a _mysql.c as a part of my distrbution of MySQLdb. Don't you?

You made me give that library a good hard stare.

And no - everything is enunciated in clear Python (.py) code with
corresponding (.pyc) and (.pyo). It appears we have Python source for
everything.

FWIW:

print MySQLdb.version _info

(1, 2, 0, 'final', 1)

There doesn't seem to be .c code to be found anywhere.
Thomas Bartkus

[Steve Holden]

Thomas Bartkus wrote:

"Steve Holden" <st***@holdenwe b.com> wrote in message
news:ma******** *************** **************@ python.org...

Thomas Bartkus wrote:

Well, I'm looking at the source for the ever popular MySQLdb library. It
appears to be nothing but straight up Python source code. I see no
reason
why you couldn't just take these modules and put them in your own
private
directory. There is nothing secret here.

I have a _mysql.c as a part of my distrbution of MySQLdb. Don't you?

You made me give that library a good hard stare.

And no - everything is enunciated in clear Python (.py) code with
corresponding (.pyc) and (.pyo). It appears we have Python source for
everything.

FWIW:

print MySQLdb.version _info

(1, 2, 0, 'final', 1)

OK. I saw that my own version was (1, 0, 0, 'final', 1), so I assumed
Andy's updated the package somewhat. However, downloading the source of
1.2 I see that _mysql.c still appears, and that the package's
__init__.py still includes the line

include _mysql

My C:\Python24\Lib \site-packages directory does contain a _mylsql.pyd
file. Would you like to check that we are talking about the same module?

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/

[Aquarius]

I am also have _mysql.c that has to be compiled. I downloaded 1.2.0
from here
http://sourceforge.net/project/showf...ckage_id=15775
(the .tar.gz). Do you mean, that if I drop the import _mysql and from
_mysql import ... lines everything will work OK? I "private install"
would be great for me, if it works :D

[Sion Arrowsmith]

Aquarius <st**********@g mail.com> wrote:

I want to know if there is a way to interface a MySQL database without
Python-MySQL or without installing anything that has C files that need
to be compiled. The reason for this, is that I want to develop a
certain web application, but my hosting provider (!#@$!@#%) isn't very
eager to supply Python-MySQL (or any modules to python). Is there an
alternative approach I could use to pass around this ridiculos lack of
functionalit y?

If you've got MySQL installed, you probably have a command-line
mysql client, and you could use subprocess or popen to run that.
That's a little desperate though, and the error handling will suck.
(I've seen this trick used with other databases.)

--
\S -- si***@chiark.gr eenend.org.uk -- http://www.chaos.org.uk/~sion/
___ | "Frankly I have no feelings towards penguins one way or the other"
\X/ | -- Arthur C. Clarke
her nu becomeþ se bera eadward ofdun hlæddre heafdes bæce bump bump bump