ruby on rails - How do MySQL and SQLite behave in case a system crashes during a commit? -

i have ruby on rails application not big, has 1 sticky requirement. requirement in event of big commit there crash, data saved somehow.

by way, in database language, such feature called? :)

ideally use sqlite database since natural ruby, want know how database in cases of data recovery , crashing? or not realistic concern?

sqlite has pretty documentation on crash behavior here:

http://www.sqlite.org/testing.html
http://www.sqlite.org/atomiccommit.html
http://www.sqlite.org/lockingv3.html#how_to_corrupt

the atomic commit page long , detailed can skip section "9.0 things can go wrong" answer question.