Litestream solves the backup issue. I use it and it’s great.