Hey Chris, this is exactly the sort of thing I would love to see more of. There are so many resources out there for building a rails app in development but very few resources like this to give us tips on production. Keep them coming! Thanks
Oh really good topic! I usually try to avoid it as much as I can, but there's always uses for it because you'll never be able to fully express SQL with an ORM.
I was just reading this post on doing trending posts in Postgres and it was one of those great places where you'd want to drop down to raw SQL to create those functions and things that you could reference later with ActiveRecord: http://sorentwo.com/2013/12...
I'll have to definitely do a screencast on this.
What do you guys think about the lol_dba?
I found it got all the basic relations I needed and then I built on top of. My apps production performance is crazy fast now!
Join 24,647+ developers who get early access to new screencasts, articles, guides, updates, and more.