{"id":1388,"date":"2018-01-13T07:50:06","date_gmt":"2018-01-13T07:50:06","guid":{"rendered":"https:\/\/2018.antwerp.wordcamp.org\/?post_type=wcb_session&#038;p=1388"},"modified":"2018-02-28T21:33:14","modified_gmt":"2018-02-28T21:33:14","slug":"krijg-meer-inzicht-in-je-data-met-sqlite-en-sequel-pro","status":"publish","type":"wcb_session","link":"https:\/\/antwerp.wordcamp.org\/2018\/session\/krijg-meer-inzicht-in-je-data-met-sqlite-en-sequel-pro\/","title":{"rendered":"Krijg meer inzicht in je data met SQLite en Sequel Pro (NL)"},"content":{"rendered":"<p>There are lots of tools out there to manage your site&#8217;s data from within wp-admin. Maybe you spend a lot of time in Excel or with csv&#8217;s to prepare data for import, or you write complicated php code to do one-off data manipulation tasks. Sequel Pro (OSX only) and SQLite (Windows, OSX) make a lot of this work easier and simpler, and leverage the power of SQL.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are lots of tools out there to manage your site&#8217;s data from within wp-admin. Maybe you spend a lot of time in Excel or with csv&#8217;s to prepare data for import, or you write complicated php code to do one-off data manipulation tasks. Sequel Pro (OSX only) and SQLite (Windows, OSX) make a lot &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/antwerp.wordcamp.org\/2018\/session\/krijg-meer-inzicht-in-je-data-met-sqlite-en-sequel-pro\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Krijg meer inzicht in je data met SQLite en Sequel Pro (NL)&#8221;<\/span><\/a><\/p>\n","protected":false},"author":8414446,"featured_media":0,"template":"","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_wcpt_session_time":1520087400,"_wcpt_session_duration":3000,"_wcpt_session_type":"session","_wcpt_session_slides":"","_wcpt_session_video":"","_wcpt_speaker_id":[1325],"footnotes":""},"session_track":[1225067],"session_category":[],"class_list":["post-1388","wcb_session","type-wcb_session","status-publish","hentry","wcb_track-trappenaula"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p93XdD-mo","jetpack_likes_enabled":true,"session_date_time":{"date":"March 3, 2018","time":"2:30 pm"},"session_speakers":[{"id":"1325","slug":"toon-van-de-putte","name":"Toon Van de Putte","link":"https:\/\/antwerp.wordcamp.org\/2018\/speaker\/toon-van-de-putte\/"}],"session_cats_rendered":null,"_links":{"self":[{"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions\/1388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions"}],"about":[{"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/types\/wcb_session"}],"author":[{"embeddable":true,"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/users\/8414446"}],"version-history":[{"count":5,"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions\/1388\/revisions"}],"predecessor-version":[{"id":2241,"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/sessions\/1388\/revisions\/2241"}],"speakers":[{"embeddable":true,"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/speakers\/1325"}],"wp:attachment":[{"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/media?parent=1388"}],"wp:term":[{"taxonomy":"wcb_track","embeddable":true,"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/session_track?post=1388"},{"taxonomy":"wcb_session_category","embeddable":true,"href":"https:\/\/antwerp.wordcamp.org\/2018\/wp-json\/wp\/v2\/session_category?post=1388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}