Honestly, I love PostgreSQL, but now I have another server or service to run. SQLite is just a file and often, that is enough.
For example, I have a compiler that compiles a DSL to a DB query which returns a list. Now that query can either be on data in the browser or can be on data on the server. Now I don't have to write the logic twice!