yahoo query language

24
Yahoo Query Language: Internet Sebagai Database

Upload: akhmad-fathonih

Post on 17-Jun-2015

375 views

Category:

Technology


4 download

DESCRIPTION

This should have been presented in #1 Barcamp Id. Covers overview on how interesting YQL is.

TRANSCRIPT

Page 1: Yahoo Query Language

Yahoo Query Language:Internet Sebagai Database

 

Page 2: Yahoo Query Language

Mashup Is The New Internet

 

Page 3: Yahoo Query Language

Screen Scraping

This is the full RFC 2822 regular expression for matching email addresses, with comments already stripped. It weighs in at a tiny 3768 bytes. (((((([\x20\x09]*(\x0d\x0a))?[\x20\x09]+)|([\x20\x09]+((\x0d \x0a)[\x20\x09]+)*))*?(([\x41-\x5a\x61-\x7a]|[\x30-\x39]|[\x 21\x23-\x27\x2a\x2b\x2d\x2e\x3d\x3f\x5e\x5f\x60\x7b-\x7e])+( \x2e([\x41-\x5a\x61-\x7a]|[\x30-\x39]|[\x21\x23-\x27\x2a\x2b \x2d\x2e\x3d\x3f\x5e\x5f\x60\x7b-\x7e])+)*)((([\x20\x09]*(\x 0d\x0a))?[\x20\x09]+)|([\x20\x09]+((\x0d\x0a)[\x20\x09]+)*)) *?)|(((([\x20\x09]*(\x0d\x0a))?[\x20\x09]+)|([\x20\x09]+((\x 0d\x0a)[\x20\x09]+)*))*?\x22(((([\x20\x09]*(\x0d\x0a))?[\x20 \x09]+)|([\x20\x09]+((\x0d\x0a)[\x20\x09]+)*))?(([\x01-\x08\ x0b\x0c\x0e-\x1f\x7f]|[\x21\x23-\x5b\x5d-\x7e])|(\x5c([\x01- \x09\x0b\x0c\x0e-\x7f]|(\x0a*\x0d*([\x00-\x09\x0b\x0c\x0e-\x 7f]\x0a*\x0d*)*))|(\x5c[\x00-\x7f]))))*((([\x20\x09]*(\x0d\x 0a))?[\x20\x09]+)|([\x20\x09]+((\x0d\x0a)[\x20\x09]+)*))?\x2 2((([\x20\x09]*(\x0d\x0a))?[\x20\x09]+)|([\x20\x09]+((\x0d\x 0a)[\x20\x09]+)*))*?)|(((((([\x20\x09]*(\x0d\x0a))?[\x20\x09.. snip ..

Page 4: Yahoo Query Language

Web ServicesSOAPREST

New FrontierRSS

JSON

Page 5: Yahoo Query Language

Orchestration: Connecting The Pipes

Page 6: Yahoo Query Language

I love SQL

SELECT * FROM detik.com/feed

UPDATE twitter.com VALUES("Gini asik kali ya")

SELECT weather, wind FROM nasa WHERE city IN (SELECT city FROM geocode WHERE lat = 12.3 AND long = 78.5)

Page 7: Yahoo Query Language

I am totally lazy.

 

Page 8: Yahoo Query Language

Scraping Made Easy

select * from html where url="http://finance.yahoo.com/q?s=yhoo" and xpath='//div[@id="yfi_headlines"]/div[2]/ul/li/a'

Page 9: Yahoo Query Language

 

 

Page 10: Yahoo Query Language

 

RSS? We Got It

Page 11: Yahoo Query Language

What? Web Services? OK.

Page 12: Yahoo Query Language

 

All SELECT makes INSERT a dull boy?

Page 13: Yahoo Query Language
Page 14: Yahoo Query Language

 

Not Cool Enough?

Page 15: Yahoo Query Language

OAuth is imposible?

Page 16: Yahoo Query Language

Orchestration = Open Table

 

Page 17: Yahoo Query Language

 

That's How We Do OAuth

Page 18: Yahoo Query Language
Page 19: Yahoo Query Language

I Wish I Can Do It All ...In Javascript 

Page 20: Yahoo Query Language

Sure, We Got PHPAnd Python

Page 21: Yahoo Query Language

Onemanga KDE Plasmoid

Page 22: Yahoo Query Language

OK, It's All Yours

• https://developer.yahoo.com/yql/console/• http://developer.yahoo.com/social/sdk/php/• http://developer.yahoo.com/yql/guide/yql-tutorials.html• http://github.com/yql/yql-tables/• http://python-yql.org/

Page 23: Yahoo Query Language

Thanks, Barcamp ID

@neofreko

Page 24: Yahoo Query Language

Picture Credits

http://www.flickr.com/photos/chris_radcliff/189404292/http://www.flickr.com/photos/psd/263092176/http://www.kylehayes.info/2009/03/29/survey-results-javascript-frameworks/http://informationarchitects.jp/wtm4/