PostgreSQL

PostgreSQL Compatible Streaming Database

RisingWave is wire-compatible with PostgreSQL. Use psql, JDBC, psycopg2, any PostgreSQL tool. Same SQL you know. Real-time speed.

Start Free CDC Streaming

PostgreSQL

Wire Compatible

Same protocol, same drivers, same tools — zero migration friction

Sub-100ms

Streaming Latency

Continuous queries deliver millisecond freshness, not hourly batch refreshes

Auto

View Refresh

Materialized views update automatically as data streams in — no manual REFRESH

Standard

SQL Syntax

Joins, aggregations, window functions, CTEs — the SQL you already know

Why RisingWave

How does RisingWave differ from PostgreSQL for streaming use cases?

PostgreSQL processes static data at rest with batch queries. RisingWave processes streams in motion with continuous queries. Data freshness improves from hours/minutes to milliseconds. View refreshes are automatic rather than manual. Latency drops from seconds/minutes to milliseconds, enabling real-time applications.

Factor	PostgreSQL	RisingWave
Data Type	Batch (at-rest)	Streams (in-motion)
Freshness	Hours/minutes	Milliseconds
View Refresh	Manual REFRESH	Automatic (real-time)
Latency	Seconds to minutes	Milliseconds
Wire Protocol	PostgreSQL	PostgreSQL compatible
Your Tools	psql, JDBC, etc.	psql, JDBC, etc. (same!)

→Same SQL syntax — no new language to learn
→Same drivers and tools — psql, JDBC, psycopg2 all work unchanged
→Continuous queries instead of periodic REFRESH commands
→Millisecond freshness instead of stale batch data

Compatibility

Which PostgreSQL tools work with RisingWave?

RisingWave supports all standard PostgreSQL clients because it implements the PostgreSQL wire protocol. Connect using your favorite tools: command-line clients, language drivers, BI platforms, and monitoring tools all work out of the box.

psql

Command-line interface — connect to RisingWave exactly like PostgreSQL

JDBC

Java applications connect with standard PostgreSQL JDBC drivers

psycopg2

Python applications use the same PostgreSQL driver for streaming queries

Superset / Grafana

BI dashboards and monitoring tools connect without any configuration changes

Migration

How do I migrate from PostgreSQL to RisingWave?

Keep your PostgreSQL database running. RisingWave ingests changes via Change Data Capture (CDC) — capturing every INSERT, UPDATE, DELETE in real-time. No extraction, no ETL downtime, no data loss. Your schema evolves alongside your PostgreSQL source.

→Keep PostgreSQL as your primary database — no disruption
→CDC captures every change in real-time from WAL logs
→No ETL pipelines, no batch scheduling, no data staleness
→Schema evolution happens automatically as source tables change
→Start querying streaming data with the same psql commands
→Materialized views update continuously — no manual REFRESH

Frequently Asked Questions

Is RisingWave fully PostgreSQL compatible?

Can I use my existing PostgreSQL tools with RisingWave?

How do I migrate from PostgreSQL to RisingWave?

What SQL features does RisingWave support?

Ready to experience PostgreSQL speed?

Start streaming with the SQL you already know.

Get Started

CDC Streaming →Stream Without Java →