I have 2 databases, one for user data, workspaces which is a Postgres while the app uses mongo. Is this design good? TC: 400k
If you want acid and sql like transactions, postgres. If the user data is user generated content , mongo , dynamo, cosmosdb, cassandra etc suits
Wow 400k earning engineers have similar questions
No one knows everything
Then it means I can be 400k engineer too and provide a better life for my family
Highly depends on the use case. What's the scale, reliability and PII requirement?