alt Hacker News> I love being able to backup by just doing a VACUUM INTO and then copying the resulting single file.
Naively, I would probably just copy the sqlite file. Is that a bad idea?
> I love being able to backup by just doing a VACUUM INTO and then copying the resulting single file.
Naively, I would probably just copy the sqlite file. Is that a bad idea?
I learned about the VACUUM INTO command through the following guide on how to backup your sqlite database: https://litestream.io/alternatives/cron/