Scott, OK, We can see how to do this (I think). Our app is written in Perl and we?d just need to capture the command we write down. The only issue I can think of is the prepare statement and making sure we capture the right SQL command. W
We?ll dig into it and have a look, Thanks for taking the time to reply. Rob On 4 May 2016, at 18:52, Scott Robison wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users