Releases: bytebase/bytebase
Releases · bytebase/bytebase
Release 2.16.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
Release 2.15.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
Release 2.14.1
🚀 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.
- The option to query and export at the workspace level is no longer available. Instead, make
- Update the visibility of SQL Editor Worksheets to
Private
,Project Read
andProject 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
Release 2.14.0
🚀 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
Release 2.13.2
🚀 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
Release 2.13.1
🚀 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
Release 2.13.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
Release 2.12.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
Release 2.11.1
🚀 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
Release 2.11.0
🚀 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.
🎄 Enhancements
- Support choosing
All users
and assign roles in a project. - Display table and column details on a hover panel in SQL Editor.
- Rearranged project page layout.
🐞 Bug Fixes
- Fixed: renaming files on Azure DevOps/Bitbucket doesn't trigger issue creation in Bytebase.
🎠 Community
- Thanks to @bds-congnguyen for fix: update bytebase-sql-review.yml for CICD #8984