Safe SQLite Migrations
by zk C
Make irreversible SQLite schema changes safely: a read-only precheck that aborts on collisions, a mandatory backup, table rebuild, and rollback on FK errors.
I'm an independent developer building local-first, offline, privacy-conscious desktop software for small businesses. My main project is simple-erp, a lightweight order-and-ledger app for small shops - Flask + SQLite, running on a single Windows PC with no cloud and no login. I care about software that keeps your data on your own machine and stays simple enough to use every day.
by zk C
Make irreversible SQLite schema changes safely: a read-only precheck that aborts on collisions, a mandatory backup, table rebuild, and rollback on FK errors.