Litestream is a library that allows you to easily create backups. You can probably just do analytics queries on the backup data.

https://litestream.io/