Re: [sqlite] Virtual table implementation details

2014-11-20 Thread Alessandro Marzocchi
Sorry but I did not make my question clear... my problem is not only restoring data to old data (easy, sqlite already does it at some time during it) but to do other operations during rollback (e.g. notifying the object that its data has changed, so the object will read it back). What I have in

Re: [sqlite] Virtual table implementation details

2014-11-20 Thread Jay Kreibich
You seem to be forgetting one important detail… if a Rollback is called, the underlying data and undo tables will be rolled back automatically. They are, after all “real” tables in the database, and will be managed as such. Unless you’re storing data outside the SQLite database, there is

[sqlite] Virtual table implementation details

2014-11-20 Thread Alessandro Marzocchi
Good day, I'm implementing a serialization/redo engine based on sqlite. My implementation (particulars omitted) will work by adding a layer of virtual tables over real sqlite data tables plus a physical table to store the list of modifications made to them (to implement undo functionality).