If someone is talking about "spinning up a separate machine" for Postgres, they're not talking about a desktop or mobile app...

Obviously SQLite is the best choice for a mobile or desktop app, that's not what's being discussed here.