Comment

Comment by pierregillesl

Don't forget to stop writing to the database while doing the backup, otherwise you can run into an infinite loop if you write faster than sqlite3 .backup is doing the backup :D

Learned that the hard way when implementing sqlite3 backups on Gladys Assistant ( open-source home automation platform https://github.com/GladysAssistant/Gladys )

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton