Can a stream database like RisingWave be used in traditional enterprise applications?

I'm curious about the practical use cases of stream databases in enterprise applications beyond the typical scenarios like machine data and real-time analytics. Specifically, I'm interested in understanding if there's a need for streaming database capabilities in more 'traditional' enterprise use cases. Here's an example of my current setup:

  1. Three-tier application architecture, such as Ruby on Rails / Django with PostgreSQL databases.
  2. Analytics data warehouse is Snowflake, with an ELT pipeline before the data warehouse.

I'm looking to add real-time capabilities, for instance, reflecting a new user signup immediately on a dashboard. Can RisingWave coexist with my current production database, or could it serve as the sole operational database in a three-tier application? Is RisingWave a good fit for this use case, or would it be like using a hammer to cut paper?


Shuo Yang

Asked on Nov 11, 2022

RisingWave can indeed be utilized in traditional enterprise applications, particularly for real-time dashboard updates. It can coexist with your operational PostgreSQL database by using Change Data Capture (CDC) and materialized views within RisingWave. However, RisingWave is not designed for transactional (TP) workloads, so it wouldn't replace PostgreSQL for that purpose. For analytics, it depends on your specific workload and query patterns. RisingWave can handle both real-time dashboards and transformation plus analytics, which could be a suitable solution for your application. If you're starting from scratch or already have a system like ClickHouse, you can gradually migrate some queries to RisingWave to evaluate its effectiveness.

Nov 15, 2022Edited by