NewSQL: concepts, realities and when you should embrace it

on YouTube ↗26m

" summary

Claim: Distributed SQL gives relational SQL and ACID consistency while scaling horizontally. Concrete examples: Google Spanner, CockroachDB, YugabyteDB; architecture uses ranges with automatic splitting, replication (typical replication factor of three), and consensus (Paxos or Raft). Walkmate scenario: a celebrity tweet drives >1M logins causing connection contention on a single Postgres RDS; Distributed SQL removes manual sharding and supports multi-region locality and data residency by pinning rows, but costs more hardware, requires careful partition keys, and risks replication storms or regional data loss if pinned incorrectly.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 1:54The History of Databases
3. 12:06Read and Write Scenario in a Distributed Sql Database
4. 13:14Read Write Scenario
5. 24:04Should You Embrace Distributed Sql

" related talks

• 29mModern Database Architecture: From SQL to NoSQL & Distributed SQLAndrei Manakov · Site Reliability Engineering (SRE) 2025
• 12mNewSQL Leveraging PostgreSQLJohn S Jones · PostgresOpen 2013
• 02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyFranck Pachot · Devoxx France 2023
• 01h 11mThe official ten-year retrospective of NewSQL databasesAndy Pavlo · Hydra 2021
• 47mAnatomy of a Distributed SQL Database - YugabyteDBFranck Pachot · Devoxx France 2022
• 31mSQL to NoSQL to NewSQL and the rise of polyglot persistence Paul DixPaul Dix · GORUCO 2017
• 31mHarness the Power of a Single Database for MicroservicesFranck Pachot · Infobip Shift 2023
• 24mTech Roundtable: Distributed SQL Around the WorldTim Faulkes, David Walker, Dai Clegg, Vish Phaneendra · Distributed SQL Summit 2022