4 ms·
PostgreSQL (+PgBouncer) will be more than enough and actually can reach higher transaction numbers than MongoDB since I doubt you need horizontal scaling for su
by gtirloni 3y ago
PostgreSQL (+PgBouncer) will be more than enough and actually can reach higher transaction numbers than MongoDB since I doubt you need horizontal scaling for such workload.
It has the added benefit of doing a lot for you. With MongoDB you'll need app logic to do certain things. MongoDB improved ACID support but it's not as smooth as just starting PostgreSQL and use it right away.
But that all doesn't matter. Pick what you're comfortable with.
- appalam 3y agoThank you for the reply. From other comments, I have decided to go with Firestore because that's faster and I am comfortable with it too. I just have one concern though, the user will be interacting heavily with the flashcards while studing and I want to store that info for the algo. Should i go with an on-device database for it? or Firestore can handle it?