Using a Materialized View with API Platform?
summary
Shows how to connect an API Platform Resource to a database materialized view to speed up slow read queries that involve complex calculations or many joins, demonstrating the setup and usage in API Platform and discussing when this approach is useful and its limitations.
AI-written summary · about
chapters (9)
- 0:00Start
- 1:17Introduction of Damien
- 2:53What is a Materialized View?
- 8:24Advantages and Disadvantages
- 11:28Where did the idea come from?
- 17:06Creating and Deleting Views
- 21:51The Extra Properties
- 25:20What's Next?
- 27:14Demo Example
related talks
35mHarnessing the Power of Materialised Views in Cosmos DB
37mContinuous Aggregates A Use Case of Materialized Views
45mpg_ivm - Extensions for Rapid Materialized View Update
41mUsing Databases to Pull Your Application Weight
42mThe future of API (Platform) architecture
02h 00mTutorial
26mServing Data as API
28mSimplify data analysis using analytic views