I am in love with the editor that Joplin provides, but the sync features are just not great. I’ve uninstalled and reinstalled the app a dozen times now trying to get things working, and something always goes wrong. I’ve corrupted the database several times and nothing I do will make the encryption & sync features work in tandem.
Why not get rid of the local database / sync database and merge them into one? Let the sync software (Dropbox and friends) handle the syncing and let the note taking software handle the note taking.
Also, the databse is just too delicate. There’s no way this is going to work long-term if the only way to fix database problems is to delete everything and restore from backup. Realistically though, the database needs to be much more robust.