{"id":183,"date":"2008-10-13T07:17:42","date_gmt":"2008-10-13T15:17:42","guid":{"rendered":"http:\/\/jaredrobinson.com\/blog\/?p=183"},"modified":"2009-07-11T04:07:02","modified_gmt":"2009-07-11T04:07:02","slug":"mysql-or-postgresql","status":"publish","type":"post","link":"https:\/\/jaredrobinson.com\/blog\/mysql-or-postgresql\/","title":{"rendered":"MySQL or PostgreSQL?"},"content":{"rendered":"<p>I&#8217;ve often wondered why people seem to prefer either MySQL or PostgreSQL. For the most part, I think it comes down to the following:<\/p>\n<p>* Familiarity.<br \/>\n* Friends (a.k.a. support system) being more familiar with one over the other.<br \/>\n* Ease of getting started. Most web hosting providers support MySQL out-of-the box.<br \/>\n* Name recognition.<br \/>\n* Ease of support.<\/p>\n<p>Here are some resources that could be useful for learning the pros and cons of each database:<\/p>\n<p>* [What MySQL can learn from PostgreSQL](http:\/\/www.scribd.com\/doc\/2575733\/The-future-of-MySQL-The-Project)<br \/>\n* [What can PostgreSQL learn from MySQL](http:\/\/www.postgresonline.com\/journal\/index.php?\/archives\/48-What-can-PostgreSQL-learn-from-MySQL.html) and the [accompanying presentation](http:\/\/www.commandprompt.com\/files\/mysql_learn.pdf)<br \/>\n* [MySQL quirks and limitations](http:\/\/use.perl.org\/~Smylers\/journal\/34246)<br \/>\n* [Why PostgreSQL?](http:\/\/wiki.postgresql.org\/wiki\/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve often wondered why people seem to prefer either MySQL or PostgreSQL. For the most part, I think it comes down to the following: * Familiarity. * Friends (a.k.a. support system) being more familiar with one over the other. * Ease of getting started. Most web hosting providers support MySQL out-of-the box. * Name recognition. &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/jaredrobinson.com\/blog\/mysql-or-postgresql\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MySQL or PostgreSQL?&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,17],"tags":[],"class_list":["post-183","post","type-post","status-publish","format-standard","hentry","category-programming","category-tech"],"_links":{"self":[{"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/posts\/183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/comments?post=183"}],"version-history":[{"count":4,"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/posts\/183\/revisions"}],"predecessor-version":[{"id":365,"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/posts\/183\/revisions\/365"}],"wp:attachment":[{"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/media?parent=183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/categories?post=183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jaredrobinson.com\/blog\/wp-json\/wp\/v2\/tags?post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}