On Wed, Mar 20, 2013 at 12:45 PM, Neo Anderson <[email protected]>wrote:

> Thanks for your detailed explanation. I think I've got my answers for my 2
> questions.
>
> But I've got another question:
>
> What happens if there is a power failure when the VFS is in middle of
> writing journal data to disk but has not yet finished?
>
> Let's say the VFS has finished writing a half of integer field and now
> power is down. Can sqlite handle this?
>

Yes.  See http://www.sqlite.org/testing.html#crashtesting and
http://www.sqlite.org/atomiccommit.html for further insight into how this
works.


-- 
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to