For our web application we used a javascript framework called Backbone, which helped us to keep our application logically structured. We’ve been able to split JavaScript into nice seperate chunks working together. Backbone uses models to represent the data that can be created, validated, destroyed or saved. The models can be saved in local storage or on the server as simply as setting the apropriate url value (to a RESTful API) or local storage variable. Making it save in both places[...]

Our last full day of Dev Camp was very productive and we completed much of the app’s functionality – it’s pretty satisfying to see the various elements come together and begin functioning nicely across our various test devices. Tomasz and Neil worked together on completing the Questionnaire and Response views, with support for pagination, asynchronous saving to local and remote storage, and a few other nice touches. Mariusz worked on completing the data management for the slider and drag &[...]

With all of the app’s basics in place, day four was pretty much just hard slog working on the nitty gritty. Slowly through the day pieces began to fall into place: The Backbone router was added and the application broken up into separate “pages” when the user clicks through the various entities to complete their questionnaire. The first drafts of the drag and drop controls were added, allowing users to place items on a grid corresponding to some sort of[...]

Before we began the Dev Camp we had a few interesting discussions about what we thought would be interesting interfaces to display to an end user. When we settled on creating a questionnaire app we started to think what kind of controls we could use to ask the questions. It was obvious that we should use some standard controls like text boxes, check boxes or radio buttons but we also wanted to use some advanced controls. Our first choice was[...]

Day 1 was spent settling in and setting up in the beautiful cotswolds. After supper and before turning in, they get stuck into business splitting up the application tasks thus: Server-side – RavenDB and ASP.Net MVC – Mariusz and Neil Client-side – Backbone.js and HTML5 – Tomasz (and Andrew, when he arrives) UX – CSS framework(s) and JavaScript – Luke They will do a fair bit of pair programming before moving on to parallel development after getting the basics done.[...]

What is CoffeeScript? It’s a little language that compiles into JavaScript. And it’s so much simpler to write and look at than original Javascript. And the best part of it? Underneath it all it is still pure JavaScript! I have to admit I was a bit sceptical at first. After looking at the documentation the syntax looked funky, and I thought that I would have to install a compiler, then run it every time I want to have a working[...]

With the second day of our dev camp coming to an end it’s time to summarise our server side work.  I’ve been working with Neil on setting up the server side part of the application while Tomasz was working on the client side. We decided that we are going to use standard MVC controllers to implement a RESTful service and RavenDB for data storage. RavenDB is a nosql database server, which stores information as JSON “documents”. These documents can have[...]

Dr John Boyle, MD, and Dr Reynold Greenlaw, Senior Project Manager are attending the CuPiD kick-off meeting in Bologna. OCC is involved in a 3 year EU project to provide personalised rehabilitation exercises for people with Parkinson’s disease (PD) at home. The project is called “CuPiD” and is powered by an eight member consortium led by the University of Bologna. Cupid will develop and test a combination of services for at home rehabilitation and training of major motor impairments caused[...]

Our day started at the OCC office with the five of us making a fantastic mess on one of the meeting-room whiteboards getting down our ideas for the domain model of the questionnaire app we are planning to build. After much discussion, especially around the issue of making the application robust vs. doing more interesting things, we settled on our model. Essentially a very simple pairing of Questionnaires as sets of Questions along with their types, and Responses as sets[...]

One of the most important elements of a modern web application is the JavaScript that powers the client-side interactions. It is what gives us AJAX for subtle server interaction; powerful manipulation of the web page’s structure; and attractive animations and effects that users come to expect from high-quality web sites. All that JavaScript can lead to a mess of script files, functions and variables, which becomes harder to manage as the application advances. To combat this a range of JavaScript[...]

Based on our requirements, we batted a few ideas back and forth before settling on a web application that will allow a user to fill in forms/questionnaires/assessments that will continue to work when the user is offline. The form would be made up of data recording objects ranging from simple sliders and data entry fields to complex canvas-based controls, sketchpads and multi-user interactions. This idea gives us a simple way of scaling the scope of what we create to the time we[...]

Starting from a blank slate on day one would be a little daunting and no doubt we’d spend a fair chunk of the week trying to decide what we’d like to build before even getting on to planning how to build it. So we decided to make a list of the technologies we’d like the chance to try out and use that to give us some direction in the sort of app we’ll be building. We came up with the[...]

First, a little introduction might be useful. I’m Luke, a developer and product manager at Oxford Computer Consultants. We build web and software applications for a really wide range of clients all over the UK and further afield – you can take a look at the OCC site if you want to know more. As part of my annual review process, this year I was particularly interested in finding new ways to give our developers a chance to express their[...]

In SQL Server 2005, you can now use a variable when getting the first n number of rows in a SELECT query: DECLARE @NumberOfRowsIWant INT SET @NumberOfRowsIWant = 23 SELECT TOP (@NumberOfRowsIWant) * FROM T_Client The OUTPUT clause added in SQL 2005 gives you access to the inserted and deleted tables, normally only useable in a trigger, in your stored procedures (SP). Combine the clause with an UPDATE or a DELETE and you can, for example, select fields from the[...]