It’s safe to say sqlite doesn’t scale at all, let alone well. It’s designed to be dedicated entirely to one process, and anything else is just gravy. What I’ve never run into in years of using sqlite is data corruption, except when I’ve shared it over NFS, which is discouraged for very good reason. SQLite goes to some quite some lengths to ensure proper write behaviors, more than most any other database I’ve seen. Since it ultimately is up to the filesystem and device to implement things properly, you can of course get corruption if you use a sloppy filesystem or storage device that actually does write-behind when it claims to do write-through.
All that said, if your database code is java, sqlite is actually not a great fit, there are better alternatives (like h2) and the only reason I’d spec it is for compatibility with Android.