Announcement: prepared statement and embedded server support on Dev-2_9 CVS

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:anonymous@cvs.perl.org:/cvs/public login
cvs -d :pserver:anonymous@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,

Patrick Galbraith

Patrick Galbraith Senior Software Developer
patg@mysql.com http://www.mysql.com

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


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org