Considerations on DB install + extensions / migrations - Githubissues

go-fed / apcore

Golang ActivityPub Server Framework

GNU Affero General Public License v3.0

104 stars 10 forks source link

Considerations on DB install + extensions / migrations #55

Open aschrijver opened 3 years ago

aschrijver commented 3 years ago

The following is based on my gofed apcore example installation experience.

Database installation

Some suggestions and observations (for separate issues):

[ ] RFC: DB + dbuser creation and configuration are not part of the CLI script, but might be.
[ ] RFC: Add extension: CREATE EXTENSION IF NOT EXISTS "pgcrypto";
[ ] RFC: Dump a .sql installation script of the actions that were performed on the DB.
[ ] BUG: A subsequent reinstall with ./example init-db fails, unless recreating the DB.

Regarding the postgres.go code:

Consider separating DB creation / install / initialization from other DB queries.

Database extensions / migrations

For my understanding of working with apcore I'd need examples of how to:

Make extensions to the DB schema (add / redefine table property, add table / index / etc.).
Facilitate DB extensions when upgrading my app, without (or with minimal) prod downtime.

cjslep commented 3 years ago

Thanks for these suggestions!