Adding history/versioning to a Nested Set model (is it possible?)
Date: Wed, 28 Oct 2009 10:55:35 -0700 (PDT)
Message-ID: <d70a4a68-f6d3-4679-888c-55b1d3254f44_at_m16g2000yqc.googlegroups.com>
Hi All,
I'm trying to implement a tree structure, hence I'd like the Nested Set model, but I need to be able to record the history of the tree structure *somehow* so that I can access previous versions.
I've searched up and down online but all I can find are transactions +rollbacks.
As far as I can see...
The simplest option would be to add a version number to the model, but then every member of the set would have to be updated each time a change is made - not feasible because of how fast that would make the table would grow, and how slow that would make it to update?
I imagine I could log each action and then replay all the log actions in a temporary table when I needed them, but that would get pretty slow after a few updates.
The previous Nested Set could be serialised to an blob and stored. That's currently looking like the best option, but only by process of elimination...
I've probably missed something obvious that's staring me in the face here! - any suggestions?
Thanks for taking the time to read this far, best regards, Ed
Received on Wed Oct 28 2009 - 18:55:35 CET