#Materialized-Views
2 notas · última:
Speeding up Queries with Materialized Views
Explains how to speed up read-heavy systems by precomputing and persisting query-optimized materialized views, using CQRS, async updates, and event streams/projections.
Spectacles
Spectacles adds database view support to ActiveRecord, with migrations, an abstract view class, and support for several database drivers. It also offers PostgreSQL materialized views with refresh and creation options.
