Guides
Learn the key concepts behind Materialize and the streaming data ecosystem.

Aug 2, 2023
How to pull data from Materialize into Excel
Materialize is Postgres wire-compatible, so a standard Postgres ODBC driver can be used to pull data from Materialize into spreadsheets in Excel.

Jul 10, 2023
MySQL CDC with Debezium in Production
Use this guide to go beyond proof-of-concept and ship a complete log-based change data capture (CDC) pipeline from MySQL to Snowflake and Materialize.

Jul 1, 2023
Data Freshness, Defined.
What is Data Freshness? It depends on the context. Read on for a working definition of this concept in Data Engineering.

Mar 30, 2023
CDC in Production: An Operating Guide
We spent hours interviewing engineers running change data capture in production, and compiled a list of their planning tips, design patterns to use and footguns to avoid here.

Jan 4, 2023
What is a Streaming Database?
Get an overview of how streaming databases differ from traditional DBs. What are the tradeoffs? How are they used?

Mar 24, 2020
Incremental Computation in the Database
Incremental computation systems are used to make frequent compute-intensive tasks faster and more efficient in compilers, front-ends, and IDEs, but what does it look like at the data layer?

Mar 24, 2020
What is a Materialized View?
What is a materialized view, where can you use them, and how are they useful?

Feb 26, 2020
What is Streaming SQL?
Get a high-level overview of what Streaming SQL means, why it's useful, how it's being used in the real world, and how you can start using it yourself.