Deploy requests now alert on potential unwanted changes
Mike Coutermarsh
Mike Coutermarsh
7/6/2022
Product4 min read

Deploy requests now alert on potential unwanted changes

We'd like to share a little detail we just shipped to the Deploy Request UI. We now show you if your schema change could result in the loss of any data due to a dropped column or table.

Deploy Request data loss warning

We're on a mission to make deploy requests the safest and least stressful way to make schema changes.

Earlier this year, we released Rewind, an in-dashboard feature that lets you revert a production schema change with one click, all while keeping any data that was written in the meantime.

Now, with this small addition to the UI, we hope to further protect developers from mistakes by surfacing warnings straight on the deploy request page.

Inspired by a rename#

The inspiration for this feature primarily came from developer's experience renaming columns through PlanetScale. It was a common question that came up: how do I safely rename a column?

A rename is an unsafe operation when it comes to zero downtime deployments.

For a rename to work successfully, you'd have to deploy your schema change and code changes at exactly the same time. This is highly risky, if not impossible to get right.

In cases where you do want to do a rename, here's the safe way:

  1. Create the new column
  2. Update your application to double write to both the old and new column
  3. Run a script to backfill old data
  4. Update your app to read from the new column
  5. Remove double writes
  6. You can now safely drop the old column

Each step is a deployment of your application. This is certainly a bit of extra work, but it's the safest way to complete a rename without risk to production or having to take your application down.

Try it#

You can give this a try today. Drop a table or column in a deploy request, and you'll see you get alerted about the risky change.

Data loss warning with example drop column SQL

If you have any feedback, we'd love to hear it. You can find us on Twitter or our GitHub discussion board.

Your business deserves a predictable database.

Never worry about another 3am wake-up call saying the site is down. Give your engineers the power they deserve with a PlanetScale database today.