postowl
postowl copied to clipboard
Implement database migrations
Currently fly-start.sh
and schema.sql
naively create tables in the DB if they don't already exist.
This allows for creating a new db on first launch and preserving content when redeploying.
But we don't have a way to do migration if we alter the db structure.
Current preferred approach is what's documented here https://david.rothlis.net/declarative-schema-migration-for-sqlite/ and in this HN discussion: https://news.ycombinator.com/item?id=31249823)