🐦 Twitter Post Details

Viewing enriched Twitter post

@charmcli

A CLI (with a TUI option!) for working with databases including SQLite, libSQL, PostgreSQL, MySQL, and MariaDB. Oh yessss 💅🏽 Built with ❤️ and - Bubble Tea: TUI framework - Lipgloss: Styling and layout https://t.co/XHE4wlPxiz

Media 1

📊 Media Metadata

{
  "media": [
    {
      "url": "https://crmoxkoizveukayfjuyo.supabase.co/storage/v1/object/public/media/posts/1956109484159619450/media_0.jpg?",
      "media_url": "https://crmoxkoizveukayfjuyo.supabase.co/storage/v1/object/public/media/posts/1956109484159619450/media_0.jpg?",
      "type": "photo",
      "filename": "media_0.jpg"
    }
  ],
  "processed_at": "2025-08-15T08:12:10.030045",
  "pipeline_version": "2.0"
}

🔧 Raw API Response

{
  "type": "tweet",
  "id": "1956109484159619450",
  "url": "https://x.com/charmcli/status/1956109484159619450",
  "twitterUrl": "https://twitter.com/charmcli/status/1956109484159619450",
  "text": "A CLI (with a TUI option!) for working with databases including SQLite, libSQL, PostgreSQL, MySQL, and MariaDB. Oh yessss 💅🏽\n\nBuilt with ❤️ and \n- Bubble Tea: TUI framework \n- Lipgloss: Styling and layout https://t.co/XHE4wlPxiz",
  "source": "Twitter for iPhone",
  "retweetCount": 22,
  "replyCount": 6,
  "likeCount": 303,
  "quoteCount": 3,
  "viewCount": 14661,
  "createdAt": "Thu Aug 14 21:43:38 +0000 2025",
  "lang": "en",
  "bookmarkCount": 177,
  "isReply": false,
  "inReplyToId": null,
  "conversationId": "1956109484159619450",
  "inReplyToUserId": null,
  "inReplyToUsername": null,
  "author": {
    "type": "user",
    "userName": "charmcli",
    "url": "https://x.com/charmcli",
    "twitterUrl": "https://twitter.com/charmcli",
    "id": "1203143241652166657",
    "name": "Charm",
    "isVerified": false,
    "isBlueVerified": true,
    "verifiedType": null,
    "profilePicture": "https://pbs.twimg.com/profile_images/1950033024420114433/JYhd63HW_normal.jpg",
    "coverPicture": "https://pbs.twimg.com/profile_banners/1203143241652166657/1753759078",
    "description": "",
    "location": "/dev/tty",
    "followers": 11525,
    "following": 10,
    "status": "",
    "canDm": true,
    "canMediaTag": true,
    "createdAt": "Sat Dec 07 02:45:14 +0000 2019",
    "entities": {
      "description": {
        "urls": []
      },
      "url": {}
    },
    "fastFollowersCount": 0,
    "favouritesCount": 2609,
    "hasCustomTimelines": true,
    "isTranslator": false,
    "mediaCount": 310,
    "statusesCount": 1505,
    "withheldInCountries": [],
    "affiliatesHighlightedLabel": {},
    "possiblySensitive": false,
    "pinnedTweetIds": [
      "1950580547560108191"
    ],
    "profile_bio": {
      "description": "We make the command line glamorous.",
      "entities": {
        "description": {},
        "url": {
          "urls": [
            {
              "display_url": "charm.land",
              "expanded_url": "https://charm.land/",
              "indices": [
                0,
                23
              ],
              "url": "https://t.co/tCZqBAME9F"
            }
          ]
        }
      }
    },
    "isAutomated": false,
    "automatedBy": null
  },
  "extendedEntities": {
    "media": [
      {
        "allow_download_status": {
          "allow_download": true
        },
        "display_url": "pic.twitter.com/XHE4wlPxiz",
        "expanded_url": "https://twitter.com/charmcli/status/1956109484159619450/photo/1",
        "ext_media_availability": {
          "status": "Available"
        },
        "features": {
          "large": {
            "faces": [
              {
                "h": 48,
                "w": 48,
                "x": 588,
                "y": 297
              }
            ]
          },
          "orig": {
            "faces": [
              {
                "h": 48,
                "w": 48,
                "x": 588,
                "y": 297
              }
            ]
          }
        },
        "id_str": "1956105072959737856",
        "indices": [
          205,
          228
        ],
        "media_key": "3_1956105072959737856",
        "media_results": {
          "id": "QXBpTWVkaWFSZXN1bHRzOgwAAQoAARslezMxGtAACgACGyV/NkEbUXoAAA==",
          "result": {
            "__typename": "ApiMedia",
            "id": "QXBpTWVkaWE6DAABCgABGyV7MzEa0AAKAAIbJX82QRtRegAA",
            "media_key": "3_1956105072959737856"
          }
        },
        "media_url_https": "https://pbs.twimg.com/media/GyV7MzEa0AAtRkV.jpg",
        "original_info": {
          "focus_rects": [
            {
              "h": 561,
              "w": 1002,
              "x": 0,
              "y": 0
            },
            {
              "h": 561,
              "w": 561,
              "x": 125,
              "y": 0
            },
            {
              "h": 561,
              "w": 492,
              "x": 159,
              "y": 0
            },
            {
              "h": 561,
              "w": 281,
              "x": 265,
              "y": 0
            },
            {
              "h": 561,
              "w": 1080,
              "x": 0,
              "y": 0
            }
          ],
          "height": 561,
          "width": 1080
        },
        "sizes": {
          "large": {
            "h": 561,
            "w": 1080
          }
        },
        "type": "photo",
        "url": "https://t.co/XHE4wlPxiz"
      }
    ]
  },
  "card": null,
  "place": {},
  "entities": {},
  "quoted_tweet": null,
  "retweeted_tweet": null,
  "article": null
}