I use sqlite for my 2-user server and haven't had any issues in the several years I've been running it.

It's possible to corrupt a sqlite database file, but generally it shouldn't happen unless you're doing something weird with it. https://www.sqlite.org/howtocorrupt.html