Olivia Iannone

The problem with credit-based pricing for data platforms

When you choose the platforms and systems that comprise your modern data infrastructure, the pricing model is a major factor to consider.  Your data warehouse and data pipelines handle a ton of data every day, and they can quickly make or break your budget. Evaluating exactly how and why you’ll be charged is a crucial …

The problem with credit-based pricing for data platforms Read More »

screenshot of the Flow web app with a Postgres capture configured

How to create a real-time materialized view in PostgreSQL

PostgreSQL is a powerful open-source database that supports materialized views. Traditional materialized views are database objects that contain the results of a query — usually, a focused subset of a large dataset. They’re powerful optimization tools.  But what about materialized views of a real-time data feed? When you run a query at a set interval, …

How to create a real-time materialized view in PostgreSQL Read More »