Out of Egypt:

facebook + mysql = a surprisingly addictive combination

Tonight I learned for the first time about FQL (Facebook Query Language). Apparently, as the samples show, you can use it in your Facebook Platform applications to query Facebook's database. And you can test it live, as long as you have a Facebook account (and possibly also a developer account, which is also free). Obviously, there are a lot of possibilities.

Here's just one of them:

SELECT name, profile_url, notes_count FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = 146900075) AND notes_count > 0 ORDER BY notes_count DESC

That shows the names and profile urls of all my Facebook friends who have posted notes, ordered by how many notes they have posted.

If y'all can think of any other cool demos, post them in the comments.