Considerations on DB install + extensions / migrations

[aschrijver]

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]

Thanks for these suggestions!