Why All the SQLite "Hate"?

Recently, as I planned a new personal project, I found myself unexpectedly curious about SQLite. As an avid fan of PostgreSQL and MySQL, I initially saw no reason to explore another relational database. Yet, as often happens on Twitter, I noticed a s...