ActivityPub Viewer

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.

Open in browser →
{ "@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 } }