News for hackers. Stuff that matters.
Re:Ask HN: Have you used SQLite as a primary database? by JohnBooty on Monday April 25, 2022 @04:10PM (#31159915)
Interesting, that's super cool to read.

   Tooling for dumping and restoring into a new schema are easy/simple/fast.
Any resources you can point to that expand on this? Is this standard SQLite tooling? I'm curious how it would perform with large-ish databases - a few hundred GB or perhaps several TB.

(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)

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.

https://www.sqlite.org/pragma.html