pipelinedb/pipelinedb

Health v2 · maintenance only

Adoption not part of the score

2662 stars · 243 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, letting you define continuous SQL queries that incrementally aggregate streaming data into queryable tables. It stores only aggregate output rather than raw events, acting like high-throughput, auto-refreshing materialized views.

Use cases

• run continuous SQL aggregations over streaming event data in PostgreSQL
• build realtime reporting dashboards without a separate stream processor
• compute rolling time-series metrics like counts and averages at high throughput
• chain continuous queries into pipelines of incremental SQL transforms
• avoid storing raw event data while keeping aggregates queryable

When to choose

• you already run PostgreSQL and want stream aggregation without extra infrastructure
• you need high-throughput incremental aggregation of time-series data
• you want SQL-based continuous views instead of learning a new stream-processing system
• you only need aggregate outputs, not raw event storage

When to avoid

• you need a project with active development and new releases (it is in maintenance mode after joining Confluent)
• you need PostgreSQL 12 or newer (only PG 10 and 11 are supported)
• you need full stream processing features like exactly-once semantics across distributed sources
• you want to retain raw event data long-term

Facets

library · maturity maintenance

database streaming analytics etl databases analytics big-data time-series self-hosted postgresql-extension continuous-queries time-series-aggregation materialized-views stream-processing sql real-time linux macos web-server

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pipelinedb/pipelinedb")