ATProto Browser

Record data

{
  "uri": "at://did:plc:xrixj7xn45gd7ea2ev3vxgdm/app.bsky.feed.post/3l525kdlqlr2c",
  "cid": "bafyreie75fejcny5tjnadsvvku5ml7o64vita5gremopvtbubux4xy667y",
  "value": {
    "text": "#database #tip When you submit a query filtering on functions of an indexed column (date from a timestamp, uppercase of a name, etc.) the index cannot be used, which leads to poor performance. On #postgresql, a solution consists in indexing column evaluations. www.postgresql.org/docs/current...",
    "$type": "app.bsky.feed.post",
    "embed": {
      "$type": "app.bsky.embed.external",
      "external": {
        "uri": "https://www.postgresql.org/docs/current/sql-createindex.html",
        "thumb": {
          "$type": "blob",
          "ref": {
            "$link": "bafkreihqllsifplsonqmperwoabq5jijvtp4rzghp6ambf6sq7epfhu5xy"
          },
          "mimeType": "image/jpeg",
          "size": 259998
        },
        "title": "CREATE INDEX",
        "description": "CREATE INDEX CREATE INDEX — define a new index Synopsis CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ …"
      }
    },
    "langs": [
      "en"
    ],
    "facets": [
      {
        "index": {
          "byteEnd": 9,
          "byteStart": 0
        },
        "features": [
          {
            "tag": "database",
            "$type": "app.bsky.richtext.facet#tag"
          }
        ]
      },
      {
        "index": {
          "byteEnd": 14,
          "byteStart": 10
        },
        "features": [
          {
            "tag": "tip",
            "$type": "app.bsky.richtext.facet#tag"
          }
        ]
      },
      {
        "index": {
          "byteEnd": 207,
          "byteStart": 196
        },
        "features": [
          {
            "tag": "postgresql",
            "$type": "app.bsky.richtext.facet#tag"
          }
        ]
      },
      {
        "index": {
          "byteEnd": 295,
          "byteStart": 261
        },
        "features": [
          {
            "uri": "https://www.postgresql.org/docs/current/sql-createindex.html",
            "$type": "app.bsky.richtext.facet#link"
          }
        ]
      }
    ],
    "createdAt": "2024-09-26T07:42:14.760Z"
  }
}