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 »
There are only a few core concepts you need to know to start using Estuary Flow. We explain them with illustrations.
As we expand our beta program, Estuary is thrilled to announce our partnership with Rockset.
A comprehensive guide to change data capture in MySQL for cross-functional data teams.
A comprehensive guide to change data capture in PostgreSQL for cross-functional data teams.
Estuary Flow lets you synchronize data across all the systems you care about, with millisecond latency. What does that actually look like in practice? Here’s a simple — but powerful — example.
The simple concept of materialization can tell us a lot about how (and why) data is stored and represented. In this post: logs and tables; data loading and queries; exports, and more.
What if we could adapt MapReduce to real-time data processing? Spoiler: it’s awesome and we’re building a next-gen data platform based on it!
Batch and streaming usually require different architectures and building infrastructure, but shouldn’t.
