I created a dedicated migration service consisting of sql migration files and small GO program that will run these migrations.
I am making progress dockerizing the services:
- GADM database – a Postgres instance with PostGIS extension and initial setup of roles, permissions and schemas.
- Api server – HTTP server written in GO.
- Migration service – An SQL scripts and a GO command line program that runs migrations
upanddown.
I am still jumping over a few hurdles related to deployment, migrations, seeding and overall automation but I feel like I am getting close.