integrate
PipelineDB
integrate | PipelineDB | |
---|---|---|
1 | 3 | |
25 | 2,603 | |
- | 0.0% | |
2.7 | 0.0 | |
over 3 years ago | about 2 years ago | |
Elixir | C | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
integrate
-
Ask HN: Is there a way to subscribe to an SQL query for changes?
https://github.com/integratedb/integrate/blob/main/lib/integ...
These approaches rely on acking the WAL to confirm data has been processed. It’s simpler than running Debezium / Kafka for “zookept” CDC. However, they are “at least once” at best and it’s easy to shoot yourself in the foot so think twice before relying on this kind of thing for a real application.
Materialize is nice — TAIL is a lovely abstraction and their data ingest uses Debezium under the hood. That said, I believe their Postgres binlog source is still alpha / under active community dev.
PipelineDB
- PostgreSQL Is Enough
-
The database inside out with event streams
I was experimenting with continuous sql queries in postgres for the same purpose. https://github.com/pipelinedb/pipelinedb
-
Ask HN: Is there a way to subscribe to an SQL query for changes?
PipelineDB might be of interest. https://github.com/pipelinedb/pipelinedb
What are some alternatives?
db_watch
TinyDB - TinyDB is a lightweight document oriented database optimized for your happiness :)
rethinkdb_rebirth - The open-source database for the realtime web.
PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
noria - Fast web applications through dynamic, partially-stateful dataflow
pickleDB - pickleDB is an open source key-value store using Python's json module.
timely-dataflow - A modular implementation of timely dataflow in Rust
ZODB - Python object-oriented database
cainophile
MerkavaDB - A fast ordered NoSQL database.
GRDB.swift - A toolkit for SQLite databases, with a focus on application development
SSShelf - An ORM for S3