A fascinating insight into how this mighty piece of software came about.
[youtube=http://www.youtube.com/watch?v=Hxx2KcPWWZg]
Tech stuff and randomness
A fascinating insight into how this mighty piece of software came about.
[youtube=http://www.youtube.com/watch?v=Hxx2KcPWWZg]
I hardly noticed, but the 3 year anniversary of K! passed the other week. And I didn’t even get my blog a present or anything. The very first post is here.
Happy 3rd birthday, K!
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.
sp_who2
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)
Exponetic’s first Facebook application, Six Degrees of Separation is apparently the fourth fastest growing app over the past week, according to Adnomics. The full league table is as follows:
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.
The “Six Degrees of Separation” application
Exponetic Facebook developers
“Six Degrees” application statistics on Adnomics
The “Six Degrees of Separation” application
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:
" image="http://apps.exponetic.com/itrust/ _img/iTrust-logo-magenta-small.gif">
(Note the slightly dodgy tag inside the content attribute.)
We’re now using it at Exponetic on our second Facebook application, called iTrust.
Exponetic, Facebook developers in London
iTrust
Six degrees of separation
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
Exponetic Facebook application development, London
The “Six degrees of separation” Facebook application