Archive for March 2012

CLR Trigger – Microsoft SQL database

In my last post (Realtime database applications with Node.JS and HTML5 WebSockets) I talked about using the CLR-trigger in combination with the Microsoft SQL database to get realtime results. Ever since I have had multiple requests about publishing the C# script, so I decided to do so! I edited out some implementation details, but I’m sure that won’t be a problem. If any more explanation is necessary, please contact me! 🙂

Continue reading “CLR Trigger – Microsoft SQL database” »

Realtime database applications with Node.JS and HTML5 WebSockets

As you could’ve read in my first post, I’m doing the Honours programme at the college I’m at. This basically means that I get extra (more challenging) work to do next to my standard college assignments.

The first assignment we got came from Thialf Heerenveen, an ice skating stadium which is also used for national and international ice skating competitions. Thialf is using the Local Position Measurement (shorthand: LPM) system which was developed by InMotio. The system is basically some sort of GPS system, but MUCH more accurate. When ice skaters are training, they get a tracker, and as they do their training, data about their training is collected. The downside about this approach was that the coaches of these ice skaters could only see the data visualised after the training was complete, which made it still handy, but made immediate feedback impossible. Also the data they were given was mostly not visual enough and required thorough analysis before you could draw conclusions.
Continue reading “Realtime database applications with Node.JS and HTML5 WebSockets” »