Make installation easier by creating necessary tables automatically when the app starts up.
Let users initialize the database with a command in the app.
Check for some default table that won't change, like collections, posts, app or app_config. If it doesn't exist, run schema.sql.
Ideally, we should embed schema.sql into the binary when we build a release, so there are fewer files laying around.
| Status | Assigned | Task | ||
|---|---|---|---|---|
| Resolved | matt | T509 Add database migration | ||
| Open | None | T528 Add database check when starting up | ||
| Resolved | matt | T529 Support SQLite for storage | ||
| Resolved | matt | T530 Import schema |
Looking at a way to include schema.sql in the binary now. So many libraries to pick from...
That latest change still needs schema.sql in the same folder, but adds the option to create tables with writefreely --init-db
Remaining work here is mentioned in T536: Compile all static / default assets into binary.