On All Things Web

September, 2009Archive

Sep 24

Most people may not realize, but you can use Facebook Connect with your http://localhost server.  This works great for ASP.NET and MVC (and other environments too, but I’m primarily a .NET guy so please pardon my favoritism).  You setup the localhost environment as the Facebook connect URL, as in http://localhost/<Virtual>.  I would recommend using a […]

Read the rest of this entry »

Sep 24

If you haven’t heard from my blog or Facebook WIKI’s before, there are two ways to query data from Facebook, using the ApiClient object to query the data from the Facebook server, or by using FQL to query against their propietary database directly.  In a recent app, I found that using FQL cut in half […]

Read the rest of this entry »

Sep 15

I really like CodeSmith, a great tool for generating templates.  It comes with a variety of default templates, all managed in a Visual Studio-like environments, complete with intellisense that’s good, but not quite as powerful as Visual Studio.  I do a lot of scripting, so I wanted to make stored procedure generation easier.  One scenario […]

Read the rest of this entry »

Sep 13

The Controller class maintains a reference to the HttpContext property, and object of HttpContextBase.  HttpContextBase is a great class because now we have an abstract way to replace default logic if needed (but generally that wouldn’t be recommended).  Ideally, it’s great for fake environments.  But I digress, HttpContextBase is the main object for accessing context-specific […]

Read the rest of this entry »

Sep 12

If you have used the Facebook FQL syntax to query the location column of a table, or have requested the location parameter from the friends_get or other API methods, what you need to know is location is a complex object consisting of the following properties: city country state street zip These properties can be directly […]

Read the rest of this entry »

Sep 12

Facebook FQL

Posted in Web       No Comments »

Facebook supports a variant of SQL called FQL, or Facebook Query Language.  If you know anything about Facebook’s data storage center, Facebook has moved away from the traditional relational database and created their own custom application for storing data, which has the ability to query petaflops worth of data in seconds.  So what is FQL?  […]

Read the rest of this entry »