NewSQL

NewSQL #

Introduction #

NewSQL databases represent a new generation of relational databases that aim to combine the best of both worlds: the scalability of NoSQL databases and the ACID properties of traditional SQL databases. In this blog post, we’ll explore what NewSQL databases are, their advantages, and some popular tools in this space.

What are NewSQL Databases? #

NewSQL databases are designed to address the limitations of traditional relational databases when it comes to scalability. They provide horizontal scalability by distributing data across multiple nodes while maintaining strong consistency and transaction support. Unlike NoSQL databases, NewSQL databases adhere to the relational data model and SQL query language.

Google Spanner #

Google Spanner is a globally distributed NewSQL database developed by Google. It combines the scalability of NoSQL databases with the consistency guarantees of traditional SQL databases. Spanner uses a combination of TrueTime (a synchronized global clock) and two-phase commit to achieve strong consistency across data centers. It’s an excellent choice for applications that require high availability and global scalability.

CockroachDB #

CockroachDB is an open-source NewSQL database inspired by Google Spanner. It provides distributed SQL capabilities, automatic sharding, and strong consistency. CockroachDB is designed to be resilient to failures, and it can automatically rebalance data across nodes. Developers can use familiar SQL queries to interact with CockroachDB, making it an attractive option for modern applications.

Learning Resources #

Courses #

Miscellaneous #