Experimental browser for the Atmosphere
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
{ "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" } }