Bytebase Changelog

🚀 New Features#

• Allow assigning roles to groups at the workspace level.
• Support disallowing sign-in with email and password, allowing only SSO.
• Add a PostgreSQL SQL review rule: Disallow setting volatile default values on columns.

🚀 New Features#

• SQL Editor displays more inline schema details including tables, views, functions and stored procedures.
• Support SQL reviews via PR comments for GitOps workflows.
• The OpenAI feature is in Community Plan (free), allowing natural language to SQL in the SQL Editor by configuring your own OpenAI key.
• Support selecting data sources between Admin and Readonly modes in the SQL Editor, configurable at the environment or project level.
• Support for Microsoft Entra as a built-in OAuth2 SSO provider.
• Support using database labels as filters for database group conditions in raw expression format.
• Support for table_name as a risk factor for DDL and DML operations.

🚀 New Features#

• Support monitoring blocking sessions during PostgreSQL task execution.
• Support auto-completion for Oracle.
• Support Kerberos authentication for Hive.
• Sync extended property MS_Description on Table/Column as comment for SQL Server.

🚀 New Features#

• Support configuring SQL review rules by database engine.
• Support connecting to Redis sentinel and native cluster.
• Add project settings:
  • Allow SQL editing after issue creation.
  • Automatically close issues after rollout completion.
• Support WeCom direct messages for issue activities.

🚀 New Features#

• Support Databricks.
• Support TLS/SSL connection for SQL Server.
• Support Lark direct notifications for issue activities.
• Support email domain restriction for user sign-up.

🚀 New Features#

• Support DynamoDB.
• Support standalone SQL review issue.
• Support Slack direct messages for issue activities.
• Support prior backup for PostgreSQL.
• Add SQL Review Rule for SQL Server: Disallow redundant indexes.

🚀 New Features#

• Support user groups.
• Support BigQuery.
• Support sync schema for SQL Server.
• Support MongoDB cluster and direct connection to a node within a cluster.
• Support displaying detailed issue task execution logs for SQL Server and Oracle.
• Add SQL Review Rules:
  • Prohibit cross-database queries in SQL Server.
  • Prohibit performing calculations or calling functions in the 'WHERE' clause for SQL Server.
  • Prohibit creating functions or procedures in SQL Server.

🚀 New Features#

• Support configuring labels for issues.
• Support displaying detailed issue task execution logs (affected rows or errors) for MySQL and PostgreSQL.
• Support configuring table or column classification on the database page. In earlier versions, this required using DDL and was only supported for MySQL and PostgreSQL.
• Add two SQL Review rules:
  • Fully qualified object name for PostgreSQL.
  • Limit DDL operations on tables with large data volumes for MySQL.

🚀 New Features#

• Support DML change pre-backup for Oracle and SQL Server.
• Support display for procedures and functions in SQL Editor.
• Support storing database passwords in AWS Secrets Manager and GCP Secret Manager.
• Support IAM-based connections to Google Cloud SQL for MySQL and PostgreSQL.
• Support editing table partitions in schema editor for MySQL and TiDB.

🔔 Brand New GitOps#

The new GitOps workflow is not compatible with the old version, if you need assistance migrating to the new version, please consult us.

• Use access tokens for authentication.
• Support multiple VCS connectors in a project.
• Support specifying a database group as the target in the VCS connector, automatically applying to all databases in a project by default.
• Deprecate database name templates and latest schema write-back.

🚀 New Features#

• Support Branching for Oracle.
• Add project switcher in SQL Editor.
• Add two SQL Review rules:
  • Disallow mixing DDL and DML statements.
  • Disallow mixing different types (UPDATE, INSERT, DELETE) of DML statements on the same table.

🚀 New Features#

• Support custom roles with specific permissions.
• Support SQL Review CI for BitBucket.
• Support queries across different databases for data masking.

🚀 New Features#

• Support Japanese.
• Support Vietnamese.

🚀 New Features#

• Support backing up data before DML is performed for MySQL.
• Support instance maximum connections, allowing control over the number of concurrent tasks per instance.
• Support compression and encryption for exported data.

🚀 New Features#

• Support advanced SQL auto-completion for PostgreSQL, Redshift and RisingWave.

🚀 New Features#

• Support advanced SQL auto-completion for MySQL.
• Support importing classification JSON data via UI.

🚀 New Features#

• Customizable Masking Algorithms and Semantic Types for Data Masking.

🚀 New Features#

• Support setting parameters for MySQL online schema change.
• Add database viewer role to Project. (Check Roles and Permissions)
• Support OceanBase in Oracle Mode.

🚀 New Features#

• More flexible options to appoint releaser to rollout changes: you can specify any dedicated role set, or the last approver of a custom approval process.
• Configure branch protection rules for projects.
• Set database labels.
• Set column labels.
• Set table classification.