> > 1. with every other database that is not sqlite, it's safe because how > most relational db work, transactions make you have always a consistent set > of results (if you use them correctly!!)
It's still "safe" in SQLite -- you just might get a little more blocking than you would with other db's. If the task isn't too frequent and the load on the app generally not too heavy, SQLite should be fine. Anthony