Riiiight up to the point that the database needs to be online and running backups at the same time.
When that occurs, your “simple” tech choice suddenly becomes a too simple straitjacket.
When that occurs, your “simple” tech choice suddenly becomes a too simple straitjacket.
You can also use Litestream to create snaphots.