Sometimes I want to run MI across multiple competitions – e.g. number of entries per club – an this is difficult as PostGres doesn’t really offer cross database queries. Therefore it would be very useful to be able to select a number of databases and then create a merged one, with an additional column added to each table of “compname”
I’ve thought about this a number of times now – tracking individual’s historical results etc. Getting the data loaded wouldn’t be a big problem, but then doing different things with it could end up exploding into a lot of additional work. You also have to consider the number of wrong BG numbers, incorrect spellings etc, which makes data sanitising a high priority item too.
I’ll put it on the roadmap!