Date: Fri, 20 Dec 2019 12:50:36 GMT
<p>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)</p> <p>Embedded means move everything in one software no network client server.</p> <p>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</p> <p>Timecodes</p> <p>What is a database Engine 3:00</p> <p>myISAM 9:43</p> <p>Aria 16:30</p> <p>InnoDB 19:00</p> <p>XtraDB 25:30</p> <p>LevelDB 27:40</p> <p>RocksDB 34:00</p> <p>SQLite 38:11</p> <p>BerkelyDB 42:00</p> <p>Demo! 47:11</p> <p>Cards</p> <p>ACID 4:30</p> <p>mysql/javascript 56:17</p> <p>Resources</p> <p><a href="https://youtu.be/V_C-T5S-w8g">https://youtu.be/V_C-T5S-w8g</a></p> <p><a href="https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-102/">https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-102/</a></p> <p><a href="https://mariadb.com/kb/en/library/why-does-mariadb-102-use-innodb-instead-of-xtradb/">https://mariadb.com/kb/en/library/why-does-mariadb-102-use-innodb-instead-of-xtradb/</a></p> <p><a href="https://github.com/facebook/rocksdb/wiki/Features-Not-in-LevelDB">https://github.com/facebook/rocksdb/wiki/Features-Not-in-LevelDB</a></p> <p><a href="https://mariadb.com/kb/en/library/aria-storage-engine/">https://mariadb.com/kb/en/library/aria-storage-engine/</a></p> <p><a href="https://dba.stackexchange.com/questions/5974/best-of-myisam-and-innodb/6008#6008">Best of MyISAM and InnoDB</a></p> <p><a href="https://dba.stackexchange.com/questions/2640/what-is-the-performance-impact-of-using-char-vs-varchar-on-a-fixed-size-field/2643#2643">What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?</a></p> <p><a href="https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html">MySQL :: MySQL 8.0 Reference Manual :: 15.6.2.1 Clustered and Secondary Indexes</a></p> <p><a href="https://eng.uber.com/mysql-migration/">Why Uber Engineering Switched from Postgres to MySQL | Uber Engineering Blog</a></p>
