Re: [sqlite] How to do rollback & rollforward?
On 11/3/17, Robert M. Münch wrote: > On 2 Nov 2017, at 16:56, Richard Hipp wrote: > >> Did you see this document: https://www.sqlite.org/undoredo.html > > No, I didn't, thanks a lot. > > >> Do the ideas talked about there help in any way? > > Yes, it's what we are seeking. > > The SESSIONs (sorry thought it's named VERSION) extension looks like > something that will handle the tracking tables for us and create those > change-sets as in the example. Storing change-sets inside the DB should work > too, I think. > > Or would it be better to use the approach from the example and omit the > SESSIONs extension at all? Either way will probably work. Which approach seems easiest for you to implement? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to do rollback & rollforward?
On 2 Nov 2017, at 16:56, Richard Hipp wrote: > Did you see this document: https://www.sqlite.org/undoredo.html No, I didn't, thanks a lot. > Do the ideas talked about there help in any way? Yes, it's what we are seeking. The SESSIONs (sorry thought it's named VERSION) extension looks like something that will handle the tracking tables for us and create those change-sets as in the example. Storing change-sets inside the DB should work too, I think. Or would it be better to use the approach from the example and omit the SESSIONs extension at all? Viele Grüsse. -- Robert M. Münch, CEO M: +41 79 65 11 49 6 Saphirion AG smarter | better | faster http://www.saphirion.com http://www.nlpp.ch signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to do rollback & rollforward?
On 11/2/17, Robert M. Münch wrote: > Hi, following scenario: > > Our app has a very exhaustive undo system. There you can, as long as you > don't change anything, go back in time, take a look at your data and than go > forward again and get back all changes you have done. > > I think the VERSION extension might help us here. On the other hand, > SAVEPOINTs look very good too as they are named. But I don't see a way how I > can go back to a SAVEPOINT and then forward again. Would this be possible > somehow? Did you see this document: https://www.sqlite.org/undoredo.html Do the ideas talked about there help in any way? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to do rollback & rollforward?
Hi, following scenario: Our app has a very exhaustive undo system. There you can, as long as you don't change anything, go back in time, take a look at your data and than go forward again and get back all changes you have done. I think the VERSION extension might help us here. On the other hand, SAVEPOINTs look very good too as they are named. But I don't see a way how I can go back to a SAVEPOINT and then forward again. Would this be possible somehow? The other idea is to take the named SAVEPOINTs idea and implement something like this manually with change-sets etc. that can be played back and forth. I'm not totally sure how to best tackle this. If using VERSION extension and storing the changes inside the DB (while excluding the tracking for the change-set-table) this should even give us a persistent undo system, right? Viele Grüsse. -- Robert M. Münch, CEO M: +41 79 65 11 49 6 Saphirion AG smarter | better | faster http://www.saphirion.com http://www.nlpp.ch signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users