similar to: Ruby on Rails Performance question

find_by_sql BREAKS THE OOP BEAUTY and perhaps we can solve that. NAMING CONVENTIONS can perhaps make find_by_sql much more clever. lets imagine that relation: publishers <- books <-> authors_books <-> authors -> universities (can''t find something else than university for that last association :) ) imagine we want to fetch every book and every associated

I was trying to do SUM based mySQL query simliar to the following: SELECT SUM(updated_on - created_on) AS total from signups If I were to run this command in the mySQL console I would get a result. However, if I were to run it using the following command in Rails: Signup.find_by_sql("SELECT SUM(updated_on - created_on) AS total from signups") The query that is written to the log is:

I am curious what you find is good and bad MVC design. Let''s use the find and find_by_sql methods as examples. Currently I have these spread out all over the place... View: here I have some find methods when I am for example populating a select list with choices in a form. Controller: here I have the simpler find methods. Model: here I have the more complicated find methods (usually

So apparently 1.8.4 is soon forthcoming. We need testing against it. Could someone help out with that? I believe Ara already checked into some of the issues, do you know if those are resolved, Ara? -- David Heinemeier Hansson http://www.loudthinking.com -- Broadcasting Brain http://www.basecamphq.com -- Online project management http://www.backpackit.com -- Personal information manager

Rails 1.1 was a big upgrade with a lot of new features and we''ve been working hard since its release to polish off the kinks revealed after it was deployed to the masses. Rails 1.1.1 contains fixes for things like Prototype memory leaks in IE 6, Oracle adapter runnings, and a number of compatibility tweaks to make most older applications work. This release still doesn''t work

Hello- I''m new to the ruby-based schemas and migrations. As I''m looking over examples and such online, I see that many of them don''t make use of schema-enforced attributes. For example, instead of: t.column "post_id", :integer, :default => 0, :null => false They do: t.column "post_id", :integer So I''m wondering -- is this

In java/c++ the method signature provide a good details on which parameters the method accept, but in rails the ability to send hash as parameters make it impossible to know which parameters can be send. This ability make the rails API doc a must to be full of details and not supply partial examples of usage. When for example I see *link_to_remote*(name, options = {}, html_options = {}) I would

Does anyone know how to view the new source in IE after an AJAX update? When I "view -> source" I get the original page source, not the page source as updated. Thanks in advance, Bill -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060403/e8d96b2e/attachment.html

Hi, I''m developing an application where I''ll have to store a lot of images coming from the users. And I''m still not sure if I should store them in MySQl as blob or just store them on filesystem. If I store them on filesystem, how to scale when I''ll have to have multiple servers ? Thanks, Pratik -- rm -rf / 2>/dev/null - http://null.in

Well, my entry for the 24-hour Rails Day competition is here: http://yubnub.org . It''s a web app called YubNub that implements the grandiose idea of a "command line for the Web OS". Type "gim porsche 911" to do a Google Image search for Porsche 911 cars. Type "random 1000" for a random number between 1 and 1000. Type "tts David Heinemeier Hansson is

Hi, I''d like to do a "find_by_sql" without a model (e.g. <model name>.find_by_sql("...")) as the results I get back are a once off special, and I''m happy to handle them as an array. How do I do this? "ActiveRecord::Base.find_by_sql(...)" does not seem to work? Background - At the moment I''m doing within a model <model_name>,

OK, I have some basic functionality to support bind variables, it appears to work with the ''old'' %s style too. I''ve altered sanitize_conditions in activerecord/lib/active_record/base.rb to check whether bind variables are in the statement (/\?/). If they are, replace all the ?s to escaped values from the arguments array. else santize and expand. There are a few

Hello folks, I use to think that a relational databases without foreign keys constraints enforced strictly by the RDBMS were no good, piece of crap, data junk. However, I''ve also learned the hard way that FKs constraints imposes serious difficulties when moving data around, specially between different DBs, or for loading test data or for upgrading DBs schemas, or for porting DBs

I have gotten acts_as_taggable to work for a test application as documented on taggable.rubyforge.org I am following Chad''s excellent examples in ROR Recipes Beta book. I have a few questions and hope that Chad or some other expert can help clarify them. 1. Why is the book suggesting to use taggings table instead of tags_contacts, as mentioned on taggable.rubyforge.org?

All, I am looking to write an ecommerce application and debating using rails or struts. Any advice as to which path to follow.

Hello, I submitted a patch <http://dev.rubyonrails.org/ticket/3287> ( http://dev.rubyonrails.org/ticket/3287) a couple of days ago. The patch adds some methods into and changes the existing methods in the CaptureHelper module. It should not, as I can see, affect any existing Rails implementations. I added the relevant unit tests and all but one of the tests pass. The test that fails failed

The cat is out of the bag, so here''s the full disclosure edition of the current security vulnerability. With Rails 1.1.0 through 1.1.5 (minus the short-lived 1.1.3), you can trigger the evaluation of Ruby code through the URL because of a bug in the routing code of Rails. This means that you can essentially take down a Rails process by starting something like /script/profiler, as the code

I''m working on a RoR project and a requirement has popped up that would required certain actions to happen at certain time intervals (as opposed to having a user initiate the action). Is there anything similar to Java''s Quartz library, *nix cron, or anything of the like for Rails? I''m certainly willing to help with/test Ruby code if someone on the list is already

Textdrive upgraded to Rails 1.1 already. I have an older rails app, and am now getting the following error: c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.0 /lib/active_support/depende ncies.rb:112:in `const_missing'': uninitialized constant LoadingModule (NameEr ror) from ./script/../config/environment.rb:91 from

I have a module that sends email to the members that have subscribed to my site. When it runs through and sends them all emails, it crashes with certain emails with: 550 <email-x+rxnKfQbAxWk0Htik3J/w@public.gmane.org>: Recipient address rejected: User unknown in virtual alias table This is on the other end right? And even so, is there a way to suppress it?