> On Apr 14, 2015, at 11:40 AM, Jonathan Moules <J.Moules at hrwallingford.com> > wrote: > > Options that have come to mind (probably missed a lot):
I personally use temp tables, e.g. 'create temporary table if not exists foo?, coupled with 'pragma temp_store = memory?, and drop/create them as necessary, e.g. 'drop table if exists?. There is a set of ETL (Extract, Transform and Load) operations to massage the data just so to their final resting place. Will not qualify this as ?best?, but it?s very workable and without much of a headache. As always, your milage may vary.
