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 »