does rails activerecord have any support for prepared statements? best I can tell -no.
A:
It has some support for it, shown in this guide, but it is only syntactic support, since the ActiveRecord replaces the question marks with their values before sending to the database.
Some people (here for example) seem(ed) to be busy with prepared statement support, but no available/working results seem to be integrated into rails yet.
Veger
2010-01-10 20:46:29
+1
A:
There are recent patches available to do this for mysql:
For Oracle, there are 2 related projects that seem like they do the trick:
plsql support http://github.com/rsim/ruby-plsql
more goodies when using Oracle and AR, with use of ruby-plsql gem for stored procs http://wiki.github.com/rsim/oracle-enhanced/
Andrew Kuklewicz
2010-01-10 22:51:05
Latest version of rails 2.3.5 has better stored proc support.
Andrew Kuklewicz
2010-01-21 06:26:07