How to know if a project needs a NoSQL database solution?
Maybe the SQL limits define it, if the project requires a larger database or larger fields than NoSQL.
Am I right?
I have examined the limitations of the NoSQL database. They are below:
For example, I use MongoDB assuming that DynamoDB has similar numbers.
mongo can be installed on multiple computers / nodes.
PostgreSQL does not provide built-in tool for sharding, but citus is present.
MongoDB supports databases up to 64 terabytes and the document size is 16 megabytes.
MySQL database limit of 256 terabytes, maximum size of a 64 TB table, and 4 gigabyte logging
PostgreSQL the database has no limit (4 terabytes exists somewhere for testing) and it has a limit of 1 gigabyte for the size of any field of a table and again 64 TB of the maximum size of a table.
Is there anything else relevant to the decision-making process?