2016-05-15 21:56 GMT+07:00 Simon Slavin <slavins at bigfraud.org>: > > On 15 May 2016, at 3:52pm, Mikael <mikael.trash at gmail.com> wrote: > > > Would there be any facility whereby after each transaction I do on a > > database or table, I could somehow make a snapshot so that at any future > > point in time, I could easily do a SELECT to a given version/snaphot? > > Do you need a solution which works for any possible SQL commands, or are > you in a situation where you execute only some sorts of commands. > > For example, it is far simpler to solve this if you only execute INSERT > and DELETE, never UPDATE. > > Simon.
Simon, yes using only INSERT and DELETE in total would be fine with me (and perhaps BEGIN and COMMIT if it's OK). What are you thinking about? Did you see a purely SQL-based solution that I don't? Also, if I could have a "snaphot *tree*" rather than one linear ladder would be cool but I guess any insights are valuable now.
