This just sounds like you haven't been using transactions. SQLite upholds transaction guarantees.