postowl icon indicating copy to clipboard operation
postowl copied to clipboard

Implement database migrations

Open keybits opened this issue 1 year ago • 1 comments

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)

keybits avatar Jun 15 '23 16:06 keybits