JS-R's citystats.uvic.ca project is entering its next phase, with the planned creation of a wizard interface that helps people to configure queries. I've started work on this, writing a couple of the backend functions for getting the unique list of years that happen to be covered by the db, and the list of unique ethnicity designations that are used in those years. The latter is not finished; still looking for an efficient way to do lookups across the large number of tables in the db right now. It might make sense to pre-calculate a lot of this stuff and store it in the db, using triggers, so that lookups are rapid. I should look at this tomorrow. There's no sense in doing the same time-consuming queries over and over again, but we need to make the db self-updating whenever new data is pushed into it.