Re:MySQL Bug #11472: Triggers not executed following foreign...
by spotman on Sunday June 21, 2015 @04:37PM
(#9754913)
Yes, agreed, if we are talking about straight concurrency only.
Other things like replication, are also not there, so it's not what I would choose for a website database, but if you can serve all your reads from one server, and don't care about high availability, then go for it.
I think what you mean here is low concurrent write requirements.
(Edit in response to below: Isn't sqlite file oriented and read-only opens eschew locking? Thus replication via network filesystems should be adequate, no?)