Tech Blog

As Facebook is probably the most viral socal application out there, we couldn’t stay behind. We developed for Tjoon a Facebook application, this weekend. This application is like the normal website, but with the extension that you can show your recorded videos to all of your Facebook friends and you can also see what your friends recorded.

As you maybe know, we developed Tjoon as a fun project. You can create split screen videos with it. We hope you will like the new addition to Tjoon, the Facebook Tjoon. Here your can install the Tjoon application.

Last week I wanted to make a small chart to display the number of users that signed up at Floorplanner per month. This is easily done by using query with a GROUP BY statement:

SELECT MONTH(created_on), COUNT(*)
  FROM users
  GROUP BY MONTH(created_on)

It returns a result with rows like this: [month number,number of accounts that month]. Since we have different kind of users (free and a couple of paid accounts) I thought it would be nice to put them in the equation too. After a while I came up with this query (actually not very different from the first one):

SELECT MONTH(created_on), account_type_id, COUNT(*)
  FROM users
  GROUP BY MONTH(created_on), account_type_id

Now it returns a result with rows like this: [month number, account type id, number of accounts that month for this type]. With some filtering I made it into a nice chart but I have the feeling that there is an easier solution.

Suggestions anyone?

Papervision3D training is coming to Europe!
The 2 day workshop will be in Amsterdam, The Netherlands on October 8th and 9th, and will be hosted by Ralph Hauwert.

Read more here.