A Simple, Table Driven Approach to Multi-Choice Questionnaires – Part 1
I’ve been working on a project recently that involves a desktop AIR application running (mostly) offline with a local SQLite database. Occasionally the app will synch collected data remotely with a central server that will have an administrative and reporting web front end. Various parts of the AIR application involve filling out a series of multi-choice questions. Considering that the data will be used by two different systems, and anticipating that questions and answers may want to be updated from the admin portal, it seems a good choice to make things as dynamic as possible based on data from the db. It’s not a difficult problem to solve, and I’ve done it a time or two before, but since it’s fresh in my head and the code is in front of me, I’m going to use a couple blog posts to document the strategy. The SQL presented is pseudo code and will not actually execute.
Part 1 is getting the database structure in place.
Read more »


At Pathfinder we do a fair amount of desktop style development — iPhone/Cocoa, WebForms, Swing — and web application development — Grails, Rails, JSP, ASP.NET, etc., etc.. In the last two years we, like a lot of other software development shops, have experienced a convergence in our efforts. The web is coming to the desktop in the form of Air and the Desktop is coming to the web in the form of RIA’s. Now web MVC, which used to be a pretty benign pattern mostly concerned with app flow and validation, is starting to resemble desktop MVC, which has to deal with document-centric models and long lived views and all of the plumbing that requires.