Newbe accessing MySQL, need something like perl's prepare_cached
morten.guldager at gmail.com
Tue Jan 8 13:45:51 CET 2013
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
Oh, by the way, I'm using "import MySQLdb", hope that's not the most
outdated, inefficient and stupid choice for a MySQL library...
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Python-list