{"id":19,"date":"2005-03-04T18:58:56","date_gmt":"2005-03-04T22:58:56","guid":{"rendered":"http:\/\/hoogervorst.dyndns.org\/~arthur\/wordpress\/?p=19"},"modified":"2005-03-04T18:59:09","modified_gmt":"2005-03-04T22:59:09","slug":"datestamps-please","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=19","title":{"rendered":"Datestamps, please."},"content":{"rendered":"<p><span class=\"dropcap\">H<\/span>ere is a tip for those aspiring web developers who think that they know it all  after they have managed to create a &#8216;database-driven&#8217; web application:\n<\/p>\n<p class=\"quote\">Always add a field to important tables that shows when specific items (or rows) were inserted or created. Call it date_created or something. At least it gives you a reference when something was created. Helps if you need to audit and verify data too.\n<\/p>\n<p>To my surprise I saw that there&#8217;s no date\/timestamp for WordPress&#8217;s *_links table. It has a &#8216;updated&#8217; timestamp field, that gets updated each time you change the link. Which gets pretty unusable.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is a tip for those aspiring web developers who think that they know it all after they have managed to create a &#8216;database-driven&#8217; web application: Always add a field to important tables that shows when specific items (or rows) &hellip; <a href=\"http:\/\/www.hoogervorst.ca\/arthur\/?p=19\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[15],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/19"}],"collection":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}