{"id":37630,"date":"2024-11-15T07:24:10","date_gmt":"2024-11-15T12:24:10","guid":{"rendered":"https:\/\/ckms.ca\/?p=37630"},"modified":"2024-11-15T07:24:10","modified_gmt":"2024-11-15T12:24:10","slug":"my-beer-database","status":"publish","type":"post","link":"https:\/\/blog.ckms.ca\/?p=37630","title":{"rendered":"my beer database"},"content":{"rendered":"\n<p>why?  i wanted to learn about SQL databases, how to make middleware (?) that used the dtabase to a web page to enter and search and keep track of drinking all the beer in the world.<\/p>\n\n\n\n<p>i only ever did write one script to query for the number of &#8220;drank&#8221; beers.   for insert\/delete i just used the myPHPadmin or some such.  clunky but functional.<\/p>\n\n\n\n<p>but since moving from GoDaddy to EasyDNS, i&#8217;ve not got it working.  i did make a daatabase &amp; uploaded the current version as when i closed my GoDaddy account.<\/p>\n\n\n\n<p>pic sech reveals the following:<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-1163-starke-pils-from-amsterdam...-cedric-silvester-facebook-2024-10-25-18-31-01.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"430\" src=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-1163-starke-pils-from-amsterdam...-cedric-silvester-facebook-2024-10-25-18-31-01.jpg\" alt=\"\" data-id=\"37631\" data-link=\"https:\/\/blog.ckms.ca\/?attachment_id=37631\" class=\"wp-image-37631\" srcset=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-1163-starke-pils-from-amsterdam...-cedric-silvester-facebook-2024-10-25-18-31-01.jpg 901w, https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-1163-starke-pils-from-amsterdam...-cedric-silvester-facebook-2024-10-25-18-31-01-300x143.jpg 300w, https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-1163-starke-pils-from-amsterdam...-cedric-silvester-facebook-2024-10-25-18-31-01-768x367.jpg 768w, https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-1163-starke-pils-from-amsterdam...-cedric-silvester-facebook-2024-10-25-18-31-01-675x322.jpg 675w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/a><figcaption class=\"blocks-gallery-item__caption\">Last beer posting to Facebook.<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"851\" height=\"423\" src=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter.jpg\" alt=\"\" data-id=\"37633\" data-full-url=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter.jpg\" data-link=\"https:\/\/blog.ckms.ca\/?attachment_id=37633\" class=\"wp-image-37633\" srcset=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter.jpg 851w, https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter-300x149.jpg 300w, https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter-768x382.jpg 768w, https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-last-twitter-posting-2022-09-25-18-40-45-Cedric-Silvester-csilvest-Twitter-675x336.jpg 675w\" sizes=\"auto, (max-width: 851px) 100vw, 851px\" \/><\/a><figcaption class=\"blocks-gallery-item__caption\">Last beer posting to Twitter.<\/figcaption><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>the database on blog.ckms.ca is as follows:<\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-2024-09-11_02-11-56.jpg\"><img decoding=\"async\" src=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-2024-09-11_02-11-56-1024x774.jpg\" alt=\"\" data-id=\"37634\" data-full-url=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-2024-09-11_02-11-56.jpg\" data-link=\"https:\/\/blog.ckms.ca\/?attachment_id=37634\" class=\"wp-image-37634\"\/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-maybe-old-992-drank-2024-09-11_02-14-19.jpg\"><img decoding=\"async\" src=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-maybe-old-992-drank-2024-09-11_02-14-19-1024x680.jpg\" alt=\"\" data-id=\"37635\" data-full-url=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-maybe-old-992-drank-2024-09-11_02-14-19.jpg\" data-link=\"https:\/\/blog.ckms.ca\/?attachment_id=37635\" class=\"wp-image-37635\"\/><\/a><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>but seems that this data might be old, since 992 drank, whereas twitter &amp; facebook posts are more.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-maybe-old-992-drank-2024-09-11_02-14-19-1.jpg\"><img decoding=\"async\" src=\"https:\/\/blog.ckms.ca\/wp-content\/uploads\/2024\/11\/beer-database-blog.ckms.ca-maybe-old-992-drank-2024-09-11_02-14-19-1-1024x680.jpg\" alt=\"\" class=\"wp-image-37636\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>why? i wanted to learn about SQL databases, how to make middleware&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[282],"tags":[51,2060],"class_list":["post-37630","post","type-post","status-publish","format-standard","hentry","category-article","tag-beer","tag-database","wpcat-282-id"],"_links":{"self":[{"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=\/wp\/v2\/posts\/37630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=37630"}],"version-history":[{"count":1,"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=\/wp\/v2\/posts\/37630\/revisions"}],"predecessor-version":[{"id":37691,"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=\/wp\/v2\/posts\/37630\/revisions\/37691"}],"wp:attachment":[{"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=37630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=37630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ckms.ca\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=37630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}