How to Shrink the Database

I had this same issue long ago. I have since migrated from rpi to a nuc, no more issues with writing to sd card on that.

But I did limit the logs, this is in my configuration.yaml

recorder:
  purge_keep_days: 7
#  purge_interval: 1