All other things being equal, I wouldn't go NoSQL over Postgres. What makes Firestore interesting to me (not used it in production) is that you can avoid the n

All other things being equal, I wouldn't go NoSQL over Postgres. What makes Firestore interesting to me (not used it in production) is that you can avoid the need for a backend completely. Your normal architecture is Client <-REST-> Backend <-> DB. You can avoid all the deployment and development in the backend by doing the work in the client.