Hello Users/Developers,

I have just committed support for prepared statements and MySQL embedded server support to CVS development branch Dev-2_9 (based off of 2.900x code) for DBD::mysql. You can get this code to try out via:

cvs -d :pserver:anon...@cvs.perl.org:/cvs/public login cvs -d :pserver:anon...@cvs.perl.org:/cvs/public co -rDev-2_9 modules/DBD-mysql

To use server side prepare statements, all you really need to do is set the value "mysql_server_prepare" in the connect string:

my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost: mysql_server_prepare=1", "","");

When you build DBD::mysql and run make test, after you first test without server side prepare statements, you can test with by exporting the environment variable MYSQL_SERVER_PREPARE

export MYSQL_SERVER_PREPARE=1

and then run 'make test' again. This stage will be improved in the future.

Also, for information about using the embedded server, please read the pod documentation found in the perl module itself.

For more information about prepared statements and how you can take advantage of them, please feel free to read my OSCON presentation:

http://patg.net/DBD.pdf

Kind regards,

"Whatever action a great man performs, common men follow. Whatever standards he sets by exemplary acts, all the world pursues" -- Bhagavad Gita