Needs advice
on
MongoDBMongoDB
and
PostgreSQLPostgreSQL

Hello everyone,

Well, I want to build a large-scale project, but I do not know which ORDBMS to choose. The app should handle real-time operations, not chatting, but things like future scheduling or reminders. It should be also really secure, fast and easy to use. And last but not least, should I use them both. I mean PostgreSQL with Python / Django and MongoDB with Node.js? Or would it be better to use PostgreSQL with Node.js?

*The project is going to use React for the front-end and GraphQL is going to be used for the API.

Thank you all. Any answer or advice would be really helpful!

READ LESS
14 upvotes·603.6K views
Replies (11)
Avatar of ivbeg
Founder - Dateno, Director - NGO "Informational Culture" / Ambassador - OKFN Armenia at Infoculture·
Recommends
on
PostgreSQLPostgreSQL

If you have a lot of realtime operations and not-so-high variability of data so Postgres is the best choice. MongoDB is less suitable for high-performance projects but is good for semi-structured data and not-realtime projects. For example we use MongoDB as DB for analytics but we use Postgres for any high-load projects

4 upvotes·1 comment·322.8K views
George Krachtopoulos
George Krachtopoulos
·
March 28th 2020 at 5:37PM

Thank you for your answer! I will look into it.

·
Reply
Code Alchemist at DOOLTA·
Recommends
on
PostgreSQLPostgreSQL

If you want safety (no data corruption/loss) Postgresql is the way to go. You can use Postgresql with python/django but also node. And as a bonus postgresql performance should match those of mongodb if properly tuned...

23 upvotes·1 comment·325.4K views
George Krachtopoulos
George Krachtopoulos
·
March 20th 2020 at 1:03PM

Thank you for your advice!

·
Reply
View all (11)
Avatar of Ivan Begtin

Ivan Begtin

Founder - Dateno, Director - NGO "Informational Culture" / Ambassador - OKFN Armenia at Infoculture