WordPress 5 Cookbook

Creating and managing custom tables

We used the previous recipe to look at the default database tables in a WordPress site and how to manage the data of these tables. In application development, we may need custom database tables due to reasons such as the following:

• Increased data volume in core tables slowing down core features
• Difficulty in matching custom data to existing table columns
• Limitations in flexibility for querying the results

WordPress also allows us to work with custom database tables through the built-in wpdb class. We can use the recommended methods for accessing custom tables through built-in functions to speed up the development process without writing custom queries for all the requirements. So, it's important to understand ...