@Crazypedia
The challenge with encryption: if your local database is lost/corrupted, you lose the encryption key too, making encrypted backup useless for recovery.
The only viable E2E approach would be deriving the key from a user passphrase, but most users won't remember/backup it properly, defeating the recovery purpose.
That's why plaintext relay backup might be more practical for actual data recovery, despite privacy trade-offs.