at://edavis.dev/app.bsky.feed.post/3kzxgryclsq22

Back to Collection

Record JSON

{
  "$type": "app.bsky.feed.post",
  "createdAt": "2024-08-18T01:34:01.430Z",
  "embed": {
    "$type": "app.bsky.embed.images",
    "images": [
      {
        "alt": "edavis.dev 01/07/2024 10:43 AM\nI have a working theory on the PLC createdAt stuff. The database stores the value with microsecond resolution while JS Date has millisecond resolution.\nEffectively, the code that handles the after filter appends three zeros to the milliseconds portion to convert it to microseconds. So a filter with 977 milliseconds becomes 977000 microseconds in the SQL which naturally will pick up a record at, say,\n977321 microseconds.",
        "aspectRatio": {
          "height": 864,
          "width": 1284
        },
        "image": {
          "$type": "blob",
          "ref": {
            "$link": "bafkreidkgtipppl5tdhvykqddkaupkaaoustupxjeyeuuhsyvq5dvp3qje"
          },
          "mimeType": "image/jpeg",
          "size": 345875
        }
      }
    ]
  },
  "langs": [
    "en"
  ],
  "reply": {
    "parent": {
      "cid": "bafyreigvgu5e7zqlky362twlkj5hb5jkpgz4nshaso5nn5aahkrnthhi3q",
      "uri": "at://did:plc:oio4hkxaop4ao4wz2pp3f4cr/app.bsky.feed.post/3kzxfvko23w27"
    },
    "root": {
      "cid": "bafyreigvgu5e7zqlky362twlkj5hb5jkpgz4nshaso5nn5aahkrnthhi3q",
      "uri": "at://did:plc:oio4hkxaop4ao4wz2pp3f4cr/app.bsky.feed.post/3kzxfvko23w27"
    }
  },
  "text": "This drove me insane. Would love to see a ops firehose endpoint someday."
}