{"id":215,"date":"2011-11-29T01:24:43","date_gmt":"2011-11-29T06:24:43","guid":{"rendered":"http:\/\/littlesvr.ca\/grumble\/?p=215"},"modified":"2012-12-05T00:52:23","modified_gmt":"2012-12-05T05:52:23","slug":"designed-a-database-recently","status":"publish","type":"post","link":"http:\/\/littlesvr.ca\/grumble\/2011\/11\/29\/designed-a-database-recently\/","title":{"rendered":"Designed a database recently?"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Today I got some news that tells me I&#8217;m going to have some spare time on my hands. So I figured I might as well find something to do with that spare time. One of the ideas in my list caught my attention and I started working on it.<\/p>\n<p>Sort of the centre of that idea is a good data store. I need to store a lot of strings and be able to search them all. And manage the entire thing of course. So I figured I&#8217;d sketch a preliminary database design.<\/p>\n<p>I could not believe what I found. I don&#8217;t remember anything about database design. I remember the normalisation rules, probably because the concept of &#8220;normalising&#8221; always seemed weird to me, my designs are usually normalised out of the box, but then.. I don&#8217;t remember anything else.<\/p>\n<p>There are primary keys and.. what are they called.. I had to google it, foreign keys. And how do I search subtables of subtables? I don&#8217;t even remember such a concept, google confirms there is no such thing as a subtable. Head scratch.<\/p>\n<p>Database stuff always seemed so benign to me I never gave it a second thought after I was done with my courses. I knew there are very complex queries and lots of issues with databases but the field didn&#8217;t interest me at all.<\/p>\n<p>Now it turns out I spent so much time with other technologies I forgot even the simplest things about databases. That struck me as so bizarre I just had to write this blog post. I guess anything can be forgotten if it isn&#8217;t used, no matter how simple it is.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Today I got some news that tells me I&#8217;m going to have some spare time on my hands. So I figured I might as well find something to do with that spare time. One of the ideas in my list caught my attention and I started working on it. Sort of the centre of &hellip; <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":{"0":"entry","1":"post","2":"publish","3":"author-andrew","4":"post-215","6":"format-standard","7":"category-safeforseneca"},"_links":{"self":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/comments?post=215"}],"version-history":[{"count":4,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":614,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/posts\/215\/revisions\/614"}],"wp:attachment":[{"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/littlesvr.ca\/grumble\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}