Bytebase Versions Save

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

🎄 Enhancements

• Support filtering audit logs by project and method.
• Support displaying schema snapshots for SQL Server.
• Support importing changelists from zip or SQL files.
• Support clicking on a line number in the SQL review results jumps to that line.
• Support jumping to a specific line by clicking on its line number in SQL review results.
• Support displaying SQL Server functions and procedures in SQL Editor.
• Support displaying uniqueidentifier typed data of SQL Server in SQL Editor.
• Improve the SQL Editor experience by customizing the database tree structure.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.16.0...2.17.0

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

🔔 Breaking Changes

• Deprecated Manage on Database Mode for Oracle; now only supports Schema Mode.

🎄 Enhancements

• Support previewing SQL file uploads with custom encoding.
• Improve auto-completion in the SQL Editor.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.15.0...2.16.0

🔔 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 Vault as an external data source for database secrets.
• Support Apache Hive.
• Add one-time data export issue type.

🎄 Enhancements

• Improve SQL Editor UI/UX.
• Add SQL review rules for PostgreSQL：
  • Detect non-transactional statements.
  • Require using NOT VALID when creating foreign keys.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.14.1...2.15.0

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

🔔 Breaking Changes

• Remove Data Access Control from Workspace Settings.
  • The option to query and export at the workspace level is no longer available. Instead, make allUsers a project member with the Querier role for the same functionality.
  • The feature to prevent copying data from the SQL Editor has been moved to the environment page.
• Update the visibility of SQL Editor Worksheets to Private, Project Read and Project Write.

🎄 Enhancements

• Display failed Oracle statement line numbers.
• Improve Snowflake syntax error messages.
• Collect all PostgreSQL slow logs if pg_stat_statements view exists.
• Enhance Oracle compatibility.

🐞 Bug Fixes

• Correct time display for slow query logs.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.14.0...2.14.1

🚀 New Features

• Support custom roles with specific permissions.
• Support SQL Review CI for BitBucket.
• Support queries across different databases for data masking.
• Support sharing links for database tables within SQL Editor and database overview page.

🎄 Enhancements

• Support MongoDB TLS/SSL connection.
• Improved Redis query result display.
• Display failed status in the issue list.
• Added a SQL review rule that suggests enabling gh-ost for big table online schema changes.
• Support PostgreSQL set role statements for creating indexes concurrently.
• Support using functions as table sources in PostgreSQL data masking.
• Automatically add newly created databases to pending issues in batch-mode projects.
• Support gh-ost for MySQL 5.6.

🐞 Bug Fixes

• Fixed compatibility issues with AWS DocumentDB.
• Fixed issues with PostgreSQL using TLS/SSL.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.13.2...2.14.0

🚀 Features

• Support Japanese.
• Support Vietnamese.

🎄 Enhancements

• Support configuring masking algorithms for sensitive data columns.
• Support viewing query results in a vertical format.

🎠 Community

• Thanks to @AbdhilahiRWabwirefor the PR chore: dependabot.yml #10677

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.13.1...2.13.2

🚀 Features

• Support backing up data before the 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.

🔔 Breaking Changes

• Changes in Bytebase API: Renamed predefined roles. Update your code if you are utilizing these roles:
  • Workspace level: OWNER->workspaceAdmin, DBA->workspaceDBA, DEVELOPER->workspaceMember
  • Project level: OWNER->projectOwner, DEVELOPER->projectDeveloper, QUERIER->projectQuerier, EXPORTER->projectExporter, VIEWER->projectViewer, RELEASER->projectReleaser

🎄 Enhancements

• Support editing indexes in Schema Editor.
• In SQL Editor, group sheets by project and database.
• Support choosing custom project roles in environment rollout policy.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.11.1...2.12.0

🚀 Features

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

🎄 Enhancements

• Support displaying the index DDL in SQL Editor.
• Support querying foreign tables for PostgreSQL in SQL Editor.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.12.0...2.13.0

🚀 New Features

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

🔔 Breaking Changes

• Sunset existing Enterprise trial license. New trial license is available upon request.

🎄 Enhancements

• Improve overall layout and navigation.
• Support displaying and querying partition tables in SQL Editor for PostgreSQL.
• Support TiDB 7.5.
• Improved filter experience for databases, instances and slow queries.
• Improved Schema Editor performance.
• Improved the compatibility of MySQL SQL Review.

🐞 Bug Fixes

• Fixed: can not query MongoDB if the result is too large.
• Fixed: can not query PostgreSQL view in SQL Editor.

🎠 Community

• Thanks to @jinrenjie for the PR fix(smtp): fix host name error in smtp authentication #9674

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.11.1...2.12.0

🚀 New Features

• Customizable Masking Algorithms and Semantic Types for Data Masking.

🔔 Breaking Changes

• Workspace Admins and Members are the updated terms for Workspace Owners and Developers, respectively.
• User page URL is now /users/{email} (previously /u/{uid}).

🎄 Enhancements

• SQL Editor: display DDL statement of the selected table (MySQL, PostgreSQL and TiDB).
• Boosted query speed when Data Masking is enabled.
• Send webhook notifications when an issue is Waiting for Rollout or Approved.
• Improved Oracle Parser for procedures and table partitions.
• Improved issue filters.
• Improved issue assignee feature.
• Improved Schema Editor performance.

📜 Changelog

https://github.com/bytebase/bytebase/compare/2.11.0...2.11.1