ok sorry, I did not red all thru, may you simply sha1 local and remote ? if != commit again
On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 15 Jul 2014, at 2:20am, William Drago <wdr...@suffolk.lib.ny.us> wrote: > > > The software doesn't crash on its own; I'm forcing it to crash with a > divide-by-zero for test purposes. This doesn't happen in actual use and > there's no reason other than a power failure for a transaction to not > commit successfully. But that doesn't mean I shouldn't handle a failed > transaction if it ever does happen. > > If all you're trying to do is spot crashes then you don't have to > implement your own semaphore system or locking system. Use > > PRAGMA journal_mode = DELETE > > which is the default. Then you know that if a journal file exists, a > process is in the middle of a transaction, or a process which in the middle > of a transaction crashed. > > All you need to do is check to see if a file exists with the name of the > journal file. Presumably you'd be wanting to do this when your application > starts up, before it opens the database. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users