Well, the assumption is that you don't need to because between migrations
and active record the SQL database itself is abstracted away. This is not
totally true but it is 95% of the time. I encourage you to try and see if
your problem can be solved this way first. If you still need to run raw
sql, you can do this...
ActiveRecord::Base.connection.execute("select * from ... ")
In the console for instance. A good reason to stay away from the sql is
that you become database agnostic. If you move your site from heroku to a
MySQL server nothing breaks, or if we offer an Oracle or SimpleDB in the
future you could use it without changing your code.
On Thu, Apr 10, 2008 at 11:56 PM, kweiner <[EMAIL PROTECTED]> wrote:
>
> Is it possible to run normal SQL commands against the PostgreSQL
> database associated with a Heroku app? I didn't see an option to do
> that.
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en
-~----------~----~----~----~------~----~------~--~---
