The major drawback I encountered when building upon SQLite is concurrency of writes.

I have a lot of worker processes writing new data.

With SQLite, I was getting a lot of "Database locked" errors and ended up having to use pg.