How to sync database with remote database with Dexie

Question

I making Notes PWA App that work offline and online.

I am saving notes records on IndexedDB with Dexie.js. I am using Quasar as frontend and backend as Laravel 8.

I want to sync IndexedDB Database with remote database. How can I do?

Did you find any solution to it? – Ritobroto Mukherjee Apr 27 '22 at 04:15 — Ritobroto Mukherjee, Apr 27 '22 at 04:15
please share the solution in a comment, if possible – Ritobroto Mukherjee Jul 19 '22 at 18:15 — Ritobroto Mukherjee, Jul 19 '22 at 18:15

score 1 · Answer 1 · answered May 23 '22 at 18:19

Look at Dexie Cloud - David has worked this out for Postgres.
If you want to write your own, it is a LOT MORE WORK than you think. We wrote our own to work with SQL Server and C#
(it is proprietary, I can't share it) Months later, we are still finding edge cases - there are many edge cases.
If you still want to write your own, you are probably mistaken..
If records can be created client side - use GUID identifiers
If it is an existing database with integer identifiers, add a GUID identifier field.
Set aside a few months of time to work out the rest.

1 Answers1