On 29 Oct 2016, at 8:05am, Yuri <y...@rawbw.com> wrote:

> The application is synchronizing the in-memory key-value table with the disk 
> one using insert/update/delete statements using that key. The in-memory table 
> was full at the moment of reboot,

You're going to have to explain that.  There can be no such thing as an 
in-memory table when you reboot.  Booting involved having nothing in memory.

> [snip]
> 
> SQLite should preserve data in such case, it should fail operations that 
> can't be performed, but the old data should absolutely stay intact.

It should do.  But bad programming can prevent things from happening properly.

For instance, does the program which makes changes to the database check the 
result values returned by each operation ?  And does it correctly crash if the 
return value indicates something went wrong with the operation ?  Many 
quickly-written simple programs just proceed with the next operation.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to