Posts tagged SQL
The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services.
YQL’s possibilities are virtuallyÂ endless, say you want to get specific Flickr Images containing a defined word in the title, or you want to geo-code some addresses on the fly. YQL makes those tasks extremely easy by just forming a simple query that gathers the data. Output can be switched between JSON and XML, so you can choose whatever fits best for your application.
The best way to go about using a YQL service is as follows:
- Construct your query using the YQL Console and try out if it gives you the right result.
- Copy the REST Query URL the console gives you at the bottom and insert it into your web app. There are even examples in the documentation on how to use REST queries in different programming environments.
Let me give you an example of such a query:
select * from upcoming.events where woeid in (select woeid from geo.places where text="Vienna, Austria")
This will give you an XML response listing all upcoming events in Vienna, Austria using the Yahoo! Upcoming API by calling the following REST URL:
This service makes it very easy to use different web APIs without knowing their respectiveÂ syntaxÂ and it becomes extremely convenient when you start joining together different webservices to get a combined result.
I’ll give you one more example here. This gets all the Foursquare places around a particular address sorted by their distance by combining geo.placefinder and Foursquare :
USE "http://www.datatables.org/foursquare/foursquare.venues.xml" as venues; SELECT group.venue.name, group.venue.address, group.venue.stats.herenow, group.venue.distance FROM venues WHERE (geolat, geolong) IN (SELECT latitude, longitude FROM geo.placefinder WHERE text="koenigsklostergasse 7, wien") | sort(field="group.venue.distance", descending="false");
Click here to try this query in the YQL Console.
The really neat thing is that YQL can be used commercially and there even is a fairly decent rate limit applied per IP address that should make it useful in production.
- YQL can be used for commercial purposes.
- If we’re going to shut down YQL, we will give you at least 6 months notice with an announcement on YDN and in our forum.
- YQL has a performance uptime target of over 99.5%.
- YQL relies on the correct operation of the Web services and content providers it accesses.
- Per application limit (identified by your Access Key): 100,000 calls per day.
- Per IP limits: /v1/public/*: 1,000 calls per hour; /v1/yql/*: 10,000 calls per hour.
- All rates are subject to change.
- YQL rate limits are subject to the rate limits of other Yahoo! and 3rd-party Web services.
- 5 Great YQL One-Liners (readwriteweb.com)
- A simple hack to geoplace images (developer.yahoo.net)
- YQL Query Builder and Explorer (developer.yahoo.com)
- Web services and YQL (developer.yahoo.net)