On Aug 19, 2009, at 3:07 PM, Chris Dew wrote: > http://www.sqlite.org/lang_savepoint.html > I'm looking for a datastore with the following properties: > * I need to 'mark' the state frequently (sub second interval). > * I need to be able to revert the datastore to a previous mark (with > no > appreciable delay). > * I only need to keep the last few hundred 'marks'. (i.e. I never > need to > revert to a datastore marked more than a few minutes ago.) > > The savepoint functionality in sqlite looks to almost fit the bill, > but its > savepoints seem to be nested - i.e. you cannot 'forget about' old > savepoints > while retaining recent savepoints. Is my understanding correct here?
That's correct. "Savepoint" is just another name for "nested transaction". Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users