POSTGRES

Summary from the TLDR newsletter

Database schema migrations are essential for keeping systems up to date and in sync with evolving application requirements, but they come with many challenges. Many developers choose to avoid complex migrations due to this and only make additive changes, resulting in an accumulation of technical debt in the database schema. pgroll is a command-line tool for performing schema migrations against Postgres databases. It allows users to define schema migrations using a high-level JSON format and then takes care of executing them.