1.0is a PostgreSQL extension for high-performance time-series aggregation via continuous SQL queries.
1.0is now available for PostgreSQL
11and Docker. Visit the getting started docs or download a release package to get started.
- PipelineDB enables realtime reporting use cases at scale, where only summary data is needed
- The next release of PipelineDB will include partitioning automation
PipelineDB extends PostgreSQL by allowing you to define continuous views over streams of time-series data. The unique thing about continuous views is that they only store the aggregate output of their query definitions. Individual time-series events are discarded from memory as soon as all continuous views that must read them have done so. Eliminating the necessity of writing all events to disk before running queries over them enables PipelineDB to deliver extremely high performance for time-series aggregation workloads.Read the full post