ATProto Browser

ATProto Browser

Experimental browser for the Atmosphere

Post

how about singling out the most commonly used columns as another, separate table and keep the join by 1 key column as principle (sql like)?

Mar 5, 2024, 6:30 AM

Record data

{
  "uri": "at://did:plc:sj4us4pfmzfywarwpi2o3adl/app.bsky.feed.post/3kmwjxxl6f32j",
  "cid": "bafyreigd4clwks3rr5fil2mn4rgz6o2rwo6buvtrryvjklogdgkdsaupfa",
  "value": {
    "text": "how about singling out the most commonly used columns as another, separate table and keep the join by 1 key column as principle (sql like)?",
    "$type": "app.bsky.feed.post",
    "langs": [
      "en"
    ],
    "reply": {
      "root": {
        "cid": "bafyreiaqbomerjnjnazhpuxqui3oikj3xaebhbfbhqun5sgg3lo2lqqotq",
        "uri": "at://did:plc:46kxtxm6ylz7wyabjs5svijj/app.bsky.feed.post/3kmv3iawe7t2u"
      },
      "parent": {
        "cid": "bafyreiaqbomerjnjnazhpuxqui3oikj3xaebhbfbhqun5sgg3lo2lqqotq",
        "uri": "at://did:plc:46kxtxm6ylz7wyabjs5svijj/app.bsky.feed.post/3kmv3iawe7t2u"
      }
    },
    "createdAt": "2024-03-05T06:30:52.435Z"
  }
}