Ask HN: What does your development / test DB setup look like?

When I'm developing or testing a new app, I usually spin up a test database (I use Postgres) with the `createdb` command and then add dummy data using a series of plain sql files with `insert` commands. This works, but it can get tedious, particularly as table definitions change and the schema becomes complex. Curious how others have approached this.