I want to test a CLI that should connect to PostgreSQL and MySQL servers using GitHub actions, on all platforms if possible: Linux, Windows and macOS.
I found instructions on how to run a Postgres services via https://github.com/actions/example-services/blob/master/.github/workflows/postgres-service.yml I found similar instruction for MySQL at https://itnext.io/github-actions-ci-configuration-for-ruby-on-rails-project-with-mysql-redis-elasticsearch-how-82ed417e3a3d.
I combined these into a workflow, https://github.com/janpio/github-action-services-test/blob/master/.github/workflows/test.yml, but this only seems to work on Linux, not Windows or macOS:
Windows fails during
Initialize Containers with
##[error]Container operation is only supported on Linux, macOS even during
Set up job with
##[error]File not found: 'docker'.
https://help.github.com/en/articles/workflow-syntax-for-github-actions#jobsjob_idservices doesn’t mention that this will only work on Linux, but I also do not know much about containers or Docker so might be missing something obvious.
Is it possible to run MySQL and PostgreSQL services on Windows and macOS on GitHub Actions?
If not, what is the best workaround here?