Bytebase Changelog

🚀 New Features#

• DML rollback supports unique indexes for MySQL, PostgreSQL, Oracle and MSSQL.
• Improve wizard for initial workspace creation.
• Introduce Parallel tasks per rollout and CI Data Sampling Size options in project settings.

Bytebase has earned SOC 2 Type 2 certification building on our earlier Type 1 certification acquisition.

🚀 New Features#

• Add basic support for Trino database.
• Support syncing OIDC IdP groups to Bytebase groups via the groups claim.
• Support Cassandra for executing statements in SQL editor and executing issues.
• Able to automatically retry PostgreSQL lock timeouts.

🚀 New Features#

• Support Cassandra in SQL Editor.

🚀 New Features#

• Support WHERE clauses and SELECT projections in Cosmos DB SQL syntax within SQL Editor.
• Support connecting to OpenSearch using the Elasticsearch client library.

💰 Plan Adjustment#

• Refine the environment rollout policy by setting manual rollout as the default option, now available in the Community Plan (Free).

🎄 Enhancements#

• Terraform provider manages more resources.

  • Support managing custom roles, semantic types, and database resources.
  • Support assigning instance licenses.
  • Support external secrets for instances.

• Allow retrying online migration tasks.

• Enable the following flags for online migration: throttle-control-replicas and attempt-instant-ddl.

• Improve the automatic quotation feature in the SQL editor.

• Consolidate the setting update UX for workspace, instance, environment, and project.

💰 Plan Adjustment#

• The Index Advisor feature is available in the Community Plan (free), enabling the suggestion of indexes for slow queries once OpenAI integration is set up.
• The SQL Sharing feature is available in the Community Plan (free), allowing users to star and share worksheets with their team in the SQL Editor.

🚀 New Features#

• Support 1-click DML rollback for Oracle.
• Support AppRole method for Vault while connecting to an instance.

🛡️ SOC 2#

We have obtained SOC 2 Type 1 certification. This certification validates our commitment to maintaining the highest standards of security, availability, and confidentiality in our database DevSecOps platform.

To request our SOC 2 Type 1 report, please email support@bytebase.com.

🚀 New Features#

• Selectively sync databases from an instance.
• Show the definition of TABLE and VIEW for Redshift and ClickHouse.

🚀 New Features#

• Add tooltips for tables, columns, and PostgreSQL view comments in SQL Editor.
• Support IM and webhook integration for Lark.
• Display table and view definition for Redshift.

🚀 New Features#

• Customizable homepage with shortcut list.
• Query for all nodes in Redis Cluster.
• Support for second-precision expiration time when granting project roles.

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

🚀 New Features#

• Add an environment policy to allow executing DDL/DML statements directly in SQL Editor.
• Support data masking for BigQuery.
• Support rollback to a specific version in the change history on the database page.
• Add data access control and masking page under each project.

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 and LOCK options for online DDL in MySQL/MariaDB.
  • Table comment checks for PostgreSQL/Oracle.
  • Column comment checks for PostgreSQL/Oracle.
• Separate SQL review rules to disallow mixing statements in DDL or DML tasks.

🚀 New Features#

• Support applying changelists to database groups.
• Add a SQL Review rule for MySQL: Enforce classification in table/column comment.

🚀 New Features#

• Support synchronizing users and groups from Entra ID (former Azure AD).
• Support CockroachDB.
• Support project-level backup settings with auto-enable and skip error options.
• Real-time syntax checking in the SQL Editor.
• Support configuring password restriction.

🚀 New Features#

• One-click rollback for PostgreSQL DML change.

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