When migrating JSON data in Postgres, it's often necessary to delete properties within a JSON object. There's a neat operator for it #-. In this example the property comment was stored as an empty string instead of the property just missing. So we delete the property for all domain messages

You can't just add a new non-nullable column to a table when it already has entries in it, as those would be pre filled with NULL. An easy solution is to create it with DEFAULT NULL, update the data and then make it non-nullable. This can look like this: ALTER