Over a million developers have joined DZone.

CAP Theorem Poll: Which Two Do You Need?

DZone's Guide to

CAP Theorem Poll: Which Two Do You Need?

The CAP Theorem dictates that, out of Consistency, Availability, and Partition Tolerance, you can only pick two features at a time. Which two do you need?

· Database Zone ·
Free Resource

Databases are better when they can run themselves. CockroachDB is a SQL database that automates scaling and recovery. Check it out here.

The CAP Theorem dictates that when you work in a database, you can have Consistency, Availability or Partition Tolerance, but only two of these features at a time.

For example, in NoSQL Systems, each database falls under combinations of two of the three categories:

For this week's poll, we want to know which two features you want. Remember, you have to forfeit the third, so if you choose consistency and availability, you'll be left without partition tolerance. You don't just have to use NoSQL, either. Give us your answer here! We'll be posting a survey result analysis next week.

Databases should be easy to deploy, easy to use, and easy to scale. If you agree, you should check out CockroachDB, a scalable SQL database built for businesses of every size. Check it out here. 

database ,nosql ,sql ,cap theory

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}