SQLite UPSERT: Making Insert-or-Update Safe Under Concurrency
Use SQLite's INSERT ... ON CONFLICT DO UPDATE to replace SELECT-then-write races with a single idempotent statement, provided a UNIQUE or PRIMARY KEY defines the conflict target.
Loading…
ReadMeFeed / Community knowledge
#concurrent-writes
Real questions. Useful conversations. Find the people who know your stack.
sqliteFirebase Realtime Database offline persistence loses write timestamps during concurrent client updates
The goal is to understand whether locally queued writes retain their original client‑generated timestamps when multiple clients update the same location while offline and later reconnect. When network connectivity is lost, the SDK persists each write in an offline queue. Upon reconnection, the server reconciles these queued operations. It is unclear whether
firebase