Problems with Relational Databases in 2020
summary
Three database experts from MySQL, ClickHouse and PostgreSQL discuss 2020 trends and practical problems with relational databases, covering criteria for choosing a DB, local vs cloud deployment, performance vs DB choice, hybrid SQL/NoSQL architectures, data compression, stored procedures, open-source vs commercial options, and high-availability and scaling (replication, sharding and balancing). They compare changes in relational and NoSQL systems over the past five years and give concrete recommendations for deployment and when to use multiple database types in one project.
AI-written summary · about
chapters (21)
- 0:00Guest introduction
- 0:36Introduction
- 1:27About trends (Peter Zaitsev)
- 3:16About trends (Alexey Milovidov)
- 5:06How to choose a DB (Andrey Borodin)
- 7:59MySQL or PostgreSQL
- 9:00Hybrid DB systems
- 12:00Entry thresholds for databases
- 13:00On-premise or in the cloud?
- 16:00If in the cloud, then how exactly?
- 18:45Significant changes in SQL databases
- 23:05SQL and NoSQL in one project
- 29:00How to compress data
- 34:00Commercial databases
- 38:00Open-source databases require money
- 45:20Open-source databases like Linux
- 48:20High-availability and Scaling (balancing)
- 52:50PostgreSQL and High-availability (sharding, etc.)
- 58:30MySQL, PostgreSQL and distributed systems (technologies)
- 1:07:16Stored procedures and functions in databases
- 1:13:50Limitations of Relational DBMS
related talks
30mThe database trends that are transforming your database infrastructure forever
25mState of Open Source Databases
35m10 things a developer should know about databases
45mBeyond Relational Databases
44mRunning Non-Cloud-Native Databases in Cloud-Native Environments
28mThe Next Decade in Data Management
52mModern Databases: How to Choose an RDBMS in 2023?
28mRelational Databases Don't call it a comeback!