🐦 Twitter Post Details

Viewing enriched Twitter post

@JustinMitchel

So... Postgres is now basically a search engine? pg_textsearch was just open sourced. It enables BM25 to search your database.... massive upgrade for key word search. Google uses BM25 in their search engine. Claude told me: "if you're already on Postgres, you can now skip the whole sync-your-data-to-Elasticsearch dance for search." (ps, how can you not love Claude). Now I got to figure out how to implement in my Django querysets... future course? Grab it at https://t.co/bMwRSgtOcO #sponsored

Media 1
View on Twitter

📊 Media Metadata

{
  "media": [
    {
      "url": "https://crmoxkoizveukayfjuyo.supabase.co/storage/v1/object/public/media/posts/2001750598329499681/media_0.jpg?",
      "media_url": "https://crmoxkoizveukayfjuyo.supabase.co/storage/v1/object/public/media/posts/2001750598329499681/media_0.jpg?",
      "type": "photo",
      "filename": "media_0.jpg"
    }
  ],
  "processed_at": "2025-12-20T13:05:59.671113",
  "pipeline_version": "2.0"
}

🔧 Raw API Response

{
  "type": "tweet",
  "id": "2001750598329499681",
  "url": "https://x.com/JustinMitchel/status/2001750598329499681",
  "twitterUrl": "https://twitter.com/JustinMitchel/status/2001750598329499681",
  "text": "So... Postgres is now basically a search engine? \n\npg_textsearch was just open sourced. It enables BM25 to search your database.... massive upgrade for key word search.\n\nGoogle uses BM25 in their search engine. \n\nClaude told me: \"if you're already on Postgres, you can now skip the whole sync-your-data-to-Elasticsearch dance for search.\"\n\n(ps, how can you not love Claude).\n\nNow I got to figure out how to implement in my Django querysets... future course? \n\nGrab it at https://t.co/bMwRSgtOcO\n\n#sponsored",
  "source": "Twitter for iPhone",
  "retweetCount": 360,
  "replyCount": 78,
  "likeCount": 4527,
  "quoteCount": 35,
  "viewCount": 439646,
  "createdAt": "Thu Dec 18 20:25:08 +0000 2025",
  "lang": "en",
  "bookmarkCount": 4245,
  "isReply": false,
  "inReplyToId": null,
  "conversationId": "2001750598329499681",
  "displayTextRange": [
    0,
    278
  ],
  "inReplyToUserId": null,
  "inReplyToUsername": null,
  "author": {
    "type": "user",
    "userName": "JustinMitchel",
    "url": "https://x.com/JustinMitchel",
    "twitterUrl": "https://twitter.com/JustinMitchel",
    "id": "14539807",
    "name": "Justin Mitchel",
    "isVerified": false,
    "isBlueVerified": true,
    "verifiedType": null,
    "profilePicture": "https://pbs.twimg.com/profile_images/1793331492569108480/_FdZ0rWD_normal.jpg",
    "coverPicture": "",
    "description": "",
    "location": "Meridian, ID",
    "followers": 3516,
    "following": 614,
    "status": "",
    "canDm": true,
    "canMediaTag": true,
    "createdAt": "Sat Apr 26 04:45:59 +0000 2008",
    "entities": {
      "description": {
        "urls": []
      },
      "url": {}
    },
    "fastFollowersCount": 0,
    "favouritesCount": 3141,
    "hasCustomTimelines": true,
    "isTranslator": false,
    "mediaCount": 348,
    "statusesCount": 3563,
    "withheldInCountries": [],
    "affiliatesHighlightedLabel": {},
    "possiblySensitive": false,
    "pinnedTweetIds": [],
    "profile_bio": {
      "description": "build your SaaS with https://t.co/ecQi2brqug. learn to 10x your output with https://t.co/9pxHgHBF6b. 3x dad.",
      "entities": {
        "description": {
          "urls": [
            {
              "display_url": "paracord.co",
              "expanded_url": "https://paracord.co",
              "indices": [
                21,
                44
              ],
              "url": "https://t.co/ecQi2brqug"
            },
            {
              "display_url": "cfe.sh",
              "expanded_url": "http://cfe.sh",
              "indices": [
                76,
                99
              ],
              "url": "https://t.co/9pxHgHBF6b"
            }
          ]
        },
        "url": {
          "urls": [
            {
              "display_url": "cfe.sh",
              "expanded_url": "http://cfe.sh",
              "indices": [
                0,
                23
              ],
              "url": "https://t.co/9pxHgHBF6b"
            }
          ]
        }
      }
    },
    "isAutomated": false,
    "automatedBy": null
  },
  "extendedEntities": {},
  "card": {
    "binding_values": [
      {
        "key": "photo_image_full_size_large",
        "value": {
          "image_value": {
            "height": 419,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=800x419",
            "width": 800
          }
        }
      },
      {
        "key": "thumbnail_image",
        "value": {
          "image_value": {
            "height": 200,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=400x400",
            "width": 400
          }
        }
      },
      {
        "key": "description",
        "value": {
          "string_value": "PostgreSQL extension for BM25 relevance-ranked full-text search - timescale/pg_textsearch"
        }
      },
      {
        "key": "domain",
        "value": {
          "string_value": "github.com"
        }
      },
      {
        "key": "thumbnail_image_large",
        "value": {
          "image_value": {
            "height": 300,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=600x600",
            "width": 600
          }
        }
      },
      {
        "key": "summary_photo_image_small",
        "value": {
          "image_value": {
            "height": 202,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=386x202",
            "width": 386
          }
        }
      },
      {
        "key": "thumbnail_image_original",
        "value": {
          "image_value": {
            "height": 600,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=orig",
            "width": 1200
          }
        }
      },
      {
        "key": "site",
        "value": {
          "scribe_key": "publisher_id",
          "user_value": {
            "id_str": "13334762"
          }
        }
      },
      {
        "key": "photo_image_full_size_small",
        "value": {
          "image_value": {
            "height": 202,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=386x202",
            "width": 386
          }
        }
      },
      {
        "key": "summary_photo_image_large",
        "value": {
          "image_value": {
            "height": 419,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=800x419",
            "width": 800
          }
        }
      },
      {
        "key": "thumbnail_image_small",
        "value": {
          "image_value": {
            "height": 72,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=144x144",
            "width": 144
          }
        }
      },
      {
        "key": "thumbnail_image_x_large",
        "value": {
          "image_value": {
            "height": 600,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=png&name=2048x2048_2_exp",
            "width": 1200
          }
        }
      },
      {
        "key": "photo_image_full_size_original",
        "value": {
          "image_value": {
            "height": 600,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=orig",
            "width": 1200
          }
        }
      },
      {
        "key": "photo_image_full_size_alt_text",
        "value": {
          "string_value": "PostgreSQL extension for BM25 relevance-ranked full-text search - timescale/pg_textsearch"
        }
      },
      {
        "key": "vanity_url",
        "value": {
          "scribe_key": "vanity_url",
          "string_value": "github.com"
        }
      },
      {
        "key": "photo_image_full_size",
        "value": {
          "image_value": {
            "height": 314,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=600x314",
            "width": 600
          }
        }
      },
      {
        "key": "summary_photo_image_alt_text",
        "value": {
          "string_value": "PostgreSQL extension for BM25 relevance-ranked full-text search - timescale/pg_textsearch"
        }
      },
      {
        "key": "thumbnail_image_color",
        "value": {
          "image_color_value": {
            "palette": [
              {
                "percentage": 88.34,
                "rgb": {
                  "blue": 255,
                  "green": 255,
                  "red": 255
                }
              },
              {
                "percentage": 5.92,
                "rgb": {
                  "blue": 16,
                  "green": 31,
                  "red": 30
                }
              },
              {
                "percentage": 1.5,
                "rgb": {
                  "blue": 117,
                  "green": 232,
                  "red": 223
                }
              },
              {
                "percentage": 0.6,
                "rgb": {
                  "blue": 46,
                  "green": 89,
                  "red": 86
                }
              },
              {
                "percentage": 0.39,
                "rgb": {
                  "blue": 81,
                  "green": 224,
                  "red": 137
                }
              }
            ]
          }
        }
      },
      {
        "key": "title",
        "value": {
          "string_value": "GitHub - timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search"
        }
      },
      {
        "key": "summary_photo_image_color",
        "value": {
          "image_color_value": {
            "palette": [
              {
                "percentage": 88.34,
                "rgb": {
                  "blue": 255,
                  "green": 255,
                  "red": 255
                }
              },
              {
                "percentage": 5.92,
                "rgb": {
                  "blue": 16,
                  "green": 31,
                  "red": 30
                }
              },
              {
                "percentage": 1.5,
                "rgb": {
                  "blue": 117,
                  "green": 232,
                  "red": 223
                }
              },
              {
                "percentage": 0.6,
                "rgb": {
                  "blue": 46,
                  "green": 89,
                  "red": 86
                }
              },
              {
                "percentage": 0.39,
                "rgb": {
                  "blue": 81,
                  "green": 224,
                  "red": 137
                }
              }
            ]
          }
        }
      },
      {
        "key": "summary_photo_image_x_large",
        "value": {
          "image_value": {
            "height": 600,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=png&name=2048x2048_2_exp",
            "width": 1200
          }
        }
      },
      {
        "key": "summary_photo_image",
        "value": {
          "image_value": {
            "height": 314,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=600x314",
            "width": 600
          }
        }
      },
      {
        "key": "photo_image_full_size_color",
        "value": {
          "image_color_value": {
            "palette": [
              {
                "percentage": 88.34,
                "rgb": {
                  "blue": 255,
                  "green": 255,
                  "red": 255
                }
              },
              {
                "percentage": 5.92,
                "rgb": {
                  "blue": 16,
                  "green": 31,
                  "red": 30
                }
              },
              {
                "percentage": 1.5,
                "rgb": {
                  "blue": 117,
                  "green": 232,
                  "red": 223
                }
              },
              {
                "percentage": 0.6,
                "rgb": {
                  "blue": 46,
                  "green": 89,
                  "red": 86
                }
              },
              {
                "percentage": 0.39,
                "rgb": {
                  "blue": 81,
                  "green": 224,
                  "red": 137
                }
              }
            ]
          }
        }
      },
      {
        "key": "photo_image_full_size_x_large",
        "value": {
          "image_value": {
            "height": 600,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=png&name=2048x2048_2_exp",
            "width": 1200
          }
        }
      },
      {
        "key": "card_url",
        "value": {
          "scribe_key": "card_url",
          "string_value": "https://t.co/bMwRSgtOcO"
        }
      },
      {
        "key": "summary_photo_image_original",
        "value": {
          "image_value": {
            "height": 600,
            "url": "https://pbs.twimg.com/card_img/2000361005033848841/KOz4YYvU?format=jpg&name=orig",
            "width": 1200
          }
        }
      }
    ],
    "card_platform": {
      "platform": {
        "audience": {
          "name": "production"
        },
        "device": {
          "name": "iPhone",
          "version": "13"
        }
      }
    },
    "name": "summary_large_image",
    "url": "https://t.co/bMwRSgtOcO",
    "user_refs_results": [
      {
        "rest_id": "13334762",
        "result": {
          "__typename": "User",
          "action_counts": {
            "favorites_count": 8462
          },
          "avatar": {
            "image_url": "https://pbs.twimg.com/profile_images/1633247750010830848/8zfRrYjA_normal.png"
          },
          "banner": {
            "image_url": "https://pbs.twimg.com/profile_banners/13334762/1765308302"
          },
          "core": {
            "created_at": "Mon Feb 11 04:41:50 +0000 2008",
            "name": "GitHub",
            "screen_name": "github"
          },
          "dm_permissions": {
            "can_dm": false
          },
          "exclusive_tweet_following": false,
          "identity_profile_labels_highlighted_label": {},
          "location": {
            "location": "San Francisco, CA"
          },
          "media_permissions": {
            "can_media_tag": true
          },
          "notifications_settings": {},
          "pinned_items": {},
          "privacy": {},
          "private_super_following": false,
          "profile_bio": {
            "description": "The AI-powered developer platform to build, scale, and deliver secure software.",
            "entities": {
              "description": {},
              "url": {
                "urls": [
                  {
                    "display_url": "github.com",
                    "expanded_url": "http://github.com",
                    "indices": [
                      0,
                      23
                    ],
                    "url": "https://t.co/bbJgfyzKzp"
                  }
                ]
              }
            }
          },
          "profile_image_shape": "Square",
          "profile_metadata": {
            "profile_interstitial_type": "",
            "profile_link_color": "981CEB"
          },
          "profile_translation": {
            "translator_type_enum": "None"
          },
          "properties": {
            "has_extended_profile": true
          },
          "relationship_counts": {
            "followers": 2595196,
            "following": 329
          },
          "relationship_perspectives": {},
          "rest_id": "13334762",
          "super_follow_eligible": false,
          "super_followed_by": false,
          "super_following": false,
          "tweet_counts": {
            "media_tweets": 2855,
            "tweets": 10199
          },
          "website": {
            "url": "https://t.co/bbJgfyzKzp"
          },
          "verification": {
            "is_blue_verified": true,
            "verified_type": "Business"
          }
        }
      }
    ]
  },
  "place": {},
  "entities": {
    "hashtags": [
      {
        "indices": [
          496,
          506
        ],
        "text": "sponsored"
      }
    ],
    "urls": [
      {
        "display_url": "github.com/timescale/pg_t…",
        "expanded_url": "https://github.com/timescale/pg_textsearch",
        "indices": [
          471,
          494
        ],
        "url": "https://t.co/bMwRSgtOcO"
      }
    ]
  },
  "quoted_tweet": null,
  "retweeted_tweet": null,
  "isLimitedReply": false,
  "article": null
}