​
🚀 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.

​
🔔 Notable 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 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.