Slashdot Mirror


Why Oracle Can't Easily Kill PostgreSQL

ruphus13 writes "Claiming that 'PostgreSQL is a FOSS alternative to MySQL and hence Oracle should be allowed to pursue MySQL' is a specious argument, according to Monty Widenius. He fears that Oracle, or someone else, can easily squash PostgreSQL by just 'buying out' the top 20 developers. The Postgre community has fired back, calling that claim ridiculous. According to the article, 'PostgreSQL as a project is pretty healthy, and shows how vulnerable projects like MySQL are to the winds of change. PostgreSQL could die tomorrow, if a huge group of its contributors dropped out for one reason or another and the remainder of the community didn't take up the slack. But that's exceedingly unlikely. The existing model for PostgreSQL development ensures that no single entity can control it, it can't be purchased, and if someone decides to fork the project, the odds are that the remaining community would be strong enough to continue without a serious glitch.'"

63 of 279 comments (clear)

  1. Widenius please move on... by Bill_the_Engineer · · Score: 5, Insightful

    You got your money and now you want MySQL (or at least the spotlight) back.

    By your argument, PostgreSQL is fragile because the top 20 developers could be bought out by Oracle. If you think that's a buyout target that can be easily squashed, just think what a SQL DB with only one copyright owner can be? Oh wait, that was MySQL and we already know what you did....

    --
    These comments are my own and do not necessarily reflect the views or opinions of my employer or colleagues...
    1. Re:Widenius please move on... by mangu · · Score: 4, Informative

      PostgreSQL is fragile because the top 20 developers could be bought out by Oracle

      His argument is "I was bought, therefore anybody else can be bought".

      If Oracle is willing to buy 20 developers at $1 billion each, then he may be right.

    2. Re:Widenius please move on... by Anonymous Coward · · Score: 5, Insightful

      ...PostgreSQL is fragile because the top 20 developers could be bought out by Oracle...

      Sort of like how Monty's been trying to buy all the top MySQL devs away from Sun...

    3. Re:Widenius please move on... by TheRaven64 · · Score: 4, Interesting

      Well, it was $1bn for the company, not just $1bn for Monty. $1bn for Postgres would be $50m for the 20 developers. Still quite a lot. Of course, there is a big problem here. Because Postgres would still be BSD licensed, there's nothing stopping these developers from giving $1m of this to pay for someone else to work full time on the project...

      --
      I am TheRaven on Soylent News
    4. Re:Widenius please move on... by thetoadwarrior · · Score: 2, Interesting

      I agree, In my opinion the guy is a jackass. I'm half tempted to quit using MySQL myself purely because it originated from him.

    5. Re:Widenius please move on... by Migala77 · · Score: 2, Insightful

      His argument is "I was bought, therefore anybody else can be bought".

      If Oracle is willing to buy 20 developers at $1 billion each, then he may be right.

      That would only lead to 20 million developers starting to learn the PostgreSQL code base, hoping to get a billion dollars as well. Developers can be replaced (not easily, but they can be).

      Sun bought MySQL (and Oracle Sun) for the control, via the assigned copyright, of the sourcecode, and of the support structure. MySQL the company has always done everything it can to keep control over the MySQL product, making the GPL license just a part of a distribution model. A lot needs to be rebuild in organizing the development process, in building a support structure, etc, to make one of the forks a relevant choice commercially. It's not impossible, but the advantages MySQL the company had over competitors in this are what made it worth $1 billion. The developers are a part of this, but far from the whole picture.

    6. Re:Widenius please move on... by unix_geek_512 · · Score: 2, Interesting

      Ladies and Gents please stop unfairly attacking Widenius, as TheRaven64 already mentioned, he absolutely positively did not get $1 billion for mysql he got about $16.6 million in 2008 which is nowhere near $1 billion. [ source wikipedia with 2 other sources providing confirmation ]

      The whole company was bought for $1 billion and a very small portion, reportedly about 12% or less of that went to Widenius and the other mysql founder.

      And keep in mind transactions like this are rarely done in cash and there are many strings attached to any stock they may have received in the deal.

      Because of this Widenius cannot buy mysql back from Sun or Oracle for $1 billion because he never got $1 billion and it is highly unlikely he could raise $1 billion to buy it back.

      It is obvious that the sale of mysql to Oracle would have major anti-trust implications no matter what side of the argument you're on.

      You may dislike Widenius and mysql and you're free to dislike them all you want but the fact is the entire community would be affected by the purchase if it goes through.

      Oracle could turn mysql into crippleware, they may go after all the users, they could kill it or do any number of things which would not be good for the community. Even if you forked mysql Oracle could shut you down any time since they already own all kinds of patents and the underlying engine.

      Like it or not, millions of websites and users depend on mysql one way or the other and migrating them all to prostgresql or any other DB would be a huge undertaking, especially if it's a forced migration.

      If the purchase goes through I would like to see mysql sold to an independent 3rd party or spun off so that Oracle does not end up with a virtual monopoly in that sector.

      A monopoly is not good for anyone.

      Note that I'm in no way advocating mysql should be given back to Widenius or anyone else, just that it become completely independent and receive a fair and reasonable license to use Oracle's engine and mutually cross-license the patents and other IP to resolve the justified anti-trust and monopoly concerns.

      That's pretty fair don't you think?

    7. Re:Widenius please move on... by turbidostato · · Score: 3, Insightful

      "there's nothing stopping these developers from giving $1m of this to pay for someone else to work full time on the project..."

      Except the non-competing clause in their contracts, of course.

      And of course too, Widenius has a point, a moot point but a point: buying out everyone that happens to compete with you is a tried and true strategy to get away competitors. It's only it is not a long time strategy against a strong and open market, it doesn't scale and it happens that open source projects with an open community backing them up (say, KDE, Debian... PostgreSQL) are the most resistant against such strategy.

      So yes, Monty has a point... whatever.

    8. Re:Widenius please move on... by koiransuklaa · · Score: 2, Informative

      None of your points are relevant...

      Of course Monty doesn't have the money to buy MySQL. It doesn't change the fact that he stayed completely silent on this until he got his millions. Maybe he only understood the problems of Oracle ownership then?

      If Oracle has patents they can use to kill MySQL, why on earth did they need to buy it first, and how would the situation improve if they were forced to sell it? That is an absurd idea.

      Of course monopoly is not good for the public. However, there is no monopoly here.

      Websites that were built on (non-gpl) mysql could be in trouble if Oracle wants to fuck them. That was the risk those websites took when they decided to go with a proprietary vendor. That would suck for them, but that's how proprietary software works.

      Users of GPL MySQL could be sightly inconvenienced: In the end a new community would still form around one of the forks. Again, for smart users selecting MySQL was a calculated risk of relying on a project with only one major developer.

      Did I forget anything?

    9. Re:Widenius please move on... by ThePhilips · · Score: 2, Insightful

      Of course Monty doesn't have the money to buy MySQL. It doesn't change the fact that he stayed completely silent on this until he got his millions. Maybe he only understood the problems of Oracle ownership then?

      He understood the problem long before. And he made an agreement with first investors (long before Sun deal) that MySQL, if sold, would be sold to a company which has more reasons to continue MySQL development than reasons to kill it. That's why Sun deal hadn't provoked his attention (and at the time he was only a member of MySQL board, not employed by MysQL AB anymore).

      After ownership of MySQL went to Sun, obviously the investors changed too. Initial investors understood the value of MySQL and to whom it can/not be sold. Now to Sun investors it's peanuts and they do not care. So they sold Sun to Oracle.

      And Monty, as responsible parent, had to speak up...

      With all the over-religious F/LOSS rhetoric, people forget that everybody needs a job. And, sorry, having Oracle as your main competitor, isn't very inspiring - good luck explaining to investors how you are NOT going to be squashed by Oracle aggressive sales department. I think many people do underestimate what Monty/etc did with MySQL and how much they have created - all that thanks to the proprietary fork of MySQL - while at the same time maintaining GPL fork too - to the extent now that MySQL blocks Sun-Oracle deal.

      Websites that were built on (non-gpl) mysql could be in trouble if Oracle wants to fuck them. That was the risk those websites took when they decided to go with a proprietary vendor. That would suck for them, but that's how proprietary software works.

      Not at all. Companies which supply 3rd party modules to MySQL are fucked - users are not affected by a slightest. (Commercial users can upgrade to GPL version anytime.)

      Oracle can't kill users - Oracle can kill all MySQL ISVs. Thanks to the fact that MySQL client libraries are covered by GPL (what apparently was a part of how Monty attracted first investors).

      Did I forget anything?

      Yes, you forgot to RTFA and also Monty blog. Knowing why other side does and says what it does and says is important. Unless of course you simply want to troll.

      --
      All hope abandon ye who enter here.
  2. Err... by Enry · · Score: 4, Insightful

    While buying out the top 20 developers (and I find it unlikely they could in the first place) wouldn't necessarily kill PostgreSQL, it would hamper development until the next 20 developers get up to speed with the code. Imagine what would happen if Microsoft were to buy out the top 20 Linux kernel developers - Linux wouldn't be dead, but it certainly would be stagnant for a while. There's also the real possibility of major changes, since the next group of developers would have a different way of doing things and different goals for the project.

    1. Re:Err... by jbwiv · · Score: 3, Insightful

      Um....there's over 70 committers to PostgreSQL. And even the top 20 work for a wide range of companies. Buying them out would be virtually impossible. PostgreSQL is an open source database done right, both technically and politically. You MySQL apologists simply refuse to acknowledge that you hitched your wagon to the wrong horse, even when your horse may be put down soon.

    2. Re:Err... by dfetter · · Score: 5, Insightful

      If somebody were willing to come up with a billion dollars in cash, they could buy the top 100 people in the PostgreSQL project, and that would cramp it severely for a couple of years.

      That said, Monty took VC money, which is basically legalized loan sharking. Taking VC money results, in the overwhelming majority of cases, in the complete screwing of the borrower. Monty was one of the lucky few who managed to get a fortune out of that situation, which makes his whining utterly unseemly.

      --
      What part of "A well regulated militia" do you not understand?
    3. Re:Err... by Kjella · · Score: 5, Insightful

      Um....there's over 70 committers to PostgreSQL. And even the top 20 work for a wide range of companies. Buying them out would be virtually impossible.

      And the whole concept seems to assume that there's a fixed pool of people. I'm guessing that if any of those companies lost their PostgreSQL guy, they'd be looking to hire another one and if it's anything like most open source software there's plenty unpaid or poorly paid people who'd love to take the position. Or with 10% unemployment, there would be soon enough if people knew they lacked developers. For that matter, I think it'd be hard to bury MySQL if just the entire community gathered on one fork and not a dozen.

      --
      Live today, because you never know what tomorrow brings
    4. Re:Err... by TheRaven64 · · Score: 4, Insightful

      Sun spent $1bn on MySQL. Spending the same amount of money on PostgreSQL would involve paying the top 20 developers $50m each not to work on PostgreSQL anymore (or to work on a proprietary fork of it). If I were offered that much not to work on a particular open source project, then I'd consider it quite seriously. For one thing I could pay someone else to work on the project full time while I did other things...

      The argument doesn't really make sense, because Oracle is vulnerable to the same tactic. What would happen if IBM offered even $1m to each of Oracle's top database programmers to quit? Would Oracle be able to survive? They'd have to hire a completely new team, but they'd probably manage it. The same is true of PostgreSQL (and other big hippyware projects). Most of the people who work on it are employed by companies which benefit from the project existing. If they all quit then these companies would hire other people to replace them. You'd see a little drop in productivity, but nothing permanent.

      --
      I am TheRaven on Soylent News
    5. Re:Err... by jadavis · · Score: 3, Interesting

      The argument doesn't really make sense, because Oracle is vulnerable to the same tactic. What would happen if IBM offered even $1m to each of Oracle's top database programmers to quit?

      That would cause a problem for any organization, of course. But both Oracle and PostgreSQL have established policies and lots of historical precedent that guide new developers and project leaders while they are getting up to speed and filling empty roles. For instance, what happens when a significant patch hits the pgsql-hackers list that implements a new feature? Discussion begins, and then it goes on a public commit-fest page (http://commitfest.postgresql.org). When the commitfest begins, everyone stops work on their own patches, reviewers get assigned to patches, and after it passes review then a committer reviews it again and potentially commits it.

      With policies like that in place, as a few developers are hired away it's much easier for new developers to take their place. You don't get lopsided efforts. How does postgresql find enough reviewers? Reviewing is that much fun? No. If you don't review at commit fest time, then your patch is either ignored or at the back of the line.

      What happens when a patch hits the mysql list from a random contributor? Well, we don't really know, because MySQL isn't really a community project. They only know how to get patches committed and releases out the door from within MySQL AB (and that could obviously be questioned as well, seeing how long they went without a release, and the problems that happened when they did release, like Monty saying it wasn't ready).

      It's much easier to cause major damage to a disorganized project like MySQL.

      I believe MariaDB and Drizzle are both attempting to establish a real community project (notice I didn't say "re-establish"). I hope they succeed for the sake of MySQL users. But new users would be wise to count on a real organization like the PostgreSQL Global Development Group and it's established policies (or Oracle, for that matter).

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    6. Re:Err... by ultranova · · Score: 2, Insightful

      If somebody were willing to come up with a billion dollars in cash, they could buy the top 100 people in the PostgreSQL project, and that would cramp it severely for a couple of years.

      If someone is willing to use a billion dollars in cash just to slow the development of a database program, they're unlikely to have a billion dollars to begin with.

      --

      Forget magic. Any technology distinguishable from divine power is insufficiently advanced.

  3. Stop quoting Monty by Anonymous Coward · · Score: 4, Insightful

    Please stop quoting Monty in slashdot stories, you're giving him a bigger platform for his comments than he deserves. He sold MySQL to Sun and then left Sun. That should be the end of the story. Now he's making sounds like a regular cry baby. Someone please tell him to get some balls and grow up.

  4. It would do fine by vanilla_face · · Score: 4, Interesting

    Postgres has a diverse group of contributors so it will be absolutely nothing like Oracle acquiring MySQL. Sure it would be temporarily damaging to the project if Oracle did go out and buy the leading contributors but I can't imagine that Oracle would get away with such predatory actions. FTR I believe that Oracle genuinely wants to use MySQL as s competitor to SQL Server in the bottom of the market.

  5. Why trust Sun? by argent · · Score: 5, Insightful

    This is precisely why people were concerned about letting ANY single company own it.

    Any company can be bought out.

    If a product can't be effectively forked, it's not completely open source.

    If a GPL fork of MySQL isn't good enough, then whose fault is that? And what does that mean for other dual-licensed GPL+Proprietary products?

    1. Re:Why trust Sun? by OverlordQ · · Score: 2, Interesting

      Any company can be bought out..

      No, not really. As pointed out one of those 'top 20' works at NTT. Lets compare revenues.

      NTT: $106.289 billion (2009)
      Oracle: $ 23.252 billion (2009)

      I think the buying out would go the other way.

      --
      Your hair look like poop, Bob! - Wanker.
    2. Re:Why trust Sun? by greg1104 · · Score: 3, Interesting

      At which point NTT would promptly hire/promote someone else into the same position with the same level of resources necessary to be effective. For example, in addition to committer Itagaki Takahiro, they also have some major work on replication being led by Masao Fujii. The point of having a big company like NTT involved is that you can't just make their need for PostgreSQL to be successful go away so easily. There's not just "that one NTT employee"--he's one of a whole team there doing PostgreSQL related work.

  6. And Monty Widenius knows about being bought! by Anonymous Coward · · Score: 5, Insightful

    no text necessary!

  7. Not even Oracle is evil enough to try this by atomic777 · · Score: 5, Insightful

    While he is technically correct that Oracle could just bribe the key developers to abandon pgsql, this would likely backfire.

    First, it assumes that the pgsql developers of importance can be bought. Our world is decadent, but not everyone has a price tag

    Second, seems Monty has been dealing with mysql code for too long. The pgsql code base (at least the parts I've seen) is significantly more pleasant to work with than MySQL's, and the sheer number of projects building off of it, commercial or OSS (due to BSD licence) are a testament to how accessible it is. Even if all of the current developers were to be bribed and stopped working on postgresql, there would be a significant incentive for other parties to step in and pick up the slack, given that postgresql has a sizable user base, and especially since it is now widely seen as the heir-apparent to mysql as the open-source rdbms of choice for your run-of-the-mill applications.

    Add on top of that the bad press from a failed attempt to use such questionable tactics, and I think not even Oracle is greedy or dumb enough to try anything.

    1. Re:Not even Oracle is evil enough to try this by Hurricane78 · · Score: 4, Insightful

      I agree. Hell, even PostgreSQL’s documentation is literally fun to read. It’s clean, it’s complete, it’s concise. Other projects should learn from them.

      --
      Any sufficiently advanced intelligence is indistinguishable from stupidity.
    2. Re:Not even Oracle is evil enough to try this by Anonymous Coward · · Score: 2, Insightful

      > First, it assumes that the pgsql developers of importance can be bought.

      No, first it assumes that Oracle has an interest in aquiring or stopping postgresql at all.

    3. Re:Not even Oracle is evil enough to try this by Blakey+Rat · · Score: 2, Insightful

      First, it assumes that the pgsql developers of importance can be bought.

      The biggest assumption is that Oracle wants to do this in the first place. Microsoft has SQL Server and IBM has DB2, neither of them have tried to buy out PostGRE... Sun's been around for decades and they've never tried it before...

      It's just fear-mongoring from Monty.

  8. Re:Let me say this as a developer, contributor, by Bill_the_Engineer · · Score: 5, Insightful

    if anything 'bad' happens to mysql, heads will roll.

    Probably yours...

    Widenius is only using scare tactics to try to get MySQL back after enjoying the profits from selling it in the first place.

    His constant whining will morph into a cautionary tale about using open source programs in a production environment.

    Phrases like "You don't get fired for buying from Oracle, Microsoft, or IBM" will return to the IT workplace and all the work open source developers did to enter the workplace will be set back several years.

    --
    These comments are my own and do not necessarily reflect the views or opinions of my employer or colleagues...
  9. A billion bucks... by RicardoGCE · · Score: 4, Funny

    ...sure makes some people whiny.

  10. Please name names by bogaboga · · Score: 3, Informative

    I would like to have a list of serious companies using PostgreSQL for serious stuff...and what stuff it is PostgreSQL is doing. In my world, all you hear is "...MySQL...MySQL...", even in cases where the back-end is being handled by PostgreSQL.

    Our three major DBs have about 13.4 million records combined, with enormous amounts of data about clients. PostgreSQL has never failed us. I work in the insurance business.

    1. Re:Please name names by greg1104 · · Score: 5, Informative

      I would like to have a list of serious companies using PostgreSQL for serious stuff

      PostgreSQL Featured Users; Quotes has additional detail about the scope of some of those. Most people are probably familiar with names like Skype and Cisco on there, but less well known companies like NTT are huge too--and they even sponsor a good chunk of PostgreSQL development because it's so heavily used there.

      And those are just the public record. Because of its BSD license, PostgreSQL also gets used in plenty of places that don't talk about what they're doing with it. For example, I've worked with financial companies that are cutting loose Oracle for PostgreSQL whenever feasible, and with some US defense companies that use PostGIS for geographic databases. (looks out window) I may have already said too much.

    2. Re:Please name names by gbjbaanb · · Score: 4, Interesting

      It'll be difficult to say who's using it because they download it, try it, run it.. all quietly without fuss. No-one at PostgreSQL website can say who's using the downloads because there's no licensing or even a 'email to get your registration' type stuff going on.

      I can tell you that 3 large UK emergency service centres (the 911 callcentres) use PostgreSQL for handling the incoming 999 calls. Its been used for some time now and we've not had a major failure (I don't think we've had a single failure of any type come to that).

      Taking calls for the emergency services is as serious as you can get. It's even more serious if you're the one who wants an ambulance!

    3. Re:Please name names by maroberts · · Score: 2, Informative

      I'm working for a major European bank; we use PostgresSQL for most of our data aggregation and analysis. I'm really a long term MySQL user, but haven't found any problems doing the same stuff with a different database

      --

      Donte Alistair Anderson Roberts - hi son!
      Karma: Chameleon

    4. Re:Please name names by Toze · · Score: 3, Informative

      For them as don't RTFL, the Featured Users include IMDB.com, SourceForge, Safeway, and Skype.

      --
      No OS on the planet can protect itself from a user with the admin password. - Yvan256
    5. Re:Please name names by mcrbids · · Score: 4, Informative

      It'll be difficult to say who's using it because they download it, try it, run it.. all quietly without fuss. No-one at PostgreSQL website can say who's using the downloads because there's no licensing or even a 'email to get your registration' type stuff going on.

      We started with yum -y install postgresql-server and now, hundreds of busy clients later and a few updates later, Postgresql is still going stronger than ever...

      And seriously, Postgres is the overachieving underdog of the database world. It has it all - replication, data integrity, legendarily stunning stability, MVCC, foreign keys, triggers, PLPGSQL, subselects, indexes, query scheduling, parameterized statements, DDBC, metatables, cross-database joins... I could go on, and on, and on. It holds up very nicely when Its security
      model is excellent. Its organizational model is stable. It holds up well under very demanding loads and just basically doesn't crash. (In a decade of using it every single business day, I've NEVER HAD an instance of Postgres corrupt running on a RedHat/CentOS server) It costs nothing, it's available by default on any RedHat install CD, and most other distros.

      If Oracle is scared, they should be scared of PostgreSQL, and if you're looking to database something, you should strongly consider Postgres!

      --
      I have no problem with your religion until you decide it's reason to deprive others of the truth.
    6. Re:Please name names by slick_rick · · Score: 5, Funny

      I happen to know that right after the Columbia accident, all the telemetry data was loaded into a PG database and that is what was used for analysis. At one point tracking the entire .org domain was done with PG as well. I've always thought of MySQL as a racehorse, no other horses can compete for speed when running around a short track (IE read-mostly website). PG is more of a draft horse, able to plow the fields, or pull the wagon, or do a million other things that MySQL is not appropriate for. Oracle would be an Elephant, too huge and expensive to maintain for most things while SQL Server would be a mule, a hopefully sterile off-breed of a horse (Sybase) and a donkey (Windows).

      --
      apt-get install redhat please god - Me (take it easy, I love Debian)
    7. Re:Please name names by shutdown+-p+now · · Score: 2, Insightful

      It does have developer mindshare, it just doesn't have PHP developer mindshare.

      Then again, PHP and MySQL are a match made in heaven - both underfeatured and broadly outdated, but immensely popular because of (often misleading) marketing, and mostly just being in the right place at the right time.

      They're also alike in that, if we could get rid of both, and have, say, Linux+Apache+Python+Postgres, that would make the lives of many developers and admins easier, and the world just a little bit better.

  11. Sod Off Monty by segedunum · · Score: 3, Interesting

    I'm getting fed up to the back teeth with this guy. He must have got himself into some mental issues he can't get out of. He had a dual licensed database server in MySQL that brought in good money and had a side-effect of making it the standard database as the web expanded, which he then sold to Sun for a very tidy sum and he still now expects to be able to control MySQL's future?

    Before Sun bought MySQL Sun was heavily involved with Postgres (still is in many ways) and they could have quite easily tried to take that project over as opposed to buying MySQL. They didn't, and they would have found that very difficult because there are a lot of different interests in Postgres now.

  12. Re:Firebird by gmack · · Score: 4, Informative

    You forgot SQLite. It's small and good enough for most of what MySQL gets used for: simple web forms, stat counters etc.

  13. Join! by Goglu · · Score: 4, Funny

    Maybe, just to ensure that this can't happen, he should join the PostgreSQL project and become a top contributor...

  14. EnterpriseDB by ascari · · Score: 2, Informative

    EnterpriseDB is a company that offers commercial support for PostgresQL. They have salaried people on staff that contribute to the project, much like IBM, RedHat etc. contribute to the Linux kernel. So I would say Monty's scenario is about as likely as Linux going away by Microsoft or Apple paying off the to 20 kernel developers. Some people just don't get how open source works.

  15. Re:Let me say this as a developer, contributor, by Anonymous Coward · · Score: 3, Interesting

    That is a very good point indeed. mysql was the cat's meow in the internet's early days; everybody was doing a web portal and mysql is fast as hell with simple lookups. Just the ticket. Now even databases that were supposed to stay simple are morphing into who knows what. mysql's engine still can't even do transactions and they own nobody whose plugin can. Even if they're not a target they'll always be weak in their market no matter how popular they are. Postgresql (for example) has always kicked mysql's butt in real database work, and now that it has pretty much closed the speed gap in the simple things there's no need to chase mysql anymore. They're after bigger game: Full SQL compliance and Oracle. And there's other OS DBs out there doing fabulous work as well.

    Personally, mysql served me well back in the day but I've moved on to new tools for new needs. Unless thay can actually own a modern engine rather than begging one I think mysql should remain as it is; sort of a bug in the amber of simpler times.

  16. Re:It is not a ridiculous claim by jocknerd · · Score: 2, Interesting

    PostgreSQL languished from 1993-1996. Then the developers who looked at the code decided it was best to rewrite everything from scratch. This slowdown in development is why MySQL became more popular in the late 1990's. Plus, it was the database used in almost PHP book published. PostgreSQL in the late 1990's through early 2000's had a very solid codebase but very little work had been done on it from a performance perspective. Work throughout the 2000's has improved the performance tremendously and now the core team is focusing on bring replication to it natively.

  17. Re:Firebird by davecb · · Score: 3, Insightful

    He's just pushing a straw-man argument, having unwisely made it for MySQL, and after embaressingly being caught twisting RMS's words (see groklaw, http://www.groklaw.net/article.php?story=20100108114314405).

    I fear he's strictly in this for himself and his friends, a certain well-know monopolist with a "Codeplex" Foundation...

    Bother! I wanted this to be over months ago, so I could get more consulting from Sun's (Now Oracle's) customers.

    --dave

    --
    davecb@spamcop.net
  18. Stallman also challenges Widenius by toby · · Score: 4, Informative

    Richard Stallman has clarified that he believes the GPL is necessary and sufficient protection for MySQL, in direct contradiction to Widenius' call that the license should be changed and copyrights rest in some entity other than Oracle.

    Stallman: One thing that makes no sense at all is the idea of changing the license of MySQL to something non-copyleft. That would eliminate the possibility of selling exceptions, but allow all sorts of proprietary modified versions. Wherever MySQL should go, it isn't there.

    Eben Moglen and the Software Freedom Law Center defend the GPL even more strongly:

    "The GPL was designed specifically to ensure the permanent freedom of software, and the ability of everyone to improve and share their improvements to the program, no matter who acquires the copyrights to the code," Moglen said of the argument he presented to the Commission. "The whole point of GPL as a copyright license is to deal with every contingency that could result in hobbling or destroying the freedom of code shared under it. The drafters of GPL versions 2 and 3 considered scenarios very similar to the ones that the Commission is concerned about now. The design of the license, and the experience we have had using it, show that it can be counted upon to operate as intended in situations like this one."

    Programs released under the GPL, including Linux, Samba, and the GNU Compiler Collection, have continually proven to be resistant to anti-competitive conduct in the marketplace. "GPL’d programs competing effectively against offerings of the richest and most powerful monopoly in the history of information technology have resisted the efforts of the monopolist to find a chink in its armor," Moglen writes.

    --
    you had me at #!
  19. Some people don't do money for the money by weston · · Score: 4, Insightful

    Some people don't do it for the money. You can't buy them. Ever.

    I don't know. I mean, I know what you're talking about: I've turned down a well-paying job with equity that would have set me up pretty good because I felt there was something more important than the money.

    But here's the thing: at a certain level, once people offer you enough money (the mark starts somewhere around a million bucks) they're not just offering you money anymore, they're offering you freedom to do whatever you'd like to with your time. If the top 20 Postgres devs would rather do nothing else than work on Postgres, then you're right, this wouldn't happen. But if enough of them have other interests, then it's entirely possible someone could buy their non-participation -- with the ability to spend all the time they like on something else.

  20. SQLite is for local storage by toby · · Score: 4, Informative

    It's not a multiuser database.

    A web site is a classic multiuser scenario for an RDBMS; you have to have concurrency issues completely nailed down (ideally with row level locking and ACID).

    It's also MySQL's sweet spot.

    --
    you had me at #!
    1. Re:SQLite is for local storage by toby · · Score: 2, Informative

      Trac also allows other RDBMS back-ends. If you had a highly loaded site (for example, a popular public project) you would not pick SQLite for the reasons I mentioned. In particular, it does not implement MVCC or row locking. Locking is coarse grained (like MyISAM) which soon limits scalability.

      Yes, SQLite's basic locking is good enough for light demands (say internal company intranet), and I am happy to use Trac+SQLite myself in these situations. I suppose if you know your site won't ever be popular, and assuming you don't need any of the other features offered by the major systems, you could get away with it for the basic stuff gmack mentioned :)

      --
      you had me at #!
    2. Re:SQLite is for local storage by TheRaven64 · · Score: 3, Interesting

      SQLite is not a multi-user database, but a web app is a single user. It does support arbitrary numbers of concurrent reads and in relatively recent versions supports concurrent writes, although the locking is not quite row granularity. Most web apps are very read-heavy, and this is where SQLite shines. Consider something like Slashdot. Loading this page required me to read over a hundred comments from the db. Each of the times I expand a hidden comment, an AJAX request handler performs another db read. I only need to write to the db when I post something (well, there may be some logging stuff, but I'm still reading a lot more than I'm writing).

      For a lot of web sites, concurrent read speed is the bottleneck, and SQLite performs better than MySQL for concurrent reads by quite a large margin.

      --
      I am TheRaven on Soylent News
    3. Re:SQLite is for local storage by PCM2 · · Score: 2, Interesting

      I don't know, but that also wasn't my point. My point was that he was claiming MySQL doesn't scale to a lot of users. Last I heard, Slashdot had a lot of users -- and it runs on MySQL.

      --
      Breakfast served all day!
    4. Re:SQLite is for local storage by greg1104 · · Score: 2, Insightful

      you have to have concurrency issues completely nailed down (ideally with row level locking and ACID).

      Even row-level locking ends up being a scalability issue eventually. This is why PostgreSQL uses MVCC for transaction isolation by default instead, which is one of the reasons it can scale upward well for some types of workloads.

  21. I had the privilege... by Toze · · Score: 5, Insightful
    of speaking with Monty on freenode's mysql channel, when he responded to my suggestion that he needed a helmet and a big cup of STFU. I asked him about forking and MariaDB, and he had pretty much the same response as in the blog linked above. The way he talked about open source, though, it was like he thought it was impossible for a large open-source project to succeed without a strong leader. He expressed little trust in the community, and no faith that an abandoned project could be picked up again. When I asked him about developers scratching itches, and solutions drawing users and more developers, he didn't seem to think it was a feasible solution. He kept defending his posts about Oracle as being about "for the users," and his motivation being to maintain choices.

    I think the problem is less about Monty wailing about Oracle's calumny, and more about Monty's view of how FOSS works. He seems to think it needs heroes, and that the rest of us plebes need someone to follow before we can get anything useful done. I'll agree with him that projects need leadership, but like comments above have said, there's a difference between project leadership and making yourself indispensable. If Monty was indispensable when he left MySQL, then he was the one that killed it, not Sun, and not Oracle.

    --
    No OS on the planet can protect itself from a user with the admin password. - Yvan256
  22. I doubt that oracle will do that by WindBourne · · Score: 2, Interesting

    If so, I suspect that the psql team will nullify a number of those patents with prior art. Long before Oracle 9/10's move into OO, Postgres was there.

    Also, once Oracle creates that kind of ill will, how fast will MS move MS-SQL to Linux/Unix? It would happen within 3 months. They would KILL to have all those OSS coders switch DBs.

    Finally, Oracle will not go after Postgres with patents. Right now, postgres has many similarities to Oracle. As such, it is increasingly being used for lower end work, and then projects move to Oracle. Basically, Oracle sees it as a feeder project. Personally, I would stick with Postgres for all bu the top demand projects.

    --
    I prefer the "u" in honour as it seems to be missing these days.
  23. Monty's just a greedy troll ... by tomhudson · · Score: 2, Insightful

    can easily squash PostgreSQL by just 'buying out' the top 20 developers

    ... like Sun quashed MySQL when Monty "sold out" ... oh, wait, it's still around ...

    what a troll - and that was lying about what Stallman said

    Can we get him put on some terr'rist list or something?

  24. The PostgreSQL project already ran that gauntlet by EbNo · · Score: 5, Interesting

    I once worked for a company called Great Bridge, which attempted to make money selling a boxed version of PostgreSQL. We employed/contracted with several key PostgreSQL developers, and I distinctly remember discussions with management and at least one of those developers about this very topic. The developers had agreed amongst themselves and with Great Bridge management to limit the number of key committers who took money from Great Bridge in order to ensure the company didn't exert too much control over the project (I'm sure we would have been happy to have every one of them on the payroll). History proves Monty wrong on this one.

  25. Re:Sour grapes? by siDDis · · Score: 4, Informative

    What? The open source replication alternatives are good enough

    You have:
            * PGCluster
            * Slony-I
            * DBBalancer
            * pgpool
            * PostgreSQL table comparator
            * SkyTools
            * Sequoia
            * Bucardo
            * Mammoth Replicator
            * Cybercluster
            * GridSQL (shared-nothing)

    All are open source and some even offer additional commercial support.

  26. Re:Monty: Biased and not open for reason by NormalVisual · · Score: 2, Insightful

    From my perspective, it's not about "selling out". Given the offer of that kind of money, I'd have had tar'd the repo up and personally delivered it to Sun within the hour in a set of gilded DVD cases, and I won't begrudge anyone that same choice either. What *is* annoying is the whole "I want to eat my cake and have it too" whining that Monty has been expressing through this whole thing.

    --
    Please stand clear of the doors, por favor mantenganse alejado de las puertas
  27. Re:It is not a ridiculous claim by stox · · Score: 2, Informative

    PostgreSQL did not exist in 1993-1995. It was Postgres, and Postgres95 in that timeframe. It had its own query language. It was re-written to use SQL, and then became PostgreSQL.

    --
    "To those who are overly cautious, everything is impossible. "
  28. Re: Yep, I don't know why people forget about it. by HiThere · · Score: 3, Interesting

    Every time I've gone looking for information on how to use FireBird with my favourite language (which changes frequently) I've come away unsatisfied. So I've gone with something that was easier to figure out how to use.

    That's a part of why FireBird gets ignored. It was sort of like what Linux was in the late 90's. Probably quite capable, but the documentation seemed to assume that you knew someone to coach you over the undocumented spots. Or that you were familiar with something sufficiently similar. Over the last decade Linux has backfilled, but FireBird hasn't. In fact it seems to have retrogressed, just based upon the last time I considered using it. (I didn't want to use SQLite because I wanted a system that let me use integer keys, and the SQLite interface to the language I was then using didn't. But I wanted a DB that would allow me to pick the file I was using as my database and store it locally with the program. FireBird would seem to have been ideal...but I couldn't easily figure out hot to use it, so I used something else. [I think that time I packed the integers into byte strings with each byte using only 7 bits.])

    --

    I think we've pushed this "anyone can grow up to be president" thing too far.
  29. Whatever! by Blakey+Rat · · Score: 2, Funny

    Whatever!

    The point is received gobs of money and now he's whining like a toddler. I think everybody's fucking sick of it by now.

    If he signed a bad deal, THAT IS HIS FAULT AND HE SHOULD FUCKING COPE WITH IT LIKE AN ADULT! And stop spamming up this, and other, forums with his bullshit whining.

  30. Re:Firebird by shutdown+-p+now · · Score: 2, Informative

    I've last used Firebird about two years ago, so this may not be true anymore... but anyway. I've had two major problems with it.

    First is documentation. There's no single place to go for it. Effectively you end up with the original Interbase manual, and then various bits and pieces which explain what was added/removed/changed, and you have to piece it all together by yourself (and there's no way to tell if you even have all the pieces in the first place). This applies to admin docs, SQL reference, and language API references.

    Speaking of which, we come to the second point: API bindings are rather messy (the C one, at least). Much more so than SQLite API, for example. Among other things, I recall it requiring things like (char*) casts back and forth to reinterpret data of appropriate types, and it seems to make a lot of assumptions about sizes of various C types, so its portability to more exotic architectures would be rather suspect.

    It also doesn't seem to be nearly as feature-rich as PostgreSQL. The core is solid, but e.g. standard function set is rather minimalist, and you end up rolling out your own for many occasions.

    That said, Firebird/Embedded is a very nice database specifically for embedding, small and yet full-featured. If you ever missed things such as stored procedures in SQLite (and they actually make quite a lot of sense specifically for embedded DBs, where DB is tightly coupled to the application anyway), I would advise to look at FB/E.

  31. Re:I would switch to postgresSQL in a heartbeat by MadCat · · Score: 2, Informative

    It is in fact easy to set up and maintain -- it just requires a bit more thinking, mostly to get the authentication and such things working right, but that's a matter of editing a config file. Maintenance wise, PostgreSQL doesn't need much of that, the occasional vacuum and that's it. With auto-vacuum enabled, even that is taken care of.

    I used MySQL a lot in the past, and ended up going to PostgreSQL around version 7.3, because I needed the triggers and the views. Never looked back to MySQL, PG might be slower at certain things, but at least I don't end up getting a call at 3am in the morning in the weekend informing me the database crapped itself up again, only to have to wait for myisamchk to go through near 20Gb of data.

    Give it a shot and you will be enlightened :)

    --
    There is no sig...
  32. Re:I hope Oracle tries by ThePhilips · · Score: 2, Interesting

    Because it allows people behind pg to -on one side- give you for free a half-baked RDBMS but -on another side- ask money for the tools/etc to make it usable.

    That what BSD license allows. And in past it was practiced by PostgreSQL core team most of whom were employed by the company which was offering all the extras to PosgreSQL.

    But that is not per se BSD license weakness - it was pg business model in the past. It kind of feels f***ed up when somebody offers a patch but it gets rejected by pg core because it competes with their commercial offering.

    That is btw explanation why pg has much lower visibility compared to MySQL. MySQL was much more open and Monty/etc were investing their time to reimplement -instead of rejecting- into their proprietary fork what OSS community was contributing to GPL'ed MySQL.

    --
    All hope abandon ye who enter here.