2 ms·
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 expan
by JohnBooty 5y ago
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)
- djbusby 5y agoI'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 https://www.sqlite.org/pragma.html