database-engine – Tarik Billa

What are MySQL database engines? [closed]

February 15, 2023 by Tarik

mysql> SHOW ENGINES; +————+———+—————————————————————-+————–+——+————+ | Engine | Support | Comment | Transactions | XA | Savepoints | +————+———+—————————————————————-+————–+——+————+ | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | … Read more

How to write a simple database engine [closed]

November 13, 2022 by Tarik

If you’re good at reading code, studying SQLite will teach you a whole boatload about database design. It’s small, so it’s easier to wrap your head around. But it’s also professionally written. SQLite 2.5.0 for Code Reading http://sqlite.org/