search

cfredericks / golf-better

MIT License
0 stars 0 forks source link

Clean up Postgres setup #20

Open cfredericks opened 3 months ago

cfredericks commented 3 months ago

Not only do we need to cleanup migrations and add creation scripts to the repo, but also need to use a better username/password combo (i.e. not "postgres" username with a temp password), and also a separate DB schema (i.e. not "public"), and also disable the public IP on the cloud SQL instance

cfredericks commented 3 months ago

maybe something like this for migrations: https://github.com/postgres-ai/dle-github-actions, which uses sqitch: https://sqitch.org/docs/manual/sqitchtutorial/

cfredericks commented 2 months ago

Migrations added here, along with dockerized postgres for ITs: https://github.com/cfredericks/golf-better/pull/26