A small tool to view real-world ActivityPub objects as JSON! Enter a URL
or username from Mastodon or a similar service below, and we'll send a
request with
the right
Accept
header
to the server to view the underlying object.
{
"@context": [
"https://www.w3.org/ns/activitystreams",
{
"ostatus": "http://ostatus.org#",
"atomUri": "ostatus:atomUri",
"inReplyToAtomUri": "ostatus:inReplyToAtomUri",
"conversation": "ostatus:conversation",
"sensitive": "as:sensitive",
"toot": "http://joinmastodon.org/ns#",
"votersCount": "toot:votersCount",
"blurhash": "toot:blurhash",
"focalPoint": {
"@container": "@list",
"@id": "toot:focalPoint"
},
"Hashtag": "as:Hashtag"
}
],
"id": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650",
"type": "Note",
"summary": null,
"inReplyTo": null,
"published": "2024-10-28T22:32:44Z",
"url": "https://techhub.social/@negative12dollarbill/113387422672484650",
"attributedTo": "https://techhub.social/users/negative12dollarbill",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://techhub.social/users/negative12dollarbill/followers"
],
"sensitive": false,
"atomUri": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650",
"inReplyToAtomUri": null,
"conversation": "tag:techhub.social,2024-10-28:objectId=197204652:objectType=Conversation",
"content": "<p>Oof. This really bit me on a project I'm working on. I thought I would seamlessly switch over databases in a few minutes.</p><p>To put it simply, you can't rely on the Last Insert ID with SQLite3 the way you can with MySQL.</p><p>Rather than rewrite everything in a more laborious way, I switched back to MySQL.</p><p><a href=\"https://techhub.social/tags/Database\" class=\"mention hashtag\" rel=\"tag\">#<span>Database</span></a> <a href=\"https://techhub.social/tags/Programming\" class=\"mention hashtag\" rel=\"tag\">#<span>Programming</span></a> <a href=\"https://techhub.social/tags/Webdev\" class=\"mention hashtag\" rel=\"tag\">#<span>Webdev</span></a> <a href=\"https://techhub.social/tags/Coding\" class=\"mention hashtag\" rel=\"tag\">#<span>Coding</span></a> <a href=\"https://techhub.social/tags/MySQL\" class=\"mention hashtag\" rel=\"tag\">#<span>MySQL</span></a> <a href=\"https://techhub.social/tags/SQLite\" class=\"mention hashtag\" rel=\"tag\">#<span>SQLite</span></a></p>",
"contentMap": {
"en": "<p>Oof. This really bit me on a project I'm working on. I thought I would seamlessly switch over databases in a few minutes.</p><p>To put it simply, you can't rely on the Last Insert ID with SQLite3 the way you can with MySQL.</p><p>Rather than rewrite everything in a more laborious way, I switched back to MySQL.</p><p><a href=\"https://techhub.social/tags/Database\" class=\"mention hashtag\" rel=\"tag\">#<span>Database</span></a> <a href=\"https://techhub.social/tags/Programming\" class=\"mention hashtag\" rel=\"tag\">#<span>Programming</span></a> <a href=\"https://techhub.social/tags/Webdev\" class=\"mention hashtag\" rel=\"tag\">#<span>Webdev</span></a> <a href=\"https://techhub.social/tags/Coding\" class=\"mention hashtag\" rel=\"tag\">#<span>Coding</span></a> <a href=\"https://techhub.social/tags/MySQL\" class=\"mention hashtag\" rel=\"tag\">#<span>MySQL</span></a> <a href=\"https://techhub.social/tags/SQLite\" class=\"mention hashtag\" rel=\"tag\">#<span>SQLite</span></a></p>"
},
"attachment": [
{
"type": "Document",
"mediaType": "image/png",
"url": "https://files.techhub.social/media_attachments/files/113/387/397/479/885/822/original/ccede9a762babc99.png",
"name": "Excerpt from SQLite3 documentation:\n--\nIf a separate thread performs a new INSERT on the same database connection while the sqlite3_last_insert_rowid() function is running and thus changes the last insert rowid, then the value returned by sglite3 last _insert_rowid() is unpredictable and might not equal either the old or the new last insert rowid. ",
"blurhash": "UISPX_RQ%Moft7off6WB~qozM{j[xuRjbGog",
"focalPoint": [
0,
0
],
"width": 774,
"height": 145
}
],
"tag": [
{
"type": "Hashtag",
"href": "https://techhub.social/tags/database",
"name": "#database"
},
{
"type": "Hashtag",
"href": "https://techhub.social/tags/programming",
"name": "#programming"
},
{
"type": "Hashtag",
"href": "https://techhub.social/tags/webdev",
"name": "#webdev"
},
{
"type": "Hashtag",
"href": "https://techhub.social/tags/coding",
"name": "#coding"
},
{
"type": "Hashtag",
"href": "https://techhub.social/tags/mysql",
"name": "#mysql"
},
{
"type": "Hashtag",
"href": "https://techhub.social/tags/sqlite",
"name": "#sqlite"
}
],
"replies": {
"id": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650/replies?only_other_accounts=true&page=true",
"partOf": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650/replies",
"items": []
}
},
"likes": {
"id": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650/likes",
"type": "Collection",
"totalItems": 1
},
"shares": {
"id": "https://techhub.social/users/negative12dollarbill/statuses/113387422672484650/shares",
"type": "Collection",
"totalItems": 2
}
}