Schema Versioning

Schema Versioning allows you to roll-back in case you make a mistake.

You can leverage versioning to help you solve problems, see differences in your work, test ideas, and easily revert back to previous versions. It also tracks who from your team made a change, and when the change was made.

Schema versioning is for database tables, API groups, API endpoints, functions, Addons, and background tasks. It allows you to easily roll back to a previous version in case you make a mistake.

The Launch and Scales plans have schema versioning enabled. The Launch plan tracks the 3 most recent versions of each database table, API group, API endpoint, function, Addon, and background task. The Scale plan keeps a record of 20 versions.

How to open schema version history

View your active (current) version, select from a previous one to roll-back, and see who made a change and when.

Version history will keep track of changes you make anywhere on a query, whether you make a change to a function or a filter. For API endpoints and functions, version history keeps a count of how many inputs, functions, and results were included in each version.

Tasks will show how many functions and schedules there were for each version.

Addons will show a count of how many inputs each version had.

Compare Differences

When selecting a previous version, you can view a screenshot of the version and the differences compared to the active version. This gives you full context of the different versions to see exactly what changes were made and whether or not you indeed want to revert to the previous version.

APIs

For example, here is the live version of an API endpoint:

After selecting Version History, we can see the different versions with some metadata and publish notes about each:

By clicking on a version, in this example we selected version #2, a modal opens showing the differences present in the current live version #4 as compared to the state of version #2.

The difference comparison tells us a few things.

  • The live version (indicated at the top) and when it was created.

  • The email of who created the version.

  • What differences the live version has compared to the old version selected.

  • When the old version was created.

  • Indications of what's been changed from the old version compared to the state of things in the live version.

Lastly, you can easily navigate through the screenshots of the different old versions.

Database

Difference comparison in schema versioning is also available on the database. In addition to information about the version number, created at time, and creator. Difference comparison on the database will include differences in:

  • Schema (columns)

  • Indexes

  • View

Last updated