{"id":163160,"date":"2014-06-26T21:12:57","date_gmt":"2014-06-27T01:12:57","guid":{"rendered":"https:\/\/2014.montreal.wordcamp.org\/?post_type=wcb_session&#038;p=163160"},"modified":"2014-08-18T12:46:37","modified_gmt":"2014-08-18T16:46:37","slug":"the-database-schema","status":"publish","type":"wcb_session","link":"https:\/\/montreal.wordcamp.org\/2014\/session\/the-database-schema\/","title":{"rendered":"The Database Schema"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/2014.montreal.wordcamp.org\/files\/2014\/06\/mo-jangda.jpeg\" alt=\"mo jangda\" width=\"102\" height=\"102\" class=\"alignleft size-full wp-image-163207\" \/>Understanding how the database schema of WordPress is setup, including a walk-through of the tables and how WordPress stores the data and helps you interact with it via its APIs. We\u2019ll also dive into the benefits and dangers of the schema and how to adapt it to go beyond just blog posts.<\/p>\n<p><em>Prerequisites: Basic understanding of PHP, (My)SQL, and technical WordPress concepts.<\/em><\/p>\n<p><a href=\"http:\/\/me.digitalize.ca\/2014\/05\/03\/presentation-database-schema\/\" class=\"simple-button\">View the slides.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Understanding how the database schema of WordPress is setup, including a walk-through of the tables and how WordPress stores the data and helps you interact with it via its APIs. We\u2019ll also dive into the benefits and dangers of the &hellip; <a href=\"https:\/\/montreal.wordcamp.org\/2014\/session\/the-database-schema\/\">Continue reading <span class=\"screen-reader-text\">The Database Schema<\/span>  <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":4229527,"featured_media":0,"template":"","meta":{"jetpack_post_was_ever_published":false,"_wcpt_session_time":1582047051,"_wcpt_session_duration":3000,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[163066],"footnotes":""},"session_track":[323010],"session_category":[],"class_list":["post-163160","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-developerprogramer"],"jetpack_sharing_enabled":true,"session_date_time":{"date":"February 18, 2020","time":"12:30 pm"},"session_speakers":[{"id":"163066","slug":"mo-jangda","name":"Mo Jangda","link":"https:\/\/montreal.wordcamp.org\/2014\/speaker\/mo-jangda\/"}],"session_cats_rendered":null,"_links":{"self":[{"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/sessions\/163160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/types\/wcb_session"}],"author":[{"embeddable":true,"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/users\/4229527"}],"version-history":[{"count":4,"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/sessions\/163160\/revisions"}],"predecessor-version":[{"id":163883,"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/sessions\/163160\/revisions\/163883"}],"speakers":[{"embeddable":true,"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/speakers\/163066"}],"wp:attachment":[{"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/media?parent=163160"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/session_track?post=163160"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/montreal.wordcamp.org\/2014\/wp-json\/wp\/v2\/session_category?post=163160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}