{"id":210,"date":"2017-08-03T15:47:36","date_gmt":"2017-08-03T15:47:36","guid":{"rendered":"https:\/\/2017.pittsburgh.wordcamp.org\/?post_type=wcb_session&#038;p=210"},"modified":"2017-09-18T13:45:51","modified_gmt":"2017-09-18T17:45:51","slug":"your-new-bffs-the-wordpress-core-tables-the-mysql-database","status":"publish","type":"wcb_session","link":"https:\/\/pittsburgh.wordcamp.org\/2017\/session\/your-new-bffs-the-wordpress-core-tables-the-mysql-database\/","title":{"rendered":"Your New BFFs: the WordPress core tables + the MySQL database"},"content":{"rendered":"<p>You&#8217;re a rockstar with the front end and the WordPress admin, but the back end is&#8230; a mystery. Ever wonder what happens when you create a user or save a post? Where does the data go? Let&#8217;s dive in to the MySQL database via phpMyAdmin. We&#8217;ll explore the WordPress core tables and investigate the fields to see how the data is stored. We&#8217;ll also touch on optimizing your tables and creating database backups without a plugin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You&#8217;re a rockstar with the front end and the WordPress admin, but the back end is&#8230; a mystery. Ever wonder what happens when you create a user or save a post? Where does the data go? Let&#8217;s dive in to &hellip; <a href=\"https:\/\/pittsburgh.wordcamp.org\/2017\/session\/your-new-bffs-the-wordpress-core-tables-the-mysql-database\/\">Continue reading <span class=\"assistive-text\">Your New BFFs: the WordPress core tables + the MySQL database<\/span>  <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":15544440,"featured_media":0,"template":"","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_wcpt_session_time":1504981800,"_wcpt_session_duration":3000,"_wcpt_session_type":"session","_wcpt_session_slides":"https:\/\/www.slideshare.net\/mobile\/secret\/4JZ6n4tIBa575v","_wcpt_session_video":"","_wcpt_speaker_id":[209],"footnotes":""},"session_track":[446812],"session_category":[],"class_list":["post-210","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-track-b"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8Begv-3o","jetpack_likes_enabled":true,"session_date_time":{"date":"September 9, 2017","time":"2:30 pm"},"session_speakers":[{"id":"209","slug":"rene-morozowich","name":"Rene Morozowich","link":"https:\/\/pittsburgh.wordcamp.org\/2017\/speaker\/rene-morozowich\/"}],"session_cats_rendered":null,"_links":{"self":[{"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/types\/wcb_session"}],"version-history":[{"count":1,"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions\/210\/revisions"}],"predecessor-version":[{"id":333,"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/sessions\/210\/revisions\/333"}],"speakers":[{"embeddable":true,"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/speakers\/209"}],"author":[{"embeddable":true,"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wporg\/v1\/users\/renemorozowich"}],"wp:attachment":[{"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/session_track?post=210"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/pittsburgh.wordcamp.org\/2017\/wp-json\/wp\/v2\/session_category?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}