Yes but this article is about web services where you clearly can use SQLite but I wanted to understand if there were good reasons to give up Postgres' advantage

Yes but this article is about web services where you clearly can use SQLite but I wanted to understand if there were good reasons to give up Postgres' advantages to do so.