I'm always looking for ways to keep data consistent. Or rather, for the database to ensure that its data is consistent. PostgreSQL has a number of tools for this. Great places to start are consistent…
It all started with wanting to move a column from one table to another. The schema changes were straightforward enough. We wanted to keep the data as well, so that too needed to be migrated. We wrote…
Constraints are a great way to ensure that an app's data conforms to certain business rules. For instance, many apps have user accounts that are identified by an email address. If a person's email…