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.

Sign up for GitHub

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

Jump to bottom

Move to Postgres #129

Open

1 of 5 tasks

finnbar opened this issue Feb 25, 2022 · 1 comment

Labels

backend IMPORTANT

Collaborator

finnbar commented Feb 25, 2022 •

edited

Loading

SQLite is fine, but not ideal for the concurrent accesses which tablebot relies on. We should move to Postgres.

Work out what CompSoc provides in terms of database access.
Spin up a Docker image for development (e.g. https://github.com/mbg/network-wait/blob/main/docker-compose.postgresql.yaml)
Replace any necessary Persistent calls.
Work out how to migrate SQLite -> Postgres.
Modify backup script to use Postgres.

finnbar added the backend label

Collaborator

L0neGamer commented Apr 22, 2022

Compsoc should be able to provide credentials for postgres, and possibly mysql although that's less clear.

finnbar added the IMPORTANT label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment