Have to admit, I have been unsuccessful in relocating the database and have the same interest of being able to exclude the database file from the Snapshot. I think having it as a checkbox option during the snapshot process would be great, but relocating the database seems viable.
The documentation for recorder states:
db_url
(string)(Optional)
The URL that points to your database.
However, my efforts to use this to modify the location (including the examples in this thread) have failed with a Recorder could not load error. I am running HA Supervisor without any additional database architecture other than Recorder. The .db file is in my config folder as is typical. Could someone tell me what that URL would look like? With that, I can hopefully make the necessary modification to make it work for me.