Consistency is the “C” within the ACID properties required for validity within the occasion of errors, community partitions, and energy failures. The 4 ACID properties are Atomicity, Consistency, Isolation, and Sturdiness.
Are your database schemas steady?
In case your database schemas are unlikely to alter considerably over time, and also you need most fields to have constant sorts from file to file, then SQL databases could be a sensible choice for you. In any other case, NoSQL databases, a few of which don’t even assist schemas, is perhaps higher to your software. There are exceptions, nonetheless. For instance, Rockset permits for SQL queries with out imposing a set schema or constant sorts on the information it imports.
Geographic distribution of customers
When your database customers are everywhere in the world, the pace of sunshine imposes a decrease restrict on database latency for the distant customers except you present extra servers of their areas. Some databases permit for distributed read-write servers; others provide distributed read-only servers, with all writes pressured to undergo a single grasp server. Geographic distribution makes the trade-off between consistency and latency even tougher.
