Thanks for the info Rafael, I will be using select statements exclusively and as far as I know these don’t lock, so I’d only need to worry about table changes on the Discourse side (i.e when upgrading) and where I could switch the other app off temporarily. Would that alleviate lock concerns?
With regards to replicating the database, that seems like an interesting option - can it be done on the fly, so it’s no more than a couple of minutes out of date? (I need to fetch latest topics frequently - almost every page on the site has them, although I do cache for two minutes but they vary per page/criteria and there will be hundreds of these types of pages). Also this may stop being an option when the DB grows? (On another Discourse Forum my dB is already a couple gig.)
(I don’t think creating a plugin would be an option here as I can’t see how it would be any better than the Data Explorer plug-in, in fact the DE plugin is almost perfect - apart from this issue.)