No Application Code
PipelineDB enables realtime data processing using only SQL. Our continuous query planner and execution engine handle all of the complexity of running realtime computation on streams.
PipelineDB is built into the PostgreSQL core and can be used as a drop in replacement for PostgreSQL without making any application code changes. It comes pre-installed with PostGIS and supports all other extensions too.
PipelineDB eliminates the ETL layer. Stream granular data directly into the database and continuously distill it with the SQL queries you’ve declared.
Efficient and Sustainable
PipelineDB stores only the output of continuous queries, which are incrementally updated as data is ingested. The database’s size is independent of the amount of data ingested over time.
What it Can Do
Continuously aggregate, filter, and distill streaming data into summary data in realtime with continuous SQL queries and store the results in PipelineDB.
Sliding Window Queries
Run continuous queries over custom time windows (1 second, 1 minute, 1 day, 30 days, etc.) and then either store the windowed query results in PipelineDB or discard the raw data after the window time has passed.
Joining Streams on Tables
Streaming analytic data oftentimes needs context. PipelineDB’s integrated relational storage engine enables you to join streaming data on historical data for comparison and analysis in realtime.
Probabilistic Data Structures
Oftentimes 100% accuracy tradeoffs in exchange for speed are acceptable with realtime analytics at scale. PipelineDB supports data structures and algorithms such as Bloom filters, count-min sketch, Filtered-Space-Saving top-k, HyperLogLog, and t-digest for very accurate approximations on high-volume streams.
How It Works
|10 + 5|