{"id":16,"date":"2024-10-21T15:07:38","date_gmt":"2024-10-21T19:07:38","guid":{"rendered":"https:\/\/community.mis.temple.edu\/yyang\/blog\/points\/choosing-a-database-postgresql-mysql-mongo-and-cloud\/"},"modified":"2024-10-21T15:07:38","modified_gmt":"2024-10-21T19:07:38","slug":"choosing-a-database-postgresql-mysql-mongo-and-cloud","status":"publish","type":"points","link":"https:\/\/community.mis.temple.edu\/yyang\/points\/choosing-a-database-postgresql-mysql-mongo-and-cloud\/","title":{"rendered":"Choosing a Database PostgreSQL, MySQL, Mongo, and Cloud"},"content":{"rendered":"<p>This course helped me understand the strengths of each option and how to choose the best database for different scenarios. I explored various database options, including PostgreSQL, MySQL, MongoDB, and several cloud-based solutions like AWS, Google Cloud, and Snowflake. PostgreSQL and MySQL are popular SQL databases, with PostgreSQL known for its versatility and MySQL for its widespread use. MongoDB, as a NoSQL database, offers flexibility in handling unstructured data. Additionally, I learned about cloud-based database services like Redshift and S3.<\/p>\n","protected":false},"author":29941,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-16","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/points\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/users\/29941"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":0,"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/points\/16\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/yyang\/wp-json\/wp\/v2\/media?parent=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}