{"id":3009,"date":"2022-08-23T16:18:52","date_gmt":"2022-08-23T21:18:52","guid":{"rendered":"https:\/\/n8finch2024.local\/?p=3009"},"modified":"2022-09-02T12:17:58","modified_gmt":"2022-09-02T17:17:58","slug":"a-hike-through-the-wordpress-database","status":"publish","type":"post","link":"https:\/\/n8finch2024.local\/a-hike-through-the-wordpress-database\/","title":{"rendered":"A Hike Through the WordPress Database"},"content":{"rendered":"\n<p>Have you ever wondered where the content on your WordPress lives? What about the settings of your WordPress. Or have you ever wondered how taxonomies related to posts?<\/p>\n\n\n\n<p>Or\u2026 maybe you\u2019ve never wondered any of this\u2026 &#x1f602; &#x1f913;<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Regardless, understanding how the WordPress database works behind the scenes is essential for planning, building, and troubleshooting WordPress websites or applications.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/drive.google.com\/file\/d\/1lvvQcMBskQgm6FzAtniPPcxrbhcNFnzH\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Presentation Slides<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever wondered where the content on your WordPress lives? What about the settings of your WordPress. Or have you ever wondered how taxonomies related to posts? Or\u2026 maybe you\u2019ve never wondered any of this\u2026 &#x1f602; &#x1f913;<\/p>\n","protected":false},"author":1,"featured_media":3012,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[46,8,48],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A Hike Through the WordPress Database | Nate Finch<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Hike Through the WordPress Database | Nate Finch\" \/>\n<meta property=\"og:description\" content=\"Have you ever wondered where the content on your WordPress lives? What about the settings of your WordPress. Or have you ever wondered how taxonomies related to posts? Or\u2026 maybe you\u2019ve never wondered any of this\u2026 &#x1f602; &#x1f913;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Nate Finch\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-23T21:18:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-02T17:17:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/n8finch-site.site.strattic.io\/wp-content\/uploads\/2022\/08\/hike.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nate\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@n8finch\" \/>\n<meta name=\"twitter:site\" content=\"@n8finch\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nate\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\"},\"author\":{\"name\":\"Nate\",\"@id\":\"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce\"},\"headline\":\"A Hike Through the WordPress Database\",\"datePublished\":\"2022-08-23T21:18:52+00:00\",\"dateModified\":\"2022-09-02T17:17:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\"},\"wordCount\":70,\"publisher\":{\"@id\":\"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce\"},\"articleSection\":[\"Talks\",\"Web Development\",\"WordPress\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\",\"url\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\",\"name\":\"A Hike Through the WordPress Database | Nate Finch\",\"isPartOf\":{\"@id\":\"https:\/\/n8finch.local\/#website\"},\"datePublished\":\"2022-08-23T21:18:52+00:00\",\"dateModified\":\"2022-09-02T17:17:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/n8finch.local\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Hike Through the WordPress Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/n8finch.local\/#website\",\"url\":\"https:\/\/n8finch.local\/\",\"name\":\"Nate Finch\",\"description\":\"All the things, keeping it clever...&#x1f913;\",\"publisher\":{\"@id\":\"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/n8finch.local\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce\",\"name\":\"Nate\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/n8finch.local\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/n8finch2024.local\/wp-content\/uploads\/2020\/11\/nate-pic_ykd6mq.jpg\",\"contentUrl\":\"https:\/\/n8finch2024.local\/wp-content\/uploads\/2020\/11\/nate-pic_ykd6mq.jpg\",\"width\":796,\"height\":792,\"caption\":\"Nate\"},\"logo\":{\"@id\":\"https:\/\/n8finch.local\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A Hike Through the WordPress Database | Nate Finch","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/","og_locale":"en_US","og_type":"article","og_title":"A Hike Through the WordPress Database | Nate Finch","og_description":"Have you ever wondered where the content on your WordPress lives? What about the settings of your WordPress. Or have you ever wondered how taxonomies related to posts? Or\u2026 maybe you\u2019ve never wondered any of this\u2026 &#x1f602; &#x1f913;","og_url":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/","og_site_name":"Nate Finch","article_published_time":"2022-08-23T21:18:52+00:00","article_modified_time":"2022-09-02T17:17:58+00:00","og_image":[{"width":1500,"height":1000,"url":"https:\/\/n8finch-site.site.strattic.io\/wp-content\/uploads\/2022\/08\/hike.jpg","type":"image\/jpeg"}],"author":"Nate","twitter_card":"summary_large_image","twitter_creator":"@n8finch","twitter_site":"@n8finch","twitter_misc":{"Written by":"Nate","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/#article","isPartOf":{"@id":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/"},"author":{"name":"Nate","@id":"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce"},"headline":"A Hike Through the WordPress Database","datePublished":"2022-08-23T21:18:52+00:00","dateModified":"2022-09-02T17:17:58+00:00","mainEntityOfPage":{"@id":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/"},"wordCount":70,"publisher":{"@id":"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce"},"articleSection":["Talks","Web Development","WordPress"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/","url":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/","name":"A Hike Through the WordPress Database | Nate Finch","isPartOf":{"@id":"https:\/\/n8finch.local\/#website"},"datePublished":"2022-08-23T21:18:52+00:00","dateModified":"2022-09-02T17:17:58+00:00","breadcrumb":{"@id":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/n8finch-site.site.strattic.io\/a-hike-through-the-wordpress-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/n8finch.local\/"},{"@type":"ListItem","position":2,"name":"A Hike Through the WordPress Database"}]},{"@type":"WebSite","@id":"https:\/\/n8finch.local\/#website","url":"https:\/\/n8finch.local\/","name":"Nate Finch","description":"All the things, keeping it clever...&#x1f913;","publisher":{"@id":"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/n8finch.local\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/n8finch.local\/#\/schema\/person\/619068414583ca3c43bb135af49a47ce","name":"Nate","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/n8finch.local\/#\/schema\/person\/image\/","url":"https:\/\/n8finch2024.local\/wp-content\/uploads\/2020\/11\/nate-pic_ykd6mq.jpg","contentUrl":"https:\/\/n8finch2024.local\/wp-content\/uploads\/2020\/11\/nate-pic_ykd6mq.jpg","width":796,"height":792,"caption":"Nate"},"logo":{"@id":"https:\/\/n8finch.local\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/posts\/3009"}],"collection":[{"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/comments?post=3009"}],"version-history":[{"count":4,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/posts\/3009\/revisions"}],"predecessor-version":[{"id":3016,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/posts\/3009\/revisions\/3016"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/media\/3012"}],"wp:attachment":[{"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/media?parent=3009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/categories?post=3009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/n8finch2024.local\/wp-json\/wp\/v2\/tags?post=3009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}