3 ms·
Have you seen Sqitch (https://sqitch.org/ https://sqitch.org/)? It does exactly this, it's a battle-tested system with a decent number of users, and it supports
by autarch 5y ago
Have you seen Sqitch (https://sqitch.org/ https://sqitch.org/)? It does exactly this, it's a battle-tested system with a decent number of users, and it supports many database. I didn't dig deep into this new system, but it looks very much like Sqitch at a glance.
- halostatue 5y agoI use sqitch quite heavily on one of our projects, and miss it on the one where we use Ecto migrations with Elixir (although, for in-built migration functionality, Ecto migrations are very good). Installing sqitch and pgTAP (a unit testing framework for PostgreSQL) has always been a pain, so I ended up making a docker image that we now use at work: https://github.com/kineticcafe/docker-sqitch-pgtap https://github.com/kineticcafe/docker-sqitch-pgtap
- autarch 5y agoThere are official Sqitch Docker images - https://hub.docker.com/r/sqitch/sqitch/ https://hub.docker.com/r/sqitch/sqitch/ But I don't know if they have pgTAP on them. Edit: I just checked. It doesn't look like they do - https://github.com/sqitchers/docker-sqitch/blob/main/Dockerfile https://github.com/sqitchers/docker-sqitch/blob/main/Dockerf...
- halostatue 5y agoI just did an update and release 1.1.0 of my docker image with support for pgTAP from 9.6 to 14. I should write up examples of how we use it, but we use a variant of the `run` script in the docker image. I’ve also built my docker image with multiple architectures as I run on arm64 but need to run on amd64 servers. The Sqitch docker images appear to be _just_ amd64 images. The other difference is that I’m using alpine instead of debian-slim.