ATProto Browser

Experimental browser for the Atmosphere

Post

@marcbrooker.bsky.social a question, if I may: snapshot isolation requires preventing lost updates on concurrent updates to the same row. Postgres does it by locking, but if you have cross-region comms only on commit, does that mean you abort on commit if there are concurrent updates to same row?

Dec 3, 2024, 10:33 PM

Loading post...

Record data

{
  "uri": "at://did:plc:nnhhbyo5prqipkd6t3cpp3l6/app.bsky.feed.like/3lch5zmrikf26",
  "cid": "bafyreia3lpihwsktrapahb4jujq6dnssoh2qob5h4jb7bxp5wqtgdb2duy",
  "value": {
    "$type": "app.bsky.feed.like",
    "subject": {
      "cid": "bafyreihon43rdbiceqehoegam4de6jgd2sz64lbqzqbv7avwtvtpvct5ge",
      "uri": "at://did:plc:vzmlifz3ghar4cu2hj3srga2/app.bsky.feed.post/3lcgozqszvs27"
    },
    "createdAt": "2024-12-04T03:01:22.789Z"
  }
}