Summary
Database options come in several flavors, and it is crucial to understand the trade-offs with each type. Each data target has specific behaviors, such as SQL having a standard, maturity, several tools, and know-how in its favor. Still, it is pretty hard to work on horizontal scalability.
NoSQL was designed to improve horizontal scalability; however, this came at the cost of less consistency than relational databases are known for.
Finally, NewSQL tries to merge both worlds and bring the benefits of both, but it lacks in both areas.
In the next chapter, we’ll cover more about the architectures and strategies of technologies and how to handle them.