all-things-risingwave
Can RisingWave be used for building near-realtime dashboards in a traditional SaaS app with PostgreSQL as the main database?
John is working on a traditional SaaS app using PostgreSQL for data storage and wants to know if RisingWave can be used for building near-realtime dashboards as a companion to the main database.
Jo
John
Asked on Mar 04, 2024
- Yes, RisingWave can be a good fit for building near-realtime dashboards in a traditional SaaS app with PostgreSQL as the main database.
- RisingWave offers a CDC source that allows ingesting data from PostgreSQL for real-time data transformation and analysis.
- The workflow involves using PostgreSQL CDC to RisingWave for real-time data processing and then back to PostgreSQL for storage.
- RisingWave can serve as a smart companion to the main database, enabling the creation of near-realtime stats, dashboards, and activity feeds for user-facing pages.
Mar 05, 2024Edited by