Needs advice
on
PostgreSQLPostgreSQL
and
MongoDBMongoDB

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·337.1K views
Replies (11)
Director - NGO "Informational Culture" / Ambassador - OKFN Russia at Infoculture·
Recommends
PostgreSQL

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

READ MORE
4 upvotes·1 comment·57.4K 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
PostgreSQL

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...

READ MORE
23 upvotes·1 comment·59.2K 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

Director - NGO "Informational Culture" / Ambassador - OKFN Russia at Infoculture