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 vaclav-hodek
CEO, lead developer at Localazy·
Recommends
on
PostgreSQLPostgreSQL

At Localazy, we have decided for PostgreSQL, because with its JSONB data type, it effectively combines both relational and document store. The relational model is still better in many situations. In combination with ACID transactions and other features, it provides you with something you are not about to get with Mongo. The ability to store JSONB gives you flexibility where you need it. Also, the SQL queries are something great and allow you to unload a lot of logic to the database server.

READ MORE
4 upvotes·322.7K views
Avatar of arhuman
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 Václav Hodek

Václav Hodek

CEO, lead developer at Localazy