Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Normalize the database initialization approach #159

Open
morganney opened this issue Jan 7, 2024 · 0 comments
Open

Normalize the database initialization approach #159

morganney opened this issue Jan 7, 2024 · 0 comments
Labels
db Related to database changes or work

Comments

@morganney
Copy link
Owner

Currently when using local development or a potential docker compose production deploy on an EC2 instance, for example, the database is initialized from the packages/api/initdb.d scripts. However, deployment to AWS via copilot does not run these initialization scripts because an Aurora Postgres cluster is used, so in that case node packages/api/dist/initDb.js is used.

Find a way to have one location for the initialization logic, so that I don't have to manage keeping the two in sync. Easy thought is to have psql installed on the api container and then put it all in a shell script to execute, but that would add some bloat to the image size, and other tradeoffs I'm sure.

@morganney morganney added the db Related to database changes or work label Jan 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
db Related to database changes or work
Projects
None yet
Development

No branches or pull requests

1 participant