Sink data from RisingWave to Supabase
Supabase is an open-source Firebase alternative. It uses PostgreSQL as the underlying storage system and therefore can be integrated with RisingWave seamlessly.
You can sink data from RisingWave into Supabase. For more details on this integration, we have an end-to-end demo to showcase how Supabase seamlessly integrates with RisingWave.
Set up Supabase
Before creating a sink in RisingWave, create a project and target table to sink data to in Supabase.
Sink data to Supabase
As Supabase is compatible with PostgreSQL, you can sink data to Supabase the same way you would sink data to PostgreSQL with the JDBC connector. For the syntax, parameters, and examples, see Sink data from RisingWave to PostgreSQL.
The following SQL command creates a sink, promotion_update
, that sinks data from the materialized view, product_calc_mv
, in RisingWave, to the promotions
table in Supabase. The columns of the materialized view must match the columns of the table in Supabase.