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.
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 ✅
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.
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:
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:
Owner and DBA can now enforce backup schedule policy for the specific environment. e.g. require daily backup for production environment.
Fresh install: /get-started/self-host
Upgrade: /get-started/upgrade
Warning: Bytebase does not support in-place downgrade. Make sure to back up your metadata before upgrading.
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.
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 ✅
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.
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:
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:
Owner and DBA can now enforce backup schedule policy for the specific environment. e.g. require daily backup for production environment.
Fresh install: /get-started/self-host
Upgrade: /get-started/upgrade
Warning: Bytebase does not support in-place downgrade. Make sure to back up your metadata before upgrading.