So currently I’ve been using a tool called Migrate to perform all my database migrations for Postgres when my application starts (Creating / Altering / Deleting tables).
However I now need to seed my database (filling some tables with data) and unfortunately this tool only really supports performing migrations it seems as it requires an .up and .down file to rollback the db to specific versions.
Is there a similar tool out there that’s well supported and can basically do a very similar thing by running through
.sql files that insert data into postgres?
I suppose I could just add the insert .sql files as a migration file, but if there’s a specific tool I would prefer that.