Hacker News new | ask | show | jobs
by mannycalavera 1894 days ago
If WAL is enabled it's easy to backup your sqlite db by using VACUUM INTO <file>.

More detailed docs: https://www.sqlite.org/lang_vacuum.html#vacuuminto