# Ruby on Rails and prepated statements

**URL:** <https://www.ruby-forum.com/t/ruby-on-rails-and-prepated-statements/172505>\
**Category:** Rails\
**Created:** [July 22, 2009, 3:17pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-prepated-statements/172505 "2009-07-22T15:17:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kronos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/aca169/32.png) [@kronos](https://www.ruby-forum.com/u/kronos)\
**Post date:** [July 22, 2009, 3:17pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-prepated-statements/172505/1 "2009-07-22T15:17:37Z")

</div>

It is knows that Ruby mysql driver supports prepared statements.  
Why do not active record adapters support them? Is there any reason  
for it?

---

<div class="post-metadata">

**Author:** ![kronos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/aca169/32.png) [@kronos](https://www.ruby-forum.com/u/kronos)\
**Post date:** [July 22, 2009, 11:24pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-and-prepated-statements/172505/2 "2009-07-22T23:24:52Z")

</div>

On Jul 22, 9:16 am, kronos [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> It is knows that Ruby mysql driver supports prepared statements.  
> Why do not active record adapters support them? Is there any reason  
> for it?

Well, ActiveRecord sort of _does_ support prepared statements, in the  
sense that parameterized queries are a type of prepared statement, and  
ActiveRecord uses parameterized queries. Are you looking for  
precompiled prepared statements? If so, perhaps stored procedures  
would be the way to go (although mySQL’s procedural language sucks)?

## Best,

Marnen Laibow-Koser  
[http://www.marnen.org](http://www.marnen.org)  
removed\_email\_address@domain.invalid