RisingWave
risingwave.com
- Free plan
- macOS
- Linux
- Web
- API
- Self-hosted
What RisingWave is
RisingWave is a distributed SQL streaming platform for ingesting, transforming, and serving real-time data. Its SQL interface is wire-compatible with PostgreSQL, allowing PostgreSQL clients, drivers, and tools to connect. Materialized views refresh automatically and are computed incrementally as events arrive. Barrier-based checkpointing and consistent snapshots support exactly-once processing; data is persisted in S3-compatible object storage, with connector offsets checkpointed for durability and delivery. RisingWave lists 31+ native connectors, including Kafka, PostgreSQL, MySQL, Iceberg, Snowflake, BigQuery, S3, Redis, and Elasticsearch. Self-managed deployments are Apache 2.0 open source without feature gates, license fees, or usage restrictions, and can run with Docker, Kubernetes, cloud VMs, or on-premises bare-metal servers. Hosted Basic is available at $0.23 a month on a pay-as-you-go basis, is limited to 64 cores, and is available in select regions; a free plan and 7-day trial are also listed. Pro offers premium 24x7 support as an option, while self-managed deployments have premium support with SLA and quarterly success reviews.
Who it suits
RisingWave suits teams building streaming data workflows with SQL and PostgreSQL-compatible tools. It offers hosted and self-managed deployment options for teams with different operating needs.
Good to know, and what to watch
- PostgreSQL-compatible SQL interface
- Materialized views update incrementally as events arrive
- Supports exactly-once processing
- Lists 31+ native connectors
- Self-managed version has no feature gates or usage restrictions
- Hosted Basic is limited to 64 cores
- Basic is available only in select regions
- The local playground stops after 30 minutes of inactivity
- Premium 24x7 support on Pro is an optional purchase
Plans
Every plan and pricePro
Self-managed
Basic
7-day trial
Getting started
- Open the RisingWave website
- Choose hosted Basic, Pro, or self-managed deployment
- Use the web or API access, or deploy on Linux, macOS, Docker, Kubernetes, cloud VMs, or bare metal
- Connect data sources through a native connector
- Use PostgreSQL clients, drivers, or tools with the SQL interface
Limits to check
The Basic plan is fully hosted, limited to 64 cores, and available only in select regions. The single-node local playground runs in memory and stops automatically after 30 minutes without activity.
The Club's review
Overview
RisingWave is a distributed SQL platform for processing live data streams and serving current results. It suits data teams that want PostgreSQL-compatible SQL, incremental materialized views, and deployment choices ranging from a hosted service to on-premises infrastructure. The main decision is whether Basic's hosted limits are enough or whether your workload warrants premium features and operational control.
Founded in 2021 and headquartered in San Francisco, RisingWave supports hybrid deployment across API, web, Linux, and macOS environments. It combines stream processing, a schema registry, and exactly-once delivery for applications and pipelines that cannot wait for batch refreshes.
Key features
SQL and incremental views
The wire-compatible PostgreSQL interface works with PostgreSQL clients, drivers, and tools, reducing friction for teams already using that ecosystem. Materialized views are recomputed incrementally as events arrive, keeping derived results current without repeatedly rebuilding the full dataset. The dbt-risingwave adapter adds a materialized_view materialization for continuously updated streaming transformations, which is useful for analytics teams bringing dbt practices to event data.
Reliable processing and storage
Barrier-based checkpointing and consistent snapshots support an exactly-once processing guarantee. RisingWave stores data in S3-compatible object storage and checkpoints connector offsets, providing durable state and exactly-once delivery across connected systems. That combination is valuable where duplicate events or lost progress would create material business errors.
Connectors and premium functions
More than 31 native connectors cover systems including Kafka, PostgreSQL, MySQL, Iceberg, Snowflake, BigQuery, S3, Redis, and Elasticsearch. This breadth supports mixed source and sink architectures rather than forcing a Kafka-only design. Premium tiers add SQL Server CDC, Snowflake and BigQuery sinks, time-travel queries, automatic schema evolution, SSO, LDAP governance, and OTEL integration; those capabilities matter to regulated, larger, or observability-focused deployments.
Security
Security controls include TLS/SSL in transit, S3 encryption at rest, certificate or password authentication, role-based grants, and SQL-based data masking. These are practical controls for protecting streaming pipelines, though the higher-end governance features are reserved for premium plans.
Pricing
Basic
Basic costs $0.23 a month on pay-as-you-go billing. It is fully hosted on AWS, GCP, or Azure, includes standard support, and allows up to 64 cores in select regions. A seven-day trial and free plan make it a low-cost way to start, but the core ceiling and regional availability can rule it out for larger or globally constrained workloads.
Pro
Pro uses pay-as-you-go or annual-contract billing with custom pricing. It supports fully hosted or bring-your-own-cloud deployment, removes core limits, and includes premium features. Premium 24x7 support is available for purchase, making Pro the hosted choice for teams that need scale or advanced governance without operating the entire platform.
Self-managed
Self-managed pricing is a custom annual contract. On-premises or Kubernetes deployments have no core limits and include premium features, premium support, and an SLA. This is aimed at organizations able to run infrastructure and willing to trade Basic's simplicity for control and service commitments.
The local single-node playground runs in memory and stops automatically after 30 minutes of inactivity, so it is suited to short evaluations rather than persistent workloads.
Platforms
RisingWave is available through API and web interfaces, on Linux and macOS, and as self-hosted software. Self-managed installations support Docker, Kubernetes with Helm charts, cloud VMs, and on-premises bare-metal servers. Supported client languages include Python, Java, and Node.js.
Who it's for
Choose RisingWave for streaming applications, operational analytics, and data pipelines that need SQL access to continuously changing results. It is especially suitable for PostgreSQL-oriented teams, organizations integrating several databases and warehouses, and companies requiring exactly-once semantics. It is less suitable when a simple event broker is all you need, or when a 64-core hosted ceiling cannot accommodate growth and self-management is undesirable.
Pros and cons
- Pros: PostgreSQL-compatible SQL lowers client integration effort.
- Pros: Incremental materialized views keep results current as events arrive.
- Pros: Exactly-once processing, durable object-storage persistence, and checkpointed offsets protect correctness.
- Pros: 31+ connectors cover major streaming, database, warehouse, and storage systems.
- Pros: Apache 2.0 self-managed software has no feature gates, license fees, or usage restrictions.
- Cons: Basic is limited to 64 cores and select regions.
- Cons: Premium capabilities and stronger support require Pro or self-managed contracts.
- Cons: Self-managed operation requires responsibility for Docker, Kubernetes, VM, or bare-metal deployment.
Alternatives
For a broader directory of event brokers and streaming tools, see Event Streaming Platforms, Streaming Analytics Software, and Stream Processing Software.
- Lightstreamer is a freemium option with a free demo capped at 20 concurrent client connections and broad client-platform support.
- Aiven for Apache Kafka fits teams wanting managed Kafka with a free tier limited to 250 KiB/s, three days' retention, five topics, and two partitions per topic.
- Confluent Cloud is an alternative managed Kafka service with a free Basic plan, autoscaling resources, and more than 80 managed connectors.
- Solace PubSub+ Event Broker offers a 30-day cloud event-broker trial.
- Apache Pulsar and Apache RocketMQ are free Apache-licensed open-source options.
- Redpanda provides paid serverless and bring-your-own-cloud deployments with a free plan.
- DataStax Astra Streaming offers a free tier and usage-based paid plans.
Verdict
RisingWave is a strong choice for teams that need PostgreSQL-style SQL over live data, incrementally maintained views, and exactly-once pipelines across many connectors. Look elsewhere if you only need a lightweight broker, cannot accept Basic's 64-core hosted limit, or do not want the operational burden of self-managed deployment.
The verdict
RisingWave combines streaming SQL with incremental materialized views and a broad connector list. Consider the hosted Basic limits or the operational needs of self-managed deployment before deciding.
Questions people ask
Is RisingWave open source?
Self-managed RisingWave is Apache 2.0 open source, with no feature gates, license fees, or usage restrictions.
What does Basic cost?
The Basic plan costs $0.23 a month, billed pay-as-you-go, and is fully hosted on AWS, GCP, or Azure.
Is there a free option or trial?
A free plan and a 7-day trial are listed.
Which platforms are supported?
Platforms include API, Linux, macOS, self-hosted, and web. Self-managed deployments support Docker, Kubernetes with Helm charts, cloud VMs, and on-premises bare metal.
What connectors are available?
RisingWave lists 31+ native connectors, including Kafka, PostgreSQL, MySQL, Iceberg, Snowflake, BigQuery, S3, Redis, and Elasticsearch.
Which languages can clients use?
Supported client languages are Python, Java, and Node.js.
What the maker publishes
- Basic limit
- The Basic plan is fully hosted, limited to 64 cores, and available in select regions. source
- Connectors
- RisingWave provides 31+ native connectors, including Kafka, PostgreSQL, MySQL, Iceberg, Snowflake, BigQuery, S3, Redis, and Elasticsearch. source
- Consistency
- RisingWave guarantees exactly-once processing with barrier-based checkpointing and consistent snapshots. source
- dbt integration
- The dbt-risingwave adapter provides a materialized_view materialization for continuously updated streaming transformations. source
- Deployment
- Self-managed deployments support Docker, Kubernetes with Helm charts, cloud VMs, and on-premises bare-metal servers. source
- Founded
- 2021 source
- Headquarters
- San Francisco, California, United States source
- Local playground
- The single-node playground runs in memory and automatically stops after 30 minutes of inactivity. source
- Materialized views
- Materialized views are automatically refreshed and incrementally computed whenever new events arrive. source
- Open source
- Self-managed RisingWave is Apache 2.0 open source with no feature gates, license fees, or usage restrictions. source
- Persistence
- RisingWave persists data in S3-compatible object storage and checkpoints connector offsets for durability and exactly-once delivery. source
- Premium capabilities
- Premium capabilities include SQL Server CDC, Snowflake and BigQuery sinks, time travel queries, automatic schema evolution, SSO, LDAP governance, and OTEL integration. source
- Product
- RisingWave is a distributed SQL streaming platform that ingests, transforms, and serves real-time data. source
- Security
- RisingWave security guidance covers TLS/SSL in transit, S3 encryption at rest, certificate or password authentication, role-based grants, and SQL-based data masking. source
- SQL interface
- RisingWave is wire-compatible with PostgreSQL and works with PostgreSQL clients, drivers, and tools. source
- Support
- RisingWave offers standard support on Basic, premium 24x7 support as an option on Pro, and premium support with SLA and quarterly success reviews for self-managed deployments. source
Checked against the maker's pages on 1 Oct 2026.