WHY DOES SQLITE (IN PRODUCTION) HAVE SUCH A BAD REP?

Summary from the TLDR newsletter

SQLite, like any other database, has its pros and cons. It's perfect for the majority of applications and scales, and developers can always use PostgreSQL for anything else. Many of the problems SQLite previously had have been fixed. One of the issues with SQLite is that it doesn't allow multiple concurrent writers, but this may not be necessary for all workloads.