I love SQLite but I don't think it's fair to compare it directly to other rdbms. As the official website itself puts it:

"Another way to look at SQLite is this: SQLite is not designed to replace Oracle. It is designed to replace fopen()."

https://www.sqlite.org/whentouse.html

There are very few instances where I end up in a position where I have to decide whether I need to use postgres or sqlite, they have very different use cases.