Re:Ask HN: What's the database you use for your simple website?
by japhyr on Saturday November 23, 2019 @06:50PM
(#21617399)
An sqlite database is a single file. So backing it up is as easy as copying that single file to an archive directory.
[ Parent
| on HN ]
Re:Ask HN: What's the database you use for your simple website?
by thijsvandien on Sunday November 24, 2019 @07:04AM
(#21619901)
Essentially true, but you need to make sure the file will be in a consistent state. Rather than locking it, it’s better to use the Backup API or VACUUM INTO command.