🚀 New Features

• Support Cassandra in SQL Editor.

🔔 Breaking Changes

• List instance API returns at most 10 instances instead of all by default. The API requires using pagination parameter to fetch more. Doc

• The statement field in Release API will be base64-encoded string.

🎄 Enhancements

• Support displaying triggers for Oracle in SQL Editor.
• Improve Elasticsearch parser accuracy.
• Binary data in SQL editor now copies in its displayed format instead of the raw value.
• Support "View Schema Text" for views in SQL Editor.
• Service account emails now use workspace domain (if set) instead of default @service.bytebase.com.

Changelog

3.5.1...3.5.2

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

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

🎄 Enhancements

• Expanded connection parameter support for PostgreSQL, MySQL, Microsoft SQL Server, and Oracle databases.
• Optimized PostgreSQL table deletion by eliminating redundant DROP statements for constraints and indexes.
• Support server-side identifier case sensitivity for OceanBase.
• Enhanced binary data visualization.
  • Updated formatting options for boolean, binary, hexadecimal, and text representations.
  • Implemented customizable binary display preferences at both column and individual cell levels.

Changelog

3.5.0...3.5.1

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

💰 Plan Adjustment

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

🔔 Breaking Changes

• Deprecated slow query feature.

• To simplify the deployment process, the custom deployment configuration feature has been removed. Deployments will now follow the straightforward order of your defined environments. For canary deployments, create a separate canary environment. Then, point your database environment to this canary environment.

• Deprecated multitenancy feature.

• Deprecated built-in GitOps feature, now you can use GitOps in a new way.

• API support pagination and filter.

  • ListProjects support page_size and page_token. Doc
  • SearchProjects support filter by name and resource_id. Doc
  • ListDatabases support filter by environment/project/instance/name/engine/label/exclude_unassigned. Doc
  • ListUsers support filter by name/email/user_type/state. Doc

  These API changes bring huge UI change and influence many features:

  • Will NOT list all projects anymore, users must fetch projects per page, or search projects by name/resource id. (For the project table & selector)
  • Will NOT list all databases anymore, users must fetch databases per page, or search databases by filter. (Almost all features are affected as long as it's using the database, for example, issue, release, rollout, database group, masking, SQL editor)
  • Will NOT list all users anymore, users must fetch users per page, or search users by name/email. (Many features are affected as long as it's using the user, for example, issue, release, group, member/IAM)

🚀 New Features

• Support Azure IAM Auth for Cosmos DB & Azure SQL.
• Sync schema for CockroachDB (PostgreSQL compatible syntax supported only).
• Support configuring custom maximum query time in SQL Editor (Workspace Settings -> General -> Security -> Maximum query time).
• Support webhook direct message for DingTalk.

🎄 Enhancements

• View affected rows of SQL check result before issue creation.
• Adjust SQL rule Disallow setting volatile default value on columns (PostgreSQL) to apply only to existing tables and the ALTER TABLE ADD COLUMN operation.
• Extend API to allow updating the plan for database group deployment.

Changelog

3.4.1...3.5.0

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

What's Changed

🎄 Enhancements

• The Bytebase Terraform provider enables the management of additional 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.

• Improved the automatic quotation feature in the SQL editor.

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

🔔 Breaking Changes

• External Approval Deprecated: Users should now use the Bytebase API for managing approvals and rollouts.
• MySQL online migration sync and cutover tasks have been consolidated into a single task. As a prerequisite, you should first create a bbdataarchive database.

Changelog

3.4.0...3.4.1

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

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

🔔 Breaking Changes

• The redundant key attribute of project has been removed.

🎄 Enhancements

• Disallow using sensitive columns in WHERE clause for SQL Server.
• Enhance SQL Server data backup experience.
• Enhance PostgreSQL data backup experience.
• The summary report of task check supports Redshift, including affected rows and statement reports.

🐞 Bug Fix

• Show the correct timestamp scale in SQL Editor.
• Fix SQL Server connection leak problem.

📜 Changelog

3.3.1...3.4.0

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

🚀 New Features

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

🎄 Enhancements

• In SQL Editor, pressing Cmd+Enter will execute the query on the current line where the cursor is located.
• Add compatibility with PostgreSQL extension CITUS.
• Improve the performance for GetChangelog and GetDatabaseSchema APIs.

🔔 API Changes

• Remove concise parameter from GetChangelog and GetDatabaseSchema APIs.

📜 Changelog

3.3.0...3.3.1

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

🛡️ 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.

🔔 Breaking Changes

• Simplify data masking, both UI and API are affected, check docs and API examples for details. Behavior changes:
  • Global masking takes precedence over column masking. Previously, column masking takes precedence over global masking.
  • Eliminate masking levels. For both global masking and column masking, you now configure the associated semantic type. Semantic type in turn maps to the corresponding masking algorithm.

🚀 New Features

• Introduce Release, the new versioned database schema migration workflow. Create releases, which are versioned migration scripts bundled as a package to deploy, tell Bytebase which databases to deploy, and Bytebase will figure out which scripts to execute or skip if already executed.
• Support CosmosDB.
• Add project setting to allow users to self-approval their own issues.
• Schema Synchronization supports PostgreSQL materialized view.
• Preliminary support PostgreSQL 17.

🎄 Enhancements

• Copy query results by selected columns or rows in SQL Editor.
• Enhance Oracle data backup experience.
• Improve the loading time for the database anomalies page.

📜 Changelog

3.2.0...3.3.0

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

🚀 New Features

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

🔔 Breaking Changes

• Change History module is renamed to Changelog. ChangeHistory API is removed, use Changelog API instead.
• Changes initiated from the UI no longer carry the version, but changes initiated from GitOps still do.
• Tasks with lower versions will block tasks with higher versions.

🎄 Enhancements

• Support querying special date/time values(e.g., infinity) for PostgreSQL in SQL Editor.
• Failed task run is now recorded to change log, before it's not.

📜 Changelog

3.1.2...3.2.0

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

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

🔔 Breaking Changes

• Remove the masking policy API v1/{instance}/{database}/policies/masking. Use v1/{instance}/{database}/metadata instead and set the columnConfigs parameter.

🎄 Enhancements

• Move the masking column page to the database detail page.
• Support popup login modal on token expiration.

🐞 Bug fix

• Fix the backup table name conflict in multi-tenant database group within the same instance.
• Fix the cross-origin issue in SSO authentication (OIDC).
• Fix bug causing QuotaExceededError in SQL Editor.

📜 Changelog

3.1.1...3.1.2

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

🚀 New Features

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

🔔 Breaking Changes

• Remove instance roles from Database messages. Call GetInstance or ListInstanceRoles to get instance role information.

🎄 Enhancements

• Well-formatted JSON in SQL Editor.
• Display PostgreSQL sequences in SQL Editor.
• Display MySQL triggers in SQL Editor.
• MySQL DUMP SCHEMA is 80% faster on large databases.
• Support PostgreSQL roles during backup and restore.

📜 Changelog

3.1.0...3.1.1

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