tangent: in modern SQLite, are writes still serialized? That's my main concern when choosing a tech stack for an app that might have thousands of writes happening on peak periods
You might start running into problems at tens or hundreds of thousands of writes a second, though even then you may be OK on the right hardware.