When a CTE makes a Postgres query faster
What a WITH clause changes in the plan, measured on 2 million rows, and how to write the same queries in Rails.
rails
3 posts
How to Use Postgres to Calculate and Save Rankings
When you need to calculate rank and save it to a field in Postgres. This example uses Rails ActiveRecord but if you can execute the query you are...
Is Rails Scalable?
Being an optimist I would say, Yes! Having worked on a large scale high visibility site I've personally seen it happen, so definitely Yes! When the budget was...