Since I started using Duplicati a few years ago, I have struggled with the occasional SQLite database corruption. Mostly due to problems in indexes, such as referred in this thread, but just a week ago I had to completely dump and recreate the SQLite database. I’ve had this type of problems about once a year. Fortunately none of them have resulted (as of yet) in actual backup loss or corruption (at least as far as I can tell).
I do not rule out the possibility that I am just an unlucky case, or that the problem sits with my environment (although periodic disk and memory diagnostics haven’t revealed any issue, and my machine is just a standard Windows PC backing up data from an SSD to an external drive). However, similar issues in other projects that rely on SQLite can easily be found online.
Are there plans to support alternative database engines somewhere in the future? Or is Duplicati very tightly integrated with SQLite? Do any of you share concerns about the reliability of SQLite, or does it generally work without major problems?
Thank you for your insights.