Using SQLite as DB in a mid-sized web app.

SQLite only allows one reader/writer at a time. That's how they guarantee ACID compliance.

if you're developing a mid sized web app then sure, but not for production

Sure, if you plan on having n<=1000 records and not many read/writes. It's good for a few admin accounts for a CMS, for example.

Otherwise it's horseshit and terribly under performant.

>>62365228
>>62365243
Thanks /g/ents!

On their website they claim that SQLite will handle well up to 100K hits per day for a small to mid website, which in my case is more than enough, but it does not sound very convincing.

https://sqlite.org/whentouse.html

>>62365228
> SQLite only allows one write at a time
ftfy, it allows multiple concurrent reads