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

Back to Collection

Record JSON

{
  "$type": "app.bsky.feed.post",
  "createdAt": "2024-04-01T18:31:02.497Z",
  "langs": [
    "en"
  ],
  "reply": {
    "parent": {
      "cid": "bafyreicu5vxteqk457fru2peileearmehav2iszipoom5g5dyyliqzbv6i",
      "uri": "at://did:plc:oio4hkxaop4ao4wz2pp3f4cr/app.bsky.feed.post/3kp3nwr46s32e"
    },
    "root": {
      "cid": "bafyreibkwtou3lmwa7gndwk2qtni4j74kjylke3eohtdtbi5j2mn5vklna",
      "uri": "at://did:plc:4nsduwlpivpuur4mqkbfvm6a/app.bsky.feed.post/3kp3jfv6bmu2q"
    }
  },
  "text": "Yeah, sure thing. At 2024-03-31T23:55:00Z the MAU count was 1605721 and then at 2024-04-01T00:00:00Z it was 1665137.\n\nFor each firehose event I upsert into a sqlite3 DB the repo DID and the commit timestamp. Reporting is \"select count(*) from users where ts \u003e strftime('%s', 'now', '-1 month')\"."
}