Use PostgreSQL service containers

[jeliasson]

I suggest using PostgreSQL service containers if possible.

deploy-target-ci/.github/actions/project-ci/action.yaml

Lines 23 to 29 in c827003

	- name: Set up Postgres
	uses: CasperWA/postgresql-action@v1
	with:
	postgresql version: '14'
	postgresql db: 'test'
	postgresql user: test
	postgresql password: password

[thedavidprice]

Nice! I'll add this to the Action I'm building for CI over here:

• https://github.com/redwoodjs/deploy-target-ci/blob/main/.github/actions/project-ci/action.yaml

I'd like this to be something we eventually publish to the GitHub Marketplace as "Redwood CI". It's almost there — just need to make each step optional and figure out if I need to add SQLite support (probably not).

@jtoar I've been meaning to have you look at this. When I try to use this action in my workflow here (https://github.com/redwoodjs/deploy-target-ci/tree/main/.github/workflows) I get syntax errors and run into a problem related to using a "local action in workflow". By chance, do you know how to resolve this so I can use this action instead of copy/paste the steps for each Job in my workflow?

[virtuoushub]

fwiw I got this working over at: https://github.com/redwoodjs/example-storybook/blob/main/.github/workflows/node.js.yml#L17-L36