On Wed, May 4, 2016 at 11:47 AM, Rob Willett <rob.sqlite at robertwillett.com> wrote:
> 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. It would require a little extra work on your part. Nothing built into the system that would accomplish this directly. However, I've done similar things and they don't involve a ton of overhead. You could use another SQLite database as the append only log, or a simple text file. I'm not aware of a free lunch solution, sadly. > > > 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 >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison