Episode 117 - Database Engines

Database engines or storage engines or sometimes even called embedded databases is software library that a database management software uses to store data on disk and do CRUD (create update delete)

Embedded means move everything in one software no network client server.

In this video I want to go through the few popular database engines, explain the differences between them and finally I want to spin up a database and change its engine and show the different features on each engine

Timecodes

What is a database Engine 3:00

myISAM 9:43

Aria 16:30

InnoDB 19:00

XtraDB 25:30

LevelDB 27:40

RocksDB 34:00

SQLite 38:11

BerkelyDB 42:00

Demo! 47:11

Cards

ACID 4:30

mysql/javascript 56:17

Resources

https://youtu.be/V_C-T5S-w8g

https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-102/

https://mariadb.com/kb/en/library/why-does-mariadb-102-use-innodb-instead-of-xtradb/

https://github.com/facebook/rocksdb/wiki/Features-Not-in-LevelDB

https://mariadb.com/kb/en/library/aria-storage-engine/

Best of MyISAM and InnoDB

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

MySQL :: MySQL 8.0 Reference Manual :: 15.6.2.1 Clustered and Secondary Indexes

Why Uber Engineering Switched from Postgres to MySQL | Uber Engineering Blog