some code similar to that (but just with synchronous=1 (NORMAL), which is safe for WAL mode):

https://github.com/jedie/PyHardLinkBackup/blob/v0.13.0/pyhardlinkbackup/backup_app/models.py#L20