Categories
Database Data Engineering Real-Time Analytics PostgreSQL Stream Processing Event Streaming Streaming DatabaseStars
Forks
Watchers
Developer links
RisingWave
With over 9,100 GitHub stars and production deployments powering real-time analytics at companies like SHOPLINE where it reduced API latency by 76.7%, RisingWave is the PostgreSQL-compatible streaming database that collapses the traditional Debezium-plus-Kafka-plus-Flink-plus-serving-database stack into a single Rust-powered system. The platform continuously ingests data from PostgreSQL and MySQL via native CDC connectors that eliminate Debezium middleware, consumes Kafka, Redpanda, Pulsar, and Kinesis topics, accepts webhook events from SaaS applications, and batch-loads historical data from S3 and data warehouses. Standard SQL defines sources, materialized views, and sinks — no new DSL, no Java, and no custom API — while the PostgreSQL wire protocol means psql, DBeaver, pgAdmin, Grafana, Metabase, Superset, Tableau, and every PostgreSQL client library works without modification. Materialized views are incrementally maintained as events arrive, delivering point lookups in single-digit milliseconds without recomputing aggregates from scratch. For long-term retention, RisingWave writes to Apache Iceberg tables with a hosted REST catalog and automated table maintenance including compaction, small-file optimization, and snapshot cleanup, with data queryable by Spark, Trino, DuckDB, and DataFusion. The disaggregated compute-storage architecture uses S3-based state management for elastic scaling, instant failure recovery measured in seconds rather than the minutes-to-hours typical of RocksDB-based systems, and cost-efficient storage tiering. An MCP server enables AI agents to query and operate RisingWave directly. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. Apache 2.0 licensed.
Benefits
- Replace Four Tools With One
- Eliminate Debezium, Kafka, Flink, and a serving database by using RisingWave as a single streaming platform that ingests, processes, stores, and serves real-time data natively.
- Full PostgreSQL Wire Protocol Compatibility
- Connect with psql, JDBC, pgAdmin, DBeaver, Grafana, Metabase, and Superset using existing PostgreSQL drivers, ORMs, and SQL skills without learning a new query language.
- Sub-Millisecond Materialized View Lookups
- Query incrementally maintained materialized views with single-digit millisecond latency for point lookups, avoiding full recomputation of aggregates on each request.
- Apache Iceberg Long-Term Lake Storage
- Write streaming results to Iceberg tables with automated compaction, snapshot cleanup, and a hosted REST catalog, keeping data queryable by Spark, Trino, and DuckDB.
Features
- Native CDC Connectors
- Ingest change data capture from PostgreSQL and MySQL transaction logs directly without Debezium or Kafka middleware, simplifying real-time replication pipelines.
- Multi-Source Event Ingestion
- Consume events from Kafka, Redpanda, Pulsar, Kinesis, S3, webhooks, and SaaS applications through a unified SQL-based source definition interface.
- Disaggregated Compute-Storage Architecture
- Scale compute and storage independently using S3-based state management with elastic scaling, instant failure recovery, and cost-efficient storage tiering.
- Streaming SQL Pipeline Definition
- Define sources, materialized views, sinks, and streaming joins using standard PostgreSQL-compatible SQL with window functions, CTEs, and aggregations.
- AI Agent MCP Server Integration
- Enable AI agents to query materialized views and operate streaming pipelines directly through the built-in Model Context Protocol server and CLI skills.