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

🎄 Enhancements

• Support PostgreSQL 16.
• Create sub-branches from a branch.
• Select alternative target branches when merging.
• SQL Editor:
  • You can now abort queries.
  • Customize your database tree view.
• Issues: use local variables for SQL Server.
• Set Postgres, MySQL, Oracle, SQL Server, Snowflake query LIMIT with Parser.
• Display column type length in the Table detail page (if applicable).

🐞 Bug Fixes

• Fixed: default column issue for Branching and Edit Schema.

Changelog

https://github.com/bytebase/bytebase/compare/2.9.1...2.10.0

🚀 Features

• Group changes into a changelist and apply them in one issue or export.
• Batch query on multiple databases with selected labels in SQL Editor.
• Support integrating external secret manager to store database credentials.
• Support Branching for PostgreSQL and TiDB.

🎄 Enhancements

• Support database labeling with multiple key-value pairs.
• SQL Editor supports reporting the exact line and column where the syntax error occurs.
• Edit Schema / Change Data button on the homepage supports selecting multiple databases from the same project.

🎠 Community

• Thanks to @CorrectRoadH for PR chore: fix warning of compiler-sfc #5864.
• Thanks to @yagueto for PR feat(frontend): Adds a hover effect when hovering an announcement #8553.

Changelog

https://github.com/bytebase/bytebase/compare/2.9.0...2.9.1

🚀 Features

• Run SQL Review checks before the issue is created.
• Predefine table templates, which can be applied when altering or designing database schema.

🎄 Enhancements

• Further advanced search for Issues: search by instance/database/issue type/date range/creator/assignee/subscriber.
• Improved Branching UX.

🐞 Bug Fixes

• Fixed compatibility issues with Oracle 11g.

🎠 Community

• Thanks to @bwcxyk for chore: fix Oracle dump #8356

Full Changelog

https://github.com/bytebase/bytebase/compare/2.8.0...2.9.0

🚀 Features

• Upgrade data masking, providing more granular masking and access control configuration.
• Revamped SQL Editor UI.
• Support sync schema for Oracle.
• Support setting announcement.

🎄 Enhancements

• Support MySQL parser-based data masking.
• Adjust the sidebar database list, and replace all with the recently visited database list.
• Support filtering by change type in the change history table.
• Support auto-merge in branching.
• Support setting 'Scan Interval' for instances.
• Add a new risk factor 'Affected Rows' for DDL.
• Built a more stable Oracle Dump Schema kernel.
• Support databases multi-selection while granting exporter roles.
• Skip empty statement for MySQL.
• Improve the expired roles display in a project, and add a button to quickly clear expired roles.

🚀 Features

• Support Git-like Branching for database schema migration.
• Support searching all Issue histories.
• Support exporting Audit Logs.

🎄 Enhancements

• Revamped UI for database change issue.
• SQL Review: configure separate settings for different database engines.
• Provide arm64 Docker image.

🎠 Community

• Thanks to @kanzihuang for #7524
• Thanks to @vladdoster for #7667
• Thanks to @heng4fun for PR docs: fix typo Bytebaes #161

Full Changelog

https://github.com/bytebase/bytebase/compare/2.6.0...2.7.0

🚀 Features

• Support using LDAP for configuring SSO.
• Support adding multiple read-only data sources.
• Schema Template supports column type restriction.
• Support Data Masking Policy for SQL Server.
• Support RisingWave.
• Support Sync Schema for TiDB.
• SQL Review CI supports Azure DevOps.

🎄 Enhancements

• Support setting a custom environment for a specific database.
• Support viewing project members grouped by their roles.
• Support adding project data querier and exporter roles to a target database.
• Improved Postgres slow query UX.
• Improved Instance detail layout.
• Improved SQL Editor navigation.

🎠 Community

• Thanks to @TennyZhuang for PR feat: support to use RisingWave as instance #7427
• Thanks to @1aal for PR fix: fix bytebase helm chart #7481
• Thanks to @kanzihuang for PR fix: sql export for bit type #7444

🚀 Features

• Support Azure DevOps for VCS integration.
• Support setting Sign-in Frequency.
• Support export changes from database change history.
• Schema Designer for MySQL.
• Support defining column template.

🎄 Enhancements

• Support more SQL Review Rules for SQL Server.
• Optimized detail view for MongoDB query results in SQL Editor.
• Optimized SQL Editor layout.
• Support batch retry failed tasks on issue detail page.
• Locating syntax error with line and column in issue detail page.
• Compatible with MySQL-like engine identifier case sensitivity.

🎠 Community

• Bytebase Crossed 1 Million Downloads 🎉 , while our goal stays the same as when we started the project!
• Thanks to @siooooo for PR #7230，#7231，#7232
• Thanks to @realize096 for PR fix(sec): upgrade nhooyr.io/websocket to 1.8.7 #7151

🚀 New Features

• Support GitHub Enterprise for VCS integration.
• Support Export Data as XLSX.
• Manage Oracle instance based on schema.

🎄 Enhancements

• Support masking sensitive data for CTE in Oracle.
• Support more SQL Review Rules for Snowflake.
• DAC (Data Access Control) now supports more types of Snowflake SQL statements.
• Improved the file format of data export as JSON.
• Disable copying data via SQL Editor by configuring Environment Policy.
• Prepared one test and prod instance each, for onboarding purposes.
• Added --disable-sample to disable running sample instance on startup.

Full Changelog

https://github.com/bytebase/bytebase/compare/2.4.0...2.4.1

🚀 Features

• Support data access control for query and export at workspace level, and support custom approval.
• Support Snowflake Task, Stream objects and data access control.
• Support Redshift datashare query, data access control, and data anonymization.
• Support data export as DML script.
• Issue comment supports markdown.

🎄 Enhancements

• Increase SQL script sheet display size to 1M.
• SQL Editor admin mode supports keeping connection session.
• Query results in SQL Editor are disallowed to copy.
• Support "force" option archiving instances and projects.
• Issue status activity sorting is more precise.

💰 Pricing

• Support granular binding between instance and paid features. Users can import all instances into Bytebase to manage, meanwhile, they can just purchase less instance licenses and assign them a subset of instances requiring advanced features https://www.bytebase.com/docs/administration/license/
• Change Free Plan to allow up to 20 users.

What's Changed

🚀 Features

• SQL Review for Snowflake.
• Introduced Export Center for data exports.
• Anonymize data for Oracle.

🎄 Enhancements

• Configure External Approval Nodes and apply to custom approval flows.
• Introduced Send back action for Approval Flows.
• Renamed Project's Tenant Mode to Batch Mode.
• Improved SQL Query and Export request flow experience.
• Improved project member page layout.

🐞 Bug Fixes

• Fixed a bug where migration fails with invalid connection when the connection timeouts.
• Fixed a bug where export data file content is truncated incorrectly by special characters.

🎠 Community

• Thanks to @whhe for fix: add missing rule mapping for OceanBase #6576

Full Changelog

https://github.com/bytebase/bytebase/compare/2.2.0...2.3.0