So, the final choice is dexie + custom backend? I've researched these open source solution before, I think dexie is the choice that you will never regret.

fyi https://dexie.org/