I was thinking about how to best represent connections between people in my Six Degrees of Separation Facebook application and Paul Crabtree recommend I get in touch with Moritz Stefaner as he had something that would fit very nicely indeed.
And he most certainly did; the relation browser was exactly what I wanted to do, but better. If you have a Facebook account, install the application, and go to the Show Network tab you'll see what I mean.
This piece of SQL is perfect for finding which query is running at any particular time, especially if you want to find what it is that's running very slowly.
This should return a list of what's running, including process ids (in the first column). Find out what's causing all the trouble and enter it's id after spid = below:
DECLARE @Handle binary(20) SELECT @Handle = sql_handle FROM master.dbo.sysprocesses WHERE spid = 55 SELECT * FROM ::fn_get_sql(@Handle)
|Weekly Movers & Shakers|
|1||TextMeNow+7,031 users (86.8%)|
|2||Cartoonify Me+65,895 users (69.2%)|
|3||Gross Out!+130,448 users (31.2%)|
|4||Six Degrees+6,979 users (30.5%)|
|5||PickOff+4,721 users (21.5%)|
|6||How Sexy Is Your Name Calculator+28,735 users (19.0%)|
|7||Cartoon Friends+8,732 users (18.8%)|
|8||mySI+22,281 users (11.6%)|
|9||Class Notes+8,372 users (9.3%)|
|10||Golf Buds+16,378 users (6.8%)|
Hopefully the trend will continue and I can keep adding new features.
Everyone's been either copying and pasting or writing from scratch some code to add "Invite friends" to their Facebook apps, but now there's a simple tag that they've provided. It's currently in beta and, knowing Facebook, is bound to change and break everything a few times, but it's very easy to use:
<fb:request-form action="invite.php" method="post" type="trust" content="Invite friends to trust you<fb:req-choice url='http://apps.facebook.com/i_trust' label='Add iTrust' />" image="http://apps.exponetic.com/itrust/ _img/iTrust-logo-magenta-small.gif"> <fb:multi-friend-selector actiontext="Select friends" /> </fb:request-form>
(Note the slightly dodgy <fb:req-choice> tag inside the content attribute.)
We've started developing Facebook applications at Exponetic and our first properly launched project, "Six degrees of separation" has passed 5000 users in under 9 days of live time. The growth has been quite amazing and still going.
Next steps are to do a bit more development on this app and there are a few more in the pipeline