ATProto Browser

ATProto Browser

Experimental browser for the Atmosphere

Post

I am a big big fan of sqlite, including for blobs, but I looked at their os_unix.c and it doesn't do anything special beyond fdatasync on the file and fsync on the directory. I *think* it doesn't even try to keep the dir inode in cache like Postgres to avoid losing a write-through error.

Apr 22, 2025, 3:42 PM

Record data

{
  "uri": "at://did:plc:x2nsupeeo52oznrmplwapppl/app.bsky.feed.post/3lnfze2fqms2a",
  "cid": "bafyreicclzwkuiwk5zh5lul6fjlyqzzhtnz4hyjf3f6navusufsyhi3w2a",
  "value": {
    "text": "I am a big big fan of sqlite, including for blobs, but I looked at their os_unix.c and it doesn't do anything special beyond fdatasync on the file and fsync on the directory.\n\nI *think* it doesn't even try to keep the dir inode in cache like Postgres to avoid losing a write-through error.",
    "$type": "app.bsky.feed.post",
    "langs": [
      "en"
    ],
    "reply": {
      "root": {
        "cid": "bafyreicmefqkxgbh2xfhrnjqbpxa43nej4w3qpmt4t7qhbm43ygax6lw7m",
        "uri": "at://did:plc:x2nsupeeo52oznrmplwapppl/app.bsky.feed.post/3lnfdtqcm5k2f"
      },
      "parent": {
        "cid": "bafyreiabg42tb7zwk7zmfjc5svi7s4vmo4caqzlkp5mu4je7c22yqmgugi",
        "uri": "at://did:plc:vwzwgnygau7ed7b7wt5ux7y2/app.bsky.feed.post/3lnfswxtr5k2x"
      }
    },
    "createdAt": "2025-04-22T15:42:12.327Z"
  }
}