Yahoo! Query Language (YQL)

[Zach]

I thought this was great. Yahoo! Query Language lets you access many web APIs using a (mostly) standardized SQL-like language. Currently, you can access:

• Yahoo! Search Results
  
• Facebook
  
• Twitter
  
• GeoIP
  
• and a bunch more.
  

It's really easy to use, too. You can get results in JSON or XML, whichever you prefer to work with, via a simple file_get_contents() in PHP or a similar function in any other language.
Recently, I used it for the "Recent Forum Posts" and "Latest News" sections on the new NiftyHost.us website. YQL has a 'feed' table that parses RSS and Atom feeds for you quickly and easily. This allowed me to set up those sections in a matter of minutes.