Bytebase 3.0.0
AI Assistant for SQL Editor
Check out our official 3.0 announcement - Bytebase 3.0 - DevSecOps for Database
🚀 New Features
- AI Assistant for SQL Editor: Convert natural language into SQL, explain SQL queries and identifies potential problems.
- Support 1-click rollback for SQL Server DML change.
- Support gh-ost online schema change for MariaDB.
- Add new SQL Review Rules:
- Require
MAX_EXECUTION_TIME
for MySQL. - Require
MAX_STATEMENT_TIME
for MariaDB. - Require
ALGORITHM
andLOCK
options for online DDL in MySQL/MariaDB. - Table comment checks for PostgreSQL/Oracle.
- Column comment checks for PostgreSQL/Oracle.
- Require
- Separate SQL review rules to disallow mixing statements in DDL or DML tasks.
🔔 Notable Changes
Behavior
We no longer allow the users to approve their own issues.
API
- CEL parsed expressions have been updated to remove unused sourceInfo, impacting the following APIs:
/v1/cel/batchDeparse
,/v1/cel/batchParse
,/v1/workspaces/*:getIamPolicy
,/v1/workspaces/*:setIamPolicy
,/v1/projects/{project}:getIamPolicy
,/v1/projects/{project}:setIamPolicy
. - Force to set
group_email
while callingPOST /v1/groups
API to create a new group. For example,POST /v1/groups?group_email=dba@bytebase.com
🎄 Enhancements
- Support table-level risk rule for DML in Risk center.
- SQL Editor displays function signatures with parameters instead of just function names.
- SELECT prompt prioritizes columns over tables in SQL Editor.
- Ignore
bbdataarchive
schema for PostgreSQL during schema synchronization. - Add
allow_missing
parameter in APIsPATCH /v1/groups/{group}
andPATCH /v1/roles/{role}
. For example, you can usePATCH /v1/groups/not_exist_group?allow_missing=true
to create a new group if the resource not found. - Use user-specified PostgreSQL role in SQL review.
🎠 Community
⚙️ Install and Upgrade
-
Fresh install: /get-started/self-host
-
Upgrade: /get-started/upgrade
Warning 1): Bytebase does not support in-place downgrade. Make sure to back up your metadata before upgrading. 2) Never run multiple containers on the same data directory. Stop and remove the old one first to avoid corruption.