Bert Nelsen wrote:
> By "corrupted" (the meaning of this word seems to differ depending on the
> user's perspective) you mean that the db is really destroyed and cannot be
> opened anymore?

Yes it's possible, if the power loss occurs at just the wrong moment.

> Another question would be: When I use transactions, and I said ".BeginTrans"
> and insert new records and then, before saying ".CommitTrans", I query the
> records, they seem to be already saved.

A transaction can always see the changes it iself made. They are not 
necessarily "saved" in the sense of being written to the disk surface: modified 
records may come from in-memory cache.

Igor Tandetnik

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

Reply via email to