Seems like DBD::Pg and mysql both support bind_param().. but do they
really? Checking mysql API docs seems to suggest (unless I'm looking at
the beginner version) there aren't any functions to prepare statements.
I haven't looked at Postgres.
Can anyone confirm/deny?
Ah ha! (answering my own question):
http://dbi.symbolstone.org/cgi/summarydump?module=Msql-Mysql-modules
? is emulated
http://dbi.symbolstone.org/cgi/summarydump?module=DBD::Pg
Yes, "?" and ":1" styles (native)
Does anyone have any Real World experience with the speed-up (even
hand-wavy vague anecdotes) of using bind values v. reparsing the SQL
each time (for databases that support this obviously). Postgres and
Oracle I'm particularly interested in.
Paul
