{"id":2723,"date":"2018-02-06T07:58:56","date_gmt":"2018-02-06T13:58:56","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/?p=2723"},"modified":"2018-02-06T07:58:56","modified_gmt":"2018-02-06T13:58:56","slug":"a-few-sql-database-links","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/2723","title":{"rendered":"A Few SQL Database Links"},"content":{"rendered":"<p>So, here are two different relational database links that I am currently interested in.<\/p>\n<p>The first is <a href=\"https:\/\/pgexercises.com\/\">PostgreSQL Exercises<\/a>.  This is a fun way to sharpen your SQL.  While I&#8217;m not a big user of PostgreSQL, I have enjoyed it the few times I&#8217;ve touched it.  And the basics of thinking in SQL are useful across any database.<\/p>\n<p>The second is <a href=\"http:\/\/modern-sql.com\/\">Modern SQL<\/a>.  I was pointed to this site (in particular <a href=\"http:\/\/modern-sql.com\/use-case\/pivot\">this page on pivots<\/a>) after asking a question on a slack (so I can&#8217;t link to it).  My question was about how to transform a set of event values (X happened Y ago, then Z happened at Y+1, and so on) up into counts (X happened N times, Z happened M times).  But the entire site is worth reading if you are a SQL nerd, especially the use cases.<\/p>\n<p>Bonus, check out this Twitter thread about using <a href=\"https:\/\/twitter.com\/bytekast\/status\/960679727303307265\">a single SQL database as a data source for multiple microservices<\/a>.  Pragmatism!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, here are two different relational database links that I am currently interested in. The first is PostgreSQL Exercises. This is a fun way to sharpen your SQL. While I&#8217;m [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,37],"tags":[],"class_list":["post-2723","post","type-post","status-publish","format-standard","hentry","category-databases","category-tips"],"_links":{"self":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/2723","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2723"}],"version-history":[{"count":3,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/2723\/revisions"}],"predecessor-version":[{"id":2726,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/2723\/revisions\/2726"}],"wp:attachment":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}