Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: [OT] Why I don't use Mysql for new projects

by Mutant (Priest)
on Jul 10, 2008 at 13:41 UTC ( #696697=note: print w/ replies, xml ) Need Help??


in reply to [OT] Why I don't use Mysql for new projects

Funnily enough, we're currently looking at Postgres vs MySQL at work, since Oracle seems to be sucking up higher and higher percentages of our budget, and we already use open source solutions to a lot of other problems, so it seems to make sense.

I haven't really used Postgres in about 4 years, but even then I preferred it to MySQL. It seems that in that time, while MySQL has made up for a lot of it's shortcomings, Postgres has continued to improve as well. It's now ever surpassed MySQL in the one thing it used to trail on - performance.

On top of that, Postgres is true open source, not backed by a company like MySQL. InnoDB (which is what gives MySQL a lot of it's improved data integrity) is closed source, and licensed from Oracle. What happens if Oracle decides to terminate that license?

The only thing is MySQL is deployed a lot more widely than Postgres (which is somewhat analogous to PHP and Perl). I'm using MySQL for a personal project of mine at the moment, because my hosting provider has it available by default. Maybe this will start to change, especially if MySQL ends up moving in a different direction in the hands of Sun.

Some intersting reading on the subject:


Comment on Re: [OT] Why I don't use Mysql for new projects
Re^2: [OT] Why I don't use Mysql for new projects
by perrin (Chancellor) on Jul 10, 2008 at 14:25 UTC
    InnoDB is not closed source. MySQL is a fully open source project. You don't need to get it from MySQL AB.

      I don't think I explained my point of view on that particularly well. What I meant was MySQL is backed by a single commercial interest (and as of this year, that commercial interest is a Big Corp). Somehow, someone has to make some money pretty directly off MySQL, and that someone has a lot of influence on the direction of MySQL. Much more than, say, IBM could ever have over the Linux kernel, despite the fact that they put money into it.

      To me, that's a conflict of interest. Plus it creates uncertainty about what might happen in the future. Sun's already talking about closing the source of some of the tools (I doubt they will ever close MySQL completely, but still...). If there's a choice, I'll usually go for the OSS project that is not primarily controlled by a company. e.g. Perl over PHP, Debian over Red Hat.

        I think you overestimate how much Sun controls MySQL. They have not made anything closed-source, and the stories that they were considering it a couple months ago were quite misleading. I think you're overestimating this in general actually. PHP is certainly not controlled by a company, and Fedora is a very open project.

        Would it be any better if the top contributors to Postgres left the project than if the MySQL ones did? Unless you have some data showing that one project has a much more centralized group of contributors, I don't think you can draw any conclusions based on who makes money from it.

Re^2: [OT] Why I don't use Mysql for new projects
by Anonymous Monk on Jul 10, 2008 at 14:43 UTC

    Pet peeve: interestingly enough, "funnily" is not a word. Not even close. "Interestingly" works because it ends in "ing", and so adding the "ly" sounds ok. Also words ending in 'e' can work, as in "strangely", or just words ending in a consonant like "thinly".

    "Funnily" sounds clumsy and made up, or possibly sounds like it's meant to mean "something vaguely funnel-like".

      Well you know what, that's a peeve you can get rid of!

      As it turns out, funnily is a word, more specifically, an adverb, meaning "in a funny manner", as any reliable dictionary will tell you.

      • another intruder with the mooring in the heart of the Perl

      My pet peeve: amateur grammar nazis.

      As grinder kindly pointed out, "funnily" is a real word. Even if it wasn't in the dictionary, that's not what makes something a "real word". It's common usage. And "funnily enough" is a reasonably common phrase, at least where I come from (NZ originally, currently UK).

      I have to also wonder if this trick would work on you.

        If you're trying to funnel me into using the word "funnily", it won't work. In other words, your funnelly attempts will not prevail. So, if you'll excuse me, I'm off to have some funnelly cake. Maybe I'll sit under some funnelly clouds while eating it.

Re^2: [OT] Why I don't use Mysql for new projects
by dragonchild (Archbishop) on Jul 11, 2008 at 01:43 UTC
    MySQL AB makes almost all of its money from the following sources:
    • Training and Certification
    • Support
    • Consulting
    • Licensing under very specific circumstances
    And, from what I understand, the licensing revenue is a pretty small part of the pie. Not surprisingly, the first three are the same ways that RT, Shadowcat, and Stonehenge makes their money. The Postgres Foundation makes money from donations. I suspect many of the organizations that the PG devs live in support themselves in similar ways as the companies previously mentioned. I know that this is the case for both MySQL and Perl and Ruby.

    My criteria for good software:
    1. Does it work?
    2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://696697]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2014-09-23 00:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (209 votes), past polls