delicious

Effectively Using Materialized Views in Ruby on Rails

A murb'ed feed, posted about one month ago filed in PostgreSQL, postgres, ruby on rails & rails.

It’s every developer’s nightmare: SQL queries that get large and unwieldy. This can happen fairly quickly with the addition of multiple joins, a subquery and some complicated filtering logic. I have personally seen queries grow to nearly one hundred lines long in both the financial services and health industries.

Luckily Postgres provides two ways to encapsulate large queries: Views and Materialized Views. In this article, we will cover in detail how to utilize both views and materialized views within Ruby on Rails, and we can even take a look at creating and modifying them with database migrations.

A tutorial that shows how to use materialized views using the Scenic-gem

Go to the original link.