{"id":3233,"date":"2010-09-28T00:02:51","date_gmt":"2010-09-27T22:02:51","guid":{"rendered":"http:\/\/notizblog.org\/?p=3233"},"modified":"2020-05-05T14:52:40","modified_gmt":"2020-05-05T12:52:40","slug":"access-the-openweb-with-yql","status":"publish","type":"post","link":"https:\/\/notiz.blog\/2010\/09\/28\/access-the-openweb-with-yql\/","title":{"rendered":"Accessing the OpenWeb with YQL"},"content":{"rendered":"\n
\"\"<\/figure><\/div>\n\n\n\n

Durch einen Artikel auf ReadWriteWeb (5 Great YQL One-Liners<\/a>) bin ich nach langer Zeit mal wieder auf Yahoos YQL-Plattform<\/a> gelandet und habe nicht schlecht gestaunt, was die Yahoo Query Language<\/em> mittlerweile alles leistet (mehr \u00fcber YQL hier<\/a>). Ich hatte z.B. keine Ahnung, dass man auch eigene table definition<\/a><\/em> schreiben kann und dass es auch schon eine ziemlich flei\u00dfige Community um diese Definitionen gibt.<\/p>\n\n\n\n

Meine Favoriten sind:<\/p>\n\n\n\n

Microformats<\/h3>\n\n\n
select * from<\/span> microformats where url='http:\/\/wait-till-i.com'<\/span><\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…findet diverse Microformats. \u00bb Direct Link<\/s><\/p>\n\n\n\n
OpenID<\/h3>\n\n\n
select * from<\/span> openid.discover where normalizedId=\"http:\/\/www.yahoo.com\/\"<\/span><\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…klassische OpenID-Discovery. \u00bb Direct Link<\/s><\/p>\n\n\n
select * from<\/span> openid.yadis where uri=\"http:\/\/www.yahoo.com\/\"<\/span><\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…YADIS-Discovery. \u00bb Direct Link<\/s><\/p>\n\n\n\n
…und es gibt noch ’ne Reihe anderer OpenID Queries<\/em>… es sollte sogar m\u00f6glich sein einen kompletten OpenID-Client mit YQL zu bauen.<\/p>\n\n\n\n
OAuth<\/strong>\n<\/h3>\n\n\n
select * from<\/span> oauth where uri='http:\/\/example.com'<\/span> and consumerKey='asd123'<\/span> and consumerSecret='zxc456'<\/span> and callbackUri='http:\/\/example.com'<\/span>;<\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…sendet einen OAuth-Request. \u00bb Direct Link<\/s><\/p>\n\n\n\n
pubsubhubbub<\/h3>\n\n\n
insert into pubsubhubbub.publisher (hub_url, topic_url) values ('http:\/\/pubsubhubbub.appspot.com\/publish'<\/span>, 'http:\/\/developer.yahoo.com'<\/span>)<\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…sendet ein Update an das angegebene Hub. \u00bb Direct Link<\/s><\/p>\n\n\n\n
Webfinger<\/h3>\n\n\n
select * from<\/span> webfinger where account='pfefferle@gmail.com'<\/span><\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…Webfinger-Discovery. \u00bb Direct Link<\/s><\/p>\n\n\n\n
OpenSocial<\/h3>\n\n\n
select * from<\/span> opensocial.people<\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…sendet eine OpenSocial People<\/em>-Anfrage. \u00bb Direct Link<\/s><\/p>\n\n\n\n
Social Graph<\/strong> API<\/h3>\n\n\n
select * from<\/span> socialgraph.lookup where q = \"notiz.blog\"<\/span> AND edo = \"1\"<\/span><\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
…erm\u00f6glicht Zugriff auf Googles Social Graph API<\/em><\/a>. \u00bb Direct Link<\/s><\/p>\n\n\n\n
Atom<\/strong><\/h3>\n\n\n
select * from<\/span> atom where url='https:\/\/notiz.blog\/feed\/atom'<\/span><\/code><\/span>Code-Sprache:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Vielleicht bekomm‘ ich die Tage ja auch mal eine Query<\/em> zusammen \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"
Durch einen Artikel auf ReadWriteWeb (5 Great YQL One-Liners) bin ich nach langer Zeit mal wieder auf Yahoos YQL-Plattform gelandet und habe nicht schlecht gestaunt, was die Yahoo Query Language mittlerweile alles leistet (mehr \u00fcber YQL hier). Ich hatte z.B. keine Ahnung, dass man auch eigene table definition schreiben kann und dass es auch schon […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"webmentions_disabled_pings":false,"webmentions_disabled":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":""},"categories":[2],"tags":[860,105,164,183,422,423,840,507,843,784],"class_list":{"0":"post-3233","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-web","7":"tag-activitystreams","8":"tag-atom","9":"tag-microformats","10":"tag-mikroformate","11":"tag-oauth","12":"tag-openid","13":"tag-pubsubhubbub","14":"tag-social-graph-api","15":"tag-webfinger","16":"tag-yql","17":"h-entry","18":"hentry"},"_links":{"self":[{"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/posts\/3233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/comments?post=3233"}],"version-history":[{"count":0,"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/posts\/3233\/revisions"}],"wp:attachment":[{"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/media?parent=3233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/categories?post=3233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notiz.blog\/wp-api\/wp\/v2\/tags?post=3233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
…interpretiert Atom-Feeds mit allen m\u00f6glichen Erweiterungen, beispielsweise der ActivityStreams-Extension<\/a>. \u00bb Direct Link<\/s><\/p>\n\n\n\n
Mehr dazu hier: SELECT * FROM microformats<\/a><\/p>\n\n\n\n