Databases
StackOverflow2013
Postsdbo
POWhy are stored procedures still not supported in Rails (3+)?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy are stored procedures still not supported in Rails (3+)?
    primarykey
    data
    text
    <p>I am familiar with the long standing love-hate relationship between Ruby on Rails, DB(MS)-drivers and Stored Procedures and I have been developing Rails applications since version 2.3.2.</p> <p>However, every once in a while a situation arises where a SP is simply a better choice than combining data on the (much slower) application level. Specifically, running reports which combines data from multiple tables is usually better suited for a SP.</p> <p>Why are stored procedures still so poorly integrated into Rails or the MySQL gem. I am currently working on a project with Rails 3.0.10 and MySQL2 gem 0.2.13 but as far as I can see, even the latest Edge Rails and MySQL gem 0.3+ still throw tantrums when you use SPs.</p> <p>The problem which has been, and still is, is that the database connection is lost after a SP is called.</p> <pre><code>&gt;&gt; ActiveRecord::Base.connection.execute("CALL stored_proc") =&gt; #&lt;Mysql::Result:0x103429c90&gt; &gt;&gt; ActiveRecord::Base.connection.execute("CALL stored_proc") ActiveRecord::StatementInvalid: Mysql::Error: Commands out of sync; [...] &gt;&gt; ActiveRecord::Base.connection.active? =&gt; false &gt;&gt; ActiveRecord::Base.connection.reconnect! =&gt; nil &gt;&gt; ActiveRecord::Base.connection.execute("CALL proc01") =&gt; #&lt;Mysql::Result:0x1034102e0&gt; &gt;&gt; ActiveRecord::Base.connection.active? =&gt; false </code></pre> <p>Is this a really difficult problem to tackle, technically, or is this a design choice by Rails?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USChrisDekker
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhy are stored procedures still not supported in Rails (3+)?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhy are stored procedures still not supported in Rails (3+)?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhy are stored procedures still not supported in Rails (3+)?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COFWIW: From Feb 2006, DHH interview: "I’m entirely uninterested in fancy features like stored procedures, triggers, and the like" -- http://dev.mysql.com/tech-resources/interviews/david-heinemeier-hansson-rails.html
      singulars
      1. POWhy are stored procedures still not supported in Rails (3+)?
      1. USJesse Wolgamott
    2. COAlso ["I consider stored procedures and constraints vile and reckless destroyers of coherence"](http://web.archive.org/web/20060418215514/http://www.loudthinking.com/arc/000516.html)...
      singulars
      1. POWhy are stored procedures still not supported in Rails (3+)?
      1. USdbr
    3. CO2006... Ancient principles (yes, 6 years is ancient in a world like Rails') rarely hold meaning against the evolution of technology (640k is enough, anyone?) There is the theoretical and practical domain. In theory I absolutely stand by the Rails paradigm, but sometimes the best normalized database gives the worst performance in the real world. When a SP can gather the data for my report in less than 100ms and doing it 'the Rails way' takes over 2-3 seconds and multiple queries fired at a shared database, I know who the clear winner is.
      singulars
      1. POWhy are stored procedures still not supported in Rails (3+)?
      1. USChrisDekker
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload