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://abpe.org/users/gslin/statuses/113025363063615588",
"type": "Note",
"summary": null,
"inReplyTo": null,
"published": "2024-08-25T23:56:13Z",
"url": "https://abpe.org/@gslin/113025363063615588",
"attributedTo": "https://abpe.org/users/gslin",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://abpe.org/users/gslin/followers"
],
"sensitive": false,
"atomUri": "https://abpe.org/users/gslin/statuses/113025363063615588",
"inReplyToAtomUri": null,
"conversation": "tag:abpe.org,2024-08-25:objectId=136755:objectType=Conversation",
"content": "<p>Google 提出的 GoogleSQL (Pipe 版本的 SQL 改良)</p><p>看到「SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL」這個研究投稿,PDF 檔案在 1004848.pdf 這邊。</p><p>Google 提出了 GoogleSQL 改善本來 SQL 的可讀性問題,另外也對 SQL optimizer 更有幫助。</p><p>直接拿 PDF 裡面的例子來說明,把本來是這樣的 </p><p><a href=\"https://blog.gslin.org/archives/2024/08/26/11949/google-%e6%8f%90%e5%87%ba%e7%9a%84-googlesql-pipe-%e7%89%88%e6%9c%ac%e7%9a%84-sql-%e6%94%b9%e8%89%af/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" translate=\"no\"><span class=\"invisible\">https://</span><span class=\"ellipsis\">blog.gslin.org/archives/2024/0</span><span class=\"invisible\">8/26/11949/google-%e6%8f%90%e5%87%ba%e7%9a%84-googlesql-pipe-%e7%89%88%e6%9c%ac%e7%9a%84-sql-%e6%94%b9%e8%89%af/</span></a></p><p><a href=\"https://abpe.org/tags/Computer\" class=\"mention hashtag\" rel=\"tag\">#<span>Computer</span></a> <a href=\"https://abpe.org/tags/Database\" class=\"mention hashtag\" rel=\"tag\">#<span>Database</span></a> <a href=\"https://abpe.org/tags/Murmuring\" class=\"mention hashtag\" rel=\"tag\">#<span>Murmuring</span></a> <a href=\"https://abpe.org/tags/Programming\" class=\"mention hashtag\" rel=\"tag\">#<span>Programming</span></a> <a href=\"https://abpe.org/tags/Software\" class=\"mention hashtag\" rel=\"tag\">#<span>Software</span></a> <a href=\"https://abpe.org/tags/database\" class=\"mention hashtag\" rel=\"tag\">#<span>database</span></a> <a href=\"https://abpe.org/tags/db\" class=\"mention hashtag\" rel=\"tag\">#<span>db</span></a> <a href=\"https://abpe.org/tags/google\" class=\"mention hashtag\" rel=\"tag\">#<span>google</span></a> <a href=\"https://abpe.org/tags/googlesql\" class=\"mention hashtag\" rel=\"tag\">#<span>googlesql</span></a> <a href=\"https://abpe.org/tags/rdbms\" class=\"mention hashtag\" rel=\"tag\">#<span>rdbms</span></a> <a href=\"https://abpe.org/tags/sql\" class=\"mention hashtag\" rel=\"tag\">#<span>sql</span></a></p>",
"contentMap": {
"zh": "<p>Google 提出的 GoogleSQL (Pipe 版本的 SQL 改良)</p><p>看到「SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL」這個研究投稿,PDF 檔案在 1004848.pdf 這邊。</p><p>Google 提出了 GoogleSQL 改善本來 SQL 的可讀性問題,另外也對 SQL optimizer 更有幫助。</p><p>直接拿 PDF 裡面的例子來說明,把本來是這樣的 </p><p><a href=\"https://blog.gslin.org/archives/2024/08/26/11949/google-%e6%8f%90%e5%87%ba%e7%9a%84-googlesql-pipe-%e7%89%88%e6%9c%ac%e7%9a%84-sql-%e6%94%b9%e8%89%af/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" translate=\"no\"><span class=\"invisible\">https://</span><span class=\"ellipsis\">blog.gslin.org/archives/2024/0</span><span class=\"invisible\">8/26/11949/google-%e6%8f%90%e5%87%ba%e7%9a%84-googlesql-pipe-%e7%89%88%e6%9c%ac%e7%9a%84-sql-%e6%94%b9%e8%89%af/</span></a></p><p><a href=\"https://abpe.org/tags/Computer\" class=\"mention hashtag\" rel=\"tag\">#<span>Computer</span></a> <a href=\"https://abpe.org/tags/Database\" class=\"mention hashtag\" rel=\"tag\">#<span>Database</span></a> <a href=\"https://abpe.org/tags/Murmuring\" class=\"mention hashtag\" rel=\"tag\">#<span>Murmuring</span></a> <a href=\"https://abpe.org/tags/Programming\" class=\"mention hashtag\" rel=\"tag\">#<span>Programming</span></a> <a href=\"https://abpe.org/tags/Software\" class=\"mention hashtag\" rel=\"tag\">#<span>Software</span></a> <a href=\"https://abpe.org/tags/database\" class=\"mention hashtag\" rel=\"tag\">#<span>database</span></a> <a href=\"https://abpe.org/tags/db\" class=\"mention hashtag\" rel=\"tag\">#<span>db</span></a> <a href=\"https://abpe.org/tags/google\" class=\"mention hashtag\" rel=\"tag\">#<span>google</span></a> <a href=\"https://abpe.org/tags/googlesql\" class=\"mention hashtag\" rel=\"tag\">#<span>googlesql</span></a> <a href=\"https://abpe.org/tags/rdbms\" class=\"mention hashtag\" rel=\"tag\">#<span>rdbms</span></a> <a href=\"https://abpe.org/tags/sql\" class=\"mention hashtag\" rel=\"tag\">#<span>sql</span></a></p>"
},
"attachment": [],
"tag": [
{
"type": "Hashtag",
"href": "https://abpe.org/tags/computer",
"name": "#computer"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/database",
"name": "#database"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/murmuring",
"name": "#murmuring"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/programming",
"name": "#programming"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/software",
"name": "#software"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/db",
"name": "#db"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/google",
"name": "#google"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/googlesql",
"name": "#googlesql"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/rdbms",
"name": "#rdbms"
},
{
"type": "Hashtag",
"href": "https://abpe.org/tags/sql",
"name": "#sql"
}
],
"replies": {
"id": "https://abpe.org/users/gslin/statuses/113025363063615588/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://abpe.org/users/gslin/statuses/113025363063615588/replies?only_other_accounts=true&page=true",
"partOf": "https://abpe.org/users/gslin/statuses/113025363063615588/replies",
"items": []
}
},
"likes": {
"id": "https://abpe.org/users/gslin/statuses/113025363063615588/likes",
"type": "Collection",
"totalItems": 2
},
"shares": {
"id": "https://abpe.org/users/gslin/statuses/113025363063615588/shares",
"type": "Collection",
"totalItems": 2
}
}