{"id":796,"date":"2008-04-17T23:07:34","date_gmt":"2008-04-18T04:07:34","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/18\/what-mysql-can-learn-from-postgresql"},"modified":"2008-04-18T10:11:35","modified_gmt":"2008-04-18T15:11:35","slug":"what-mysql-can-learn-from-postgresql","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-postgresql","title":{"rendered":"What MySQL Can Learn from PostgreSQL"},"content":{"rendered":"<p>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 &#8220;improve&#8221; in time. Just not today. Believe me, sitting in the talk, was highly painful, and I&#8217;m wondering where my aspirin stash might be. The slides will be available soon, and lets just consider this a learning experience. It reminded me of the time Eric Raymond came to the Fedora Project&#8217;s very first FUDCon in Boston 2005 (probably the only session without available video :P).<\/p>\n<p>What MySQL can learn from PostgreSQL<br \/>\n<a href=\"http:\/\/people.planetpostgresql.org\/joshua\/\">Joshua Drake<\/a><br \/>\n<!--more--><br \/>\nCompared us at OSCON 2007. MySQL lacked technical meat, compared to PostgreSQL. Since 2005, PostgreSQL booth had most visitors besides Mozilla.<\/p>\n<p>MySQL Community is a second class citizen. MySQL AB does not advocate. They promote, they sell.<\/p>\n<p>Does MySQL community advocate? No. PostgreSQL community does. In 2008, there are 7 planned events by community.<\/p>\n<p>MySQL User Conferences? None that he knows of.<br \/>\n&#8211; go to a college and educate students<br \/>\n&#8211; teach a workshop maybe<\/p>\n<p>There is nothing wrong with corporate conferences, but for a community to be truly sustainable, the community must have its own ecosystem.<\/p>\n<p>What makes a community? Members and Users.<\/p>\n<p>Ubuntu: most popular Linux distribution in 4 years. Rabid, helpful, friendly community members.<br \/>\nPostgreSQL: all walks of technical life drive it.<\/p>\n<p>PostgreSQL Association in the US: drive PostgreSQL in higher education.<\/p>\n<p>Where are the people contributing to MySQL because its MySQL the project?<\/p>\n<p>PostgreSQL has defined community leads. MySQL doesn&#8217;t.<\/p>\n<p>The community is the real stock holder in Open Source. To be truly successful, as an open source project (with commercial participation) the commercial participation must be a servant to the community.<\/p>\n<p>In 5 years, there will be no MySQL. Sun won&#8217;t allow MySQL to exist. Maybe it will be Sun-MySQL. Why is the community not ensuring there is more groundwork, beyond the corporate entity?<\/p>\n<p>What happens when the corporate culture disappears, now at Sun?<\/p>\n<p>Sun spent $1 billion on something that is only worth $250 million. That money, was goodwill money based on name. You must produce profit of that billion dollars. So in the next 5 years, they must show the shareholders that the billion dollars gave them 25 years.<\/p>\n<p>Changing the model of MySQL must happen for Sun to justify spending the money.<\/p>\n<p>&#8220;I&#8217;m wondering if there&#8217;s an open source model to MySQL&#8221;.<br \/>\nMySQL controls all of the committers. Is MySQL an open source project?<\/p>\n<p>Marten Mickos asked him to give this talk. No one is going to throw tomatoes at him.<\/p>\n<p>&#8220;I&#8217;m not here to bash MySQL&#8221; &#8211; its just differences that he sees.<\/p>\n<p>People have a tendency to change their goodwill gestures when their coffers are getting thinner. So Sun may make hard decisions to focus on sales.<\/p>\n<p>No co-opetition, that is not sustainable.<\/p>\n<p>Without diversification, the project suffers. Look at the manual, look at the things that have changed. Really? What?<\/p>\n<p>&#8220;Enterprise customers get the alpha code, and the community gets it back later after its tested&#8221;.<\/p>\n<p>CommandPrompt will be fully 100% open source in under 60 days. EnterpriseDB is the opposite, they&#8217;re closing up more and more.<\/p>\n<p>MySQL adds features more quickly than PostgreSQL due to its willingness to add features to stable releases. PostgreSQL only does so in major releases, causing 12-14 months breaks between feature sets. May 2007, no new features, in GA releases<\/p>\n<p>PostgreSQL only adds features based on:<br \/>\n&#8211; correctness<br \/>\n&#8211; maintainability<br \/>\n&#8211; portability<br \/>\n&#8211; stability<\/p>\n<p>Attacks someone from Fox Interactive Media. They have issues with PostgreSQL, and they call Sun, but Joshua wants people to communicate to the community. Sponsor someone. Sun doesn&#8217;t address your needs. This is the 5TB problem in PostgreSQL.<\/p>\n<p>MySQL is an embarrassment at being the &#8220;world&#8217;s most popular open source database&#8221;. That&#8217;s like Microsoft.<\/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%20What%20MySQL%20Can%20Learn%20from%20PostgreSQL&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F04%2F17%2Fwhat-mysql-can-learn-from-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=\"6c91970ceb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-postgresql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-796\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-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-796\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-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-796\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-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>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 &#8220;improve&#8221; in time. Just not today. Believe me, sitting in the talk, was highly painful, and I&#8217;m wondering where my aspirin stash might be. [&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%20What%20MySQL%20Can%20Learn%20from%20PostgreSQL&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F04%2F17%2Fwhat-mysql-can-learn-from-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=\"6c91970ceb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-postgresql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-796\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-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-796\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-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-796\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/what-mysql-can-learn-from-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":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-cQ","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":886,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/07\/24\/mysql-vs-postgresql","url_meta":{"origin":796,"position":0},"title":"MySQL vs. PostgreSQL","date":"24\/7\/2008","format":false,"excerpt":"We were at the Sun+Zend party last night, and it was a blast (thank you Jesse Silver!). If you're a PostgreSQL or MySQL user\/developer or just a general database geek, you should've been there. Why? (watch the video if its stripped in your feed reader) Monty Widenius (MySQL) and Josh\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1706,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2010\/03\/03\/mysql-ecosystem-complementary-talks-at-the-conference","url_meta":{"origin":796,"position":1},"title":"MySQL Ecosystem &#8211; complementary talks at the conference?","date":"3\/3\/2010","format":false,"excerpt":"Its times like this, I want to hear from the greater community - the ones that are reading say, Planet MySQL or Planet MariaDB. MySQL to me, and many others is an ecosystem. We've had for the longest time, complementary technology talks, like for memcached (which have been popular, filled\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3491,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep","url_meta":{"origin":796,"position":2},"title":"Database Tab Sweep","date":"10\/11\/2019","format":false,"excerpt":"I miss a proper database related newsletter for busy people. There\u2019s so much happening in the space, from tech, to licensing, and even usage. Anyway, quick tab sweep. Paul Vall\u00e9e (of Pythian fame) has been working on Tehama for sometime, and now he gets to do it full time as\u2026","rel":"","context":"In &quot;MongoDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":365,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/01\/07\/mysql-101","url_meta":{"origin":796,"position":3},"title":"MySQL 101","date":"7\/1\/2006","format":false,"excerpt":"Some quickies that have been sitting in my blog poster for a while... Quick Polls are an interesting bit of the MySQL site. Look at all the interesting polls, and see where the community come from!I was doing a search on \"migrate from Postgresql to MySQL\" on Google, and all\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":734,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/03\/06\/lots-of-database-talk-at-sun-tech-days","url_meta":{"origin":796,"position":4},"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":[]},{"id":1049,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/20\/mysql-conference-2009-open-source-databases-miniconf-at-linuxconfau","url_meta":{"origin":796,"position":5},"title":"MySQL Conference 2009, Open Source Databases MiniConf at linux.conf.au","date":"20\/9\/2008","format":false,"excerpt":"It is no secret that I am the Program Chair for the MySQL Conference & Expo 2009, and am truly excited about it (big shoes to fill in from Jay). I expect it to be a great conference, with over 2,000 attendees and lots and lots of great talks. The\u2026","rel":"","context":"In &quot;Databases&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\/796"}],"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=796"}],"version-history":[{"count":0,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/796\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=796"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}