I think differently. If multiple users need to query the database directly then postgres. If no one is ever going to look at the db except one person or one application then sqllite. It's an interesting question as to whether micro services should be sqllite.

Postgres is recommended because it's free, easy to maintain, install and it's has excellent query features.