pg_ivm
risingwave
pg_ivm | risingwave | |
---|---|---|
19 | 27 | |
774 | 6,309 | |
9.9% | 5.4% | |
6.3 | 10.0 | |
about 1 month ago | 4 days ago | |
C | Rust | |
GNU General Public License v3.0 or later | 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.
pg_ivm
- Postgres is eating the database world
-
What Is Incremental View Maintenance (IVM)?
FTA, because I don't like Jeopardy questions in headlines:
“Incremental View Maintenance (IVM) provides a method for keeping materialized views current by calculating and applying only the incremental changes, as opposed to the complete recomputation of contents performed by the REFRESH MATERIALIZED VIEW command.”
Article shows using the pg_ivm Postgres extension available here: https://github.com/sraoss/pg_ivm
- Pg_ivm: Incremental View Maintenance as a Postgres Extension
- Anyone have experience with incremental materialized views in postgres?
- Incremental View Maintenance for PostgreSQL
-
a temporary-ish table vs materialize view?
There is an extension that provides some limited incremental MVIEW refresh: https://github.com/sraoss/pg_ivm
- Features I'd Like in PostgreSQL
- IVM (Incremental View Maintenance) Implementation as a PostgreSQL Extension
-
Materialized View: SQL Queries on Steroids
There’s awesome work being done on incremental view maintenance in postgres:
https://github.com/sraoss/pg_ivm
-
Should I replace all db select query REST APIs with a single generic router ?
It makes sense to perform managed denormalization - use a materialized view or automatically refresh a table or foreign server (via FDW) using common triggers (like pg_ivm does). And it's fine to add a TTL to it and use as a read store... update on user login and make a partial index just for that. And that's how you could get CQRS...
risingwave
-
Proton, a fast and lightweight alternative to Apache Flink
How does this compare to RisingWave and Materialize?
https://github.com/risingwavelabs/risingwave
-
RisingWave's Roadmap - Redefining Stream Processing with the Rust-Built Streaming Database
Hey everyone - One and a half year ago, we open sourced RisingWave, a Rust-built streaming database, under Apache 2.0 license. Two weeks ago, we released RisingWave 1.3. Just last week, we unveiled RisingWave's roadmap.
- Risingwave: Redefining Stream Processing
-
Highlights of RisingWave v1.3: The Open-Source Streaming Database
Look out for next month’s edition to see what new, exciting features will be added. Check out the RisingWave GitHub repository to stay up to date on the newest features and planned releases.
- Optimizing Rust Code for the Lsm-Tree Iterator in RisingWave
- Hummock: A Storage Engine Designed for Stream Processing
-
RisingWave 1.2 released - the open-source streaming database built in Rust
If interested, please feel free to join our Slack community! Thanks eveyone for your generous support!
-
Query materialized views with Java, Spring, and streaming database
We will spin up on our local environment the existing RisingWave fully-featured demo cluster on GitHub which is composed of multiple RisingWave components. To simplify this task, it leverages docker-compose.yaml file which includes additional containers for Kafka message broker, and data generation service.
-
Real-time Data Processing Pipeline With MongoDB, Kafka, Debezium And RisingWave
To complete the steps in this guide, you must download/clone and work on an existing sample project on GitHub. The project uses Docker for convenience and consistency. It provides a containerized development environment that includes the services you need to build the sample data pipeline.
-
Flink CDC / alternatives
Hey have you looked at RisingWave (https://github.com/risingwavelabs/risingwave) before? It's a stream processing system with PostgreSQL interface. It also have integrations similar to Flink CDC.
What are some alternatives?
prawn-stack - A pageview counter using the AWS free tier, Postgres, Node and React
materialize - The data warehouse for operational workloads.
datafuse - An elastic and reliable Cloud Warehouse, offers Blazing Fast Query and combines Elasticity, Simplicity, Low cost of the Cloud, built to make the Data Cloud easy [Moved to: https://github.com/datafuselabs/databend]
pg_hint_plan - Extension adding support for optimizer hints in PostgreSQL
ksql - The database purpose-built for stream processing applications.
contour - Contour is a Kubernetes ingress controller using Envoy proxy.
greptimedb - An open-source, cloud-native, distributed time-series database with PromQL/SQL/Python supported. Available on GreptimeCloud.
pg_jsonschema - PostgreSQL extension providing JSON Schema validation
chdb - chDB is an embedded OLAP SQL Engine 🚀 powered by ClickHouse
OpenLogReplicator - Open Source Oracle database CDC
roapi - Create full-fledged APIs for slowly moving datasets without writing a single line of code.