Scott, Thats an interesting idea. Is there an option in SQLite to do this for us, or do we have to write a small shim in our app?
I like the idea of this as its simple and elegant. Rob On 4 May 2016, at 16:51, Scott Robison wrote: >>> This is going to become a bigger problem for us as the database will >>> only get bigger so any advice welcomed. > > Perhaps, rather than backing up the live data, you create an append > only > log of each and every query you send to the database. Should you need > to > restore, you replay the log of statements. Or at the appointed backup > time, > you replay the day's log of statements into another database. No need > to > ever take the live database offline at the cost of slightly longer > running > commands during the day to handle the append operation. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users