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",
"Hashtag": "as:Hashtag"
}
],
"id": "https://mastodon.social/users/OfShad0ws/statuses/110141986890709886/replies",
"type": "Collection",
"first": {
"id": "https://mastodon.social/users/OfShad0ws/statuses/110141986890709886/replies?page=true",
"type": "CollectionPage",
"next": "https://mastodon.social/users/OfShad0ws/statuses/110141986890709886/replies?only_other_accounts=true&page=true",
"partOf": "https://mastodon.social/users/OfShad0ws/statuses/110141986890709886/replies",
"items": [
{
"id": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707",
"type": "Note",
"summary": null,
"inReplyTo": "https://mastodon.social/users/OfShad0ws/statuses/110141986890709886",
"published": "2023-04-04T18:39:56Z",
"url": "https://mastodon.social/@OfShad0ws/110142003386328707",
"attributedTo": "https://mastodon.social/users/OfShad0ws",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://mastodon.social/users/OfShad0ws/followers"
],
"sensitive": false,
"atomUri": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707",
"inReplyToAtomUri": "https://mastodon.social/users/OfShad0ws/statuses/110141986890709886",
"conversation": "tag:mastodon.social,2023-04-04:objectId=426963528:objectType=Conversation",
"content": "<p>8. Чтобы соединить несколько таблиц с помощью full join и не задублировать первичный ключ (a), используйте такую конструкцию:<br />select coalesce(t1.a,t2.a,t3.a,t4.a) as a<br />from t1<br />full join t2 on t2.a = t1.a<br />full join t3 on t3.a = coalesce(t1.a,t2.a)<br />full join t4 on t4.a = coalesce(t1.a,t2.a,t3.a)</p><p>9. Если таблица присоединяется к первой left join, а следующая присоединяется ко второй inner join, то left превращается в inner: это частая ошибка.</p><p><a href=\"https://mastodon.social/tags/SQLtips\" class=\"mention hashtag\" rel=\"tag\">#<span>SQLtips</span></a></p>",
"contentMap": {
"ru": "<p>8. Чтобы соединить несколько таблиц с помощью full join и не задублировать первичный ключ (a), используйте такую конструкцию:<br />select coalesce(t1.a,t2.a,t3.a,t4.a) as a<br />from t1<br />full join t2 on t2.a = t1.a<br />full join t3 on t3.a = coalesce(t1.a,t2.a)<br />full join t4 on t4.a = coalesce(t1.a,t2.a,t3.a)</p><p>9. Если таблица присоединяется к первой left join, а следующая присоединяется ко второй inner join, то left превращается в inner: это частая ошибка.</p><p><a href=\"https://mastodon.social/tags/SQLtips\" class=\"mention hashtag\" rel=\"tag\">#<span>SQLtips</span></a></p>"
},
"updated": "2023-04-04T18:48:22Z",
"attachment": [],
"tag": [
{
"type": "Hashtag",
"href": "https://mastodon.social/tags/sqltips",
"name": "#sqltips"
}
],
"replies": {
"id": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707/replies?min_id=110142058951998000&page=true",
"partOf": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707/replies",
"items": [
"https://mastodon.social/users/OfShad0ws/statuses/110142058951998000"
]
}
},
"likes": {
"id": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707/likes",
"type": "Collection",
"totalItems": 0
},
"shares": {
"id": "https://mastodon.social/users/OfShad0ws/statuses/110142003386328707/shares",
"type": "Collection",
"totalItems": 0
}
}
]
}
}