Bytebase 3.1.0

NingjingNingjing2 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
  • API change:

    • Remove the database field of sheet in SheetService.
    • Disallow adding service account to a group via API (previously restricted in the UI) .
    • Deprecate SQLService.Execute method.
  • 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 and SET 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

Warning: Bytebase does not support downgrade. Make sure to back up your meta data before upgrading.

Back to Changelog

Subscribe toย Newsletter

By subscribing, you agree with Bytebase's Terms of Service and Privacy Policy.