SQLite has always been nothing but awful to me.
"You don't know how to use it", they say, and now suddently the entire world of web development loves SQLite and is pushing SQLite from many different directions.
But it does look like that if you're trying to access it from multiple concurrent requests it will behave much worse than normally.