pg_trickle turns PostgreSQL 18 into a real-time data platform. Define stream tables on top of any base table and let the extension maintain materialized views incrementally — keeping only the delta in flight rather than recomputing the full result set. Built on a trigger-based CDC pipeline and a differential dataflow engine written in Rust, pg_trickle delivers sub-millisecond propagation latency with no external dependencies, no message broker, and no ETL pipeline. Your views stay fresh, your queries stay fast, and your data never leaves the database.
