Re:Ask HN: Have you used SQLite as a primary database?
by djbusby on Monday April 25, 2022 @08:34PM
(#31162627)
I'm just using shell scripts and the SQLite CLI. I dump/restore files to the same FS so I can mv into place when ready.
Checkout the PRAGMA user_version, I just modify on schema change, so app knows where stuff is.
(This is one of those things where I can "just Google it" but I was wondering if perhaps there was a particularly useful article that points out potential gotchas, etc)