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

🚀 Features

• Support batch change by database groups in tenant projects.
• Support table-level data query requests.
• SQL Editor supports multiple running SQL SELECT statements in one query.
• Support SQL review for OceanBase.

🎄 Enhancements

• Display warnings on oversized sheets.
• Support loading files larger than 1MB from GitHub.

🎠 Community

• Thanks to @whhe for feat: enable existing Mysql advisor rules for OceanBase #6355

Full Changelog

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

🚀 New Features

• Support Data Query and Data Export approval flow.
• Support SSH tunneling for PostgreSQL and Redis.
• Support SQL Review for Oracle.

🎄 Enhancements

• Completed issues are automatically resolved.
• Batch transfer databases out of a project.
• Support configuring Webhook URL for GitOps workflow.

Full Changelog

https://github.com/bytebase/bytebase/compare/2.0.0...2.1.0

🚀 New Features

• Support AI-based index optimization advisor for slow query.
• Support setting secret variables at the database level and using it in SQL change workflow.
• Support MyBatis 3 XML SQL Review in the code repository as part of the GitOps workflow.
• Support connection over SSH for MySQL instance.

🎄 Enhancements

• Show SQL review check errors before warnings.
• Add an option to skip server certificate verification for SSO OIDC.

🐞 Bug Fixes

• Fixed some compatibility issues with Oracle 11.

🎠 Community

• We are proud to unveil our new official website.
• Bytebase 2.0 is now live on Product Hunt! Help us spread the word by sharing, upvoting, and commenting. Thanks!
• Thanks to @bun4uk for chore: update role.go #5888

Full Changelog

https://github.com/bytebase/bytebase/compare/1.17.0...2.0.0

🚀 New Features

• Display slow queries for MySQL and PostgreSQL.
• Send weekly slow query summary Emails.
• Sync schema to multiple target databases.
• Configure custom roles for projects.
• Support OceanBase & Redshift.
• New language option: Spanish 🇪🇸.

🎠 Community

• Thanks to @Akrista for feat: 🇪🇸 Spanish Translation #5712
• Thanks to @whhe for feat: ssl support for OceanBase #5741

Full Changelog

https://github.com/bytebase/bytebase/compare/1.16.0...1.17.0

🚀 Features

• Customize your Approval Flow based on risk levels.
• Support databases: Oracle, MSSQL & MariaDB.
• Require two-factor authentication (2FA) for all users.

🎄 Enhancements

• Filter improvements for transferring databases.
• Skip all failed tasks in the current stage of the issue.
• Show progress while uploading SQL for issues.

Full Changelog

https://github.com/bytebase/bytebase/compare/1.15.0...1.16.0

🚀 New Features

• Bytebase now offers a SaaS version https://hub.bytebase.com/.
• GitOps supports Bitbucket Cloud (bitbucket.org) as the Git provider https://www.bytebase.com/docs/vcs-integration/bitbucket-org.

🎄 Enhancements

• SQL Review supports checking PostgreSQL view dependencies.

🐞 Bug Fixes

• Fixed the issue where some objects could not be recognized in MySQL 5.7.20-log version.
• Fixed the issue where MySQL could not recognize the creation of a database in the lower_case_table_names = 1 scenario.

🚀 Features

• ChatSQL: use natural language and have it converted to SQL by Bytebase. Powered by OpenAI ⚡️.
• Support Two-Factor Authentication (2FA) for login.
• Support State-based Migration for MySQL in GitOps workflow (Beta).
• Added support for Redis ❤️.

🎄 Enhancements

• Use the lower-case Environment Identifier (ENV_ID) instead of the Environment Name (ENV_NAME) for your GitOps SQL file path name. E.g. use prod, instead of Prod. We changed the environment placeholder to use the unique ENV_ID instead of ENV_NAME. This way, when you change an Environment Name, it won't break the existing GitOps setup.
• Execute multiple SQL statements at a time in SQL Editor's Admin Mode.

🐞 Bug Fixes

• Fixed the problem where login with SSO didn't redirect properly in the mobile browser.

Full Changelog

https://github.com/bytebase/bytebase/compare/1.13.0...1.14.0

🚀 Features

• Generate SQL statements to rollback DML for MySQL. www.bytebase.com/docs/change-database/rollback-data-changes
• Support Single Sign-On (SSO) with OIDC. www.bytebase.com/docs/administration/sso/oidc
• GitOps workflow now supports GitLab.com as a VCS provider. Now Bytebase supports GitLab.com, GitHub.com and GitLab self-hosted. www.bytebase.com/docs/vcs-integration/gitlab-com

🎄 Enhancements

• Improved UI for viewing and configuring SQL review policies.
• Support executing multiple statements for PostgreSQL in SQL Editor Admin mode.

🎠 Community

• We just crossed 5K GitHub stars 🥳!
• Add a tutorial page to include all Bytebase tutorials. www.bytebase.com/tutorial
• Thanks to @piglig for PRs
  • #4874 chore: adjust plugin names to conform to conventions
  • #4875 docs: update the reference of the plugin generator doc
  • #4878 fix: wrong dir path when generating MySQL Advisor

Full Changelog

https://github.com/bytebase/bytebase/compare/1.12.1...1.13.0

What's Changed

🚀 Features

• Support OAuth 2.0 for Single Sign-On (SSO) https://www.bytebase.com/docs/administration/sso/oauth2.
• Support change and query for Spanner https://www.bytebase.com/docs/introduction/supported-databases.
• Support watermark https://www.bytebase.com/docs/administration/watermark.
• Terraform Bytebase provider supports MySQL role CRUD.
• Mask sensitive fields for PostgreSQL.

🎄 Enhancements

• For projects with GitOps workflow enabled, schema and data changes are also supported through UI.
• Improved onboarding flow.
• Start a 14-day trial of the Enterprise Plan by default.
• Improved Schema Editor's UX.
• Improved Schema Diagram: filtering, navigation, focusing and export PNG files. https://www.bytebase.com/docs/change-database/schema-diagram
• Rename "Protected environment" to "Production environment". https://www.bytebase.com/docs/administration/environment-policy/tier
• Improved schema viewing and editing experience in SQL Editor.
• Add an icon to identify sensitive data columns in the query result of SQL editor.

🐞 Notable Bug Fixes

• Fixed: Change history detail in MongoDB collection pages doesn't work correctly.

🎠 Community

• Thanks to @alexey-milovidov for PR: Change ClickHouse Docker repository. #4648

Full Changelog

https://github.com/bytebase/bytebase/compare/1.12.0...1.12.1