Choose a proper database in order to handle the requirement to have customers choosing their own form schemas

reach4help / covidhelphub-backend

MIT License

0 stars 1 forks source link

Choose a proper database in order to handle the requirement to have customers choosing their own form schemas #3

Closed puzzledbytheweb closed 2 years ago

puzzledbytheweb commented 2 years ago

Our customers need to create their own forms so they can't be bound to a rigid schema defined by us. We need to play around with noSQL and SQL databases to find the best suit for this.

I'm thinking about trying our PostgresSQL in the SQL realm and in MongoDB in the noSQL realm, just because those are the two DBs I'm most acquainted with.

edmkitty commented 2 years ago

I am also familiar with PostgreSQL and I think it's pretty popular, so my vote goes to PostgreSQL. I have no objection to mongo either. I am also familiar with Redis, but that is a key-value store instead of a document store so I'm not sure it will solve the same use cases as mongo.