{"id":1200,"date":"2023-04-02T22:03:50","date_gmt":"2023-04-03T05:03:50","guid":{"rendered":"https:\/\/devjamie.com\/?p=1200"},"modified":"2023-04-02T22:03:50","modified_gmt":"2023-04-03T05:03:50","slug":"learning-reflection-journal-post-7","status":"publish","type":"post","link":"https:\/\/devjamie.com\/index.php\/2023\/04\/02\/learning-reflection-journal-post-7\/","title":{"rendered":"Learning Reflection Journal Post #7"},"content":{"rendered":"\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large is-style-rounded\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"980\" height=\"392\" data-id=\"1201\" src=\"https:\/\/i0.wp.com\/devjamie.com\/wp-content\/uploads\/2023\/04\/istockphoto-1401158747-1024x1024-1.jpg?resize=980%2C392&#038;ssl=1\" alt=\"\" class=\"wp-image-1201\" srcset=\"https:\/\/i0.wp.com\/devjamie.com\/wp-content\/uploads\/2023\/04\/istockphoto-1401158747-1024x1024-1.jpg?w=1024&amp;ssl=1 1024w, https:\/\/i0.wp.com\/devjamie.com\/wp-content\/uploads\/2023\/04\/istockphoto-1401158747-1024x1024-1.jpg?resize=300%2C120&amp;ssl=1 300w, https:\/\/i0.wp.com\/devjamie.com\/wp-content\/uploads\/2023\/04\/istockphoto-1401158747-1024x1024-1.jpg?resize=768%2C308&amp;ssl=1 768w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/><figcaption class=\"wp-element-caption\">Panoramic view of multiple database is placed on Relational database tables. Concept of database server, SQL, data storage, database diagram design, Data center, Webhosting. 3D illustration.<\/figcaption><\/figure>\n<\/figure>\n\n\n\n<p>Setting up an SQL database seems to be pretty straightforward with my classwork assignment besides the few quirks in my provider Hostinger. I did notice something that I had issues with on my sight and that was I could only seem to have only one user per database. Only admin accounts that wouldn&#8217;t work if I wanted a proper database. I looked up why this was so. <\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/support.hostinger.com\/en\/articles\/1583542-how-to-create-a-new-mysql-database\n<\/div><\/figure>\n\n\n\n<p>What it comes down to is that I need to have an additional service with my web hosting account. &#8220;Each database can only have one user. If you need multiple users, you can consider a <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.hostinger.com\/vps-hosting\" target=\"_blank\">VPS plan<\/a><\/strong>&#8221; is what I found on the page. So I guess I need to spend more per month for the ability to have a proper database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Setting up an SQL database seems to be pretty straightforward with my classwork assignment besides the few quirks in my provider Hostinger. I did notice something that I had issues [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[39,1],"tags":[40],"class_list":["post-1200","post","type-post","status-publish","format-standard","hentry","category-cosw-30","category-uncategorized","tag-cosw30"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/posts\/1200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/comments?post=1200"}],"version-history":[{"count":1,"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/posts\/1200\/revisions"}],"predecessor-version":[{"id":1202,"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/posts\/1200\/revisions\/1202"}],"wp:attachment":[{"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/media?parent=1200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/categories?post=1200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devjamie.com\/index.php\/wp-json\/wp\/v2\/tags?post=1200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}