> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bytebase 0.7.0 - Oct 07, 2021

> PostgreSQL support, schema drift detection, anomaly center, backward incompatible schema migration check, backup schedule enforcement and more

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](https://cloud.google.com/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.

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/0.7.0/schema-drift.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=e161626cd3b18e8a4aee0e710c324f06" alt="_" width="1213" height="474" data-path="content/changelog/0.7.0/schema-drift.webp" />

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/0.7.0/schema-drift-detail.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=f7eee7ed264400489588db418478187b" alt="_" width="1403" height="692" data-path="content/changelog/0.7.0/schema-drift-detail.webp" />

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

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/0.7.0/anomaly-center.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=a72dd0807c32768dcc6fcfcd5d824e6c" alt="_" width="1267" height="894" data-path="content/changelog/0.7.0/anomaly-center.webp" />

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](https://www.bytebase.com/docs/sql-review/error-codes/#compatibility) and surface them in the SQL review panel:

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/0.7.0/backward-compatible-check.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=8545f428c84d4e4a5ab29489b0ad5f9f" alt="_" width="1284" height="458" data-path="content/changelog/0.7.0/backward-compatible-check.webp" />

### Backup schedule enforcement

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

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/0.7.0/environment.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=e41ea510e841c33ecaaef62114488962" alt="_" width="1223" height="811" data-path="content/changelog/0.7.0/environment.webp" />

## 🎄 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](https://www.bytebase.com/) with the wonderful illustration. The figure derives from our logo and we plan to continue this path to strength our branding identity.

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/0.7.0/frontpage.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=fe1769c6d1fc94e16b4e54575d36e7e3" alt="_" width="1423" height="760" data-path="content/changelog/0.7.0/frontpage.webp" />

* We have open sourced our [take-home interview assignment](https://github.com/bytebase/interview).  And yes, we are looking for talented frontend engineer and full-stack engineer to join our remote team. Checkout [job details](https://www.bytebase.com/jobs).

## ⚙️ Install and Upgrade

* [Fresh install](/get-started/self-host/deploy-with-docker)

* [Upgrade](/get-started/self-host/upgrade)

*Before upgrading: 1) Back up the [metadata](https://www.bytebase.com/docs/administration/back-up-restore-metadata/) — in-place downgrade is not supported. 2) Do not run multiple containers on the same data directory. 3) Terraform users: upgrade Bytebase server first, then apply the new Terraform config.*
