←back to thread

MVCC – the part of PostgreSQL we hate the most (2023)

(www.cs.cmu.edu)
366 points virtualwhys | 1 comments | 20 Oct 24 15:30 UTC | HN request time: 0.277s | source
Show context
uvas_pasas_per ◴[21 Oct 24 12:21 UTC] No.41903373[source]▶
My problem with PG is it just doesn't seem to help much with my situation. I want to write apps that work offline and sync data across devices using the 'cloud'. I think that means Sqlite on the client, but ?? for the server. I have yet to find a good book explaining techniques for this kind of replication/syncing.
replies(4): >>41903396 #>>41903423 #>>41903746 #>>41904249 #
1. beng-nl ◴[21 Oct 24 12:27 UTC] No.41903423[source]▶
At risk of saying something you know, CRDT’s may be a good fit for your use case.

The problem is of course making changes offline that the user assumes are permanent but then later, when sync time comes, then turn out to conflict with changes made in the meantime. So changes can’t be made permanent. Either that requires difficult UX to reconcile or something that always will give you something consistent, like a crdt.