Why do you need to understand how databases work under the hood? What file types do databases use? What are the database indexes? What are the different types of databases out there? What questions do you need to ask to pick a database that fits your solution?
Chapter 1 of Database Internals(www.amazon.com...) book gives the answers to these questions, and in this video, we will cover those answers!
#database #softwarearchitecture
Blog: vvsevolodovich...
Telegram channel: t.me/architect...
Patreon: / vvsevolodovich
Boosty: boosty.to/vvse...
0:00 Start
0:54 Chapter one intro
1:17 Why understanding DBs is important?
5:35 Questions to choose a DB
7:35 Database engine architecture
9:36 In-memory vs Disk-based databases
10:22 Rows vs column-oriented databases
13:33 Benefits of DBMS over the plain filesystem
15:00 File types in DBs
16:23 Index files