Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eweka.nl!lightspeed.eweka.nl!194.134.4.91.MISMATCH!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
MIME-Version: 1.0
Date: Tue, 8 Jan 2013 13:45:51 +0100
Subject: Newbe accessing MySQL, need something like perl's prepare_cached
From: Morten Guldager <morten.guldager@gmail.com>
To: python-list@python.org
Content-Type: multipart/alternative; boundary=f46d040169136cb2c704d2c65330
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.271.1357649160.2939.python-list@python.org>
Lines: 50
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:36426

--f46d040169136cb2c704d2c65330
Content-Type: text/plain; charset=ISO-8859-1

'Aloha Friends!

Still quite new to python I'm trying to access a MySQL database. Being a
former perl programmer I recognize much of the semantics going on.

Create a database handle, compile a piece of SQL and put it into a cursor,
run the query and use the result. exactly the same flow as I am used to.
And it works just fine.

But as programs grow larger, it is sometimes becomes a burden to compile
those SQL's over and over again when they should be perfectly reusable.
 And implementing a "query cache" by myself seems not to be the right thing
in this batteries included environment.

Donno exactly what I'm looking for, but the perl equivalent is
called prepare_cached.

Oh, by the way, I'm using "import MySQLdb", hope that's not the most
outdated, inefficient and stupid choice for a MySQL library...

-- 
/Morten %-)

--f46d040169136cb2c704d2c65330
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

&#39;Aloha Friends!<div><br></div><div>Still quite new to python I&#39;m tr=
ying to access a MySQL database. Being a former perl programmer I recognize=
 much of the semantics going on.</div><div><br></div><div>Create a database=
 handle, compile a piece of SQL and put it into a cursor, run the query and=
 use the result. exactly the same flow as I am used to. And it works just f=
ine.</div>
<div><br></div><div>But as programs grow larger, it is sometimes becomes a =
burden to compile those SQL&#39;s over and over again when they should be p=
erfectly reusable. =A0And implementing a &quot;query cache&quot; by myself =
seems not to be the right thing in this batteries included environment.=A0<=
/div>
<div><br></div><div>Donno exactly what I&#39;m looking for, but the perl=A0=
equivalent is called=A0prepare_cached.</div><div><div><div><br></div><div>O=
h, by the way, I&#39;m using &quot;import MySQLdb&quot;, hope that&#39;s no=
t the most outdated, inefficient and stupid choice for a MySQL library...</=
div>
<div><br></div>-- <br>/Morten %-)=20
</div></div>

--f46d040169136cb2c704d2c65330--