Bytebase Changelog

Open source, web-based, zero-config, dependency-free database schema change and version control tool for Developer and DBA.

Never miss a thing

Learn product updates and everything about database.

Bytebase 0.7.1

0 min read

This is a security fix release. Please consider upgrading it.

๐ŸŽ„ Enhancement

  • Fixed a bunch of security issues found by huntr.dev

1. Reject the current user operation if the user has just been de-activated.

2. Secure the access token to prevent CSRF attack.

3. Disallow Bytebase to be loaded in an iframe.

๐ŸŽ  Community

๐Ÿ“• Upgrade instruction

Bytebase 0.7.0

3 min read

This release takes a bit longer because we are packaging couple exciting features in it. Let's check them out.

๐Ÿš€ New Features

Support PostgreSQL ๐Ÿ˜ ๐Ÿ˜ ๐Ÿ˜

Our team really love PostgreSQL and we are the ones delivering the initial launch of managed PostgreSQL at Google Cloud SQL. So we are really happy to announce the official PostgreSQL support in Bytebase. Elephant in the room โœ…

Schema drift detection

Bytebase will periodically compare the recorded schema with the actual schema and expose the drift if occurs. We also provide a side-by-side view to show the diff.

Introduce Anomaly Center

Many things can go wrong for your database and unnoticed until an outage happens. We are always thinking of a proactive way to help user catch those problems. Today we introduce Anomaly Center, our attempt to address this challenge. A background process will periodically scan potentially anomalies on the managed instances and databases, then expose them in a holistic view.

We currently detect following anomalies and will add more in the future:

  • Database connection issue
  • Backup policy violation
  • Expected backup missing
  • Schema drift
  • Migration schema missing

Backward compatible schema migration check (MySQL/TiDB)

In the last release, we introduce the task check system and introduced the basic SQL syntax check. In this release, we advance the check to catch backward incompatible schema migration (e.g. RENAME TABLE). Introducing backward incompatible schema changes is one of the most common mistakes made by developers and enforcing backward compatible schema change is the standard practice adopted by many engineering organizations. Bytebase now automatically checks all common incompatible schema change scenarios and surface them in the SQL review panel:

Backup schedule enforcement

Owner and DBA can now enforce backup schedule policy for the specific environment. e.g. require daily backup for production environment.

๐ŸŽ„ Enhancement

  • Improve the onboarding workflow to establish the initial schema baseline.
  • Allow user to specify empty password when connecting the instance (though not recommended).
  • Sync detailed "View" schema info.
  • Many other UX improvements and we plan to write a separate article to talk about those small but also meaningful improvements.

๐ŸŽ  Community

  • We revamped our landing page with the wonderful illustration. The figure derives from our logo and we plan to continue this path to strength our branding identity.

๐Ÿ“• Upgrade instruction

Bytebase 0.6.0

1 min read

Update instruction

๐Ÿš€ New Features

Support TiDB

TiDB is an open-source, cloud-native, distributed SQL database for elastic scale and real-time analytics.

Add task check to gate schema change

  • This works similar as GitHub merge request check. The schema change only proceeds if all check pass.
  • In this initial launch, we enforce 2 checks, db connection check and syntax check for the schema change task. We plan to add more checks like advanced SQL analyzer in the future.

๐ŸŽ„ Enhancement

  • Show VCS push event info in the migration history detail page.
  • Improve UX for configuring the instance connection.
  • Improve UX for transferring database between projects.
  • Create dedicated migration history tab for a particular database.
  • Add baseline migration history record upon creating the database.

๐ŸŽ  Community

  • A special thanks to TiDB's open source compatible MySQL parser. It saves us a lot of effort to implement our syntax checker.
  • We have migrated changelog to our newsletter system as well. So in the future, new changelog will also be delivered to your email automatically.

Bytebase 0.5.0

1 min read

๐Ÿš€ New Features

Project level activities

  • Database ownership transfer
  • Membership change
  • Version Control Workflow based push event

Version Control Workflow enhancement

  • Allow user to specify the migration file path template. Detailed guide
  • Allow user to specify the schema path template. This is useful to let repository always keep a complete schema of the corresponding database. Detailed guide
  • Record schema snapshot in every migration history record

A dedicated page for individual migration history

The page shows applied migration statement as well as the schema snapshot after the migration.

๐Ÿž Important Bug Fixes

MySQL 5.7 compatibility

In the previous version, Bytebase couldn't sync the migration history properly because it used a MySQL 8.0 only feature.

๐ŸŽ„ Enhancement

  • Make task scheduler run task asynchronously.
  • For database creation task, add database and its creation state (pending or created) to the issue sidebar.
  • For database schema update task, show indication if it's a baseline migration.
  • Add schema version link to the backup table row.

๐ŸŽ  Community

  • Thanks @chenliang for providing a detailed bug report for MySQL compatibility issue and even suggesting the fix.
  • Thanks @yaohui-wyh for the contribution.

Bytebase 0.4.1

1 min read

Update instruction

๐Ÿš€ New Features

SQL rollback (detailed guide)

User can now create rollback issue from the original closed issue easily via the UI.

๐ŸŽ„ Experience Enhancement

  • Taking backup in a single transaction to make the backup consistent.
  • Add alter schema button on the database detail page.
  • Add button to allow quickly applying SQL statements to other pipeline stages.
  • Hide project quick action list for non-project member.
  • Optimize database table list.

๐ŸŽ  Community

  • We have reworked our changelog and blog site to build directly on bytebase.com. This should offer a better browsing experience for our users.
  • We published our first technical post on database schema design Choose Primary Key - UUID or Auto Increment Integer? Go check it out.

Bytebase 0.4.0

1 min read

Update instruction

๐Ÿž Important Bug Fixes

MySQL 5.7 compatibility

In the previous version, Bytebase couldn't sync the migration history properly because it used a MySQL 8.0 only feature.

๐Ÿš€ New Features

Backup and restore (detailed guide)

User can now configure weekly automatic backup for the database. Meanwhile, user can also take manual backup anytime. Later on, User can restore the backup to a new database.

Webhook (detailed guide)

User can now configure webhook to allow Bytebase to post messages to the configured webhook endpoint upon varioius events. Bytebase currently supports following events:

  • Issue creation
  • Issue status change
  • Issue task status change
  • Issue info change such as its assignee, title, description
  • Issue comment creation

Bytebase also supports following webhook providers:

  • Slack
  • Discord
  • Microsoft Teams
  • DingTalk (้’‰้’‰)
  • Feishu (้ฃžไนฆ๏ผ‰
  • WeCome (ไผไธšๅพฎไฟก๏ผ‰

๐ŸŽ  Community

  • Thanks @zhj-hx for providing feedback and helping us troubleshooting the MySQL 5.7 compatibility issue
  • Thanks @iczc for the PR.

Bytebase 0.3.0

1 min read

Update instruction

๐Ÿš€ New Features

  • Environment approval policy (detailed guide) - For a particular environment, the workspace Owner or DBA can configure whether the database schema change requires approval.
  • Inbox - Added Inbox to the left sidebar. Issue's status change will post to its creator, assignee and subscribers inbox. If there occurs failed task, there will be additional alert symbol.
  • Database instance user sync - Bytebase will now periodically sync instance's users and their corresponding grants and display those info on the instance detail page. This helps Bytebase user to quickly recognize who has acccess to an certain instance.

๐ŸŽ  Community

  • We received our first customer review. Thanks @barretlee for the detailed review!
  • Our GitHub repository has reached 100 stars at the begining of the week. The user name is @binarysort :)
  • We appeared on GitHub Trending during the week and accumulated 500 stars over the week.

Bytebase 0.2.2

1 min read

Update instruction

๐Ÿž Important Bug Fixes

  • MySQL connection leak - In the previous version, when Bytebase does not properly release the connection after finishing connecting the MySQL instance, which will cause MySQL connection pool exhaustation.

๐Ÿš€ New Features

  • External SQL console (detailed guide) - Allow user to configure an external SQL console like phpMyAdmin. If configured, Bytebase will surface the link to the console in the relevant database and table page
  • Issue list page - Added a dedicated page to list issues. It supports to filter based on user/project/environment/issue status.
  • Project migration history tab - The tab lists the migration history for each database under that project. For each database, Bytebase will list at most 5 most recent migration history, and user can click the database name to view the complete migration history.

๐ŸŽ„ Experience Enhancement

  • Added new 403, 404 page

๐ŸŽ  Community

  • We launched our English blog, checkout our launch post.

Bytebase 0.2.0

1 min read

Update instruction

๐Ÿš€ New Features

  • Migration history - Added the migration history to the database detail page. This is applicable to project using either UI or Version Control workflow.
  • Table detail page - Added table detail page. This is normally reached via the database detail page. The table detail page displays the basic table info as well as its columns and indexes.

๐ŸŽ„ Experience Enhancement

๐ŸŽ  Community

  • In the first week after we open sourced Bytebase on GitHub, we have added 3 external contributors. We also created and resolved the first issue. Thanks @silentred, @s7v7nislands, @spinningbot for the PR, as well as @IronManZ suggestions on how to improve the MySQL setup guide.

Bytebase 0.1.0

0 min read

For fresh installation, follow https://github.com/bytebase/bytebase#installation.

We released our first open source version on GitHub. Please checkout our launch post.