> I’d like to use a web service or app backed primarily by SQLite and see how it goes.

Look no further than sqlite's own source control system: <https://fossil-scm.org>

i've used that site almost daily since the end of 2007 and have encountered maybe (maybe) three "db is locked" errors.