Rich, I have lived and worked in New York and DC but not for too many years. I have fond memories of the eastern seaboard.
I think you are correct with first, second and third passes on design. We?re into our second pass now. As we work through the issues we may redesign bits of it. However the chain of data flow is now getting complex so ?small' changes can take a long time to move through (and yes we have abstracted our designs out). All the very best. Rob. > On 23 May 2015, at 18:56, Rich Shepard <rshepard at appl-ecosys.com> wrote: > > On Sat, 23 May 2015, Rob Willett wrote: > >> Thanks again and as its Saturday have a drink. If any of you are near York >> in England I?ll happily buy you a pint. > > Rob, > > I'm in the upper left corner of the US so I'll have to pass on your kind > offer. > > Germane to your fundamental concern, over the years I've found that my > first pass at a database schema is usually sub-optimal. The first design is > based on initial assumptions, and further deep thinking can bring up issues > not recognized before. > > I'm sure you will evolve a schema that works well for your needs and > avoids hidden problems. > > Rich > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users