Access to facebook data

Question

I want to access facebook's database. I want to have some SQL-like access, let's like this:

"select name from facebook-big-database-table where location='France' and city='Paris' and age
between 30 and 40;"

But, it need not to be SQL, PHP or JAVA would also be nice to use to me.

Does anybody know where to start? To be honest, I got a little bit lost in all the tutorials Facebook offers. Is it the so called "Connect" program which offers me what I want or something different?

Answer 1

Facebook does have a bunch of API's, one of which actually looks like SQL. They call it FQL. Check it out here. Maybe it can help you some part of the way at least.

Note that it won't give you raw access to the underlying tables. But still, better than nothing I guess.