Re: [sqlite] Keeping a history of structured data

2014-07-18 Thread Tristan Van Berkom
On Thu, 2014-07-17 at 21:43 +0100, Simon Slavin wrote: On 17 Jul 2014, at 8:43pm, Tristan Van Berkom wrote: > The objective is to keep a revisioned history of 'E' whenever 'E' has > changed, or any of it's 'P' counterparts have changed, ideally without > storing a duplicate row for the one '

Re: [sqlite] Keeping a history of structured data

2014-07-17 Thread Pavlos Christoforou
On 17 July 2014 21:43, Tristan Van Berkom wrote: > > Hi all, > > We've been pondering how to keep history of structured records without > storing the entirety of the structured record for each new revision, we > have some ideas on how to achieve this but I wanted to consult this list > in case we

Re: [sqlite] Keeping a history of structured data

2014-07-17 Thread Simon Slavin
On 17 Jul 2014, at 8:43pm, Tristan Van Berkom wrote: > The objective is to keep a revisioned history of 'E' whenever 'E' has > changed, or any of it's 'P' counterparts have changed, ideally without > storing a duplicate row for the one 'E' and every one of its 'P's every > time anything changes.

[sqlite] Keeping a history of structured data

2014-07-17 Thread Tristan Van Berkom
Hi all, We've been pondering how to keep history of structured records without storing the entirety of the structured record for each new revision, we have some ideas on how to achieve this but I wanted to consult this list in case we have overlooked some other strategies, and also just to see if