Understanding the WordPress database
Typical full stack web development frameworks don't come with a preplanned database structure. Instead, these frameworks focus on the core foundation of an application while allowing the developers to focus on application-specific features. On the other hand, WordPress provides a preplanned database structure with a fixed set of tables. WordPress is built to function as a content management system and hence it can be classified as a product rather than a pure development framework. A WordPress core database is designed to power the generic functionalities of a CMS. So, it's our responsibility to use our skills to make it work as an application development framework.
Our WordPress database is intended to work with MySQL and hence we need to have a MySQL database set up before installing WordPress. On successful installation, WordPress will create 11 database tables to cater to core functionality with the default MySQL table engine.
Note
MyISAM was used as...