{"id":886,"date":"2008-07-24T16:36:53","date_gmt":"2008-07-24T21:36:53","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=886"},"modified":"2008-07-24T16:36:53","modified_gmt":"2008-07-24T21:36:53","slug":"mysql-vs-postgresql","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql","title":{"rendered":"MySQL vs. PostgreSQL"},"content":{"rendered":"<p>We were at the Sun+Zend party last night, and it was a blast (thank you Jesse Silver!). If you&#8217;re a PostgreSQL or MySQL user\/developer or just a general database geek, you should&#8217;ve been there. Why?<\/p>\n<p><object width=\"425\" height=\"344\"><param name=\"movie\" value=\"http:\/\/www.youtube.com\/v\/AAGgUCDiRlQ&#038;hl=en&#038;fs=1\"><\/param><param name=\"allowFullScreen\" value=\"true\"><\/param><\/object><br \/>\n(<a href=\"http:\/\/www.youtube.com\/watch?v=AAGgUCDiRlQ\">watch the video if its stripped in your feed reader<\/a>)<\/p>\n<p><a href=\"http:\/\/monty-says.blogspot.com\/\">Monty Widenius<\/a> (MySQL) and <a href=\"http:\/\/it.toolbox.com\/blogs\/database-soup\/\">Josh Berkus<\/a> (PostgreSQL), decided to start sumo wrestling! It ended with a 5-0 score, advantage MySQL. <\/p>\n<p>An attendee Tim Moore <a href=\"http:\/\/twitter.com\/tmoore\/statuses\/866821712\">twittered<\/a>: &#8220;Postgres is totally losing the sumo match. I&#8217;m migrating all of my databases to MySQL tomorrow.&#8221;<\/p>\n<p>Monty says, this is what we do to people that leave Sun! In fact, if you didn&#8217;t already know, Josh Berkus, my esteemed colleague in the Database Group at Sun Microsystems, is <a href=\"http:\/\/it.toolbox.com\/blogs\/database-soup\/sun-rise-sun-set-26078\">leaving<\/a> his post as the PostgreSQL Team Lead. We met for the first time, face to face at <a href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/02\/14\/fossin-day-2-a-day-of-sun\">foss.in last year<\/a>, and all I can say is I&#8217;m truly saddened to see him leave. But thanks to the magic of the open source world, we&#8217;ll still be interacting, I&#8217;m sure. Good luck Josh! (and better sumo practising next time, mmmkay?)<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%20vs.%20PostgreSQL&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F07%2F24%2Fmysql-vs-postgresql&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"92675abadb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-886\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-886\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-886\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>We were at the Sun+Zend party last night, and it was a blast (thank you Jesse Silver!). If you&#8217;re a PostgreSQL or MySQL user\/developer or just a general database geek, you should&#8217;ve been there. Why? (watch the video if its stripped in your feed reader) Monty Widenius (MySQL) and Josh Berkus (PostgreSQL), decided to start [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%20vs.%20PostgreSQL&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F07%2F24%2Fmysql-vs-postgresql&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"92675abadb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-886\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-886\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-886\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[102,342,1775,318,319,45,350,351,81,212,352],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-ei","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":715,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/02\/14\/fossin-day-2-a-day-of-sun","url_meta":{"origin":886,"position":0},"title":"foss.in, day 2: A day of Sun","date":"14\/2\/2008","format":false,"excerpt":"Day 2 for me started with watching Simon Phipps talk about Sun's FOSS Philosophy and Strategy. It rained in the morning, so the talk started a little late, and there were hopes of better attendance. Nonetheless, the talk was interesting, and the announcement that there was money in it for\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":796,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-postgresql","url_meta":{"origin":886,"position":1},"title":"What MySQL Can Learn from PostgreSQL","date":"17\/4\/2008","format":false,"excerpt":"Hi! So this is completely my notes taken from the conference, without my thoughts attached to it. I should definitely post a lot more about this, and how the community can \"improve\" in time. Just not today. Believe me, sitting in the talk, was highly painful, and I'm wondering where\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":917,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/08\/05\/monty-speaks-about-maria","url_meta":{"origin":886,"position":2},"title":"Monty speaks about Maria","date":"5\/8\/2008","format":false,"excerpt":"Michael Widenius, commonly referred to as Monty, gave a very interesting talk on Maria at OSCON 2008. He not only had a talk in the main session, that was well attended, titled Architecture of Maria, the New Transactional Storage Engine for MySQL (slides are available in ODP there), he also\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":878,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/23\/brian-monty-and-tim-oreilly-at-oscon-2008-keynote","url_meta":{"origin":886,"position":3},"title":"Brian, Monty and Tim O&#8217;Reilly at OSCON 2008 Keynote","date":"23\/7\/2008","format":false,"excerpt":"Interested in MySQL? Drizzle? How the Sun acquisition is going for MySQL? Listen to Brian, Monty, and Tim speak about this, at the OSCON panel. Watch the video, its 20+ minutes, it starts off a bit shaky (oops), but I'm mostly happy with the rest. Enjoy.","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2849,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/01\/14\/mariadb-in-japan","url_meta":{"origin":886,"position":4},"title":"MariaDB in Japan","date":"14\/1\/2014","format":false,"excerpt":"MariaDB is in Debian\/unstable now, and its great to see that we already have a Japanese po-debconf translation\u00a0(in under a month!). The last time I was in Tokyo, Japan we seemed to have great interest in MariaDB, especially with the backing of MariaDB.com\/SkySQL investment dollars and the MariaDB Foundation to\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/farm2.staticflickr.com\/1308\/1364156568_174456e763_n.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":734,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/03\/06\/lots-of-database-talk-at-sun-tech-days","url_meta":{"origin":886,"position":5},"title":"Lots of database talk at Sun Tech Days","date":"6\/3\/2008","format":false,"excerpt":"I didn't get to attend many sessions at the Tech Days, as I was mainly meeting with people, or at the PostgreSQL on Solaris booth (figures someone from MySQL should've been there too). I had plenty of interesting conversations with Tom Daly; we met by chance since I had a\u2026","rel":"","context":"In &quot;Travel&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/886"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=886"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/886\/revisions"}],"predecessor-version":[{"id":887,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/886\/revisions\/887"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=886"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}