RisingWave | Postgres-Compatible Streaming Database by cloudimg

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

RisingWave is a Postgres-compatible streaming database that replaces the need to deploy a separate stream-processing framework alongside a traditional database. Instead of learning a new query language, managing JVM-based infrastructure, or configuring a separate state backend, your team expresses real-time analytics as ordinary SQL and queries continuously-maintained results whenever needed.

Unlike architectures that require stitching together a message broker, a stream processor, and a serving database, RisingWave collapses these layers into a single process that speaks the PostgreSQL wire protocol. Any psql client or PostgreSQL driver connects unchanged - no new tooling, no retraining.

Consider a warehouse or e-commerce operation that needs accurate stock visibility across locations. With RisingWave you define a change-data-capture source capturing every inventory change, create materialized views that aggregate stock levels per SKU and location, and query the results with standard SQL. Stock counts stay incrementally up to date as changes stream in, preventing stockouts and overstock without batch ETL delays or custom application code.

Standing up RisingWave yourself means fetching and pinning the release binary, writing a standalone single-node configuration, deciding where the state store and metadata should live, binding the data plane so it is not exposed, adding password authentication that the default install does not enforce, and provisioning a dedicated disk for durable state. This image resolves every one of those decisions: launch an instance, read your unique password over SSH, and connect with any PostgreSQL client. A working streaming database is running within minutes of launch.

This image runs RisingWave in standalone single-node mode where one process hosts the meta, compute, frontend, and compactor components. There is no external cluster to provision and no separate object store to configure. The standalone state store and metadata are kept on the machine's own dedicated data volume. Point RisingWave at your streaming sources - Kafka, Kinesis, Redpanda, Pulsar, MQTT, and more.

RisingWave's state store and metadata live on a dedicated, independently resizable EBS data volume mounted at /var/lib/risingwave. Streams, tables, and materialized views persist across restarts, and the state volume can be grown independently of the operating-system disk.

Security is not an afterthought - this image ships with deliberate hardening:

• Loopback-only binding - the PostgreSQL wire protocol is never exposed to the network by default; access requires an SSH tunnel or an explicit security group change.
• Unique generated password - a per-instance password is created on first boot and enforced on the root user; anonymous and wrong-password connections are rejected.
• No default credentials - nothing is baked into the image.
• Dedicated system user - a non-root user owns the data directory and runs the daemon.
• systemd management - automatic restarts and clean logging.

1. Launch the instance from the AWS Marketplace listing.
2. SSH in and read the generated password from the root-only credentials file.
3. Connect with psql to the loopback Postgres wire on port 4566, database dev, user root.
4. Create a table, define a materialized view that aggregates over it, insert rows, and read the incrementally-maintained result.
5. Connect an external streaming source such as Kafka to ingest your own data.

cloudimg provides 24/7 technical support by email and chat covering deployment, connecting external streaming sources, sizing, tunnelling and remote access, TLS, and upgrades. For sizing guidance, email support@cloudimg.co.uk  with your expected event rate and source types.

RisingWave is distributed under the Apache License 2.0. All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.