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·428.7K views
Replies (11)
CTO at Seaber.io at Seaber.io·
Recommends
PostgreSQL

I'd recommend using PostgreSQL and the built in row level security it offers. You can easily make multi-tenant real-time systems using it and https://www.graphile.org/postgraphile/ which gives you an GraphQL api guaranteed to be in sync with your database for free. Also, the transactional support in postgres shines in comparison to mongodb.

READ MORE
5 upvotes·1 comment·148.7K views
George Krachtopoulos
George Krachtopoulos
·
March 28th 2020 at 5:37PM

Thank you for your answer! I look forward to exploring graphile.

·
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·150.7K views
George Krachtopoulos
George Krachtopoulos
·
March 20th 2020 at 1:03PM

Thank you for your advice!

·
Reply
View all (11)
Avatar of Mikael Sand

Mikael Sand

CTO at Seaber.io at Seaber.io