4 ms·
Looks useful, but it depends on PipelineDB, a PostgreSQL extension for streaming data. Unfortunately PipelineDB hasn't been updated since May 2019 [0] when they
by edraferi 6y ago
Looks useful, but it depends on PipelineDB, a PostgreSQL extension for streaming data. Unfortunately PipelineDB hasn't been updated since May 2019 [0] when they were acquired by Confluent [1]. The former PipelineDB team appears to be focused on Confluent's KSQL product [2]. There's an open source "ksqlDB" but it appears to depend on Kafka, so it's not a 1:1 replacement for PipelineDB[3].
[0] https://github.com/pipelinedb/pipelinedb https://github.com/pipelinedb/pipelinedb
[1] https://www.confluent.io/blog/pipelinedb-team-joins-confluent/ https://www.confluent.io/blog/pipelinedb-team-joins-confluen...
[2] https://www.confluent.io/blog/confluent-cloud-ksql-as-a-service/ https://www.confluent.io/blog/confluent-cloud-ksql-as-a-serv...
[3] https://ksqldb.io/quickstart.html https://ksqldb.io/quickstart.html
- rkwz 6y agoYes, I'm relying on the "continuous views" feature of PipelineDB which is like autorefreshing materialized views. I'm planning to swap PipelineDB with TimescaleDB in near future Most of the heavy lifting is done by Postgres/PipelineDB with Node.js as a simple wrapper so it's both performant and consumes less resources. http://docs.pipelinedb.com/continuous-views.html http://docs.pipelinedb.com/continuous-views.html https://docs.timescale.com/latest/using-timescaledb/continuous-aggregates https://docs.timescale.com/latest/using-timescaledb/continuo...