TLDR Dev · MISCELLANEOUS
YOU GOTTA PUSH IF YOU WANNA PULL
Summary from the TLDR Dev newsletter
Data management systems have historically been built around the notion of pull queries. This approach of pulling data works well, and it matches how people think and operate. However, there are some challenges with the approach: performance, data formats, data shape, and data location. These problems can be overcome with the help of materialized views. By materializing views incrementally and efficiently, you make your data available for pull-based querying in the right format and shape, at the right location.