Understanding the WordPress Posts Table: wp_posts
A practical introduction to what the wp_posts table stores, how post types work, and how post relationships are represented.
-
-
Understanding Data Relationships in the WordPress Database
Learn how one-to-one, one-to-many, and many-to-many relationships appear across the WordPress database tables.
-
Understanding WordPress Content Types: Post Types
A practical introduction to the main content types in WordPress, how posts, comments, users, and metadata relate to each other, and why post types matter.
-
WordPress Trivia: How Many Posts Can WordPress Support?
A fun look at the theoretical maximum number of posts WordPress can store based on the bigint ID field used in its database tables.
-
Understanding the WordPress Database Structure and the Relationships Between Its Tables
A detailed introduction to the WordPress database structure, the content types it stores, and the relationships between the core tables.
-
Understanding WordPress Taxonomies in Depth
A detailed introduction to WordPress taxonomies, taxonomy terms, and how taxonomy data is stored across WordPress database tables.
-
Understand the WordPress Database Structure Through a Peewee Model
Convert the WordPress database schema into Peewee models to inspect the database structure more clearly and reuse it in a Python ORM workflow.
