Introduce how to integrate Bytebase with RisingWave for schema management.
Bytebase is a database DevOps tool that provides a streamlined way to manage schema changes, enforce best practices, and collaborate on database development. This guide explains how to integrate Bytebase with RisingWave to manage schema evolution in real-time data processing environments.
Before you begin, ensure you have the following:
Create a RisingWave cluster in RisingWave Cloud using the free plan. For more information, refer to the RisingWave Cloud documentation.
You can run Bytebase using Docker or use Bytebase Cloud:
Access Bytebase UI at http://localhost:8080
and set up an admin account.
Then, add RisingWave as a new database:
Test
localhost
or RisingWave Cloud’s instance host4566
bytebase
(the super user that you created)bytebase
userAfter creating the RisingWave instance, you will see the RisingWave databases under the Databases section as follows:
In Bytebase, go to Projects and create a new project.
After creating the new project, click on it, then select Transfer DB and choose the RisingWave database named dev. This will transfer the database to the project.
Click on the new database instance to view all its details, the Schema Diagram, and open the SQL Editor.
Click on SQL Editor and use the following SQL script to create a table in RisingWave in Admin Mode:
Below is the SQL Editor of Bytebase:
Below is the result when querying the table in Bytebase’s SQL editor:
Bytebase maintains a record of schema changes history, allowing you to:
You can integrate Bytebase with CI/CD pipelines for automated schema deployments:
Bytebase provides gRPC and RESTful APIs, enabling full automation of database workflows. The UI console itself runs on this API, allowing seamless integration with your internal developer platform.
Key capabilities:
Bytebase supports GitOps workflows, allowing schema changes via pull requests. Connect your repository and configure automatic deployment rules.
By integrating Bytebase with RisingWave, you can efficiently manage schema changes, enforce best practices, and improve collaboration in real-time data streaming applications. This setup ensures schema consistency and reduces errors in production deployments.
For more information on leveraging Bytebase and its features, see Bytebase Documentation.