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