{"id":595,"date":"2017-11-11T11:06:48","date_gmt":"2017-11-11T16:06:48","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=595"},"modified":"2021-09-16T14:58:00","modified_gmt":"2021-09-16T18:58:00","slug":"yet-another-reason-to-learn-sql","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=595","title":{"rendered":"Yet Another Reason to Learn SQL"},"content":{"rendered":"<p>If you are interested in learning how to program for <a title=\"What is Android OS? - Definition from WhatIs.com\" href=\"http:\/\/searchmobilecomputing.techtarget.com\/definition\/Android-OS\" target=\"_blank\" rel=\"noopener\">Android<\/a> or other mobile system, you might need to manage data and that is where\u00a0<a title=\"What is SQL (Structured Query Language)? - Definition from WhatIs.com\" href=\"http:\/\/searchsqlserver.techtarget.com\/definition\/SQL\" target=\"_blank\" rel=\"noopener\">SQL<\/a> comes in handy &#8212; especially <a title=\"SQLite\" href=\"https:\/\/www.sqlite.org\/\" target=\"_blank\" rel=\"noopener\">SQLite<\/a>.<\/p>\n<blockquote><p><em>In Android development, we tend to use SQLite which is ideal for mobile applications and particularly useful for permanently storing data. MySQL is more commonly installed on servers where it can be used by web apps. Either way, using databases to store information allows us to organize that data in a far more logical and structured manner, and then access and manipulate that information dynamically.<\/em><br \/>\n<a title=\"A SQL primer for Android app developers - Android Authority\" href=\"https:\/\/www.androidauthority.com\/sql-android-app-development-812969\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.androidauthority.com\/sql-android-app-development-812969\/<\/a><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>If you are interested in learning how to program for Android or other mobile system, you might need to manage data and that is where\u00a0SQL comes in handy &#8212; especially SQLite. In Android development, we tend to use SQLite which is ideal for mobile applications and particularly useful for permanently storing data. MySQL is more [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[3,1,17,2],"tags":[],"class_list":["post-595","post","type-post","status-publish","format-standard","hentry","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=595"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/595\/revisions"}],"predecessor-version":[{"id":596,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/595\/revisions\/596"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}