Bytebase 3.1.0
Ningjing2 min read
๐ New Features
- Support PostgreSQL role selection in DDL/DML issues.
- Add PostgreSQL database tenant mode option in project setting.
- Display package metadata for ORACLE on database page and SQL Editor.
- Support setting colors for environments for better visual distinction.
- Allow workspace admin to disable data export functionality.
- Add new SQL Review Rules for MySQL:
- Prohibit DDL on specific tables for MySQL.
- Prohibit DML on specific tables for MySQL.
๐ Breaking Changes
-
Redefine SQL Editor related permissions:
- Permissions
bb.databases.query
->bb.sql.select
bb.databases.queryDML
->bb.sql.dml
bb.databases.queryDDL
->bb.sql.ddl
bb.databases.queryExplain
->bb.sql.explain
bb.databases.queryInfo
->bb.sql.info
bb.databases.export
->bb.sql.export
bb.instances.adminExecute
->bb.sql.admin
- Roles
roles/projectQuerier
->roles/sqlEditorUser
- Permissions
-
API change:
- Remove the
database
field ofsheet
inSheetService
. - Disallow adding service account to a group via API (previously restricted in the UI) .
- Deprecate
SQLService.Execute
method.
- Remove the
-
Default PostgreSQL role to run a DDL/DML issue:
- Instance connection user (previously database owner)
- If PostgreSQL database tenant mode is on for a project, the role remains database owner.
- For existing projects: PostgreSQL tenant mode will be automatically enabled if multitenancy is enabled for any database group.
๐ Enhancements
- Expand audit log coverage to include more event types.
- Upgrade 1-click rollback user experience for MySQL.
- Upgrade parser to be compatible with PostgreSQL 15 syntax.
- Add compatibility with Elasticsearch 7.x.
- Support
DECLARE
andSET
for SQL Server in SQL Editor.
๐ฐ Pricing Adjustments
- Move SSO OAuth2 Google and GitHub from Enterprise to Pro Plan.
- Move self-service signup restriction from Enterprise to Pro Plan.
โ๏ธ Install and Upgrade
-
Fresh install: https://www.bytebase.com/docs/get-started/self-host
Warning: Bytebase does not support downgrade. Make sure to back up your meta data before upgrading.