Slashdot Mirror


Sun May Begin Close Sourcing MySQL Features

An anonymous reader writes "From the MySQL User's Conference, Sun has announced, and former CEO Marten Mickos has confirmed, that Sun will be close sourcing sections of the MySQL code base. Sun will begin with close sourcing the backup solutions to MySQL, and will continue with more advanced features. With Oracle owning Innodb, and it being GPL, does this mean that MySQL will be removing it to introduce these features? Sun has had a very poor history of actually open sourcing anything."

509 comments

  1. This is great news.... by poet · · Score: 5, Insightful

    For PostgreSQL :) http://www.postgresql.org/

    Would you like another round of ammo with that foot gun Sun?

    --
    Get your PostgreSQL here: http://www.commandprompt.com/
    1. Re:This is great news.... by Daniel+Dvorkin · · Score: 5, Insightful

      I used to be one of MySQL's vociferous defenders, arguing that speed, ease of use, quality of documentation, and the size of the community made up for its limitations relative to PostgreSQL. But this is pretty much the end. Sun is clearly determined to destroy whatever's good about it. For small, lightweight projects, SQLite is the way to go, and for anything bigger, PostgreSQL is now the clear choice. I guess it's time to see if PostgreSQL's documentation and tools have managed to get any less user-hostile over the years.

      The one remaining question is mindshare. For example, pretty much every ISP offers MySQL as part of a basic hosting package. No one's saying they have to stop doing that, but are they going to start offering other open source DBMSs in the same way now? I sure hope so.

      --
      The correlation between ignorance of statistics and using "correlation is not causation" as an argument is close to 1.
    2. Re:This is great news.... by Poromenos1 · · Score: 1

      Close sourcing is never good news for anyone...

      --
      Send email from the afterlife! Write your e-will at Dead Man's Switch.
    3. Re:This is great news.... by K.+S.+Kyosuke · · Score: 3, Interesting

      And for Firebird (http://www.firebirdsql.org) as well. :) I am going to celebrate! (Or maybe it is that Sun bought MySQL just to sweep in under the carpet so that it will not spoil their PostgreSQL interests? Probably not, but it's a funny idea nevertheless. ;-))

      --
      Ezekiel 23:20
    4. Re:This is great news.... by Anonymous Coward · · Score: 0

      Looks like I'm going to have to finally bite the bullet and play with Postgre. Was nice knowing you MySQL. (Disclaimer: I didn't rtfa, and since this is /. the summary is probably pretty sensationalist)

    5. Re:This is great news.... by Anonymous Coward · · Score: 5, Funny

      Close sourcing is never good news for anyone...
      Tell that to the Chinese. We lost our manufacturing base to them. They source all of our close we wear nowadays.
    6. Re:This is great news.... by MadnessASAP · · Score: 5, Funny
      Even nicer PostreSQL has an animal mascot, I can see the jokes now: A Penguin, Indian and Elephant walk into a bar...

      We even still get a pronounceable acronym LAPP. It looks like the future is still rosy for the rest of us.

      --
      I may agree with what you say, but I will defend to the death your right to face the consequences of saying it.
    7. Re:This is great news.... by SL+Baur · · Score: 3, Informative

      Yes, it's sensationalistic. They will be close sourcing portions of the source, but not the database core itself. The only piece mentioned in TFA is the online backup utility.

      I've never understood the reluctance towards PostgreSQL. It's been quite good for quite a long time now.

    8. Re:This is great news.... by niteice · · Score: 1

      -1, terrible pun

      --
      ROMANES EUNT DOMUS
    9. Re:This is great news.... by Anonymous Coward · · Score: 0

      Someone really needs to make a web app, say something like a content management system or the like, called "Dance". LAPP Dance FTW!

    10. Re:This is great news.... by sticks_us · · Score: 4, Interesting

      I guess it's time to see if PostgreSQL's documentation and tools have managed to get any less user-hostile over the years.

      I've been using PostgreSQL on-and-off for about 7 years now, and I have to say: it's *all* gotten a lot better.

      In fact, feel free to check out (I think it's on Safari) how slick things have gotten, try Korry Douglas' book (forgot the title right now). I think it's a stellar example of book writing in general, and does a very good job of explaining a lot of the advanced features (like clustering, failover, etc).

      I won't miss MySQL one bit--PG rules!

      --
      "Beware of bugs in the above code; I have only proved it correct, not tried it." -- Donald Knuth
    11. Re:This is great news.... by Registered+Coward+v2 · · Score: 5, Insightful

      For PostgreSQL :) http://www.postgresql.org/

      Would you like another round of ammo with that foot gun Sun? From the pSQL web page:

      Best of all, PostgreSQL's source code is available under the most liberal open source license: the BSD license. This license gives you the freedom to use, modify and distribute PostgreSQL in any form you like, open or closed source. Any modifications, enhancements, or changes you make are yours to do with as you please. As such, PostgreSQL is not only a powerful database system capable of running the enterprise, it is a development platform upon which to develop in-house, web, or commercial software products that require a capable RDBMS.

      That seems to be the same thing Sun is saying - we're going to add some closed source features to MySQL; the same as pSQL's license allows.
      --
      I'm a consultant - I convert gibberish into cash-flow.
    12. Re:This is great news.... by Anonymous Coward · · Score: 0

      What would be interesting is if the many open source CMS/blog/forum packages start providing better support for PostgreSQL, and if more shared hosting services start offering it.

      It's kind of a chicken or the egg type problem for PostgreSQL. They'll start seeing better CMS support when more hosts offer it, hosts won't offer it if more people don't use it, and more people won't use it until it gets better CMS support.

    13. Re:This is great news.... by X0563511 · · Score: 1

      Maybe it's just because I'm not your average bear... but (as a complete DB newbie) I had no trouble discovering and understanding the point of that "su postgres" step. I like the idea that the database is unusable until I say otherwise.

      --
      For large sets, this will be our guide even unto death, for the LORD will work for each type of data it is applied to...
    14. Re:This is great news.... by Anonymous Coward · · Score: 0

      What more can you expect from a clothes horse?

    15. Re:This is great news.... by CastrTroy · · Score: 2, Informative

      Works much better than MS's famous "the default sa password is empty string".

      --

      Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
    16. Re:This is great news.... by Anonymous Coward · · Score: 0

      The Good and Great Must Ever Shun
      That Reckless and Abandoned One
      Who Stoops to Perpetrate a Pun

    17. Re:This is great news.... by Cecil · · Score: 5, Informative

      Having a good bit of experience with both, I'd say that the documentation and overall support structure for PG is about the same as MySQL these days.

      The only caveat that typically hangs up new users (especially ones coming from a MySQL background) and is not particularly clearly documented is the default authentication mechanism.

      By default (at least on many distributions), Postgres uses "ident" authentication, which means no password is required for database logins on a local socket. What *is* required, on the other hand, is that you must be logged in/running as the UNIX user of same name. Obviously this poses problems for webapps that want their own database user and is generally just very confusing for users who are used to the database having its own independent set of usernames and passwords (which Postgres still does, for remote connections... causing further confusion)

      Of course, like any good database Postgres will be more than happy to handle its own user authentication entirely natively, you simply have to use md5 instead of ident in pg_hba.conf

    18. Re:This is great news.... by X0563511 · · Score: 1

      We are using the MS SQL enterprise manager in class (database security) and it bothers me that all this is going on and I really don't have much of a clue what it is doing. I recognize that I'm unusual in that I'd rather spend an assload of time doing it all myself with the documentation and know what is done.

      --
      For large sets, this will be our guide even unto death, for the LORD will work for each type of data it is applied to...
    19. Re:This is great news.... by _KiTA_ · · Score: 2, Insightful

      simply put, it's harder for a person new to databases to jump into. MySQL kinda holds your hand with phpmyadmin and it's other admin tools. PG has pgadmin (but not as featureful) and by default installs where you can't access the DB until you su as the postres user and give out permissions. Are they *trying* to make things hard?? So... if they're both open source, why not just port phpmyadmin to PG? Would it really be that hard?
    20. Re:This is great news.... by rainhill · · Score: 5, Interesting

      Guy n Gals.. Lets just fork the thing.., then we can call it iSQL

    21. Re:This is great news.... by EvilIdler · · Score: 2, Insightful

      The current maintainers of Postgres still release new source to the public. Sun intends to hold back some.
      I don't mind some proprietary software, but open source software which suddenly turns proprietary is
      downright uncool. No MySQL on my dinky little servers; PG all the way.

    22. Re:This is great news.... by SL+Baur · · Score: 1

      Don't get me wrong though, I love postgres. I learned it and mysql before I graduated college. However, once in the working world I learned SQL Server, and it's tools (especially the 2005 SQL management studio) make it far more attractive because it's just plain easier to use. I was introduced to RDBMS programming (Ingres, Omnibase and later Sybase) at work about a decade before I introduced myself to PostgreSQL.

      PostgreSQL lends itself well to programming. I wrote the XEmacs Lisp bindings to its pgsql programming interface. Database programming in Lisp really rocks. I don't know how they could make it any easier. A superb programming library (pgsql), conformance to standards (I always used a trade SQL book when I needed a language reference) and good performance (sometimes needing some tuning, but they had builtin tools to help you with that).
    23. Re:This is great news.... by Achromatic1978 · · Score: 1

      2000 called, they want your old meme back. That was eight years ago, you realize?

    24. Re:This is great news.... by smittyoneeach · · Score: 1, Flamebait

      ISTR that iSQL is the name of the command-line client for Sybase.
      How about SQOOLMy? (pronounced 'school me')
      Same letters as before, only with some leftover 'OO' pixie dust from the Clinton Administration mixed in.
      Just no way to work XML in there while remaining mellifluous, alas.

      --
      Get thee glass eyes, and, like a scurvy politician, seem to see things thou dost not.--King Lear
    25. Re:This is great news.... by LiENUS · · Score: 1

      Me personally... I'm hoping Firebird gets some of what sun is losing. Firebird is very easy to administrate, supports an embedded mode for windows applications where you don't even have to install a server (the entire process exists within a dll file) and features a very functional multi generational architecture. My Firebird installations tend to be forgotten about after the software is initially set up, because it is so easy to use and administrate.

    26. Re:This is great news.... by rainhill · · Score: 1

      This is great news for PostgreSQL completely agreed.. this news basically means to me that MySQL development will slow down
    27. Re:This is great news.... by osu-neko · · Score: 2, Interesting

      Thanks for that. I switched from PostgreSQL to MySQL in 2001 due to some problems I was having at the time, and haven't looked at it since. For a few years I would explain why I thought MySQL was better, but in the last few years I've just pleaded ignorance when asked, since my reason now for using MySQL is just that I've been using it for years and it's what I'm familiar with and had no compelling reason to change. But with this happening, and knowing that PostgreSQL has improved since I last looked at it... looks like it's time to take a fresh look at PostgreSQL.

      --
      "Convictions are more dangerous enemies of truth than lies."
    28. Re:This is great news.... by Anonymous Coward · · Score: 0

      That seems to be the same thing Sun is saying - we're going to add some closed source features to MySQL; the same as pSQL's license allows. Well, the PostgreSQL licence is not really exactly the same as what Sun are doing.

      PostgreSQL allows for ANYONE to redistribute its database, open or closed. That doesn't mean that the source code that you receive from the PostgreSQL website is closed source.

      Sun (who own MySQL AB, the company who created MySQL), are releasing portions of it's database as closed source. That effectively means that user contribution to certain parts of the standard MySQL database is not possible.

      Either way, this is good news, PostgreSQL is a great database that deserves to have a larger user base.
    29. Re:This is great news.... by Orion+Blastar · · Score: 2, Interesting

      Yeah I've always seen PostgreSQL as an open source version of Oracle because both of them support PL/SQL. PostgreSQL may not be as good as Oracle is, but it is good enough for most projects that it doesn't have to be. Much better than MySQL anyway.

      I sort of seen MySQL as only being partly finished and more like an open source version of SyBase but without stored procedures and triggers, etc, unless they recently added them and I didn't know it. MySQL was usually good enough for most small projects and web sites and when you needed to upgrade the database to advanced features you went to PostgreSQL or Oracle or even, shudder MS-SQL Server or Sybase. Of course there is always Firebird the open source version of the old Borland Innerbase which became the Inprise database and Inprise company after Borland made changes but the database dates way back to 1981. I think that Firebird can replace MySQL for an open source database if people give it the chance. I think they just got a Mac OSX 32 bit version and are working on the 64 bit Mac OSX version. It exists for many variations of Unix, as well as Windows. Under Vista you have to disable the control panel or else it breaks Vista's control panel but they are working on fixing that. The Flamerobin GUI is in alpha but it is being worked on as well. MySQL happened to be in the right place at the right time and got the web standard before Firebird did, but now that MySQL is starting to go closed source, Firebird is looking better as an alternative to MySQL. Instead of LAMP we might get LAFP some day or maybe LAPP with PostgreSQL replacing MySQL.

      --
      Remember, Slashdot does not have a -1 disagree moderation, and no, troll, flamebait, and overrated are not substitutes.
    30. Re:This is great news.... by penix1 · · Score: 5, Informative

      Just one line for you...

      http://phppgadmin.sourceforge.net/

      --
      This is a sig. This is only a sig. Had this been an actual sig you would have been informed where to tune for more sigs.
    31. Re:This is great news.... by CastrTroy · · Score: 2, Insightful

      It was the only version of SQL server available until 2005 came out, only 3 year ago. And even then, many companies are still using SQL server 2000.

      --

      Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
    32. Re:This is great news.... by Sancho · · Score: 5, Funny

      Eh, Linux is ok on the desktop, but for servers, I really prefer FreeBSD.

      Sometimes I get tired of that, and use NetBSD for a while. A short stint with NetBSD, Apache, Postgresql, and PHP usually refreshes me long enough so that I can FreeBSD, Apache, Postgresql, and PHP again.

    33. Re:This is great news.... by Registered+Coward+v2 · · Score: 1

      The current maintainers of Postgres still release new source to the public. Sun intends to hold back some.
      I don't mind some proprietary software, but open source software which suddenly turns proprietary is
      downright uncool. No MySQL on my dinky little servers; PG all the way. Perhaps the maintainers do; but that does not mean everyone that makes and distributes changes has to make the code available, according to the PG license.

      While I share your sentiments there appears to be nothing that prevenst a PG developer form doing exactly what Sun is; in fact the PG sourceforge page trumpets that as a good feature of the BSD license.
      --
      I'm a consultant - I convert gibberish into cash-flow.
    34. Re:This is great news.... by jedidiah · · Score: 2, Insightful

      No, it's not "sensationalistic". It's one of those things that helps
      confirms the fact that mySQL isn't some place to keep your data if
      you are serious about protecting it. Backing your database without
      causing a total outtage is not a "minor or peripheral" feature.
      Neither is the ability to recover all transactions that have occured
      between your last backup and the point of your "disaster".

      Sun is intentionally hamstringing the libre version of mySQL with this
      sort of shenanigan.

      It's time to fork.

      --
      A Pirate and a Puritan look the same on a balance sheet.
    35. Re:This is great news.... by mindsuck · · Score: 2, Funny

      Eh, Linux is ok on the desktop, but for servers, I really prefer FreeBSD. Sometimes I get tired of that, and use NetBSD for a while. A short stint with NetBSD, Apache, Postgresql, and PHP usually refreshes me long enough so that I can FreeBSD, Apache, Postgresql, and PHP again. So, you FAPP, NAPP and then FAPP again?
      --
      --- I w00t, therefore I'm l33t.
    36. Re:This is great news.... by DAldredge · · Score: 1

      True. Because backups aren't an important mission critical portion of database work. I mean they could have closed off access to something really important.

    37. Re:This is great news.... by Sancho · · Score: 5, Funny

      That would be the joke, but I was going for a touch more subtlety.

    38. Re:This is great news.... by debrain · · Score: 3, Informative

      I'm very happy to concur. I just tried to put triggers on MySQL databases, admittedly a relatively new feature for the little database that could, and it was a nightmare to manage them. phpMySql didn't have any interface to it, nor did any of the other tools for Mac OS X (which I'm using primarily). I'm not averse to the command line, but there are times when it's just nicer to have a visual interface. I've switched over to PostgreSQL, and its' web-management tool phpPgAdmin allows me to quickly view and edit triggers and many other nuances to my heart's content. Further, the documentation answered all of my questions in very short order.

      I'm sincerely impressed with what PostgreSQL has done. I hope they continue working, and hope they are never picked clean by those who "don't get it", ala. what appears to be happening to MySQL.

    39. Re:This is great news.... by Curien · · Score: 1

      My text-mode interface to Sybase is called tsql. Oracle ships with a web interface called iSQL, though.

      --
      It's always a long day... 86400 doesn't fit into a short.
    40. Re:This is great news.... by larry+bagina · · Score: 1

      I'll take Pg Admin3 over phpmyadmin any day of the week. With ajax, it's probably possible to write a decent db manager front end, but phpmyadmin is too clunky, IMO. [yeah, I don't like the php pg admin thing either].

      --
      Do you even lift?

      These aren't the 'roids you're looking for.

    41. Re:This is great news.... by Anonymous Coward · · Score: 0

      2005 called, they want your old meme back.

    42. Re:This is great news.... by Anonymous Coward · · Score: 0

      1. SQL Server Enterprise Manager is obsolete; that's SQL 2000 and below. Use SQL Server Managment Studio (2005 and above).

      2. It's not really that difficult to click on "Generate Change Script" button instead of the "Save" button (or click on the "Script" button instead of the "OK" button.) It then gives you the relevant SQL commands, saving you your 'assload of time' - you can then, at least, look up the relevant commands in the online help.

      (Admittidly, this might be a 2005 only feature. Still, you really should be using 2005 instead of 2000.)

    43. Re:This is great news.... by EQ · · Score: 1

      Even nicer PostreSQL has an animal mascot, I can see the jokes now: A Penguin, Indian and Elephant walk into a bar...


      We even still get a pronounceable acronym LAPP. It looks like the future is still rosy for the rest of us.

      And using FreeBSD, you get FAPP.
      --
      Buffalo buffalo Buffalo buffalo buffalo buffalo Buffalo buffalo! http://goo.gl/J9bkO
    44. Re:This is great news.... by Heembo · · Score: 2, Insightful

      Make your life easier, just fork the backup stuff. The vast majority of MySQL is staying open source - Sun needs the free coders. It's just the backup stuff that Sun wants to privatize.

      --
      Horns are really just a broken halo.
    45. Re:This is great news.... by lewp · · Score: 1

      If you have PGSQL installed on your system, just make a directory in your home dir, add PGDATA= to your environment, run initdb, pg_ctl start, and you can connect to your own instance as your own user without having to worry about permissions at all (by default). That's what I tend to do if I'm working on a web app or something, and it's not any harder than connecting to your MySQL server and changing the empty root password.

      --
      Game... blouses.
    46. Re:This is great news.... by smittyoneeach · · Score: 1

      I've always favored PostGreSQL. The whole My* naming thing seems so last decade, whereas PostGreSQL jumps back over a score of years.
      Go retro!

      --
      Get thee glass eyes, and, like a scurvy politician, seem to see things thou dost not.--King Lear
    47. Re:This is great news.... by Heembo · · Score: 1

      I agree, Postgres is SOLID. Not a bad choice. For those who have already invested heavily in MySQL, I do not think you need to jump off the cliff, yet.

      --
      Horns are really just a broken halo.
    48. Re:This is great news.... by gumbi+west · · Score: 3, Interesting

      Is there good mirroring of databases? I use a laptop and desktop and appreciate that MYSQL lets my have my wiki with me when I travel because I mirror

    49. Re:This is great news.... by Vancorps · · Score: 1

      Here's news for ya, SQL 2000 asks ya for a password for SA if you want to use database authentication which is optional.

      Just because people enabled SQL authentication and didn't bother to set the password on the same damned screen speaks nothing about the product itself other than the fact that they make it real easy to setup and install and get running.

      I'll add that Oracle even to this day doesn't input text into the password field for you during install because they expect you set it which is pretty logical.

    50. Re:This is great news.... by encoderer · · Score: 1, Insightful

      Are you seriously complaining about the fact that 3rd party tools don't give you WYSIWYG support for triggers, something that you can control entirely by simply writing a query?

      I mean, seriously, the CREATE TRIGGER statement is not rocket science.

      Besides, creating them programatically is just better business. I can keep a db_setup_triggers.sql in source control and make it part of automatic builds.

      MySQL is far from perfect. But to criticize it for THIS?

    51. Re:This is great news.... by electrosoccertux · · Score: 1

      so is the pronunciation "post-gresskwel"?

    52. Re:This is great news.... by burnin1965 · · Score: 4, Interesting

      made up for its limitations relative to PostgreSQL

      All the community, documentation, and speed in the world wont make up for lack of features.

      I'm no dbms expert but when I first started learning about relation databases, wow, seems like 6+ years ago now, it was obvious from reading the features of mysql versus postgresql that there was no making up for the fact that mysql wasn't a real relational database. Since I was learning about relational databases I never even bothered with mysql and jumped right into postgresql. So I guess I'm biased but I never ran into a problem with tools, libraries, documentation, or community support.

      Mysql has made many improvements since then, and I even started to play with it as I've been working on some open source projects which are web based applications and as such may need to support the widely popular mysql. So far its not bad, but it would be nice if their mysql command line tool would do TAB completion as psql does. It always takes me a few tabs before I realize that mysql isn't going to help my lazy ass out.

      burnin
    53. Re:This is great news.... by Alpha830RulZ · · Score: 1

      Dunno about Sybase, but it certainly was for informix.

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    54. Re:This is great news.... by agendi · · Score: 2, Insightful

      The one remaining question is mindshare. For example, pretty much every ISP offers MySQL as part of a basic hosting package.

      This is probably what makes it so damn attractive. Taking control of what people have come to rely on, even in tiny ways, makes them either beholden to you or new enemies.

      --
      I just can't be bothered.
    55. Re:This is great news.... by arodland · · Score: 4, Informative

      I guess it's time to see if PostgreSQL's documentation and tools have managed to get any less user-hostile over the years. Buh? Postgres had some really quality documentation before MySQL had much of anything, and a summarized version of it is even available live in the client. Yeah, it's slightly less verbose than MySQL's has gotten to be, but it's certainly not incomplete. It just isn't "SQL for Dummies". (Side note: that's one of the better "Dummies" books ever printed).

      As to tools, I'm not sure what you're after, as postgres has less need for addon tools than mysql, doing more via SQL instead. The only thing that's especially tricky in configuration is pg_hba.conf -- but comparison with mysql's user auth shows the complexity to be worthwhile.
    56. Re:This is great news.... by paulkoan · · Score: 1

      cPanel supports mysql and postgresql, and we (a hosting provider) will begin supporting Postgresql as demand requires it.

      But this is a small part of the jigsaw of Postgresql becoming the de-facto standard. Ultimately it is the body of open source applications out there that are built on mysql which would need to have their reliance on a specific dbms reduce.

      --
      This signature intentionally left blank
    57. Re:This is great news.... by Alpha830RulZ · · Score: 2, Interesting

      Um, maybe I missed something when I was snoozing, but how can something that implements SQL not be a 'real' relational database? Seems to me that Codd said, "A relational database is a time-varying collection of data, all of which can be accessed and updated as if they were organized as a collection of tabular time-varying tabular (nonhierarchic) relations of assorted degrees defined on a given set of simple domains." Since he and Date kind of defined the realm, I'm inclined to go along with his definition.

      In what way would you assert that MySQL doesn't fit this criterion?

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    58. Re:This is great news.... by claytonjr · · Score: 1

      simply put, it's harder for a person new to databases to jump into. MySQL kinda holds your hand with phpmyadmin and it's other admin tools. PG has pgadmin (but not as featureful) and by default installs where you can't access the DB until you su as the postres user and give out permissions. Are they *trying* to make things hard?? So... if they're both open source, why not just port phpmyadmin to PG? Would it really be that hard? They did, per se. Its called phppgadmin. It is nice, for simple tasks.

      http://phppgadmin.sourceforge.net/
    59. Re:This is great news.... by Anonymous Coward · · Score: 0

      That seems to be the same thing Sun is saying - we're going to add some closed source features to MySQL; the same as pSQL's license allows. I'm not sure what you mean as "the same thing". Sun is close-sourcing some part of the MySql code whereas PG is fully open source. The bsd license 'allows' you to close source your addition codes but not PG itself. Get your facts right.

      btw, enough *insert-your-license* war. cheers
    60. Re:This is great news.... by cyphercell · · Score: 1

      (obligatory princess bride ref)
      Anyone using a MAPP?
      ...
      "No more rhymes now I mean it!"
      "Anyone got a peanut?"

      --
      Under the influence of Post-Cyberpunk Gonzo Journalism
    61. Re:This is great news.... by enoz · · Score: 1

      So far its not bad, but it would be nice if their mysql command line tool would do TAB completion as psql does. The MySQL command line tool does do tab completion for table and field names, however I recall that it does not work if you are using the Windows client. (but then again, even the Windows command line only features a very limited tab completion support).
    62. Re:This is great news.... by kestasjk · · Score: 5, Insightful

      I used to be one of MySQL's vociferous defenders, arguing that speed, ease of use, quality of documentation, and the size of the community made up for its limitations relative to PostgreSQL. But this is pretty much the end. Sun is clearly determined to destroy whatever's good about it. PostgreSQL is definitely better in terms of being free.
      • No one company owns it; it's added to by individual companies which need additions, so no-one can buy it out and stomp it out
      • No one company dominates support; you can go wherever you get the best price/service, and there's no incentive to try and get you to need support
      • No dual licensing; it's all BSD licensed, which means if you want to take it and close the source for a commercial project you can. If you think you can take Postgres, close source it, and improve it to the extend that people would pay for it, then good luck to you (but I don't see it happening ;) ). More likely you'd want to embed Postgres, or extend it somehow and not have to worry about licensing or pay fees, and with Postgres (as with SQLite) you can.
      So from a licensing perspective PostgreSQL is definitely a good deal safer.

      For the web I started off with Postgres but eventually had to move to MySQL because it has such wide support, but as I use InnoDB I've grown more and more uneasy at seeing Oracle and Sun buy off chunks of MySQL.
      Even putting aside any arguments about performance/features (not that Postgres is bad in this regard), PostgreSQL would be better as an FOSS DB standard, just because there wouldn't be any worries about license/ownership instability.


      However, before we go nuts with Postgres love, I think it's safe to say Sun won't be close sourcing MySQL to a damaging degree; that'd be like killing the goose that lays the golden egg.
      The reason MySQL is so valuable is because of its wide usage, and they'll want to use that to their advantage in more subtle ways than close sourcing and cashing in. The comments so far have been a bit OTT.
      --
      // MD_Update(&m,buf,j);
    63. Re:This is great news.... by SL+Baur · · Score: 1

      If you cared about your data, you probably wouldn't have gotten involved in the first place. At the time Slashdot picked it up, it wasn't all that good at data integrity in the face of many simultaneous updates, ie. not a real relational database.

      They closed off access to their backup utility. You will now have to pay to get it and not get the source code to boot.

      Doing relational database backend code is hard work and most lucrative for those who are good at it. Do not expect to be able to support a fork there.

      I have no problem with busineses (or individuals like myself) paying for Open Source software. My line is drawn as to whether I have source code or not and if I can support it myself if the original developer support goes away (ie. the current Microsoft Windows XP EOL "crisis").

      A talented group of people can produce outstanding software regardless of whether it is open or closed source. From what I've seen throughout my career the most gifted programmers are drawn towards Open Source.

      So now that I've defined the problem, the solution is obvious. Fork the backup utility from whatever last version was Open Source and continue on with that. The quickest and best way to tell Sun Micro that They Have Fucked Up(tm) is to produce an Open Source version of the backup utility that works better than whatever crap they're selling their "Enterprise" customers.

      Simple, no?

      Sun Micro is dense, like any big company. At times they extend a hand to us (as I experienced first hand with XEmacs) and at other times they do not (as I also experienced first hand with XEmacs). A kick in the ass never hurt anyone and IMO would do some good here. Sun Micro isn't evil, just stupid at times. And unlike some people and organizations, if you beat them over the head with a clue stick a few thousand times they will eventually get the message.

    64. Re:This is great news.... by PS3Penguin · · Score: 1

      I am a true blue MYSQLer ... Hated the mention of anything MYSQL .. believed the party-line that PostgreSQL was "old school" and not commercial grade. However ... due to Sun's recent actions (and your link :) ) .. I just did the 60s tour of the docs .. not only did I find things in order like MySQL documentation .. but HOLY COW .. the extra data types are what I've been dreaming of coding inot MySQL!!! Arrays??? ... Geometric data points (I work a lot with stored polygon data .. had been hand coding /uncoding it)... WOW .. I think I just switched parties!! Thanks SUN! (for making me look else where!) ... And thanks poet for you simple link!

    65. Re:This is great news.... by Anonymous Coward · · Score: 0

      We even still get a pronounceable acronym LAPP Surely PLAP is the obvious choice here....
    66. Re:This is great news.... by hotfireball · · Score: 1

      Correction: Indian with a python on the neck.

    67. Re:This is great news.... by Anonymous Coward · · Score: 0

      pronounceable acronym LAPP

      Whose still using LAMP? We are moving on to UNRRP -- Ubuntu Linix (need the U to make it pronouncable) Nginx, Ruby on Rails, PostgreSQL. Come on, keep up. By the time you learn this one all the cool people will have switched to Merb and Datamapper on JRuby anyway.

    68. Re:This is great news.... by Kristoph · · Score: 5, Interesting

      But this is pretty much the end.

      You need to get a grip and possibly read for yourself what this is.

      Sun is saying that they may (not yet decided) offer some add on components to mySQL backup that may (not yet decided) use a license other than GPL. The add on in question will be integrated through a backup API mySQL has for exactly this purpose (to enable 3rd party extended backup solutions).

      What exactly do see wrong with that? First, nothing precludes building open source backup solutions for this API and nothing precludes other 3rd parties from building other solutions. Why should Sun not have the same right?

      ]{

    69. Re:This is great news.... by tubapro12 · · Score: 1

      I'm late arriver to server management (in other words, I don't know what it was like 10 years ago) and I've always found MySQL harder to manage than PostgreSQL. That's my $.02.

    70. Re:This is great news.... by Corrado · · Score: 0, Troll

      However, before we go nuts with Postgres love, I think it's safe to say Sun won't be close sourcing MySQL to a damaging degree; that'd be like killing the goose that lays the golden egg. That's assuming that Sun can do anything right and you know what happens when you ass-u-me, right?! Let's face it, Sun screws up everything it purchases, they couldn't open source something even if their life depended on it (and it does) and about the only thing they have going for them is Java, and thats still not a very bright light in the dark.

      I really, really want to like Sun and their cool stuff (neato servers) but they just don't act like responsible citizens. The get a new toy, play with it a while and then break it into little pieces.

      My advice for Sun: Just let the engineers back into the company (Go Go Gosling!) or stare into the obscure face of your fallen ancestors - DEC, SGi, NExT, etc...
      --
      KangarooBox - We make IT simple!
    71. Re:This is great news.... by rawg · · Score: 1

      I prefer FreeBSD, Nginx, Mongrel, Ruby, Merb/Rails myself. But I don't do simple web pages, I write applications.

      --
      The above is not worth reading.
    72. Re:This is great news.... by sxpert · · Score: 3, Informative

      as long as you use the same versions of postgres (well, really this should read "the versions you use are using the same disk format)) it should be a simple rsyncing the data directory to the laptop.

    73. Re:This is great news.... by Anonymous Coward · · Score: 2, Informative

      A relational database is a time-varying collection of data, all of which can be accessed and updated as if they were organized as a collection of tabular time-varying tabular (nonhierarchic) relations of assorted degrees defined on a given set of simple domains. (emphasis mine)

      That is where MySQL has problems. It does not enforce the database schema correctly by design, as opposed to other RDBMSs that simply lack a feature or fail to do so due to a bug. Thus it it is only a time-varying collection of data, and fails the rest.

      There used to be truckloads of examples, but these days it's 'only' down to some incorrect null handling, silent errors, and transactions succeeding even if they should fail due to the prior.

    74. Re:This is great news.... by burnin1965 · · Score: 2, Informative

      I wouldn't know about windows clients, haven't used them for years. Table name completion does work, column completion is basically worthless as it lists every column available in every table, not just the table you listed in the FROM portion of the statement. And there is no completion for any of the SQL commands.

      At least that is the case in mysql 5.0.45-6

    75. Re:This is great news.... by burnin1965 · · Score: 4, Insightful

      It does not enforce the database schema

      Well stated. :)

      When your learning about referential integrity but the RDBMS doesn't support it your stuck in a conundrum. Unless you choose an RDBMS that actually does its job of keeping the database relational.
    76. Re:This is great news.... by kisielk · · Score: 3, Informative

      I would say I'm fairly new to Postgres, at least from an administration standpoint. I was just going through their online documentation the other day (which, by the way, is excellent!) and they explained the authentication mechanisms quite well.

    77. Re:This is great news.... by Antique+Geekmeister · · Score: 1

      I tend to use Webmin for administering MySQL. It may not be feature complete, but I find it very robust and effective for doing small repairs and setups.

    78. Re:This is great news.... by ansa · · Score: 1

      Yes but oracle installation STOPS if you don't enter a password, MSSQL just goes on with an empty password...

      --

      --
      "The crux of the biscuit is the Apostrophe(*)" - FZ
    79. Re:This is great news.... by elp · · Score: 2, Insightful

      Speaking as the owner of a mid-size hosting company, I'd say yes definitely. We're whores, we'll sell whatever the customers want.

      Right now there's zero demand for postgresql, I've got thousands and thousands of mysql sites but only a handful of postgresql ones. The instant that starts to change I'll start including postgresql in the entry level packages because I know my competitors be will too.

    80. Re:This is great news.... by Anonymous Coward · · Score: 0

      You're working at NASA, no?

    81. Re:This is great news.... by Beefpatrol · · Score: 3, Informative

      I've been using PostgreSQL pretty heavily for the last year or so, and since the version of Gentoo I was originally using had 8.0.12 as the default version, and I am now using 8.2.6, I can say that it has improved tremendously just through those two minor releases. I have also not found the documentation to be significantly lacking. It is well organized and covers everything you need for even a fairly heavily used system.

      I haven't tried doing any of the more esoteric things with it that the documentation suggests can be done; one thing that I have not tried is installing any of the alternative languages that can be used to write embedded functions. (The list of available languages is pretty impressive, including some that do not initially seem to be semantically even remotely similar to PL/PgSQL.)

      I've currently got a database running whose data takes up about 25 GB on disk, and queries that involve using a good portion of this data seem to have scaled well versus queries that use only a tiny fraction. In moving from one machine to another, I've used the utilities that come with it to dump and restore the database, (and I use them regularly to do backups), and they work well.

      The only thing that ever makes me covet MySQL is the ability to use different storage types for tables. PostgreSQL only has one type of table storage, but any performance issues I have had have been curable in a way other than changing table types.

      #postgresql on freenode is quite useful; fairly frequently, there are representatives of the core development group hanging around, and they have always been willing to answer questions and explain how stuff works.

      One bit of performance advice: if you can get 3 drives, one for the data, one for the indexes, and one for the write-ahead logs, performance will improve drastically. Also, the default settings for the tweakable operational variables are not really set well for speed or efficiency. I'm not sure what kind of system they would be good for, but if you read the documentation, you can glean reasonable settings fairly easily and they make a huge difference. Overall, I have found it to be very reliable. I have never had any problems with this system that were related to the system itself; everything that I have had to deal with has been because I initially didn't know what I was doing and had created some fairly awful database designs.

    82. Re:This is great news.... by johannesg · · Score: 1

      I don't know about the old days, but today the documentation of PostgreSQL is _THE VERY BEST_ I have ever seen on an Open Source project, and should be the standard that other projects aspire to. In fact, I can only name a handful of closed source projects that reach that same level of quality and comprehensiveness.

      As for tools, of course I do not know what you need, but pgAdmin 3 is absolutely excellent for inspecting and modifying your database structure and doing some adhoc queries. Other things, like reporting tools, and things like Powerbuilder, aren't really there as far as I can tell. And I have no experience with PostgreSQL clustering so I cannot tell you how good it is.

    83. Re:This is great news.... by johannesg · · Score: 0, Troll

      (Side note: that's one of the better "Dummies" books ever printed). I'm just trying to imagine the issues that you must have if you are buying shelves full of those "...for dummies" books... ;-)
    84. Re:This is great news.... by tonyr60 · · Score: 1

      "Sun intends to hold back some" And where do Sun explicitly say that?

      So you can read minds. forsee the future? I would have thought that if Sun had such an intention it would be expressed in Java and Solaris. In both those cases there is no evidence of holding some back.

    85. Re:This is great news.... by Angostura · · Score: 1

      To be honest, most people I know just pronounce it Post-gres and ignore the QL.

    86. Re:This is great news.... by shish · · Score: 1

      Maybe sun *really* loves open source, and they're secretly doing this because they want to force people to use better software? ;)

      --
      I mod down anyone who says "I will be modded down for this", regardless of the rest of their comment
    87. Re:This is great news.... by Angostura · · Score: 1

      ... apart from the shareholders - sometimes. Contentious I know, but true.

    88. Re:This is great news.... by Micah · · Score: 1

      I guess it's time to see if PostgreSQL's documentation and tools have managed to get any less user-hostile over the years. I'm fairly familiar with both, and I believe PG's manual is better than MySQL's. They are both good, but every section in PG's manual gets straight to the point with as few words as possible, and it is very easy to follow.

    89. Re:This is great news.... by Anonymous Coward · · Score: 0

      Having a good bit of experience with both, I'd say that the documentation and overall support structure for PG is about the same as MySQL these days.

      The only caveat that typically hangs up new users (especially ones coming from a MySQL background) and is not particularly clearly documented is the default authentication mechanism.

      By default (at least on many distributions), Postgres uses "ident" authentication, which means no password is required for database logins on a local socket. What *is* required, on the other hand, is that you must be logged in/running as the UNIX user of same name. Obviously this poses problems for webapps that want their own database user and is generally just very confusing for users who are used to the database having its own independent set of usernames and passwords (which Postgres still does, for remote connections... causing further confusion)

      Of course, like any good database Postgres will be more than happy to handle its own user authentication entirely natively, you simply have to use md5 instead of ident in pg_hba.conf Then, why not go document it and submit your documentation to the Postgres people for use in the manual.

      You have done a pretty good job of summarising it in this post, so spend a little more time and effort and contribute instead of having a gentle moan about it.
    90. Re:This is great news.... by Micah · · Score: 2, Interesting

      The only thing that's especially tricky in configuration is pg_hba.conf -- but comparison with mysql's user auth shows the complexity to be worthwhile. Amen. User access privileges positively drive me nuts about MySQL. It is completely inane. Different passwords for the same user for different hosts and/or databases? Guuuuh!

      PG works exactly as should be expected, with the added benefit of hierarchical roles. It may be good to change the default auth method from ident to md5, though.
    91. Re:This is great news.... by Kennon · · Score: 5, Funny
      Or how about: OurSQL...bitches.

      yeah the whole thing.

      --
      "All those moments, will be lost in time...like tears in rain..."
    92. Re:This is great news.... by Anonymous Coward · · Score: 0

      Actually I was never happy with MySQL. It started from the attitude of the developers (we are enterprise ready, who needs transactions etc...)
      and ended with oss license changes to payware models while trying to hide that behind a oss facade.
      I am not sure if MySQL itself ever really was oss in the sense of having an open community.
      Things like not properly implementing UTF-8 while propagating having UTF-8 and only documenting that it is not properly working in the forums did it for me to hate that stuff forever.

      On the other hand I have yet to have a single problem with PostgreSQL, ok I have not used it as extensively as MySQL but I also never had any problems.

      The funny thing was in my last MySQL based project I ran into a connection being dropped without notifying the driver problem, that problem went away when I switched to a DB with a MySQL emulation layer. Speaking of code quality (that was version 5 btw, which was supposed to be enterprise ready)

      Id say the sooner MySQL is in oblivion the better, there are better choices out there which really would deserve more populrity, as others have pointed out SQLLite, Firebird, but also HSQLDB, which can serve the small end better.

      And of course there is PostgreSQL which has gained a tremendous speed boost the last few releases.
      I ported an old project to the latest version (the old project was running mostly on MySQL MyIsam and I roughly got the same speed on Postgres in a situation where MySQL was supposed to be fastest!

      I dont even want to think about the speed differences once you switch to transactional storages in MySQL!

    93. Re:This is great news.... by Anonymous Coward · · Score: 0

      Don't forget to mention FireBird (http://www.firebirdsql.org/)

    94. Re:This is great news.... by Bert64 · · Score: 1

      Well, you can use something like mpm-peruser for apache, which means every site runs as it's own user, and then use ident auth on postgres with it.

      --
      http://spamdecoy.net - free throwaway anonymous email - avoid spam!
    95. Re:This is great news.... by Saint+Fnordius · · Score: 1

      As far as animal mascots go, I guess you could call fellow advocates of this configuration your LAPP dawgs. Writers of elegant solutions would be LAPP dancers, and the boys in the server farm would be running LAPPs...

      I'll stick to Mac OS X, and look for a solution in that direction. Anyone else want to join me on a MAPP quest?

      Of course, I don't think FreeBSD proponents would be too happy with being called FAPPers, but no solution is perfect. Also, I smell detractors complaining of the "peepee" smell from this...

    96. Re:This is great news.... by Anonymous Coward · · Score: 2, Funny

      No,

      RSQL.

      Sounds like our SQL.

    97. Re:This is great news.... by ryszard99 · · Score: 1

      The instant that starts to change I'll start including postgresql in the entry level packages because I know my competitors be will too. why not come in ahead of your competitors and do it now?
      --
      -- $_='ab-bc ratvarre';tr"'a-z'"'n-za-m'";print
    98. Re:This is great news.... by Ed+Avis · · Score: 1

      Does SQLite still accept "hello" as an integer? Does it still completely ignore foreign key constraints? Honestly, people like to beat up MySQL for not enforcing data integrity (especially a few years ago), but at least they make some effort.

      --
      -- Ed Avis ed@membled.com
    99. Re:This is great news.... by Hognoxious · · Score: 2, Funny

      Q. What's the difference between a Scotsman with an extended family that are very fond of making lame wordplay jokes and Baldrick from Blackadder?

      A. One has a punning clan...

      --
      Confucius say, "Find worm in apple - bad. Find half a worm - worse."
    100. Re:This is great news.... by Anonymous Coward · · Score: 0

      Even Sun isn't stupid enough to raise the possibility of closed-source components to a famous open-source product, unless they actually plan to do that.

    101. Re:This is great news.... by Anonymous Coward · · Score: 1, Informative

      Mirroring is nowhere near as easy to set up in PG, but it is a lot more robust and scalable than MySQL's. Unfortunately, though, PG mirroring is achieved by using 3rd party tools such as Slony-I.

      I've had experience with Slony-I in the past. Once working, it's very solid, but the installation was a nightmare. The documentation and install guide are incomplete, and the helper scripts packaged with it are buggy and semi-functional.

      I'm told you can now do mirroring and action replays in PG using the binary logs (which is similar to the method MySQL uses). This is good news because I wasn't too happy relying totally on triggers, which is how Slony-I was written.

    102. Re:This is great news.... by segedunum · · Score: 1

      No dual licensing; it's all BSD licensed, which means if you want to take it and close the source for a commercial project you can.
      In all honesty, I really don't care what license Postgres is under. It's just the all-round better database system.
    103. Re:This is great news.... by elp · · Score: 1

      Right now postgresql's take up rate is so low that the economies of scale aren't there to make it worth while.

      You wouldn't notice it from reading slashdot but postgresql supporters are like Ruby on Rails or Ron Paul supporters. A few extremely vocal supporters but no real grass roots support.

      As long as the primary marketing strategy of postgres is "mysql is bad use us instead" they aren't going to gain any major market share. The benefits of sticking with a widely used standard outweigh the relatively minor benefits of moving.

    104. Re:This is great news.... by eokyere · · Score: 1

      whoever moded this insightful is an idiot!

    105. Re:This is great news.... by shutdown+-p+now · · Score: 1

      I guess it's time to see if PostgreSQL's documentation and tools have managed to get any less user-hostile over the years.
      Can't say much about the tools, but the docs are great. I've been using PostgreSQL manual as a general-purpose SQL reference for a while now (it's possible because they clearly mark any extensions/deviations of their dialect from the SQL standard), because it is quite detailed, and actually makes sense when you read it for the first time.
    106. Re:This is great news.... by dintech · · Score: 1

      how can something that implements SQL not be a 'real' relational database
      The query language doesn't dictate what the underlyng data structure is. For example KDB+ is a column database that with it's own vector processing language called K (also Q). This isn't a relational database in the traditional sense but it supports SQL92 queries.
    107. Re:This is great news.... by bhtooefr · · Score: 2, Informative

      What about StarOffice, which they bought, and later forked into OpenOffice?

    108. Re:This is great news.... by Anonymous Coward · · Score: 0

      I switched to Postgresql after I heard Sun was buying MySQL.

      Its actually very very good, and I was very pleasantly surprised, especially by its feature set.

      I'd recommend anyone feeling nervous about MySQL giving Postgresql a go. You might even like it!

    109. Re:This is great news.... by Crayon+Kid · · Score: 1

      The hosting services I use all offer Postgres as well. And it's no accident.

      I don't think that's the issue. The issue are all those very popular applications that use only MySQL. Such as WordPress. For many of them, migrating to Postgres is not trivial.

      In regard to licensing, since a hosting service makes money out of hosting stuff on MySQL, do they need to pay for a MySQL commercial license?

      --
      i ate crayons when i was a kid and now i have two braincells and the blue ones taste nicer
    110. Re:This is great news.... by TheRaven64 · · Score: 3, Insightful

      When I was doing my second-year undergrad database coursework (2001) it was possible in Postgres but impossible in MySQL because MySQL didn't support foreign keys. It's pretty much impossible to define nontrivial relations without foreign keys, or to get much beyond first normal form. I hear MySQL now has support for foreign keys, but I'd much rather use a database that has had this kind of core functionality for well over a decade than one that has recently bolted it on top of a flawed design.

      --
      I am TheRaven on Soylent News
    111. Re:This is great news.... by Corrado · · Score: 1

      Ok, Ok, OpenOffice is pretty cool so I'll give you that one, however I still stand by my statement. On the plus side their not as bad as Microsoft when it comes to screwing up. :)

      BTW: I still don't like the large amount of Java in OOo. Either make it Java so that it runs everywhere (i.e. Mac) or take it out. Grrr...

      --
      KangarooBox - We make IT simple!
    112. Re:This is great news.... by Jon_E · · Score: 1

      For PostgreSQL :) http://www.postgresql.org/

      Would you like another round of ammo with that foot gun Sun? what .. like supporting it since 2005? or bundling it with the operating system .. they've also got quite a few developers working directly with postgresql, and have based and supported quite a few projects on postgresql

      i'm not sure i understand the level of FUD slinging that slashdot has risen to these days

    113. Re:This is great news.... by Marcus+Green · · Score: 1

      Well the innodb backend for MySQL supports the enforcement of referential integrity, i.e. foregin keys. But the vast majority of installations of MySQL are not using innodb, and I suspect most new installations use MyIsam.

    114. Re:This is great news.... by headLITE · · Score: 2, Informative

      There are close to no free coders involved. 99.999% of all MySQL code is currently being written by the more than 400 employees that joined Sun by way of being acquired along with MySQL AB.

      The architecture that is being suggested for backup here is in fact open source friendly, as Sun could just as easily have decided to NOT implement the provisions for it in the GPL code base. As it is now, there will be plenty of opportunity to hook up your own backup stuff, which is a good thing.

    115. Re:This is great news.... by headLITE · · Score: 1

      The command line tool DOES do tab completion if you use readline (and not libedit). Maybe it doesn't do it your specific case. What are you trying to do?

    116. Re:This is great news.... by jacksonj04 · · Score: 1

      Yep.

      --
      How many people can read hex if only you and dead people can read hex?
    117. Re:This is great news.... by Tony+Hoyle · · Score: 3, Informative

      sqlite is a very simple single user db. It's easy to integrate and because it doesn't need a server, works extremely well where you'd like to use SQL but don't need a heavy database. It's not even in the same target application space as MySql.

      MySql is a full fledged client/server database and *should* support referential integrity properly. Of course its biggest problem is licensing - you can only use mysql with 100% GPL applications (unless you're prepared to pay $200/user for the client licenses, or stick to the 3.23 client which is the last free to use version), which limits it somewhat.. TBH given that restriction I'm really surprised web hosts still ship it, as they're opening themselves up to all sorts of liability issues if one of their customers uses/builds a non-gpl app using it.

      Postgresql is basically mysql without all the silly politics.

    118. Re:This is great news.... by ta+bu+shi+da+yu · · Score: 2, Informative

      I'm wondering what part of "I'm not averse to the command line, but there are times when it's just nicer to have a visual interface" you didn't get.

      The guy isn't complaining, he's just saying that PG does it better. And it's true.

      --
      XML is like violence. If it doesn't solve the problem, use more.
    119. Re:This is great news.... by ta+bu+shi+da+yu · · Score: 1

      Sounds like "rascal".

      --
      XML is like violence. If it doesn't solve the problem, use more.
    120. Re:This is great news.... by ptarra · · Score: 1

      That seems to be the same thing Sun is saying - we're going to add some closed source features to MySQL; the same as pSQL's license allows.

      The only difference is that anybody can do it with PostgreSQL but with MySQL only Sun....

      Regards

    121. Re:This is great news.... by debrain · · Score: 5, Interesting

      Are you seriously complaining about the fact that 3rd party tools don't give you WYSIWYG support for triggers, something that you can control entirely by simply writing a query? No. I'm complaining about the fact that, for example, phpMySql requires you to type the following to view the triggers on your database:

      SELECT TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_TABLE, ACTION_STATEMENT
          FROM INFORMATION_SCHEMA.TRIGGERS
          WHERE TRIGGER_SCHEMA='dbname';
      Let alone, ALTER/UPDATE statements.

      Alternatively, here's what I do in phpPgAdmin: click Table, click Triggers. There's a list. I can edit it by clicking on a specific trigger. phpMySql has no such interface to triggers, and every view, creation and edit must be done by manually typing in the SQL (but, based on the tone of your reply, I'm sure you knew that). Maybe you have time for that, and it's not a big concern (on what terms do you get paid?). For any serious database development, it strikes me as a grotesque waste of time.

      I mean, seriously, the CREATE TRIGGER statement is not rocket science. Nobody implied that it was. However, complex trigger statements are what beget the necessity of being able to edit them handily- something that I would imagine you couldn't do with a WYSIWYG (exactly what would a WYSIWYG TRIGGER editor do, anyway?). Wasting 15-20 minutes typing the SELECT/CREATE/ALTER TRIGGERS statement in another editor and then running a blanket update over the whole SQL database strikes me as fundamentally wrong, especially where there is a trivial and effective interface in phpPgAdmin.

      Besides, creating them programatically is just better business. I can keep a db_setup_triggers.sql in source control and make it part of automatic builds. Who ever suggested or implied that you wouldn't create them programatically? Please, feel free to describe how else you would do it.

      MySQL is far from perfect. But to criticize it for THIS? I think you're fundamentally confused about what I was criticizing, meaning you either did not take the time to read my comments, are ignorant of MySql/phpMySql, and/or didn't take the time to think about either before you started ranting. If that be the case and you are fundamentally confused, you've contributed little if anything to the discussion, sounded condescending, acted presumptuously, and been indignant about something that does not even exist (a criticism about the lack of a TRIGGER WYSIWYG, the very suggestion of which reeks of ignorance). If indeed that is the case, next time you consider writing something, perhaps you could do us all a favour and not.

    122. Re:This is great news.... by Cerberus7 · · Score: 1

      THANKYOU!!! I just started working with Postgres and this problem has been driving me nuts. I'm writing some testing C++ programs using the psql library to learn my way around it, and it works as long as I pass the same uid/password with the program as the user I'm logged in as. As soon as I try to pass a different one, it fails. I've been chasing roles as a problem, thinking I missed something simple/stupid in that direction, but I think you just provided me with my solution. Off I go to play with it now!

      --
      I don't know about you, but my servers run on the power of cotton candy and happy thoughts. -Anonymous Coward
    123. Re:This is great news.... by CastrTroy · · Score: 1

      You don't usually accidentally type rm -rf /~ by accident, without really noticing what you are doing. It's very easy to breeze through the sql server install and not even realize that you should have entered a password, or that it was a really good idea to do so.

      --

      Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
    124. Re:This is great news.... by Svartalf · · Score: 1

      That's not what they're doing. They appear to be taking things private, something also allowed by the license.

      --
      I am not merely a "consumer" or a "taxpayer". I am a Citizen of the State of Texas
    125. Re:This is great news.... by Anonymous Coward · · Score: 0

      they're = they are not as bad their = their way of working is not as bad don't want to grill you for the error, just want to give an example to be constructive.

    126. Re:This is great news.... by Muad'Dave · · Score: 1

      As I pronounce things (much to the dismay/delight of those around me) iSQL would be "I Squeal". Maybe we should name it "iSQL-uSQL".

      --
      Tiller's Rule: Never use a word in written form that you've only heard and never read. You will end up looking foolish.
    127. Re:This is great news.... by DarkKnightRadick · · Score: 1

      I'm more interested in whether or not software like WordPress will switch over to Postgre if Sun is going to be an idiot. I know I'll no longer be using MySQL where I have the choice.

      --
      "There is a way that seems right to a man, but its end is the way of death." Proverbs 16:25 (NKJV)
    128. Re:This is great news.... by MobyDisk · · Score: 2, Informative

      Perhaps the only problem with PostgreSql is that it has so many mirroring options, depending on your needs. For your purposes, Slony is probably what you want. Either that, or just use pg_dump or a file copy to copy the entire database in one big chunk.

      Postgres 8.4 will have Postgres-R built-in, which is really just the existing "Mammoth" replication tool, but integrated in.

    129. Re:This is great news.... by MobyDisk · · Score: 1

      Is there nothing in between? SqlLite is not very powerful, nor very efficient. It stores everything as plain strings, is weakly typed, and isn't ACID. But PostgreSql/MySql run as services. What choices does an application developer have for an efficient ACID database that isn't a service running on the machine?

    130. Re:This is great news.... by Anonymous Coward · · Score: 0

      So, you're running a FAPP server?

    131. Re:This is great news.... by Anonymous Coward · · Score: 1, Informative

      Right now there's zero demand for postgresql, I've got thousands and thousands of mysql sites but only a handful of postgresql ones. The instant that starts to change I'll start including postgresql in the entry level packages because I know my competitors be will too.

      Those of us who desire PostgreSQL usually start with the list over at PostgreSQL's site.

    132. Re:This is great news.... by Anonymous Coward · · Score: 0

      The other problem with Postgres is that there is literally no way to implement a HA Cluster with any kind of reliability. Sure, MySQL's sucks ass, that you need essentially 4 computers to make a 2 node cluster, the tables have to fit entirely in RAM, and that there is little security on the cluster itself, but hey, it's the old college try, isn't it?

    133. Re:This is great news.... by WuphonsReach · · Score: 1

      One bit of performance advice: if you can get 3 drives, one for the data, one for the indexes, and one for the write-ahead logs, performance will improve drastically.

      Even putting just the WALs on a separate set of spindles will help immensely.

      (Convincing SELinux to let you do that is a bit more difficult until you learn how to use "ls -Z" and how to set security contexts on the new partition. Which isn't hard, just tedious.)

      --
      Wolde you bothe eate your cake, and have your cake?
    134. Re:This is great news.... by neoform · · Score: 3, Informative

      By the way, there is a WYSIWYG editors for both mysql and postgres that handles triggers..

      http://www.navicat.com/

      --
      MABASPLOOM!
    135. Re:This is great news.... by Anonymous Coward · · Score: 0

      Sounds like "Retard"

    136. Re:This is great news.... by irc.goatse.cx+troll · · Score: 1

      Tell that to all the times I recked my friends linux box while learning linux through his shell (Thanks Adam).

      One little typo or forgetting your CWD and you're deleting a lot. As it should be, really.

      The real problem with SQL Servers behavior as I understand it is just that we've been so conditioned to blow through installers without reading or paying attention due to how many of them are just carbon copies of each other.

      It would be like if there was a default password you had to set with ./configure --default-password=hax and you just went straight for a ./configure && make && make install without bothering to notice.

      The solution of course being better package management. Apt solves this by rarely prompting you when it isn't something it really needs a decision on. Windows could benefit a lot from a port of apt and some good packaging standards (even if third party)

      --
      Pain lasts, kid. Its how you know you're alive. Sometimes I think this growing up thing is just pain management-TheMaxx
    137. Re:This is great news.... by Alpha830RulZ · · Score: 1

      Sounds like your instructor had you implementing product/SQL features, rather than databases. We were building third normal form dbs without product based foreign key/constraint/RI support from the product in about 1989 (Informix), and building business application db's that were more or less 3NF (often denormed for performance in places) throughout the late 90's with Mysql. Sure, it puts RI checking into the application, which is why constraints are a great feature. But your assertion that you can't go to 3NF without product support for foreign keys seems a bit of a stretch.

      And again, if Codd and Date say that the prior definition is what defines a relational database, I think it's safe to say that MySQL has been one from day zero.

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    138. Re:This is great news.... by Alpha830RulZ · · Score: 1

      Internally, every DBMS has a structure that isn't tabular in nature, but which is accessed and managed by the DBMS so that it seems like it is to the user. Oracle, SQL Server, MySQL, they all have some internal data structure that is physically not organized into rows and columns. MySQL in particular allows use of multiple storage managers.

      The definition I presented previously, from Codd himself (see Edgar Codd ) , focuses on how the data can be accessed by and is presented to the using process. If you can access it with standard SQL, it's an RDB, as far as he and I are concerned.

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    139. Re:This is great news.... by Quattro+Vezina · · Score: 1

      Gah. When I first read your post, I thought you were comparing Postgres to Solid.

      *shudders*

      --
      I support the Center for Consumer Freedom
    140. Re:This is great news.... by discord5 · · Score: 1

      TBH given that restriction I'm really surprised web hosts still ship it, as they're opening themselves up to all sorts of liability issues if one of their customers uses/builds a non-gpl app using it.

      Actually webhosts don't open themselves up to anything. One of their customers can develop whatever they want, and the webhost isn't liable for it. As a customer, you can still develop whatever you want as long as it's GPL, and if you don't distribute your application you don't have to provide source. Not distributing your application sort of makes the whole licensing thing a moot point anyway.

      I'd be scared to be a webhoster if I were to be held responsible for any content my customers put online. I'd be forced to check the content of every file on a system, which then conflicts with local privacy laws, trade laws, and would probably piss off my customer.

      Postgresql is basically mysql without all the silly politics.

      Most people don't care about "open-source politics". If someone writes a webapp that uses MySQL and wants to sell it to his customer, they'll gladly include the amount for the MySQL licenses, and the customer will happily fork over the money if they really want it that much. Otherwise they'd 've sticked to an open source application anyway.

      Having said that, postgres is a really nice database and most experiences I've had with it have been pleasant. It's just that it doesn't get installed very much on cheap hosting environments, and usually mysql will do.

    141. Re:This is great news.... by Fweeky · · Score: 1

      TBH given that restriction I'm really surprised web hosts still ship it, as they're opening themselves up to all sorts of liability issues if one of their customers uses/builds a non-gpl app using it. Why would *they* be opened up to liability issues? It's not exactly their concern if one of their clients links libmysql to their closed source app and distributes it. On the other hand it's completely irrelevent when it comes to the vast majority of web applications, because they're written on top of a runtime that is license compatible with libmysql, and even if it isn't, it's not like a web host is likely to be distributing their builds to third parties.
    142. Re:This is great news.... by lastchance_000 · · Score: 1

      SQL Server's command line tool is isql (using DB-Lib connection). The equivalent ODBC tool is osql.

    143. Re:This is great news.... by mgkimsal2 · · Score: 1

      Thanks - that's the best concise explanation of the default authentication I've read. It explains some of the frustration I've had with postgresql over the years, and imo is one of the major reasons why mysql was able to take off years ago: having an easy default way of handling independant user/pass for local apps.

    144. Re:This is great news.... by bhtooefr · · Score: 1

      I'll note that OOo 1.x didn't actually require Java to be installed...

      Yet OOo 2.x is actually faster...

      Oh, and offtopic: G60, VR6, or some form of swap?

      (I've not owned a Corrado, just a Jetta and Golf diesel.)

    145. Re:This is great news.... by ari_j · · Score: 1

      ...and, once you make that change, you realize how much easier user and permissions management is on Postgres as compared with MySQL, and wish that you'd started using it 5 years ago.

    146. Re:This is great news.... by Anonymous Coward · · Score: 0

      Good idea! You first :)

    147. Re:This is great news.... by jadavis · · Score: 1

      You don't want to rsync a data directory on a running server. Either shut the server down, or use a filesystem-level snapshot.

      "Mirroring" isn't as easy to do as it is to say, unfortunately. Depending on exactly how you're using it, there are a lot of pitfalls. This is true for any replication system, not just postgres.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    148. Re:This is great news.... by jadavis · · Score: 1

      Postgres 8.4 will have Postgres-R built-in

      What makes you say that?

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    149. Re:This is great news.... by jadavis · · Score: 1

      The other problem with Postgres is that there is literally no way to implement a HA Cluster with any kind of reliability.

      It depends on what you mean by "HA". If you can stand a couple seconds of downtime, and loss of client connections, you can use a "warm standby" system. And that is reliable, unless you have other information.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    150. Re:This is great news.... by jadavis · · Score: 1

      There are close to no free coders involved.

      I mostly agree, but I'd like to add that there are all of the application developers that have made MySQL so popular. Sun needs those people, and if they jump ship (to a fork, or to PostgreSQL), that will be a problem for MySQL.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    151. Re:This is great news.... by ChrisA90278 · · Score: 1

      As for PostgreSQL documentation. Just do a search at amazon.com you will find enough there. More than you could ever read.

    152. Re:This is great news.... by jadavis · · Score: 1

      I'm impressed by your faith in the GPL. All of the coders work for Sun now, so that means everyone who started up the fork would be new to the codebase.

      I haven't looked at that code, but it doesn't have a reputation for being clean, readable, well-commented code -- especially compared to PostgreSQL.

      I have my doubts that the project could pick up where Sun left off in any reasonable amount of time. If there were no other options, it would be one thing. But PostgreSQL is a great option, so why would people spend so much effort trying to rebuild the MySQL developer base from scratch?

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    153. Re:This is great news.... by Anonymous Coward · · Score: 0

      Sorry. Active-active replication of load balanced machines.

    154. Re:This is great news.... by srealm · · Score: 1

      That was a very cunning stunt ...

    155. Re:This is great news.... by ivanmarsh · · Score: 1

      My thoughts exactly.

      Way to suck Sun!!!!

    156. Re:This is great news.... by LaRueLaDue · · Score: 0

      Wy the changes? There isn't much difference, really, if you know your stuff... I used to use FreeBSD for a long time (3.2 - 6.2), but have moved to netbsd recently. FreeBSD seems too much like Linux for my taste lately...

    157. Re:This is great news.... by Sancho · · Score: 1

      It was a joke. If you look at the acronyms those words form, you might see it.

      Going even further off-topic, I actually feel that FreeBSD is a cleaner, simpler implementation of Unix than Linux, and their focus on network throughput is pretty outstanding. I actually don't do much with the APP of my acronym, and even less since I'm messing with lighttpd a little more now (turning the acronym into the unintelligible mess of "FLPP".)

      One of the neat things about FreeBSD over Linux is that it's got a stable ABI between releases.

    158. Re:This is great news.... by jadavis · · Score: 1

      there appears to be nothing that prevenst a PG developer form doing exactly what Sun is

      From a legal standpoint, maybe. Apparently the GPL isn't really helping keep MySQL free either, because the MySQL code is owned entirely by Sun, so they can do whatever they want. For instance, if Sun develops a crucial feature and makes it closed, like online backup, they can prevent the GPL versions from being accepted to the project, and can let alternatives to that closed solution fall into unmaintained disrepair.

      In contrast, the PostgreSQL community is a group of many individuals and companies, and they cannot prevent free versions of important features from being committed.

      So really, the question is not what could be done legally, but what actually is happening, and what is likely to continue happening. MySQL started as a commercial product, went GPL, and now they are introducing closed features again. They always maintained copyright ownership.

      Again, in contrast, the PostgreSQL community started with a free license, and has a wide group of contributors that each retain copyright for their respective contributions. Perhaps most importantly, PostgreSQL has very well-commented, readable source code.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    159. Re:This is great news.... by Watts+Martin · · Score: 1

      FNMRM and FNMRR are terrible acronyms! But setting that aside, "LAMP" and its derivatives are basically describing the "OS, Web Server, Database, and Language/Framework" stack. None of what you've mentioned are databases, which is a little ironic when it's coming up in a thread about, you know, a database server. :)

    160. Re:This is great news.... by sgtrock · · Score: 1

      From SQLite's Features page:

      "Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures." The other two issues that you raise may be there for all I know. However, for the class of apps that SQLite is aimed at, who cares? :)
    161. Re:This is great news.... by burnin1965 · · Score: 1
      Okay, mysql DOES do tab completion, poorly. The way its implemented is worthless, allow me to demonstrate...

      >mysql -h 192.168.0.35 -u dbadmin -p test
      Enter password:

      mysql>se [TAB][TAB][TAB]

      'oh crap forgot I'm not using psql, damn it'

      mysql>select * from [TAB]
      Display all 196 possibilities? (y or n)

      'wtf, I don't have 196 tables in this schema, doh, I'm not using psql'

      mysql>select * from cust[TAB]
      customer customer.c_discount customer.c_state
      customer.c_balance customer.c_first customer.c_street_1
      customer.c_city customer.c_id customer.c_street_2
      customer.c_credit customer.c_last customer.c_w_id
      customer.c_credit_lim customer.c_middle customer.c_ytd_payment
      customer.c_d_id customer.c_payment_cnt customer.c_zip
      customer.c_data customer.c_phone
      customer.c_delivery_cnt customer.c_since

      'WTF, this is lame'

      mysql>select * from customer where [TAB]
      Display all 196 possibilities? (y or n)

      'ugh, this is really stupid'

      mysql>select * from customer where c_last li[TAB]

      'screw this'

      mysql>quit
      >yum remove mysql
      >yum install postgresql

      better? :P
    162. Re:This is great news.... by ne0n · · Score: 1

      Pleasantly understated masturbation humour certainly takes this database discussion to another level.

      Respect.

      --
      $ :(){ :|:& };:
    163. Re:This is great news.... by Discoflamingo13 · · Score: 1

      As long as people don't read the second part as "Micro-Squeal", I think it could catch on.

    164. Re:This is great news.... by jadavis · · Score: 1

      MySQL in particular allows use of multiple storage managers.

      But to be called a relational database management system, choosing a different storage engine should not affect the behavior, only performance.

      In MySQL it does affect behavior to use a different storage engine, so it fails to abstract the relations from the physical storage.

      I suppose you could argue that MySQL is really a lot of different relational database management systems combined in one package, but it still fails to enforce domain constraints, so it still fails to be an RDBMS.

      Focuses on how the data can be accessed by and is presented to the using process.

      That changes radically depending on the storage engine and various configuration options.

      If you can access it with standard SQL ...

      MySQL does not enforce the SQL standard in many fundamental ways, unless I'm seriously mistaken about the SQL standard (which I may be). Does the SQL standard really allow such disregard for type constraints and foreign keys? Are backticks really an acceptable way to quote identifiers according to the standard?

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    165. Re:This is great news.... by jadavis · · Score: 1

      The benefits of sticking with a widely used standard

      You mean like SQL? PostgreSQL supports it. MySQL doesn't. So I don't follow your argument here.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    166. Re:This is great news.... by Christopher+B.+Brown · · Score: 1

      I guess it's time to see if PostgreSQL's documentation and tools have managed to get any less user-hostile over the years. In 8.3, the "contrib" docs have been integrated into the main SGML documentation base, which seems pretty helpful. Whether or not to regard this as "user-hostile" seems to be very much in the eye of the beholder. There's the old joke that "Unix is user friendly; it's just a bit selective about its friends" which seems likely to apply pretty well.

      To my mind, it's fairly "friendly," notably from the perspective that it's not got the frightening quantities of version-dependent caveats that I frequently see when browsing MySQL documentation. (Of course, those caveats tend to be driven by wild variations in functionality between storage engines...)

      The one remaining question is mindshare. For example, pretty much every ISP offers MySQL as part of a basic hosting package. No one's saying they have to stop doing that, but are they going to start offering other open source DBMSs in the same way now? I sure hope so. My hosting service (a2) offers both. Now there are obviously a lot of the built-in apps that are entirely MySQL-specific (e.g. - such as WordPress and such), but PostgreSQL is there.
      --
      If you're not part of the solution, you're part of the precipitate.
    167. Re:This is great news.... by Christopher+B.+Brown · · Score: 1

      But PostgreSQL is a great option, so why would people spend so much effort trying to rebuild the MySQL developer base from scratch? That's a spectacularly good point that proponents of the "faith in the GPL" position seem wont to miss.

      Yes, indeed, if MySQL AB (or Sun) suddenly "turn evil" (and as Sun hasn't got the most spectacularly positive history with any of their acquisitions; name one?), this introduces the problem that fans of MySQL(tm), which would probably need to change its name (as happened when Interbase became Firebird), would need to recreate a developer base as well as organizational reputation from zero.

      It might be apropos to compare to SAP-DB aka MaxDB, which, when "open sourced," engaged rather little enthusiasm, even though it had plenty of functionality that MySQL(tm) doesn't have yet. There was no choice but to engage paid developers whose job it was to maintain it. It never developed such "organizational reputation" in the Open Source community.

      Mozilla looks like a pretty big success, independent of former parent, Netscape, but it took years of very active sponsorship for that to happen.

      I could easily see an "Independent MySQL Fork" being destined for failure.

      --
      If you're not part of the solution, you're part of the precipitate.
    168. Re:This is great news.... by gumbi+west · · Score: 1

      right, but MySQL just replicates when I hookup my laptop to the wireless. I do nothing, this is completely different from shutting down both servers and rsyncing.

    169. Re:This is great news.... by ttfkam · · Score: 1

      The issue are all those very popular applications that use only MySQL. Such as WordPress. For many of them, migrating to Postgres is not trivial.

      Well said. When your app is a big ball of mud, moving from an old, soft foundation to a newer, stronger foundation is very difficult without breaking the big ball of mud.
      --

      - I don't need to go outside, my CRT tan'll do me just fine.
    170. Re:This is great news.... by Alpha830RulZ · · Score: 1

      Forest for the trees, my friend. Does mysql support

      "select this, that and theother from sometable join someothertable on sometable.keyfield = someothertable.keyfield"

      and deliver a set of rows and columns? Has it always done this? That's pretty much what Codd and Date were using as a definition. SQL only matters in that it assumes the tabular view. MySQL may have a limited feature set, a non-standard feature set, and may not be what you want. But it just doesn't make sense to say that that isn't implementing a relational model, and that it's databases aren't 'real' relational databases. Quacks like a duck, might as well be a duck.

      Let me guess, you guys are Oracle fans, no?

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    171. Re:This is great news.... by Alpha830RulZ · · Score: 1

      whoops, my lyricism got in the way of my SQL. S/B

      "select this, that, theother from sometable join someothertable on sometable.keyfield = someothertable.keyfield"

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    172. Re:This is great news.... by AngryDill · · Score: 1

      I still don't like the large amount of Java in OOo

      To my knowledge, the usage of Java in OOo is really quite limited. The "Base" component uses the embedded Java DBMS HSQLDB; the original StarOffice DB component didn't have open-sourceable licensing and presumably the OOo developers didn't feel like "re-inventing the wheel" in order to replace it. I believe that you could use OOo sans Java if you're using it as a front-end to a standalone DB (MySQL, PostgreSQL, Oracle, etc.)

      The UI designer part of the OOo Macro "IDE" uses Java as well; I'm not aware of the history of that code. I would guess, however, that those who develop macros with dialogs would constitute a small minority of the OOo user community.

      The vast majority of the OOo codebase, I have read, is implemented in C++.

      -a.d.
      --


      I'm Erwin Schrodinger and I approve of this message, and I do not approve of this message!
    173. Re:This is great news.... by msromike · · Score: 1

      WHy do you have to stop using a good product becuase it isn't open source? Sounds more like making decisions based on emotion rather than on objective data.

    174. Re:This is great news.... by Anonymous Coward · · Score: 0

      I switched to PostGreSQL a few years back for development. _BECAUSE_ I was writing closed source. One of the problems I found with MySQL is that they would sprinkle GPL licenses on some of their key libraries instead of LGPL. This was purely done as a tactic to squeeze money out of the developers. Because MySQL offered special licenses for those who wanted to sell closed source software. If Sun fixes the GPL-ed libraries and makes them LGPL. Thats enough to make me reconsider MySQL. As far as this chunk of code that is going to be closed source enterprise feature to do online backups... I'm not sure its quite the gloom and doom the world is coming to an end and soon MySQL is going to be licensing connections like MS-SQL. I think that is a exaggeration. Sure we all like open source as much as possible. But online backups? I'm assuming this would be a monthly service anyways. How many people would really use this service if it was open source? How many open source online backup services are there? I'm not being rhetorical either. I'm seriously wondering even if there is any open source alternative solutions available to the demonized closed source code chunk. On any case. PostGreSQL's BSD license is much friendlier to all developers of open source and closed source projects alike.

    175. Re:This is great news.... by Corrado · · Score: 1

      Now that you mention it, I do remember turning off Java (for better startup times). In reality, I really like OOo and recommend it heartily above that "other" office suite to anyone that will listen. I just had to point out something "bad" when bhtooefr poked holes in my "Sun is stupid" comment. Java was the first|only thing I could think of. :)

      --
      KangarooBox - We make IT simple!
    176. Re:This is great news.... by Anonymous Coward · · Score: 0

      FlameRobin works very well, and is very stable, current version is ~0.8.6

    177. Re:This is great news.... by Wiseman1024 · · Score: 1

      Quit whining, phpMySQLAdmin is NOT a MySQL tool. The MySQL client tools are the mysql client and the MySQL Query Browser. Criticize MySQL for that, not for phpMySQLAdmin, and for your own good, use the command-line client. I'm tired of seeing people who can't do crap the second they're left without their favourite clicky tool, and those clicky tools do not support automation.

      Also, use SHOW TRIGGER STATUS/SHOW CREATE TRIGGER to view your triggers.

      --
      I was about to say 13256278887989457651018865901401704640, but it appears this number is private property.
    178. Re:This is great news.... by Wiseman1024 · · Score: 1

      I like how FAPP sounds. *fapp* *fapp* *fapp*

      But I'm happy with GNU/Linux. And my P is for Python.

      --
      I was about to say 13256278887989457651018865901401704640, but it appears this number is private property.
    179. Re:This is great news.... by marcosdumay · · Score: 1

      Well, it is the Postgres database with a sql frontend... So, it is formaly named Postgresql. Postgres had originaly a object oriented frontend, but since there is no other distribution anymore, calling it just "Postgres" is not misleading.

    180. Re:This is great news.... by marcosdumay · · Score: 1

      Do you mean replication? Postgres do that too.

    181. Re:This is great news.... by X0563511 · · Score: 1

      Explain that to Thomson Course Technology :/

      --
      For large sets, this will be our guide even unto death, for the LORD will work for each type of data it is applied to...
    182. Re:This is great news.... by Registered+Coward+v2 · · Score: 1

      there appears to be nothing that prevenst a PG developer form doing exactly what Sun is

      From a legal standpoint, maybe. Apparently the GPL isn't really helping keep MySQL free either, because the MySQL code is owned entirely by Sun, so they can do whatever they want. For instance, if Sun develops a crucial feature and makes it closed, like online backup, they can prevent the GPL versions from being accepted to the project, and can let alternatives to that closed solution fall into unmaintained disrepair. However, someone else could maintain the GPL'd code; add whatever features they want or other users want; and release it under the GPL. There is no reason the code can't be forked; other than if there turns out to be a lack of interest in he wider community in maintaining a fully GPL'd version of MySQL.

      My SQL is no less free if Sun adds proprietary extensions; the underlying code which is available today would still be available for anyone to use as they see fit; including adding GPL'd versions of Sun's closed extensions.

      In contrast, the PostgreSQL community is a group of many individuals and companies, and they cannot prevent free versions of important features from being committed. Neither can Sun, nor can the PG community prevent someone from modifying PG and not making the modifications available.

      So really, the question is not what could be done legally, but what actually is happening, and what is likely to continue happening. MySQL started as a commercial product, went GPL, and now they are introducing closed features again. They always maintained copyright ownership. As a copyright owner they are obviously free to with their product whatever they want; it also appears that they will allow others to add proprietary features if they desire via API's.

      Again, in contrast, the PostgreSQL community started with a free license, and has a wide group of contributors that each retain copyright for their respective contributions. Perhaps most importantly, PostgreSQL has very well-commented, readable source code. Which, under the license, can be taken by anyone an used in a closed source project.

      I'm not saying any one model is better; just pointing out similarities between the two.

      IMHO, the BSD license is more permissive than the GPL in that it allows anyone to use the code in closed as well as open sourced projects; whether that is "good" is obviously open to debate.

      The GPL only allows the copyright owner to do that; it appears SUN has decided to modify MySQL to allow closed source code to run in conjunction with the GPL'd code but not be incorporated in the GPL'd code base so they can sell that as a value added product. If that results in improvements to the GPL'd and a more robust open product then I think it's a good thing; but again YMMV.
      --
      I'm a consultant - I convert gibberish into cash-flow.
    183. Re:This is great news.... by ckaminski · · Score: 1

      And using solaris you get SAPP

    184. Re:This is great news.... by jadavis · · Score: 1

      That's pretty much what Codd and Date were using as a definition.

      I don't know Codd's work well enough to disagree. But Chris Date and Hugh Darwen would almost certainly disagree strongly with your perception of the relational model.

      Quacks like a duck, might as well be a duck.

      The SQL standard is already imperfect, and MySQL deviates further from the relational model in important ways.

      Let me guess, you guys are Oracle fans, no?

      No. Although as an RDBMS, it's a respectable second-best to PostgreSQL.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    185. Re:This is great news.... by jadavis · · Score: 1

      There is no reason the code can't be forked;

      But there are reasons that such an attempt at a fork will ultimately fail. All of the developers are employed by Sun, and won't participate in the fork. So that means you have to build a developer community from nothing, which is almost impossible unless there's a lot of motivation. With an alternative like PostgreSQL, nobody's going to be motivated enough to learn the MySQL source code.

      People throw around words like "fork" as if it were a realistic alternative for MySQL, but it's not.

      If there were a big divide in the PostgreSQL community, chances are there would be a lot of developers on both sides, because they don't all work for the same company.

      There are fundamental organizational differences between the two projects that matter much more than which licenses they happen to use.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    186. Re:This is great news.... by Anonymous Coward · · Score: 0

      http://www.h2database.com/ is open source and it is faster than MySql and Postgress. And it is fully relational and transaction based from day zero.

      Besides it is written in Java, so it is fully portable without requiring to recompile and the source code is lean and mean, much simpler than other databases.

    187. Re:This is great news.... by Anonymous Coward · · Score: 0

      That last paragraph may be the most reusable response that I've ever read. Thank you for this.

    188. Re:This is great news.... by morgan_greywolf · · Score: 1

      Oh, sheesh. So melodramatic. Hasn't anybody around here heard of forking?

    189. Re:This is great news.... by tyler_larson · · Score: 1
      Not only does MySQL have a mascot (dolphin), but that dolphin actually has a name.

      Take that, anonymous elephant!

      --
      "With sufficient thrust, pigs fly just fine. However, this is not necessarily a good idea...."
      RFC 1925
    190. Re:This is great news.... by Anonymous Coward · · Score: 0

      Mysql does have tab completion.

      You have to configure it to load up the meta-info for it to work, or use \# to load it on the fly.

      The default is to not load it, since it does cause overhead time for a large DB to start up the mysql monitor.

      I use \# all the time, personally.

    191. Re:This is great news.... by MobyDisk · · Score: 1

      It was announced at the East coast conference about a month ago. I'm not on the developer mailing lists so I don't know anything more than that.

  2. Not that I begrudge them a right to make a buck... by Chas · · Score: 0, Redundant

    But this is going to seriously piss off those who've been relying on these features.

    --


    Chas - The one, the only.
    THANK GOD!!!
  3. Close sourcing? by RedWizzard · · Score: 1, Redundant

    WTF is "close sourcing"?

    1. Re:Close sourcing? by tgatliff · · Score: 2, Interesting

      As much as these "old" companies claim they understand where the industry is headed, they really have no clue....

      The only thing that Sun will achieve in this change is a fork... Maybe that was the plan all along... The founders of MySQL AB get their big checks, and then create a new company with a forked version of MYSQL.. Brilliant!!! :)

    2. Re:Close sourcing? by eclectro · · Score: 0

      WTF is "close sourcing"? It's like when your slashdot post is modded down to -1 where no one can see it.
      --
      Take the cheese to sickbay, the doctor should see it as soon as possible - B'Elanna Torres, "Learning Curve"
  4. Re:Not that I begrudge them a right to make a buck by andersbergh · · Score: 5, Informative

    That's not what the linked blog post says, basically what they're doing is developing new features to be put in MySQL 6.0 enterprise, and these _new_ features won't show up in community.

  5. You can't effectively close-source anything GPL... by edlinfan · · Score: 0, Flamebait

    ...because someone with the source will fork it.

    Sun appears to have made a bonehead move. Now the masses will turn somewhere else for high-quality FOSS SQL...

  6. harsh judgement by irtza · · Score: 5, Insightful

    didn't sun buy star office and give us the OPEN SOURCE - openoffice.org?

    given the size and nature of this move, I don't begrudge sun anything in its commitment to open source.

    --
    When all else fails, try.
    1. Re:harsh judgement by Anonymous Coward · · Score: 5, Funny

      quiet! stop ruining my argument with facts

    2. Re:harsh judgement by nurb432 · · Score: 4, Insightful

      And don't forget Netbeans.. Oh, and SPARC..

      --
      ---- Booth was a patriot ----
    3. Re:harsh judgement by Anonymous Coward · · Score: 0

      That's one of the worst trolls I've ever seen in a summary. Granted, I don't usually pay much attention to them.

      Just because Sun didn't choose somebody's license of choice doesn't make their code less open source.

      Just off the top of my head, they've open sourced 3 gigantic projects:

      1. OpenSolaris
      2. Java
      3. OpenOffice

      On top of that, there's a bunch of less noteworthy stuff.

      Whoever added that to the summary is a fucking idiot.

    4. Re:harsh judgement by RiotingPacifist · · Score: 0

      java not full open source
      OpenOffice not really GPL
      OpenSolaris i dont know enough about

      --
      IranAir Flight 655 never forget!
    5. Re:harsh judgement by Alpha830RulZ · · Score: 5, Insightful

      Java is pretty neat, too.

      I do like NetBeans.

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    6. Re:harsh judgement by An+dochasac · · Score: 5, Interesting
      java not full open source

      Where have you been? Java source code has been available for a long time but after years of people complaining that it wasn't "free enough", Sun fully released Java under a GPL 2 years ago.

      OpenOffice not really GPL

      O.K. so it's LGPL So what, so is Gtk, most of GNOME and probably 80% of what you and joe-sixpack considers to be "opensource" in "Linux". GPL is just one license. GPL was never fully tested in court and doesn't provide patent indemnity as CDDL does. I'd be happier if Java, OpenOffice and MySQL were CDDL but there would be too much gnashing of teeth from the Linux creationists.

      OpenSolaris i dont know enough about

      OpenSolaris is licensed under CDDL. Look here for an FAQ which explains in simple terms why CDDL is superior to GPL.



    7. Re:harsh judgement by Nazlfrag · · Score: 3, Insightful

      I'd like you to try to name another company off the top of your head that has contributed to OSS like Sun has. They not only open source this stuff but actively develop and maintain it and understand that being the first stop for support and services they provide (like online backup features in their Enterprise tools) is the reward they receive for this generous GPLing of their codebase. GP is right, article is a troll.

    8. Re:harsh judgement by Richard+W.M.+Jones · · Score: 1

      Java is pretty neat, too.

      Java is the COBOL of the naughties - verbose, bloated and full of horribly bad design choices.

      Rich.

    9. Re:harsh judgement by shutdown+-p+now · · Score: 1

      On a side note, we are finally going to see OpenJDK as a default JVM in the upcoming Fedora 9. I was waiting for that sort of thing, since it's really the only way to ensure that Sun really did what they said they did.

    10. Re:harsh judgement by Nullav · · Score: 1

      Other than the GPL, what is compatable with the GPL?

      --
      I just read Slashdot for the articles.
    11. Re:harsh judgement by Alpha830RulZ · · Score: 1

      Whatever. You clearly have never used COBOL. If you aren't old enough to have spilled a deck of punch cards, you don't know how easy you have it.

      Java is a solid language, that is stable, rich, well documented, with great industry support. It's free, comes with a great IDE, and there are multiple rich app server environments to develop to, which are also mostly free. Perhaps this is the 'bloat' you refer to.

      I've been coding long enough to remember when FORTRAN 77 was new and neat, and we all wanted it. After living through and delivering production applications in FORTRAN, 3 versions of BASIC, COBOL, PL/1, C, VB, Java, Perl and Python, so far, it's my not so humble opinion that anyone who sneers at Java is a spoiled brat. Sure, there are other great environments, but Java is a technological asset of no small value.

      Now get off my lawn. :-)

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    12. Re:harsh judgement by houghi · · Score: 1

      Novell?

      --
      Don't fight for your country, if your country does not fight for you.
    13. Re:harsh judgement by MikeFM · · Score: 1

      Yeah but Sun is a multi-headed beast like most corporations. One head doesn't know what the other is doing or always go along with the same behaviors.

      Besides, if OpenOffice didn't basically suck then Sun probably would bundle the better features into a closed source version. Luckily, OpenOffice is such a bit of crap that nobody is very likely to pay for it when they could just pay for M$ Office.

      --
      At what price learning? At what cost wisdom? The price is a man's peace of mind, and the cost is his life.
    14. Re:harsh judgement by SkipRosebaugh · · Score: 1

      There's a long list of licenses compatible with the GPL at http://www.gnu.org/licenses/license-list.html#SoftwareLicenses .

      Some of the more well-known ones are the Apache License (version 2, compatible with GPL3 but not GPL2), the modified BSD License, the X11 License, and others.

      GPL2 wasn't very compatible with other licenses because it forbade adding more restrictions (such as indemnification requirements) out of concern that people might add restrictions that served to make the software non-free. GPL3 section 7 specifically allows you to add certain restrictions that are common in other free software licenses, so it's more compatible with other licenses (at the cost of not being compatible with GPL2 unless the 'or any later version' clause was used).

      Yeah, it's complex. But RMS's goal was first and foremost to make sure your rights as a user couldn't be taken away by a competent but unfriendly developer, and other people have had different goals. (e.g., it's safe to say that GPL focuses on the rights of the user, while BSD focuses on the rights of the developer.) In the real world, when goals conflict, complexity happens.

    15. Re:harsh judgement by IronChef · · Score: 1

      didn't Sun do nfs? and zfs?

    16. Re:harsh judgement by RiotingPacifist · · Score: 1

      java not full open source


      Where have you been? Java source code has been available for a long time but after years of people complaining that it wasn't "free enough", Sun fully released Java under a GPL 2 years ago.

      "As of May 2007, in compliance with the specifications of the Java Community Process, Sun made available most of their Java technologies as free software under the GNU General Public License."
      Not all of it has been released.

      OpenOffice not really GPL


      O.K. so it's LGPL So what, so is Gtk, most of GNOME and probably 80% of what you and joe-sixpack considers to be "opensource" in "Linux". GPL is just one license. GPL was never fully tested in court and doesn't provide patent indemnity as CDDL does. I'd be happier if Java, OpenOffice and MySQL were CDDL but there would be too much gnashing of teeth from the Linux creationists.

      "However, OpenOffice.org requires a copyright assignment for contributions to the main code base; this allows Sun to create proprietary versions of the software (notably StarOffice). NeoOffice chooses not to assign their code to Sun; this prevents NeoOffice code from being used in official OpenOffice.org versions. Instead, NeoOffice is released only under the GPL (this is allowed by the LGPL), which ensures that any software based on it remains free."
      Sounds like open office are happy to release a product aslong as they can then add closed source stuff to it and re-release it.

      OpenSolaris i dont know enough about

      OpenSolaris is licensed under CDDL. Look here for an FAQ which explains in simple terms why CDDL is superior to GPL.

      "We needed an open source license that allowed files released under the license to be linked with files released under other licenses. While a license like LGPL would allow this for dynamically-linked code, we also needed to be able to release software that statically links source files available under different licenses. In addition, we wanted to allow others to add externsions to OpenSolaris with different license terms."
      Sounds like the same trick, we'll open source it but we might want to add closed stuff latter. They also deliberately chose a GPL incompatible license!

      --
      IranAir Flight 655 never forget!
    17. Re:harsh judgement by Wiseman1024 · · Score: 1

      Parent is insightful.

      --
      I was about to say 13256278887989457651018865901401704640, but it appears this number is private property.
    18. Re:harsh judgement by aled · · Score: 1

      More FUD. I did work programming in COBOL for a couple of years. Java is nothing like COBOL. You don't know what you are talking about.

      You can't really blame COBOL either for being verbose and bloated, it was one of the first high level programming languages ever. Show more respect for your elders!

      This article and most of the posts are full of FUD. SUN open sourced its office suite, its operating system, its languages, application servers, development tools and processors (!). Java was open sourced under GPL.
      What else people want them to open source? this is ludicrous.

      --

      "I think this line is mostly filler"
    19. Re:harsh judgement by RiotingPacifist · · Score: 1

      http://slashdot.org/firehose.pl?op=view&id=639082

      OpenOffice has a clause that you have to sign so that they can add it to closed source products, thats why neo office cant contribute to OpenOffice

      CDDL deliberaly chosen to be GPL incompatible, and as a bonus allow them to release close sourced modules for it if they decide open source isn't for them

      --
      IranAir Flight 655 never forget!
  7. Re:You can't effectively close-source anything GPL by andersbergh · · Score: 2, Insightful

    How could you fork code that hasn't been released in the first place?

  8. Whatever by Anonymous Coward · · Score: 0

    As someone who is not advanced enough in programming, I really don't care. All I know is that a great tool has been adopted by tech company with deep pockets, which means that there will soon be cool mySQL tools, GUI interfaces, backups/replicate/security features etc.
    If I can't get to the code, it really doesn't bother me.
    Just keep making the product better.

    1. Re:Whatever by piojo · · Score: 1

      If I can't get to the code, it really doesn't bother me.
      Just keep making the product better. Well, the omission in that line of thinking is, what happens when they decide not to support you? What happens if they decide not to fix some bug? What if they stop releasing for your architecture? (64-bit Windows is pretty unpopular, are there binary builds for that?)

      However, as other comments imply, it doesn't seem that they are actually close sourcing anything, just declaring that certain new developments will be closed.
      --
      A cat can't teach a dog to bark.
    2. Re:Whatever by sg_oneill · · Score: 1

      As someone who is not advanced enough in programming, I really don't care. All I know is that a great tool has been adopted by tech company with deep pockets, which means that there will soon be cool mySQL tools, GUI interfaces, backups/replicate/security features etc.
      If I can't get to the code, it really doesn't bother me.
      Just keep making the product better. Lets just hope you aren't dependant on an operating system thats designed around having source available to help integrate things, like, ooh say, linux.
      --
      Excuse the Unicode crap in my posts. That's an apostrophe, and slashdot is busted.
    3. Re:Whatever by The+End+Of+Days · · Score: 1

      Since he's someone not advanced enough in programming to deal with it (like the vast majority or people) it's not like an abandoned open source database would solve that problem for him either.

    4. Re:Whatever by Anonymous Coward · · Score: 0

      Here's the thing. I have used Netbeans, Postgresql, mySQL and ... um ...whatelse? ... anyway - lot's of things. I have never as much as seen 1 line of their code. And they have all worked on my linux and BSD distros. So why would I NEED the source to be productive. i simply do not know enough to actually use it.

    5. Re:Whatever by Anonymous Coward · · Score: 0

      So why would I NEED the source to be productive. i simply do not know enough to actually use it.


      This is quite a common misconception about the usefulness and benefit of having the full source code open.

      Not just part of the source code ... the full amount of the source code.

      There exists a large community of open-source programmers ... over 1.5 million of them. If the full source code is available ... some of them will look at it and be able to understand it ... and hence know if there is anything in it that isn't to their own interest ... and yet they use it themselves.

      This is the guarantee of open source. It is auditable by people who didn't write it but want to use it.

      It is not that YOU IN PARTICULAR can look at the source that is valuable ... just that it can be looked at and that it actually is looked at.

      You lose that value the moment even a small part of the codebase of a project becomes closed source ... no-one then knows (publicly) just what is contained within the closed bit ... so the whole product loses that auditability and independent review.
    6. Re:Whatever by piojo · · Score: 1

      Of course you're right, but maybe there are others like him on the same platform that are sufficiently sophisticated. Maybe there's a packager for his distro, if he's using Linux. Or maybe all it takes is a change (or ten) to a makefile.

      --
      A cat can't teach a dog to bark.
  9. Last part a Joke? by gQuigs · · Score: 5, Informative

    OpenOffice.org - no mention eh. :P
    Java - I am running the IcedTea free software version right now
    OpenSolaris - might not be GPL, but it still qualifies as free software... right?

    Of course I'm hoping the first part is a joke too.

    1. Re:Last part a Joke? by davecb · · Score: 2, Insightful

      No, Anonymous just has an axe to grind. MySQL is releasing some stuff in the for-pay codebase first. And I note a commentator below says the backup is in the GPL codebase after all...

      --dave

      --
      davecb@spamcop.net
    2. Re:Last part a Joke? by junglee_iitk · · Score: 5, Insightful

      That when RMS himself says that Sun is the biggest single corporate contributor to open source.

      Slashdot's credibility is drowning.

    3. Re:Last part a Joke? by Midnight+Thunder · · Score: 1

      Slashdot's credibility is drowning.

      You have it all wrong. They are trying to compete with the Enquirer and FoxNews. ;)

      --
      Jumpstart the tartan drive.
    4. Re:Last part a Joke? by jtn · · Score: 1

      You make it sound like they had much to begin with.

    5. Re:Last part a Joke? by jedidiah · · Score: 1

      That's kinda like saying that Alexander the Great was a nice guy
      when compared to other conquerors like Hitler and Ghengis Khan. ...that statement also ignores what else Sun does that might
      effectively undo all of the good that is done by the original claim.

      --
      A Pirate and a Puritan look the same on a balance sheet.
    6. Re:Last part a Joke? by Dahamma · · Score: 1

      Godwin's Law invoked!

    7. Re:Last part a Joke? by skeeto · · Score: 2, Insightful

      That when RMS himself says that Sun is the biggest single corporate contributor to open source.

      I don't remember him wording it quite that way, though. :-P

    8. Re:Last part a Joke? by Anonymous Coward · · Score: 0

      zfs, dtrace

    9. Re:Last part a Joke? by Anonymous Coward · · Score: 0

      Slashdot is not a source of factual information, but a discussion arena. In other words, I don't think credibility means what you think it does.

    10. Re:Last part a Joke? by junglee_iitk · · Score: 1

      Yeah, you are correct. I don't know how to say it though...

      There has to be a word for it and it looks like I almost remember it, but I don't :(

    11. Re:Last part a Joke? by Anonymous Coward · · Score: 0

      I actually tried to find the article (it was reported here on Slashdot)... but could't find it.

    12. Re:Last part a Joke? by Anonymous Coward · · Score: 0

      RMS would never refer to anything as "Open Source".

    13. Re:Last part a Joke? by Anonymous Coward · · Score: 0

      Apparently, Sun, like AOL (Winamp, shoutcast, ICQ, Mozilla), and Microsoft (um ... I'm sure there is something ... msdn is pretty cool?! Wordpad?), can do no right.

      It's interesting to note when two companies with opposite stigmas, say, Apple and Microsoft, do nearly identical actions that one is seen as the coming saviour and the other is seen as some slimey marketting screwball ruining everything...

      So much for independent, objective thought. I suggest against it, unless you are on Propecia and Xanax - because you'll have plenty of reason to when holding ground for well-reasoned, but unpopular ideas (like AOL being generous (run by religious people who are protective by also very giving and fairly hands off on their acquisition model))

      Anyway, good luck!
      -anon

    14. Re:Last part a Joke? by Drantin · · Score: 1

      Slashdot's credibility There are precious few stronger oxymorons...
      --
      Actio personalis moritur cum persona. (Dead men don't sue)
    15. Re:Last part a Joke? by Drantin · · Score: 1

      ...but doesn't mentioning Godwin's law negate it's effect?

      I swear it's like fight club or something...

      --
      Actio personalis moritur cum persona. (Dead men don't sue)
    16. Re:Last part a Joke? by Dahamma · · Score: 1

      ...but doesn't mentioning Godwin's law negate it's effect?

      Yeah, I hope it does if the original post was trying to use a Hitler analogy as a convincing argument...

    17. Re:Last part a Joke? by njcoder · · Score: 1
      Economic impact of open source software on innovation and the competitiveness of the Information and Communication Technologies (ICT) sector in the EU This is a report created for the EU where Sun Microsystems is credited as the largest corporate contributor to open source.

      Table 5 on page 51 shows the breakdown by company for "Cost estimate for FLOSS code contributed by firms"
      Total contribution from firms
      Number of firms 986
      Top contributors
      Rank Name Person-months Cost (mil euro)
      1 sun microsystems inc. 51372 312
      2 ibm corp. 14865 90
      3 red hat corp. 9748 59
      4 silicon graphics corp. 7736 47
      5 sap ag 7493 46
      6 mysql ab 5747 35
      7 netscape communications corp. 5249 32
      8 ximian inc. 4985 30
      9 realnetworks inc 4412 27
      10 At&t 4286 26


      I don't know if RMS ever said anything along the same lines or not.


      MySQL had always been under a dual license and some items were available in the paid version that weren't available in the community edition. From what I've read, the changes being attributed to Sun were in the works before the acquisition.


      Not sure why Sun always gets a bad wrap from the F/OSS community.

  10. Comment by Rinisari · · Score: 5, Informative
    Marten replied already:

    Marten Mickos Says:
    April 16th, 2008 at 17:28:26

    Thanks for all your comments on our business model. I wanted to present here the quick facts around this to avoid misunderstandings:

    In 6.0 there will be native backup functionality in the server available for anyone and all (Community, Enterprise) under GPL.

    Additionally we will develop high-end add-ons (such as encryption, native storage engine-specific drivers) that we will deliver to customers in the MySQL Enterprise product only. We have not yet decided under what licence we will release those add-ons (GPL, some other FOSS licence, and/or commercial).

    Because the main backup functionality goes into the main server under GPL, anyone can of course use the api and build their own add-ons or other modifications.

    Marten
    1. Re:Comment by Anonymous Coward · · Score: 0

      Man, Sun fricking rocks. I love that company!
      Java, netbeans, solaris etc etc
      Man how could I get a job there?

    2. Re:Comment by Ai+Olor-Wile · · Score: 2, Informative

      Sounds like the story may need a "troll" tag!

    3. Re:Comment by Anonymous Coward · · Score: 0

      I'm with you on Solaris... but Java, Netbeans and MySQL are terrible.

    4. Re:Comment by dmsuperman · · Score: 1

      I love how this post has been made, yet the argument continues on as if it had not. I mean, nobody has even replied to this. Just READ IT.

      Can we mod this +15 and attach it to the original article?

      --
      :(){ :|:& };: Go!
  11. Hmmm.... by Tpl2000 · · Score: 1

    Since when could stars code?

    --
    Epic. Just epic.
  12. -1, Flamebait by Anonymous Coward · · Score: 5, Insightful

    Sun has had a very poor history of actually open sourcing anything.

    That's rubbish. The article claiming OpenSolaris isn't really open source bases it on the lack of community and ideology. I'm sorry, but if you want ideology, then it's Free Software you're after, not open source.

    OpenSolaris is definitely open source, and Sun don't have a poor history of open sourcing things. Anybody who says otherwise has an axe to grind.

    1. Re:-1, Flamebait by Rogan's+Heroes · · Score: 1

      I'm sorry, but if you want ideology, then it's Free Software you're after, not open source. But Sun is a patron of the FSF. I guess they want ideology.
    2. Re:-1, Flamebait by Anonymous Coward · · Score: 0

      uuh.. J2ME is the embedded platform version, for phones and the like. Look at the half-assed job you did of researching for this post. Either that or you need to L2grammar.

    3. Re:-1, Flamebait by Anonymous Coward · · Score: 0

      J2ME is the embedded platform version, for phones and the like.
      I know that. I've written code for J2ME. Perhaps you think I meant J2EE? I've never used that so I don't know anything about what it may be licensed with.

      I think you need to be careful about making assumptions about the amount of research I've done. I'm making this post because I've seen the consequences of this in practical terms.
    4. Re:-1, Flamebait by Rogan's+Heroes · · Score: 1
      Except you clearly said that J2ME was a browser plugin.

      The browser plugin (which they recently came out with a new version of, IIRC), J2ME.
    5. Re:-1, Flamebait by mindsuck · · Score: 1

      I believe he meant to quote two different examples of things that aren't open source:
      1. The browser plug-in (which they recently came out with a new version of, IIRC)
      2. J2ME

      Can we move on now?

      --
      --- I w00t, therefore I'm l33t.
    6. Re:-1, Flamebait by Rogan's+Heroes · · Score: 1

      He might have, but his improper grammar leads to it saying something other than what he might mean.

    7. Re:-1, Flamebait by DocHoncho · · Score: 2, Informative
      --
      Celebrity worship is a poor substitute for Deity worship and costs more to boot.
    8. Re:-1, Flamebait by segedunum · · Score: 1

      That's rubbish. The article claiming OpenSolaris isn't really open source bases it on the lack of community and ideology.
      OpenSolaris uses a license that deliberately creates licensing incompatibilities, muddying the waters for developers, and trying to make sure that any contributions you make find their way back to Sun. The (Linux) community has pretty much forced Sun into revamping Solaris completely into something modern, with a half decent package management system and where you actually have virtual consoles in X (and most of that code is GPL or LGPL anyway). The world isn't going to drop other licenses for the CDDL, and many open source licenses have been modified to be happily GPL compatible. IBM did the same thing with its own open source license, and it was totally ignored.

      OpenSolaris is definitely open source, and Sun don't have a poor history of open sourcing things. Anybody who says otherwise has an axe to grind.
      The statement is accurate. Sun has a decent track record of contributing to existing open source projects. It, however, has a poor track record of initiating new open source projects. Trust is based on ethics and actions, not on lines of code though.
    9. Re:-1, Flamebait by Anonymous Coward · · Score: 0

      OpenSolaris uses a license that deliberately creates licensing incompatibilities, muddying the waters for developers

      The same thing can be said for the GPL. Is the GPL not really an open source license?

      trying to make sure that any contributions you make find their way back to Sun.

      The same goes for the Mozilla license. Is that not really an open source license?

      Trust is based on ethics and actions, not on lines of code though.

      Except the allegation was that they have a poor history of open sourcing things, not that they are untrustworthy.

    10. Re:-1, Flamebait by ljgshkg · · Score: 1

      I totally agree with you. In fact, considering the market value of OpenJDK, OpenSolaris, OpenOffice.org etc., not only you can't say they've a poor history of open sourcing softwares, instead, they've a good history of doing so. They're a business, you can't expect them to spend huge cost developing stuff and then disclosing everything to everyone to use. It's not like they're making mySQL close source nor are they goign to stop developing mySQL, they're just adding more "advanced" closed source features for Enterprise. Who knows if they'll put more human resources into it?

    11. Re:-1, Flamebait by eclectus · · Score: 2, Interesting

      Sorry for tirade, but I am so tired of people bashing the CDDL, especially when they are probably using a browser that falls under the license that CDDL was based on. CDDL is nothing more than the Mozilla license with the Mozilla specific stuff removed. If you are going to bash CDDL, then I kindly invite you to remove firefox from your system and start using wget.

      Stepping down from my soapbox now...

      --
      This signature is a waste of 42 characters
    12. Re:-1, Flamebait by essh10151 · · Score: 1

      i've never laughed at xkcd until that link

    13. Re:-1, Flamebait by segedunum · · Score: 1

      especially when they are probably using a browser that falls under the license that CDDL was based on.
      Hmmmmmmm. Why didn't they actually just use the MPL again?

      If you are going to bash CDDL, then I kindly invite you to remove firefox from your system and start using wget.
      No because Mozilla came up with a multi licensing scheme (as of 1.1) that satisfied peoples' desire for compatibility between licenses.
  13. look at the time by Anonymous Coward · · Score: 0

    its time to fork...

  14. Re:Not that I begrudge them a right to make a buck by Mrs.+Grundy · · Score: 2, Insightful

    It's not just going to piss off people relying on MYSQL, it should REALLY piss off the people who with a sense of open source community built it. Is this the new way for business to embrace OSS--to let all the cute little developers work on a project until it is stable and successful and then when the kids have had enough fun let the adults take over and transistion it away from OSS. This is very discouraging.

  15. What the hell? by joe_bruin · · Score: 5, Informative

    Sun has had a very poor history of actually open sourcing anything Yes, let's forget about Java, that was recently GPL'd. Or Open Solaris, including ZFS. Or Open Office. Or OpenSPARC (you can download and implement their latest processors). Or Netbeans (and Forte before that, though it was lousy). Or being a patron of the FSF.

    Those guys are such dicks, they never give the community anything.
    1. Re:What the hell? by jgardner100 · · Score: 1

      or OpenWindows, NFS, Glassfish etc. That would mean they had a history of Open Sourcing dating back more than ten years.

    2. Re:What the hell? by ahankinson · · Score: 2, Funny

      Ok, so other than Java, and Solaris and ZFS and OpenOffice and OpenSparc, Netbeans, NFS, Glassfish or Open Windows, what have the Romans^WSun ever given us?

    3. Re:What the hell? by nrozema · · Score: 1

      Sun has had a very poor history of actually open sourcing anything (!GPL Compatible) != (!Open Source).

    4. Re:What the hell? by jedidiah · · Score: 1

      Java and Solaris aren't great examples since both were opened in response to
      the original projects being eclipsed by CLONES or COMPETITORS.

      --
      A Pirate and a Puritan look the same on a balance sheet.
    5. Re:What the hell? by Anonymous Coward · · Score: 2, Insightful

      The reason is completely irrelevant. And Java is massively popular and hasn't been eclipsed by anything. .NET isn't anywhere close.

    6. Re:What the hell? by fimbulvetr · · Score: 1

      Wine?

    7. Re:What the hell? by Gazzonyx · · Score: 1

      NIS? NIS+? Oh, yeah... I should bring up Sun's "Microsoft Bob" of the directory world; it's probably not helping. :) But I maintain that it is free and I can ransack their code base at this moment if I weren't such a sorry, lazy, excuse for a developer. I say let the admins have the NIS code base.

      Did I miss anyone in my tirade? *Ducks*

      --

      If I mod you up, it doesn't necessarily mean I agree with what you've said, sorry.

    8. Re:What the hell? by shutdown+-p+now · · Score: 3, Insightful

      And Java is massively popular and hasn't been eclipsed by anything. .NET isn't anywhere close.
      Careful there, lest you delude yourself. Yes, Java is still ahead by a sizable margin, but have you seen the trends? .NET is catching up quickly, with Microsoft playing its "one vendor offering integrated solutions for everything" card.

      But hey, it's always good to have some real competition there. At least that way Sun is forced to actually add major new features to Java at a reasonable pace.

    9. Re:What the hell? by eclectus · · Score: 1

      10 years? nfs is closer to 20 years old.

      --
      This signature is a waste of 42 characters
  16. Guess it's not really MySQL any more. by Anonymous Coward · · Score: 0

    Maybe it should be renamed Sun'sSQL.

  17. Sun to Begin Close Sourcing MySQL by brianc · · Score: 5, Funny

    Oh, no they don't. They can't do that to MySQL.

    They can do it to TheirSQL, but not MySQL...

    --


    SIGLOST && SIGUNUSED && SIGQUIT
    1. Re: Sun to Begin Close Sourcing MySQL by teslatug · · Score: 1

      Time for a fork, OurSQL

    2. Re: Sun to Begin Close Sourcing MySQL by RiyazShaikh · · Score: 1

      Doesn't the GPL license allow one to fork open source code, develop your own features and make them closed source? I mean... could I have simply developed my own MySQL "advanced features", not share the code with anyone and sell the features as MySQL-myedition? Why is it any different for Sun?

    3. Re: Sun to Begin Close Sourcing MySQL by Orange+Crush · · Score: 2, Informative

      No. That's the key difference between the GPL and permissive licenses like BSD and MIT. You cannot take GPL code, modify it, and re-release it as a closed source product. The terms of the license explicitly state that you must provide source code with any modified or derived version you distribute.

      *UNLESS* you are the sole copyright holder to the GPLed work and any outside contributors have assigned copyright to you, in which case you can re-release it under whatever license you please (of course, the most recent GPLed version remains in the wild and can be forked by the community).

    4. Re: Sun to Begin Close Sourcing MySQL by Anonymous Coward · · Score: 0

      The GPL is still somewhat permissive - I'm fairly sure it's fine to tinker with and create your own custom versions and keep your modifications proprietary if you don't distribute them. Still, if you're doing that you're sorta missing the whole point of the GPL.

  18. Re:You can't effectively close-source anything GPL by Just+Some+Guy · · Score: 1

    ...because someone with the source will fork it.

    Uh-huh. That's especially likely when almost every contributor to said project works for the company that sells it. Oh, wait, it's not likely at all.

    --
    Dewey, what part of this looks like authorities should be involved?
  19. Re:You can't effectively close-source anything GPL by larry+bagina · · Score: 2, Informative

    Sure, you can fork it, but almost all MySQL development is done by paid MySQL engineers (or paid InnoDB engineers). I think Google might have some engineers working on it, and I think Slashdot/VA Linux/Whatever they're called now might have had 1 at one point. The GCC/EGCS fork worked because most of the developers went with the EGCS. The XFree86/X.org fork worked because most of the developers went with the X.org. Lucid probably spent 250-500k in producing the XEmacs fork. How many other big projects have successfully forked?

    --
    Do you even lift?

    These aren't the 'roids you're looking for.

  20. Re:Not that I begrudge them a right to make a buck by randomnote1 · · Score: 2, Informative

    Thank you for pointing this out. Sun is not close sourcing existing portions of MYSQL. Just adding new features for the customers who will pay an arm and a leg for it. It may not be the smartest move in scoring points with the open source community, but it gives them more leverage with their high end customers.

  21. They are forking the code by spun · · Score: 4, Informative

    Sun will only develop and release certain features in the Enterprise version, specifically relating to online backup, management, and other advanced features. What's in the current version stays in the current version, but they will phase out those features in the community branch. Someone can still port them from the old version, but even then, we won't get the benefit of Sun's new developments.

    --
    - None can love freedom heartily, but good men; the rest love not freedom, but license. -- John Milton
    1. Re:They are forking the code by Chaos+Incarnate · · Score: 2, Informative

      It's not that they're phasing them out of the GPL'd branch; these are new features that were never GPL'd in the first place.

      --
      Benford's Corollary to Clarke's Law: "Any technology distinguishable from magic is insufficiently advanced."
    2. Re:They are forking the code by zotz · · Score: 1

      And so move to fail one of my personal rules of thumb.

      I don't mind too much people who dual license GPL code. I don't like projects which have "enterprise" versions and community versions with different code bases.

      Give better support for your "enterprise" customers, fine. Well, we will see how this works out I guess, but this is just another of Sun's boneheaded moves in my book if this is what they are doing. They have twittered away so much potential and good will over the years with their inability to make up their minds and strongly back Free Software. And the funny thing is, IBM is not necessarily a whole lot better but somehow they seem to manage not to shoot themselves in the foot the way Sun seems to...

      all the best,

      drew
      http://packet-in.org/wiki/index.php?title=Main_Page
      Packet In - net band, libre music, sometimes gratis...

      --
      FreeMusicPush If you want to see more Free Music made, listen to Free
    3. Re:They are forking the code by spun · · Score: 2, Insightful

      It's not that they're phasing them out of the GPL'd branch; these are new features that were never GPL'd in the first place. Ah, well that's not so bad then. Their money, their choice. Plenty of companies do that and we don't generally come down on them.
      --
      - None can love freedom heartily, but good men; the rest love not freedom, but license. -- John Milton
    4. Re:They are forking the code by oliderid · · Score: 1

      Well I hardly consider this as a threat to the GPL nature of MySQL.
      There are already commercial (closed source) products available for this. Nobody has ever complained IMHO.

      Thx for pointing it out.

      Anyway most of the time, MySQL is used as a dumb DB. I mean you simply stores values with an ID, you may tweak indexes, you may carefully design data schemes and all...But seriously most web projects I have work for would hardly use 10% of the MySQL potential (especially concerning the queries)and they can be easily use another DB even lighter.

  22. Can you say... by TheSHAD0W · · Score: 2, Funny

    ...YourSQL?

    1. Re:Can you say... by Anonymous Coward · · Score: 0

      This will be MYSQHELL!

  23. Re:Not that I begrudge them a right to make a buck by Anthony+Boyd · · Score: 4, Insightful

    We do get to keep what we made. If it's under the GPL, we can always fork it into a new Open Source product called OurSQL. It's just that we won't be able to integrate any of their proprietary new features that are NOT under the GPL. But, hey, who needs 'em for that? If Open Source could get it this far, odds are good Open Source can do even more.

  24. Comments from MySQL by martenmickos · · Score: 5, Informative

    Thanks for all the comments on this. We are listening attentively. Let me clarify some facts:

    * The business decision on this was made by MySQL AB (by me as the then CEO) prior to the acquisition by Sun, so this has nothing to do with Sun. On the contrary, Sun is more likely to influence this decision the other way.

    * It is not a quesiton of close sourcing any existing code, nor anything in the core server. Everything we have released under GPL continues to be under GPL, and the core server will always be under GPL (or some other FOSS licence).

    * We will introduce backup functionality for all users (Community and Enterprise) under GPL in version 6.0.

    * Additionally we will develop high-end add-ons (such as encryption, native storage engine-specific drivers) that we will deliver to customers in the MySQL Enterprise product only. We have not yet decided under what licence we will release those add-ons (GPL, some other FOSS licence, and/or commercial).

    * At all times, because the main backup functionality goes into the core server under GPL, anyone can of course use the api and build their own add-ons or other modifications.

    Those are the facts on this. The interesting topic is of course the one of the business model and what the best business model for FOSS software is. I hope to cover that in a separate posting.

    In all of this, you have our undivided continued commitment to providing a fantastic and complete MySQL server under GPL for anyone to download and use. If we for whatever reason would not do that, we would risk losing users to other open source databases or risk seeing a fork of our own product. This is the power of open source.

    Make sense?

    Marten
    previously CEO of MySQL, now SVP at Sun

    1. Re:Comments from MySQL by Chandon+Seldon · · Score: 2, Insightful

      Thanks for posting and clarifying.

      That seems to be basically what the article says too. I wonder if Slashdot editors actually read stories before posting them with flamebait summaries?

      --
      -- The act of censorship is always worse than whatever is being censored. Always.
    2. Re:Comments from MySQL by pembo13 · · Score: 5, Insightful

      If this is true, could the editors please alter the article title accordingly? Or at least point directly to the above comment? These articles get indexed.

      --
      "Thanks for all the money you paid to us. We've used it to buy off ISO among other things" -Microsoft
    3. Re:Comments from MySQL by AmyRose1024 · · Score: 2, Interesting

      I think the article was supposed to scare people. I know some people on /. have a tendency to "stretch the truth" to scare people.

    4. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      Most of these stories wouldn't get read if it wasn't for the sensationalist titles.

    5. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      Assuming this is legit, you have my thanks for posting a reply here at Slashdot.

    6. Re:Comments from MySQL by cynicsreport · · Score: 5, Insightful

      Thanks for all the comments on this. We are listening attentively. Let me clarify some facts:
      .....
      Marten previously CEO of MySQL, now SVP at Sun

      I didn't actually read any of the points - the mere fact that he posted a comment on slashdot proves that Sun is committed to open source.
      When was last time Bill Gates posted a reply on slashdot?
      --
      - Demosthenes
      cynicsreport.com
    7. Re:Comments from MySQL by DAldredge · · Score: 1

      When is the last time CmdrTaco posted a reply on /. ?

    8. Re:Comments from MySQL by Kawahee · · Score: 1
      --
      I'll subscribe to Slashdot when I see a month without a dupe, a typo, or an article the "editors" didn't read.
    9. Re:Comments from MySQL by Orange+Crush · · Score: 1
    10. Re:Comments from MySQL by scribblej · · Score: 5, Funny

      He posts here all the time! You just have to browse at -1...

    11. Re:Comments from MySQL by Jah-Wren+Ryel · · Score: 1

      I didn't actually read any of the points - the mere fact that he posted a comment on slashdot proves that Sun is committed to open source.
      When was last time Bill Gates posted a reply on slashdot? Faulty reasoning. When has Bill Gates ever claimed to be committed to open source?
      If anything, he is committed to the opposite of open source. So why would he post on slashdot?

      If you want to compare apples to apples, a much better question would be:
      "When was the last time Bill Gates posted a reply on MSDN?"
      --
      When information is power, privacy is freedom.
    12. Re:Comments from MySQL by pallmall1 · · Score: 2, Insightful

      Thanks for your post, Marten.

      MySQL has made controversial decisions in the past (such as the SCO deal), but you have always been very straightforward with the open source community about the rationale behind the decisions, and taken the time to address their concerns. Most important, you have always kept your word regarding your commitment to the open source community.

      There are many situations where special extensions are needed by a small or select subset of the general user base (a niche, per se), but would not really be of use to the rest. As long as things like bug-fixes and identical add-on capability (i.e. you can write your own equivalent add ons) remain in the community edition, maybe your business model will work. Perhaps the "secret" recipe for the open-source business model isn't really "secret" at all, and has been staring at everyone all the time -- just be open and honest with the community, and honor your commitments to the same.

      Seems to me like that's what you're doing.

      --
      3 things about computers: they're alive, they're self-aware, and they hate your guts.
    13. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      the mere fact that he posted a comment on slashdot proves that Sun is committed to open source.

      When was last time Bill Gates posted a reply on slashdot? Thankfully politicians haven't been abusing slashdot ... yet. Until they do, you won't hear from him directly, only shills and maybe one or another fanboi.
    14. Re:Comments from MySQL by pirhana · · Score: 1

      Marten,
                    I appreciate your willingness to clarify. But let me suggest you something.
            Why can't you follow the successful business model adopted by redhat ? i.e let everything be GPL. But support is ONLY for paying customers.Which model you think would give you better revenue, market value and *credibility* as a company and product in the long run ? the one (like redhat) where everything is GPLed but support is ONLY for paying customers or the one(followed by MySQL now) in which there is *always* some confusion and complication regarding the license with some portion of it proprietary(later planned to be GPLed ...?). Have you done a serious study on what is the revenue generated by these kind of proprietary add-ons vs the loss of community and credibility for the product ? I doubt Sir. If a small company like Redhat can be successful with GPLed code, why can't someone who is part of SUN ?

    15. Re:Comments from MySQL by hotfireball · · Score: 1

      When was last time Bill Gates posted a reply on slashdot?

      Well, there are two kind of people: one who talk, another who are object of talks...

    16. Re:Comments from MySQL by Kristoph · · Score: 1

      Thank you for taking the time to write a response.

      It is a sad day when slashdot editors becomes first class purveyors of FUD.

      ]{

    17. Re:Comments from MySQL by martenmickos · · Score: 4, Interesting

      Thx. We have considered Red Hat's model carefully, and it may indeed be one that we and others could also adopt to 100%. If we reach that conclusion, we will align our model with theirs.

      But we are not absolutely certain that this is the case, and so we are experimenting with other models. We believe that a DBMS behaves somewhat differently in the market compared to an operating system. We believe that Red Hat's competitive situation is different from ours. And we are not fully convinced that Red Hat gets a fair compensation in the market for their enormous (and great) investments and contributions.

      So for these reasons we continue to test out new models.

      Marten

    18. Re:Comments from MySQL by Kymermosst · · Score: 1, Insightful

      Can you please point me to GPLed Red Hat Network Satellite server srouce code? Despite this article, it doesn't seem very easy to find.

      Thanks!

      --
      "Alcohol, Tobacco, Firearms, and Explosives" should be a convenience store, not a government agency.
    19. Re:Comments from MySQL by pirhana · · Score: 1

      I sincerely appreciate your willingness to listen to others ; I really do .

      >Thx. We have considered Red Hat's model carefully, and it may indeed be one that we and others could also adopt to 100%. If we reach that conclusion, we will align our model with theirs.

      I really wish for that.

      >But we are not absolutely certain that this is the case, and so we are experimenting with other models. We believe that a DBMS behaves somewhat differently in the market compared to an operating system.

      I would be more than happy if you could explain further upon this. And as far as I remember, operating system is not the only one redhat doing. In fact I myself had subscribed so many RHEL license for running mysql cluster on top of RHEL. I went for support/subscription because of some company requirements. If subscription from you for mysql cluster was an option (at that time), I would have definitely opted for that.

      > We believe that Red Hat's competitive situation is different from ours. And we are not fully convinced that Red Hat gets a fair compensation in the market for their enormous (and great) investments and contributions.

      Isn't it fair enough that a company with less than 200 developers (or even lesser) can compete successfully with world's largest software companies ?

      I repeat marten, you please do a study on the revenue generated by this proprietary add-ons vs the loss of whatever incurred by the same.Specifically, the role a fully GPLed mysql solution would play in SUN's complete solution stack. I am sure you would lean towards the Redhat model.

    20. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      We love you, too, Sunshine.

    21. Re:Comments from MySQL by Anonymous Coward · · Score: 1, Funny

      "When was last time Bill Gates posted a reply on slashdot?"

      I do all the time

    22. Re:Comments from MySQL by jimicus · · Score: 1

      Thank you.

      Not many companies the size of Sun would even have let you post a rebuttal on /. in the first place - though I daresay SVP in your job title doesn't hurt.

      TBH, I think most of the commenters realised that someone was on the wacky baccy with the note in the summary saying "Sun has had a very poor history of actually open sourcing anything."

    23. Re:Comments from MySQL by danskal · · Score: 1

      ... could the editors please alter the article title accordingly? ... These articles get indexed. I second that.... I would go as far as to say as the summary is slander. If it was my company, and I had a lawyer on staff, I would look into the option of suing.

      I don't want to compliment digg, but they at least have a "mark as inaccurate" feature, which maybe slashdot should look into.
    24. Re:Comments from MySQL by LarsWestergren · · Score: 1

      If this is true, could the editors please alter the article title accordingly? Or at least point directly to the above comment?

      Nah, the Slashdot editors (and most of the readers) have never let facts get in the way of a little good ol' Java or Sun bashing, so don't expect them to start now.

      --

      Being bitter is drinking poison and hoping someone else will die

    25. Re:Comments from MySQL by vague+disclaimer · · Score: 1

      Surely that's -666 ?

    26. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      You've just lost one to Postgres.

      I hope you really -are- listening, because I expect you're about to lose a lot more.

    27. Re:Comments from MySQL by Constantine+XVI · · Score: 1

      So you're saying that Slashdot was sold to News Corp. while I was frozen?

      INCONCEIVABLE!

      --
      "I think an etch-a-sketch with an ethernet port would beat IE7 in web standards compliance."
    28. Re:Comments from MySQL by martenmickos · · Score: 2, Interesting

      Thx. Some more comments on the differences I referred to earlier:

      I believe that customers using operating systems will mostly want the latest updates and patches, so on-going support (or subscription) is vital to the the well-being of the installation. But with databases, customers typically want to avoid updates unless they absolutely need them. For this reason I believe that selling a support program (only) to database customers may not be as good a business as doing it to operating system customers.

      Another point worth making is that the business model decisions we make are based not so much on what end-customers should or should not be able to do, but what competitors should or should not be able to do.

      An example: the MySQL brand and trademark is owned by us. We don't mind if end-customers say "I am running on MySQL" but we do mind if a vendor names a product "MySQL XYZ" without our permission. In the latter case there is a risk that end-customers would get confused by the naming. They may think the XYZ product comes from the MySQL company when in reality it doesn't. So we use our ownership of the trademark more to govern what vendors can do than what customers can do.

      Similarly with what is here being discussed - the advanced add-ons for backup that in 6.0 will be distributed in MySQL Enterprise only to paying customers (whereas core online backup will be available to everyone) - we want to make sure that *we* get to decide who can sell and ship such a complete subscription offering to customers.

      But then also, all this time we will continue to deliver a fully GPLd MySQL database server that provides tremendous value to users and customers alike. We will continue to compete for the hearts and minds of developers and users who pay us nothing. That ambition has not gone anywhere. If anything, it has grown, and you will see MySQL as part of many different stacks under the GPL licence.

      We just think that we also must have a way of making money with customers who have serious mission-critical production deployments of MySQL. Of course such customers will not be forced to buy anything from us. They can probably manage without the subscription service, they can build the additional features themselves, they can commission someone else to build them, and they can buy them from any of our partners and competitors who also provide such functionality or service.

      So for these reasons I believe that there is no serious downside either for our users or our customers.

      But time will tell, as noted, and we will be ready to make changes to our business model as we learn more about how this works.

      Thanks again for your comments.

      Marten

    29. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      Yes, it does make sense. You're exploiting the open source community to create the "base" for your product, and then creating addons that provide enterprise-class features...so long as you cough up the cash. It makes a lot of sense, actually, and I'm sure it'll make you some money, too.

      Myself, I'll be switching to PostgreSQL and not looking back at the mess that you and Sun have created. I'll bet I won't be the only one.

    30. Re:Comments from MySQL by pirhana · · Score: 1

      Thanx indeed for your patience. I do understand that you have put serious thoughts in to the issues I have raised ; but let me clarify on certain points.

      >I believe that customers using operating systems will mostly want the latest updates and patches, so on-going support (or subscription) is vital to the the well-being of the installation. But with databases, customers typically want to avoid updates unless they absolutely need them. For this reason I believe that selling a support program (only) to database customers may not be as good a business as doing it to operating system customers.

      Let me disagree with you on this. I do agree that customers/sys admins don't like to patch/update DB server on an ongoing basis as much as they do with OS. BUT, DB server is the most critical for any organization and they would like to run some hardware/software combination which is CERTIFIED. Because of this reason they are more likely to be paid customer for DB server/software. One e.g I have about 40-50 Linux servers all of which are CentOS except half a dozen RHEL servers which are DB servers(Actually MySQL). Because on DB we want some certified and officially supported software/hardware.

      > An example: the MySQL brand and trademark is owned by us. We don't mind if end-customers say "I am running on MySQL" but we do mind if a vendor names a product "MySQL XYZ" without our permission. In the latter case there is a risk that end-customers would get confused by the naming. They may think the XYZ product comes from the MySQL company when in reality it doesn't. So we use our ownership of the trademark more to govern what vendors can do than what customers can do.

      Absolutely ; but if you are bold/confident/capable , then you cannot be beaten by competitors. GPLing will not make you any more vulnerable. One example. Have you ever thought why Oracle Linux initiative has been such a disaster ? How has Redhat become immune to such competition ?

      A couple of points more,

      Can you point out a single "open source(tm)" company which has established a successful business and credibility with such a hybrid model like you in the long run? I can point out atleast one company which is successful with pure GPL code (redhat)

      There are many companies like HP who sell support for Linux and make good money out of it. They infact charge much more than linux vendors. Still people go to them because of the complete stack (HP hardware/HP supported Linux). Why can't SUN come up with such a stack ?

    31. Re:Comments from MySQL by martenmickos · · Score: 1

      Thx. I think your points are valid and make sense in some portion of the universe. The difficulty is knowing to what extent. If they are valid to the largest extent, then you are correct and we (when we realise this) will follow your advice.

      Until then we will continue to experiment. You are right that there is no other example larger than MySQL than Red Hat. But I am not ready to think that we have explored all useful avenues and should settle on what we have today. I am ready to experiment.

      My experience tells me that by experimenting, new innovations will emerge. It may not be the innovation you thought you were creating - it may be something else. I love this quote by Arthur Schopenhauer in this regard: "The alchemists in their search for gold discovered many other things of greater value."

      Marten

    32. Re:Comments from MySQL by martenmickos · · Score: 1

      Some more detailed answers to your questions:

      * On the support issue, I think there are customers of all types - both the type you describe and the one I described.

      * As for Red Hat's immunity to distro clones, I am not sure we know the result yet. It indeed seems that Red Hat is immune, but can we be certain after only a year or two?

      * As for the stack, Sun can certainly create such a stack, as can other vendors. And will, I'd say. I see that as an orthogonal issue - i.e. stacks can be created and will be created nevertheless. Our business model decision doesn't (in my mind) affect stacks much.

      But I can of course be wrong.

      Marten

    33. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      Yes, if you're going to drag Sun's name through the mud with a totally inaccurate article, please have the decency to correct it. Especially when you have the CEO of MySQL explaining the situation to you.

      I don't know why I'm bothering to post, Slashdot is all about inflammatory subject lines with no factual basis at all. I guess that gets people to read the articles, gets them more clicks, and more money.

      The MySQL CEO also responded directly to the blog (in the blog comments), but I don't suppose anyone noticed that.

      Yes, I work at Sun, on OPEN SOURCE software that people use freely.

    34. Re:Comments from MySQL by pirhana · · Score: 1

      Thanx again for the insightful comments,

      > * On the support issue, I think there are customers of all types - both the type you describe and the one I described.

      Yes indeed. Thats why I say you need to do deeper analysis and study

      > * As for Red Hat's immunity to distro clones, I am not sure we know the result yet. It indeed seems that Red Hat is immune, but can we be certain after only a year or two?

      They are immune and successful so far and would be in the near future IMHO. But in the long term future ...? I dont think so . In fact I dont think any of the business model currently practiced (including pure proprietary ones) would be successful as everything in IT field is getting commoditised.

      > * As for the stack, Sun can certainly create such a stack, as can other vendors. And will, I'd say. I see that as an orthogonal issue - i.e. stacks can be created and will be created nevertheless. Our business model decision doesn't (in my mind) affect stacks much.

      But their current stack( Solaris/Linux/Java/Netbeans) is open source(at least likely to be so in near future). An open source(without tags) DB server would be a perfect fit to this than one with a proprietary add-ons. Also, as everything is getting commoditised and open sourced, I think companies with better service would excel over the competitors. IBM has sort of realized this I believe.

      One final word, changing the license model often spoil your credibility a lot, as a company and as a product.

    35. Re:Comments from MySQL by martenmickos · · Score: 1

      Yep (on the stack), but note that MySQL is open source as well, and will continue to be so.

      What we are talking about are pluggable additions that we will ship to subscription customers only. But we have not yet decided on the licensing for such pluggable additions. We may choose a commercial licence, but we may also choose the GPL. In the latter scenario the code would be free and open source software, but we as the product vendor would deliver it only to paying customers. That's how Red Hat does it as well.

      Whichever licensing we end up choosing, there will always be a fully functional GPLd MySQL server that can be put in a variety of stacks.

      Yes, there is a risk of harm to our credibility as we experiment with the business model and potentially make licensing changes. This is why we don't do these decisions lightly. At the same time we feel we just must continue to innovate and to question the status quo.

      We will inevitably upset some people, but we may also win new friends. We must make sure that we don't let our operations be subjected to the tyranny of a vocal minority, many of whom have not produced GPL code or built an open source product themselves. They are important community members and we listen carefully to their input. But we must know that it is always easier to criticise what someone else is doing than doing something oneself or having a concrete and constructive counter-proposal.

      You, however, have presented good constructive proposals in your postings here, and I am very thankful for them. Perhaps it turns out that you are exactly right and we should follow your advice. Time will tell. And again this is a demonstration of the power of open source: solutions are scrutinised in public and opinions can be expressed freely. In the long run, that leads to the best outcome for all.

      Marten

    36. Re:Comments from MySQL by mjasay · · Score: 1

      And a Java-based application (like a content management system) behaves even more differently, yet a Red Hat-esque model has worked for Alfresco. It's possible that it will stall over time but that's where building in additional value around the core product becomes important. Happy experimenting!

    37. Re:Comments from MySQL by headLITE · · Score: 1

      I'm sorry, but you're a bit off here.

      There is no exploitation of the open source community going on here. There is no measurable contribution to the MySQL code base from the community. 99.99% of all work on it is done by the 400+ employees that MySQL AB had when it was acquired. Sun would possibly even like free developers that they could exploit, but there aren't really any. For almost any person in the OSS community, MySQL being available under the terms of the GPL *only* means that they can use it for free, ignoring some small-scale projects like Google Summer of Code for simplicity.

      If you're looking for companies that exploit OSS developers, look at the Postgres based commercial database offers. Postgres is licensed under the BSD licensing terms, which allows companies to basically use the source with almost no obligations (and none that have any business relevance). There are quite a number that are doing this, see Greenplum, EnterpriseDB etc.

    38. Re:Comments from MySQL by Anonymous Coward · · Score: 0

      I notice that you completely ignore any comments that are critical of said "model," but are happy to answer the positive ones.

      Interesting.

    39. Re:Comments from MySQL by Ice+Station+Zebra · · Score: 1

      You may have troll rated this comment, but given that I have 20+ years of experience with sql databases, I speak the truth.

    40. Re:Comments from MySQL by Ohrion · · Score: 1

      I have to say, this is probably the best conversation I've read on Slashdot in a LONG time! It's nice to see vendors and users communicating in an honest and open manner while actually listening. Thanks!

    41. Re:Comments from MySQL by martenmickos · · Score: 1

      Thank you!

      In my experience there seems on the surface to be a lot of noise on Slashdot discussions, but you do find plenty of of signal once you focus on a real topic with slashdotters with insightful comments.

      Marten

  25. Re:You can't effectively close-source anything GPL by smellotron · · Score: 1

    Now the masses will turn somewhere else for high-quality FOSS SQL...

    You mean like Postgres? (^:

  26. Comment removed by account_deleted · · Score: 2, Insightful

    Comment removed based on user account deletion

  27. Best not to worry about forking by pembo13 · · Score: 0, Flamebait

    I like MySQL, I have no real issues with it. But if it's going closed source, I say let it be. Time to put energy behind Postgresql

    --
    "Thanks for all the money you paid to us. We've used it to buy off ISO among other things" -Microsoft
  28. Noooo!! (MySQL 1995-2008) by Bushido+Hacks · · Score: 0, Flamebait

    MySQL was outstanding. At least in my opinion. Where Oracle took 2 GB of space to download then had to be burned to a CD, MySQL was a lightweight, straight-forward relational database managment system.

    Closing off MySQL will have serious consequences for PHP and C developers since SUN will rewrite the entire MySQL API strictly in Java.

    Perhaps now would be a good time to migrate to PostgreSQL.

    Goodbye MySQL. :-(

    --
    The Rapture is NOT an exit strategy.
    1. Re:Noooo!! (MySQL 1995-2008) by autocracy · · Score: 1

      What hat did you pull those ideas out of?

      --
      SIG: HUP
    2. Re:Noooo!! (MySQL 1995-2008) by Samah · · Score: 1

      > Where Oracle took 2 GB of space to download then had to be burned to a CD, MySQL was a lightweight, straight-forward relational database managment system.
      You've nailed it right there--MySQL is lightweight and straight-forward. You seem to be neglecting the fact that Oracle is not intended to be lightweight. Its enormous feature set and bulk requires a lot of configuration and thus generally requires an experienced Oracle DBA to manage it.
      I'm not disagreeing with you re: MySQL, just that I think your comparison is a little unfair in this case. If you don't need any of the things Oracle has that MySQL doesn't (yet), MySQL is obviously your best choice. Sorry I can't comment on PostgreSQL as I've never used it (might do so soon though).

      Disclosure: I use Oracle every day at work; I only use MySQL for home projects.

      --
      Homonyms are fun!
      You're driving your car, but they're riding their bikes there.
  29. Re:You can't effectively close-source anything GPL by SL+Baur · · Score: 3, Informative

    The GCC/EGCS fork worked because most of the developers went with the EGCS. That fork worked because the GCC mainline was dead *and* the people doing all the real work were the ones who created EGCS. Indeed, what is now called "GCC" is the offspring of EGCS, the orignal GCC was killed.

    No comment regarding XFree86/Xorg.

    No comment regarding the Emacs/XEmacs fork, except to point out that there was an earlier fork called Epoch made in the version 18 days and that didn't go anywhere. I used it for a time in 1990 and preferred it to straight Emacs 18.

    The only other major fork I can think of would be the *BSD forks, Open, Net and Free.

    Successful forking is very rare and requires a truly dedicated developer community or large corporate backing to pull it off. Out of the few examples listed one of them was not a fork at all, but a coup and resulted in the death of the parent.
  30. -1, Flamebait NOT: Prod Solaris is NOT opensource. by gd23ka · · Score: 1

    Actually it's true. So I can get the OpenSolaris sources... yay! Great. But what I really need is the
    sources to the Solaris I'm actually running. So no, it's not really open source because we're not running here
    some eternal Beta like OpenSolaris but production Solaris. I want the exact source that reflects the
    patch level on the system. Where can I get that?!

  31. MySQL & FOSS by martenmickos · · Score: 5, Insightful

    All,

    I tried to clarify the facts in another posting a moment ago: http://developers.slashdot.org/comments.pl?sid=525246&cid=23098626

    Here I will discuss the business model considerations, MySQL's commitment to Free and Open Source Software (FOSS), and why we made the decision we made.

    First and foremost: we at MySQL firmly believe that open source is a superior way of producing software. You get better quality faster, and you often get better innovation too.

    So it is not lightly that we have decided a few times to produce non-open software, such as the MySQL Monitor introduced some years ago. So why do we do that?

    The reason is that we have an ambition not only to produce FOSS code, but also to be a profitable business that can exist for a long time. Each time we make more money, we hire more developers to develop GPL code.

    If the world were perfect, we would only produce GPL code and we would have a great business that cna fund the software development. But we have found that the world is not perfect. We have been experimenting with a variety of business models around FOSS (dual licensing, support only, simple subscriptions, different binaries for community and enterprise, non-open source features) to find the best one. And we will continue to experiment until we are satisfied. We need to find a model that allows us to produce a ton of great code under GPL while having the financial strength to do all this.

    To get to this goal of ours, we believe we have to be more pragmatic than dogmatic. Call it a necessary evil if you like. Having production add-ons that we provide only to paying customers currently seems to use to be a useful model. Our partners and customers think it is great. Many users think it is great. But not all do (as evident from this thread on /.). I would hope we could please all, but I am afraid we cannot.

    In all of this - i.e. as we experiment with open source business models (as there aren't really any role models bigger than ourselves that we could learn from) - we remain fully committed to producing the core database server always under the GPL (or some other approved FOSS licence).

    In this work, we feel we have been able to produce enormous benefits to the world in the form of GPL software. The MySQL server could not have evolved as much as it did (not that I am saying it has evolved perfectly) if we hadn't had a revenue stream to fund the hiring of developers and others. We have open sourced MySQL Cluster which was an advanced closed-source database engine at Ericsson. We open sourced the Falcon storage engine.

    I can appreciate that many of you are upset with our decisions. It has happened before that the community has been upset with us. But I hope that you can see that

    * we are trying to be fully open and transparent with our decision-making in these areas

    * we have a full commitment to produce the core MySQL server under GPL

    * we are actively listening to your input

    We can probably not please all, but you should know that we are trying to serve our community. We are immensely thankful for all the support and contributions that we have received in our 13-year history. We are hoping that we are good stewards of the MySQL phenomenon, and we hope that you can come to terms with the fact that we find revenue generation a vital part of our mission.

    We may not have come up with the perfect business model yet (and perhaps the decision that is here being debated was utterly stupid), but we are determined to continue to seek the perfect business model for open source software so that we can continue to exist and be strong, and so that other software entrepreneurs can learn from our successes and mistakes.

    Finally, please note that this entire decision and reasoning is something we developed on our own at MySQL AB several months ago, before being acquired by Sun. Sun has not asked us to do this or that. Or in fact, Sun has asked us the opposite - i.e. whether we should not

    1. Re:MySQL & FOSS by GumphMaster · · Score: 1

      Thank you for taking the time to explain the MySQL AB rationale. Perfectly sane to my eyes.

      --
      Patent litigation: A doctrine of Mutually Assured Destruction... in which everyone seems willing to push the button
    2. Re:MySQL & FOSS by rainhill · · Score: 1

      This is not one of your best moves, especially at a time everyone is watching you due to Sun buyout.

      dual licensing? - fine!
      some code closed for payers? - not fine!

      why? coz we, the average IT guy got the impression that we will not be seeing some new cool code as you will be closing it.

      don't turn your back to the people who made you so popular so that you can get $1b paycheck from Sun.

      comeon guys..
      regards from my basement..

    3. Re:MySQL & FOSS by Orion+Blastar · · Score: 4, Interesting

      Of course open source licenses allow for some code and features to be released from the open source license by paying off the developers who developed the code and having them sign a contract. In that way their open source developments pay off and they can finally earn an income for their hard work.

      What the community doesn't seem to get is that this is basically creating two versions of the same product. One open sourced and one closed source. It is basically forking off a closed source version and paying off developers to release it so they are finally paid for their hard work and years dedicated to writing code. Just that the open source version now doesn't have the same code and features as the new closed source version has. But that wouldn't stop open source developers from writing new code to put features back in the open source version. As long as it doesn't use source code from the closed source fork of it. For example this was done to WINE to create Crossover Office, WINEX/Cediga, et all. Also Red Hat Enterprise is different from Red Hat Fedora. Just that one version went commercial and the other went open source.

      As an open source developer you actually want this to happen, so that all of your hard work is paid off finally. You want a company to buy out your work and pay you for it eventually. That doesn't make you selfish and it doesn't make you greedy either. I mean you spend years supporting the open source community for free and writing a lot of code without even being paid for it. So they really can't say you haven't given anything to the open source community. While people jokingly call open source developers as communists or hippies, in reality they are capitalists at heart. In the end they want equal pay for equal work. Open source projects are a good way to market their skills and show off their coding abilities and ability to work in a team. Plus it gives back to the community in free software. But the time will come eventually when some company decides the project is good enough to license and use in a commercial project so they sell their rights to it for money. Most of the time that doesn't happen and it continues to be unsupported and open source developers have friends and family members wondering if they are insane, doing all of that hard work for free and it looks like they are throwing away money or flushing it down the toilet.

      There will still be an open source version of MySQL, just that parts of it got spun off into a closed source commercial version. I did a lot of research into open source business plans myself in college. You try to earn money via charging for tech support or donations, failing that you try to get some company like Sun to buy your code and pay off your developers to release the code from open source. But some open source companies sell t-shirts and stuffed animals and other stuff. Any way you look at it, it is still capitalism and still a company trying to earn a profit. You still have stock holders who want a return on their investments. You still have employees that expect a paycheck. It may be free software, but people aren't really writing it for free, they expect a payoff sooner or later.

      --
      Remember, Slashdot does not have a -1 disagree moderation, and no, troll, flamebait, and overrated are not substitutes.
    4. Re:MySQL & FOSS by Improv · · Score: 1

      The decision makes sense, but to the extent that MySQL depends on geek mindshare, it will suffer. MySQL's interests and those of the open source community may not be precisely the same, and the community has no assurances that whatever closeness there is between our interests and those of MySQL AB will remain.

      --
      For every problem, there is at least one solution that is simple, neat, and wrong.
    5. Re:MySQL & FOSS by Saint+Aardvark · · Score: 1

      Thanks very much for taking the time to respond. I appreciate your taking the time to do so.

    6. Re:MySQL & FOSS by RevRa · · Score: 1

      Now kindly get off my lawn. /I've been saying that Sun supports Open Source more than other companies for years. It's nice to finally see someone with some authority at Sun (even if only as of late) say so here on slashdot.

      --
      - Kate
      "DNA is life. The rest is just translation."
    7. Re:MySQL & FOSS by pallmall1 · · Score: 1

      Thank you for taking the time to explain the MySQL AB rationale. Perfectly sane to my eyes.
      You have good eyes.

      Marten, I would like to also thank you for your informative posts. Even though I use postgresql (I need the postgis extensions), I think that MySQL is on the right track with it's business model development.
      --
      3 things about computers: they're alive, they're self-aware, and they hate your guts.
    8. Re:MySQL & FOSS by Alpha830RulZ · · Score: 1

      Martin,

      I advise my clients that MySQL is a reasonable option for their data warehouses on a weekly basis. Your decision does not make me question that advice. I can appreciate your stance, and generally enjoy using your product.

      --
      I was taught to respect my elders. The trouble is, it's getting harder and harder to find some.
    9. Re:MySQL & FOSS by mabinogi · · Score: 1

      MySQL depends on one thing, and one thing only - Hosting providers.
      If it weren't for the fact that it was pretty much universally provided by hosting providers it wouldn't have reached anywhere near the popularity it has today. The same goes for PHP.
      PostgreSQL has always had the geek mindshare.

      --
      Advanced users are users too!
    10. Re:MySQL & FOSS by Anonymous Coward · · Score: 0

      All,

      I tried to clarify the facts in another posting a moment ago: http://developers.slashdot.org/comments.pl?sid=525246&cid=23098626

      Here I will discuss the business model considerations, MySQL's commitment to Free and Open Source Software (FOSS), and why we made the decision we made.

      First and foremost: we at MySQL firmly believe that open source is a superior way of producing software. You get better quality faster, and you often get better innovation too.

      So it is not lightly that we have decided a few times to produce non-open software, such as the MySQL Monitor introduced some years ago. So why do we do that?

      The reason is that we have an ambition not only to produce FOSS code, but also to be a profitable business that can exist for a long time. Each time we make more money, we hire more developers to develop GPL code.

      If the world were perfect, we would only produce GPL code and we would have a great business that cna fund the software development. But we have found that the world is not perfect. We have been experimenting with a variety of business models around FOSS (dual licensing, support only, simple subscriptions, different binaries for community and enterprise, non-open source features) to find the best one. And we will continue to experiment until we are satisfied. We need to find a model that allows us to produce a ton of great code under GPL while having the financial strength to do all this.

      To get to this goal of ours, we believe we have to be more pragmatic than dogmatic. Call it a necessary evil if you like. Having production add-ons that we provide only to paying customers currently seems to use to be a useful model. Our partners and customers think it is great. Many users think it is great. But not all do (as evident from this thread on /.). I would hope we could please all, but I am afraid we cannot.

      In all of this - i.e. as we experiment with open source business models (as there aren't really any role models bigger than ourselves that we could learn from) - we remain fully committed to producing the core database server always under the GPL (or some other approved FOSS licence).

      In this work, we feel we have been able to produce enormous benefits to the world in the form of GPL software. The MySQL server could not have evolved as much as it did (not that I am saying it has evolved perfectly) if we hadn't had a revenue stream to fund the hiring of developers and others. We have open sourced MySQL Cluster which was an advanced closed-source database engine at Ericsson. We open sourced the Falcon storage engine.

      I can appreciate that many of you are upset with our decisions. It has happened before that the community has been upset with us. But I hope that you can see that

      * we are trying to be fully open and transparent with our decision-making in these areas

      * we have a full commitment to produce the core MySQL server under GPL

      * we are actively listening to your input

      We can probably not please all, but you should know that we are trying to serve our community. We are immensely thankful for all the support and contributions that we have received in our 13-year history. We are hoping that we are good stewards of the MySQL phenomenon, and we hope that you can come to terms with the fact that we find revenue generation a vital part of our mission.

      We may not have come up with the perfect business model yet (and perhaps the decision that is here being debated was utterly stupid), but we are determined to continue to seek the perfect business model for open source software so that we can continue to exist and be strong, and so that other software entrepreneurs can learn from our successes and mistakes.

      Finally, please note that this entire decision and reasoning is something we developed on our own at MySQL AB several months ago, before being acquired by Sun. Sun has not asked us to do this or that. Or in fact, Sun has asked us the opposite - i.e.

    11. Re:MySQL & FOSS by Per+Wigren · · Score: 1

      So, when will the default global SQL-mode setting be STRICT_TRANS_TABLES, STRICT_ALL_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_AUTO_VALUE_ON_ZERO, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, ANSI_QUOTES ?

      I really like MySQL's cluster/replication features but I'm having a hard time taking it seriously until the above is the default setting, combined with having the Falcon engine as the default one.

      --
      My other account has a 3-digit UID.
    12. Re:MySQL & FOSS by Anonymous Coward · · Score: 0

      eh, whatever, I still prefer Postgres.

    13. Re:MySQL & FOSS by Anonymous Coward · · Score: 0

      Yeah... I'm listening... but this is Slashdot, so all I heard was...

      "We hate you and want to be like Microsoft."

    14. Re:MySQL & FOSS by Squeeself · · Score: 1

      Sun just got major kudos in my book for not only responding to this Slashdot article, but responding in the comments. There's not much more evidence you can provide that they are listening than this...especially with the Slashdot crowd. Now, can someone please fix this summary? FUD should only come from Microsoft articles, am I right?

    15. Re:MySQL & FOSS by wrook · · Score: 1

      I'm going to have to disagree with you to a certain extent. As an open source developer, *I* don't want a company buying my code and close sourcing additional features. Certainly it is possible to make money this way, but it would not be my preferred method.

      Instead my preferred method would be to get people to *pay for* my development and still have it open sourced. In other words, don't write a loss leader and hope that somebody will pay you at the back end. Find customers who want solutions and are willing to pay you to deliver them.

      I have always thought that MySQL is well positioned to make money doing things this way. And now being part of Sun they have access to marketing resources that they probably didn't have before. Many large companies require advanced features and should be willing to pay for development if it is shown that it is cheaper than doing it themselves.

      The closed source model is interesting in that it allows you to spread the cost of development around. But it is intrinsically risky because it forces you to guess what your customers will want (rather than working closely with them to create a custom solution).

      I guess I find it a little difficult to believe that they can't find enough people willing to give them work to sustain development (in much the same way that Cygnus did with GCC) and still make a good profit. I suspect (and please correct me if I'm wrong!) that it's more a matter of being willing to take the risk in order to hopefully get a big payoff in the future.

    16. Re:MySQL & FOSS by Rich0 · · Score: 1

      First - I like the innovative approach MySQL is taking with dual-licensing/etc. I think that sustainable approaches to Open Source are something that are underexplored.

      The only downside to this is what I might call the Norton-factor from the days of DOS/Win95/etc:

      Microsoft releases product lacking key critical features. Microsoft works with 3rd-party partners to overcome these lacks of features (undelete, defrag, disk repair, registry cleanup, etc). 3rd party becomes entrenched and Microsoft doesn't want to upset them, so they license stripped-down versions of the 3rd party code and never change their software design to avoid needing the 3rd party tools in the first place (journaled filesystems, robust undelete, no rats-nest registries, self-defragging filesystems, etc). Microsoft has tended to see the error of its ways and WinXP is generally free of stuff like Stacker/ RamDoubler/ PC-Tools/ Norton/ etc.

      When a new feature truly is a significant value-add I think that treating it as a separate closed-source product is appropriate. When a new feature is really just making something work correctly that ought to just work, I think we're starting to drift into some mistakes that others have made before.

      In the post you just made the one that stands out to me is the Monitor tool. I've sat and looked at PHPMyadmin at all the red fields that tell me that something non-ideal is going on. I'm told that I have queries that aren't using indexed joins. Unfortunately, I have thousands of queries running every day from about 5 different programs, and figuring out which ones are the culprits aren't easy. I can look at the slow-query log and find out what some real monsters are, but often those can't be improved significantly (tons of functions in the SQL - short of a significant app design change not much would happen and this isn't my app), and they don't run often anyway. I don't mind taking the time to run EXPLAIN on my queries, but sometimes it is hard to tell if there is some frequent query running that could be optimized. I think that MySQL monitoring is perhaps a little deficient, and the existence of a separate monitoring tool obviously doesn't help there. Perhaps there should be some improvements to the community monitoring tool, or maybe just better documentation around how to go about doing monitoring manually. I'm fine with the paying customers getting first attention - just try to avoid repeating MS's past mistakes (from which I think even they have learned).

    17. Re:MySQL & FOSS by Anonymous Coward · · Score: 0

      Hi,

      Why can't the model of MySQL work as a simple source release + support only model for paying customers?

      I feel that many corporations pay mainly for support.

    18. Re:MySQL & FOSS by martenmickos · · Score: 1

      Thanks! I will ask our MySQL Monitor team to look into your suggestions.

      Marten

    19. Re:MySQL & FOSS by Anonymous Coward · · Score: 0

      Hi Marten,
                      While I agree the code is yours and you can do ANYTHING you want, still closed source forces the end user(no matter what competance() to run ONLY on the OS of YOUR choice not theirs.

      In my case that OS of choice is OpenBSD, an OS that is NOT officially supported by MySQL, so I get to run 3rd party products instead of MySQL Monitor, which I happily would have BOUGHT had it been a supported product for my OS with source included.

      In this case Closed source products actually COST you at least the income from a sale(s) to my corp.

            I am sure I am NOT the only would be customer who feels this way.

                anon

    20. Re:MySQL & FOSS by Anonymous Coward · · Score: 0

      Marten,

      thank you very much for clearing and clarifying all the mess and FUD that has grown around your decision. Some of your theses are just some political and PR-ish, but I believe in you.

    21. Re:MySQL & FOSS by Margrave · · Score: 1

      Hmm, It is good that you are actively listening. Perhaps a forum, on the web, for you to communicate with your supporting community, where you could outline your objectives and ask for experimental ideas and engage them in evaluating the results, yes, perhaps that would convince me you were listening actively. Besides convincing me, albeit an onerous task, it might just bring out an idea that results in a win-win. With tongues wagging in a vacuum of information, what we have is a lose/lose.

    22. Re:MySQL & FOSS by hackus · · Score: 1

      First of all, to end your message with a tongue and cheek response of "let me know if you find a better business model", is the worse ending in hubris I have ever seen.

      Do you honestly expect open source community members to accept that ludicrous excuse? The community did not put the company up for sale and now that you did, your looking for US to fix this major gaffe on your part?

      Secondly, this move is fundamentally against what built MySQL in the first place. It is with a total disregard for the validity of peer review, the cornerstone of what makes well engineered software better than commercial software in the open source world, that personally got me upset as a end user.

      I can only image what this is doing to the developers.

      PostGRES anyone?

      It would have been better if you would have not responded as it just makes it that much more infuriating.

      -Hack

      --
      Got Geometrodynamics? Awe, too hard to figure out? Too bad.
  32. Re:Not that I begrudge them a right to make a buck by jocknerd · · Score: 2, Interesting

    Correct me if I'm wrong, but I don't think MySQL ever had an open source developer community. It was developed by a company and released as an open source product. Unlike PostgreSQL, which really is developed by a community of developers.

  33. GPL facts by WarJolt · · Score: 1

    With Oracle owning Innodb, and it being GPL, does this mean that MySQL will be removing it to introduce these features? The article only mentioned backup features. Maybe there is more features, but for MySQL online backups can be accomplished by daemons that aren't linked to MySQL in any way. GPL'ed and non-GPL'ed applications can legally communicate through pipes or sockets.
  34. Is anyone actually reading TFA? by FliesLikeABrick · · Score: 5, Insightful

    Looking at the actual link, this is talking about select _new_ features. The /. summary clearly is trying to scare us all into thinking that existing parts of MySQL would somehow be turned into a closed-source product.

    Talk about someone trying to be misleading...

  35. Re:You can't effectively close-source anything GPL by Anonymous Coward · · Score: 0

    MySQL is hardly high quality.

  36. Slasdot: useless. Commenters: the REAL story. by Anonymous Coward · · Score: 0

    I love how you can basically nowadays RELY UPON Slashdot to frame tech issues incorrectly, specifically with a sensationalist bent. If you want to get the REAL story, and not just the jazzed-up headline, you have to read the comments and find out where the editors lied.

  37. Re:You can't effectively close-source anything GPL by dfranks · · Score: 1

    Just like Firebird when Borland/Inprise close sourced Interbase.

    Borland may have added features since then (I haven't even looked), but Firebird is much more useable than Interbase even was.

    http://www.sourceforge.net/projects/firebird

  38. 67comet by 67comet · · Score: 1

    Friggin' "A" I've only "just" gotten comfy with MySQL. Time to start changing my server over to another application for my database needs. I have no issues with Java, since they didn't start open I don't expect much from them when they say they are "opening" things up, but taking a previously open application and closing parts off? No thank you, I'll find something else. What a shame, Justin

    --
    It's a nice feeling to remove all the fat from my hard drive.
  39. mrghemp by MrGHemp · · Score: 5, Insightful

    The title of this article is a bit dramatic and incorrect. There is nothing in the story about the core MySQL engine being moved from open source to a closed source mentioned in the story. Rather a fancy new backup add-on is being released to Enterprise edition, and possibly added to the community version later.

    MySQL is one of the most popular open source products out there, but they get lambasted if they create an add-on and want to actually get paid for it. Too many ppl react as if they are defecating on a holy shrine in the land of FOSS.

    The title of this article and some of the reactions here strikes me a chicken little "the sky is falling" BS. I love open source software and the general movement, but I hate it when people jump to conclusions like this... and jumping to conclusions like this seems to happen all to often by ppl on /. and the open source community in general. I'd like to see more people showing respect for a company that has done so much for open source and respect the fact that they deserve to actually make a little money along the way.

    I can't help but wonder how many of the people, who treat this story like the evil Sun is going ruin MySQL, run MySQL but haven't open sourced the programs that they've written that access the database... I'd bet a hell of a lot of closed source programs use MySQL as their database... should we scream at them for being evil too?

    1. Re:mrghemp by mjasay · · Score: 1

      MySQL may simply be doing what Red Hat did before it: Keeping its core 100% open while offering new services (e.g., Red Hat Network) as commercial, add-on services. I don't think MySQL has done a good job of telling this story, but I do think that's the story (or should be). Many didn't like Red Hat's split between Fedora and RHEL, but ultimately it has arguably been good for both Fedora and RHEL. MySQL just needs to better define what it's doing.

    2. Re:mrghemp by pirhana · · Score: 1

      > MySQL may simply be doing what Red Hat did before it

      There is a fundamental difference between Redhat and MySQL . Every piece of code developed by Redhat is GPL(or similar FOSS license) . That is not the case with MySQL. They have code which are not FOSS. Comparing MySQL with Redhat is totally wrong. I would like to add that one company is bold and clear about its business model and has a vision. While the other one is always confused and timid.

    3. Re:mrghemp by mjasay · · Score: 1

      Not actually true. RHN has always been proprietary (until they announced a change to this, though I think they have yet to open source it). I was actually arguing (if you followed the link) that MySQL should follow Red Hat's policy: Make its code open but only (initially) available to paid subscribers. Once someone pays, they can redistribute as it's GPL. But few exercise that right. So, we're in agreement. Btw, I talked with MySQL about this and it's not even remotely clear that they are making these add-ons proprietary in the way you envision. It sounds to me like they're doing what Red Hat does.

    4. Re:mrghemp by pirhana · · Score: 1

      > Not actually true. RHN has always been proprietary (until they announced a change to this, though I think they have yet to open source it)

      RHN is not a product right?

      > Once someone pays, they can redistribute as it's GPL. But few exercise that right

      CentOS ?

      > Btw, I talked with MySQL about this and it's not even remotely clear that they are making these add-ons proprietary in the way you envision.

      They are NOT planning to open source the add-ons and I dont think they even permit the redistribution of the binary of the same(I could be wrong in the second part). How is it same as redhat ?

      And they are NOT going by redhat way ; atleast as of now. Please see the following thread I had with their CEO in this discussion.
      http://slashdot.org/comments.pl?sid=525246&cid=23100380

    5. Re:mrghemp by mjasay · · Score: 1

      Not a product. That is my point! I am arguing that MySQL should have gone that route rather than closing off add-ons to its database except to the extent that those add-ons are separate services.

  40. And now it begins... by bgibby9 · · Score: 1

    Sorry to sound pessimistic but doesn't look too good for the future of MySQL. MySQL has always been an honest, what's best for the people kind of company in my eyes, and regardless of what really is happening, the end result of this is that my idea of MySQL has changed. This is something that other people will also feel so in any light, regardless of the outcome, doubt will now be part of people's minds when it comes to MySQL. Sorry guys!

    --
    http://www.gibby.net.au
  41. Comment removed by account_deleted · · Score: 1

    Comment removed based on user account deletion

  42. open source as a lock-in hook ? by cats-paw · · Score: 2, Interesting

    It occurs to me that buying an open source software company might be a sneaky way to get some good, old fashioned customer lock-in.

    Look for free software program, preferably complicated, with a large user base.

    Close it, and begin charging.

    It seems as though you could get customers to stick around with the right price point. Now you may begin your ad infinitum licensing fees.

    I'm not saying that's what's happening in this case, but it seems like something to evaluate. The two flaws in this idea:

    The customers migrate to another free software tool - which might be difficult to do.
    The program forks.

    Seems to minimize risk a high percentage of the userbase would pay as the path of least resistance.

    The fact that the buyers could get to this point on the (free) contributions of the original authors is kind of annoying.

    Your probably still better off having used free software in the first place.

    --
    Absolute statements are never true
    1. Re:open source as a lock-in hook ? by Anonymous Coward · · Score: 0

      It occurs to me that buying an open source software company might be a sneaky way to get some good, old fashioned customer lock-in.

      Look for free software program, preferably complicated, with a large user base.

      Close it, and begin charging. OMG! You've cracked it. And they know it, and they'll be COMING AFTER YOU.

      You want to know what's worse? Here's what's worse: they KNEW YOU WERE GOING TO CRACK IT. And THEY'RE TAUNTING you. BEFORE you EVEN POSTED.

      No, but wait, it's even WORSE. They did it on April 1st, so everyone else would THINK THEY'RE KIDDING. But YOU know they're NOT!

      Man, don't you wish you hadn't posted? Sorry, dude.
    2. Re:open source as a lock-in hook ? by Vexorian · · Score: 1

      Close it, and begin charging.

      Your probably still better off having used free software in the first place.
      It's GPLed, man.
      --

      Copyright infringement is "piracy" in the same way DRM is "consumer rape"
  43. Sun and Postgres by Anonymous Coward · · Score: 0

    For PostgreSQL :) http://www.postgresql.org/

    Would you like another round of ammo with that foot gun Sun? Um, yeah:

    http://www.sun.com/software/products/postgresql/
    http://www.sun.com/software/products/postgresql/support.jsp

  44. In the end, that is the same thing... by Futurepower(R) · · Score: 1

    "Sun is not close sourcing existing portions of MYSQL. Just adding new features for the customers who will pay an arm and a leg..."

    In the end, that is the same thing as closed source. The development will be in the direction of helping the "Enterprise", expensive version, and eventually, after many years, that will be the only version in wide use.

    Maybe Sun will change the name to "OurSQL".

    1. Re:In the end, that is the same thing... by jedidiah · · Score: 1

      If you are willing to pay an arm and a leg, you can just forego mySQL entirely.

      What seem to be talking about here is stuff that was put into the likes of
      Oracle and MSSQL 10 or 15 years ago. So you will probably not even need to
      buy the "expensive" versions of any of these old school products in order
      to match the "extra features" you would get out of the Sun-payware version
      of mySQL.

      --
      A Pirate and a Puritan look the same on a balance sheet.
    2. Re:In the end, that is the same thing... by RiotingPacifist · · Score: 1

      Or simply d/l and compile it anyway, like centos vs redhat

      --
      IranAir Flight 655 never forget!
  45. wait a minute.... by AmaDaden · · Score: 4, Interesting

    I know it's all over the story on Slashdot's end but the article it self does not say anything will be closed. GPLed code can be open but cost money. Am I missing some other article? Because to me it sounds like they plan on doing things the Red Hat way. Public free version and Enterprise pay version.

    1. Re:wait a minute.... by mabhatter654 · · Score: 5, Insightful

      but it's backwards of the Red Hat way. With Fedora, Red Hat lets the community run the roost and run whatever crazy things are cool on the tubes. They reserve RHEL for the cleaned up professional version that has what paying customers NEED and they support it. The community gets the warty version with all the lumps in return for it being free.

      Sun wants to treat MySQL like a product. They want to give away the "free" version as a stripped down marketing tool. They want to put new code in Enterprise first, where fewer people will see it. The current model is that Enterprise is MORE stable and less agressive. The value of the GPL version is that lots of people put up with warts because it's free... paying customers won't do that by a long shot. The first time a nasty data killing bug shows up for the top paying customers they'll all jump ship for Sun not testing better.

    2. Re:wait a minute.... by Daengbo · · Score: 1

      As far as I know, the "introduce new features into the paid version" plan is the method that MySQL has been using for a while, upsetting many paying customers when bugs bit clients.

    3. Re:wait a minute.... by Anonymous Coward · · Score: 0

      Actually this is not the same as Red Hat. Red Hat charges for binaries only. All source is available for download in SRPMS. Sun will have some code that is not available for download.

    4. Re:wait a minute.... by MrMunkey · · Score: 1

      MySQL Enterprise has its different versions as well. The last company I was at used Enterprise. You *can* use the bleeding edge version, or you can use the "guaranteed to be stable" enterprise version which they make very distinct from the rest. With Enterprise you also get service level agreements on if a bug is found. Those levels differ based on what support contract you purchased. I just wanted to make sure people knew that they didn't have to be on the bleeding edge if they didn't want to be.

  46. Re:Slasdot: useless. Commenters: the REAL story. by MrGHemp · · Score: 3, Interesting

    I agree... it seems the headlines and articles have been getting things wrong more often lately... it seemed like the reviewer who posted the story would at least add to the post if they thought part of it was incorrect or misleading... but that doesn't seem to happen as often anymore... I hope /. editors start correcting this, because if the stories become more and more inaccurate... we won't be able to trust /. as a reliable source of tech news. And once ppl don't trust the source, well it's game over.

  47. Re:Not that I begrudge them a right to make a buck by rainhill · · Score: 1

    well, yes but, we wanna have all that new features OPEN too.. imagine RedHat tomorrow saying, "yo guys, RH engineers gonna add new advanced features closed source.."

    this is not good, not good at al...

  48. Re:-1, Flamebait NOT: Prod Solaris is NOT opensour by thePowerOfGrayskull · · Score: 4, Insightful

    THere's an appropriate saying about getting free donuts and complaining about the holes...

  49. Wrong by Anonymous Coward · · Score: 0

    You're doing it wrong!

  50. Who Needs MySQL? by Anarchysoft · · Score: 2, Informative

    When there are so many good alternatives! Check it out.

  51. Sun? by Dave+Walker · · Score: 1

    I don't know what to think now. My earliest memories of the 'net involve sunsite.unc.edu. I WANT to believe in Sun. They make that hard to do...

    1. Re:Sun? by Anonymous Coward · · Score: 2, Funny

      I don't know what to think now. Think "This is Slashdot. The summary is probably way off base."

      Think "the former CEO of MySQL posted a cogent response to this confirming that the summary is way off base."

      Think "I really ought to read some of the comments before I freak out."

      Think "It's Wednesday; we're supposed to hate Sun on *Thursdays*."
    2. Re:Sun? by osu-neko · · Score: 1

      What's really funny is, the summary is completely written by "An anonymous reader" with no additional commentary by the editor.

      So, apparently, if I want to submit a pack of lies an distortions to Slashdot on hopes of getting it posted on the main page, I can do it anonymously, and even then, the editors won't bother to do any fact checking, but just post my slanders verbatim without comment.

      How do I moderate the editors? I need to mod down samzenpus, he's clearly either an idiot or a troll himself. Probably a PostgreSQL fan looking for ways to get people to switch, even if it's for the wrong reasons. (I will be looking at PostgreSQL, merely because I've been reminded of the fact that I haven't looked at it in years and don't really know the state of it, but if I switch, it'll be for valid reasons, not FUD from /. trolls.)

      --
      "Convictions are more dangerous enemies of truth than lies."
  52. The summary is bad... by steelfood · · Score: 5, Insightful

    ...the editors can't even be bothered to read the link and verify the information.

    I went to firehose to vote this story down with the reason "not the best". I suggest we all start doing this for all such examples of yellow journalism. Maybe if we do it enough, the editors will start to get a clue.

    --
    "If a nation expects to be ignorant and free in a state of civilization, it expects what never was and never will be."
  53. Re:Not that I begrudge them a right to make a buck by BluBrick · · Score: 2, Insightful
    Hmm, I think you have the adults/kids analogy all bass-ackwards.

    This is more like the adult teaching a kid about sharing by playing with a toy with the child. Eventually, the kid's gonna snatch it off the adult, clutch it to his chest possessively and and yell "MINE!"

    I solved that with my 3 YO daughter by taking the batteries out of her toy and telling her that the toy is hers, but the batteries were mine. When she realised that the toy didn't work without the batteries, she understood the meaning of sharing.

    --
    Ahh - My eye!
    The doctor said I'm not supposed to get Slashdot in it!
  54. gawd dam forking whackers! by Anonymous Coward · · Score: 0

    So, just where do you suppose sun's is actually shining?

    Why, way deep down in a dark, smelly corporate code hole!

    - just a thought -

  55. Comment removed by account_deleted · · Score: 1

    Comment removed based on user account deletion

  56. What is a "sourcing"... by fucket · · Score: 0

    ... and how, exactly, would I go about closing one?

  57. Re:-1, Flamebait NOT: Prod Solaris is NOT opensour by mabhatter654 · · Score: 1

    the point is that the PAYING customers are still stuck with the same-old closed source product. The "open" version will always have little version differences from the supported version, so troubleshooting YOUR problems as a paying customer still isn't any easier.. for a matter of fact if you were using OpenSolaris developed software (free from the community) on Solaris, you could end up with MORE problems because the free people can't support you. It makes the free version nothing but a parlor trick.

  58. no doubt... by haroldag · · Score: 1

    [ ~]$ yum remove mysql

  59. SUN can take MySQL wherever they want: They own it by Anonymous Coward · · Score: 0

    If you think you don't like the direction MySQL is taking have a look at PostgreSQL. That's all I'm going to say; just check it out and decide for yourself. :)

  60. Remove this! by spydabyte · · Score: 0, Flamebait

    How can false opinionated stories like this be published? With it being Sun Week on campus, I've had some recent (yesterday) exposure and discussions with some of their representatives. Sun singlehandedly contributes the majority (Yes, above 50%) of Open Source code in the online community, thanks to their newly acquired MySQL. Read More, and next time get your facts right.

  61. Sun has had a very poor history by SlappyBastard · · Score: 0, Troll

    OK, stop right there. That's really all that has to be said. Sun sucks. Sun will make MySQL suck. It's not that hard to understand. Just as Java never really reached as far and wide as its potential, Sun will squeeze the fricking life out of MySQL.

    --
    I scream. You scream. I assume that means we're both acquainted with the problem. We proceed.
  62. why closed source is better. . . by Anonymous Coward · · Score: 0

    You don't have to deal with flametards on Slashdot. Open source is like welfare programs. The sense of entitlement is baseless and so it is defended all the more vigorously.

    I was reading about RMS meeting a rep from IBM. IBM talks about running a closed source software on an open source platform. RMS immediately goes into geek puffer fish mode -- reaction is to compete with anyone trying to make a buck and run them out with Commie goodness.

    As a geek advocacy group, Slashdot is its own worst enemy -- they want (1.) no patents for small developers, (2.) hate people selling software, and (3.) want increased liability for developers.

    Now I feel better.

  63. Close Sourcing by Anonymous Coward · · Score: 0

    "Close sourcing"? What kind of genius English major came up with a term like that? A better, yet still sensationalist, title would have been "Sun to Begin Making MySQL Proprietary", or if you absolutely have to remain within the walls of the "open source" garden, "Sun to Begin Closing MySQL Source".

    Also, this has nothing to do with being commercial or non-commercial, so please stop saying "commercial" like it's the opposite of freedom or openness.

  64. Fork it? by at_slashdot · · Score: 1

    I'm waiting for the announcement of somebody forking the code... if not there's always PostgreSQL.

    --
    "It is our choices, Harry, that show what we truly are, far more than our abilities." -- Prof. Dumbledore
  65. Let's kill MySQL so PostgreSQL can take over! by rossz · · Score: 2, Insightful

    MySQL has a few advantages over PostgreSQL. Primarily, it's supported by just about every damn open source package in the world. If MySQL is closed up, OSS developers may choose to drop support for it. Personally, I think PostgreSQL is a better package than MySQL, but I mostly use MySQL because of its compatibility with everything. I won't, though, hesitate to switch if I am not happy with the direction of MySQL.

    --
    -- Will program for bandwidth
  66. MySQL has been drifting towards closed source for by PinchDuck · · Score: 2, Insightful

    awhile. I was hoping that Sun would reverse that trend. It sounds like they are keeping the base package free (for now), but that high end add ons will be closed/commercial. That is fine, but it is also enough of a closed-source move for me to start looking at alternatives. I wish them the best of luck, but I will make sure I do what is best for me and my clients. Maybe I'll use MySQL, maybe I won't, it will depend on license, price, functionality, and community support.

  67. Very insightful by CustomDesigned · · Score: 1

    I hadn't noticed before how cleverly, yet ethically Red Hat leverages the community by exercising enterprise features in Fedora before springing them on enterprise customers. Not only is playing with the latest LVM features in a low risk setting fun, but it helps Red Hat sell to big business when I discover breakage. (I really have to try out Zumastor...)

    1. Re:Very insightful by Nushio · · Score: 1

      Hey, I'm sorry but if using 2 year old software is deemed "Stable" then I'd rather live on the bleeding edge.

      --
      Check out Unsealed: Whispers of Wisdom! http://unsealed.k3rnel.net It's an action-RPG about Open Sourcerers.
    2. Re:Very insightful by Svartalf · · Score: 1

      This works for many, but not for enterprise level stuff where you can't afford to take that level of risks with your systems.

      It works for me, but I'd consider caution in fielding things that weren't armor-plated and a bit long in the tooth in something that collected or processed financials, etc.

      --
      I am not merely a "consumer" or a "taxpayer". I am a Citizen of the State of Texas
    3. Re:Very insightful by Antique+Geekmeister · · Score: 3, Informative

      This is frequently, though not always, true for RedHat. Some of their clustering systems are closed source, and available on RHEL and not Fedora. But it's generally true.

      There are companies that use the 'closed first, GPL later' approach: Xensource did with Xen virtualization softwre, and Citrix is allegedly doing the same now that they bought Xen. AFPL does this with Ghostscript, and at last look Zmanda was doing this with Amanda.

    4. Re:Very insightful by Bert64 · · Score: 1

      That's a standard practice across the board...
      When a piece of commercial software is released, it's usually been tested through internal and external beta programs for a year or two at least... And even then, very few businesses will adopt the latest versions immediately.

      With open source, there is greater possibility to use software at a much earlier stage of development, and less cost in updating to the latest version when it comes out. But that doesn't mean all users necessarily want the latest and greatest, it's just good to have the choice.

      --
      http://spamdecoy.net - free throwaway anonymous email - avoid spam!
    5. Re:Very insightful by superskippy · · Score: 1

      The RedHat clustering is freely available and GPL on Fedora.

    6. Re:Very insightful by Anonymous Coward · · Score: 0

      That is wrong man, Red Hat Cluster Suite and GFS are both open source and available in RHEL, Fedora and CentOS

    7. Re:Very insightful by jadavis · · Score: 1

      RHEL backpatches a lot of stability and security fixes from newer software. This means that you have the benefit of the new fixes, without the drawback of the new flaws.

      It also avoids breaking backward compatibility.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    8. Re:Very insightful by ckaminski · · Score: 1

      Are you kidding? Most software almost never goes through a public beta process. Perhaps Microsoft products, perhaps Oracle products, but almost nothing else. You're lucky if it spent a month in the QA process.

  68. Forking by Anonymous Coward · · Score: 1, Funny

    Fork, Fork, Fork!!! Stick a fork in Sun they are done.

  69. Trend to close source by wshwe · · Score: 1

    I predict that more successful open source software companies will sell out for profit and go closed source.

  70. OK.. everyone take collective breath... by Eth1csGrad1ent · · Score: 1

    OK.. everyone take collective breath... and Step 1. Hit CTRL+F Step 2. Type "MartenMickos" Step 3. Hit Enter Dont even need to RTFA, just read the comments and all your answers are belong to us. Summary: -1 Flamebait.

  71. And the new slogan will be... by MaGGuN · · Score: 1

    "My God, it's full of stars!"

  72. Re:Not that I begrudge them a right to make a buck by kylehase · · Score: 1

    I fully agree. I much prefer the RH OSS model. They provide enterprise software and services which many companies are more than willing to pay for even though the RHEL source is open.

    --
    You want fun, go home and buy a monkey!
  73. Geez Louise by yomegaman · · Score: 2, Insightful

    For a userbase that is always congratulating itself on how smart it is, there sure are a lot of gullible people reading Slashdot...

    --
    ...wearing a skin-tight topless leather jumpsuit, with cutaway buttocks and transparent crotch panel.
  74. Post / Grez / Queue /El by paulthomas · · Score: 3, Informative

    Post / Grez / Queue /El

    Because it is such a common question (and such an odd name), it is aptly an entry in the PostgreSQL FAQ.

    If you don't like my phonetic spelling and prefer IPA, Wikipedia has you covered.

    Many people, myself included, simply call it Postgrez.

    1. Re:Post / Grez / Queue /El by HeroreV · · Score: 1

      I pronounce it "post grey S Q L", but I've been learning lately that I pronounce a lot of things differently from everybody else. (e.g. "V" for vi) This is friggin 2008, can't we get some audio recordings of how these things are supposed to be pronounced?

    2. Re:Post / Grez / Queue /El by narthollis · · Score: 1

      yup, check the Wikipedia page posted by the grandparent!

    3. Re:Post / Grez / Queue /El by paulthomas · · Score: 1

      The audio file linked to by Wikipedia is the same one as linked to from the FAQ.

      Also, I guess I had it a little wrong, too. The very source I linked has it as "gres," whereas I pronounce the "s" more as a "z".

    4. Re:Post / Grez / Queue /El by zsau · · Score: 1

      Wikipedia's IPA disagrees with you, claiming the middle syllable is "gress" (in your notation), and this is how I've always understood it should be said. Quite what to make of the first syllable, which uses a vowel not found in British or American English (/o:/) I'm not sure; I imagine it's intended as a poor representation of the vowel in "post" (many foreign learners of English use /o:/ for that vowel, and it's also similar to the /o/ used in American English and many regional British dialects). (The vowel /o:/ exists in Australian English, which would make the first syllable "pawst" --- but that doesn't seem likely.)

      --
      Look out!
    5. Re:Post / Grez / Queue /El by HeroreV · · Score: 1

      That's really great for the names that are popular and/or that many people get wrong (like GNU and Linux), but I even get wrong names like "Ada", "Haskell", and "Novell".

    6. Re:Post / Grez / Queue /El by morgan_greywolf · · Score: 1

      Ada", "Haskell", and "Novell".


      Most people pronounce the first one aid-uh (After Ada Lovelace, for whom the language is named), the second one I don't really know...I'd guess "Hass-kuhl" (schwa sound for the 'e') or "haz-kel' with 'e' as in bet)

      The last one is no-vel, with long o as in coat and 'short' e as in bet) Anyone pronouncing it like 'novel' deserves to be shot.

  75. Re:Not that I begrudge them a right to make a buck by kylehase · · Score: 1

    While that's a little better, it means that those using the community version won't be able to take advantage of features that could be essential for future applications. The problem is that we don't know what features will become essential in the future.

    Imagine if a hugely popular DB went closed source years ago before any ACID features were available. Then ACID features were developed as closed source and only available in the commercial version. Almost any large scale application would require the commercial version.

    --
    You want fun, go home and buy a monkey!
  76. I've run into this with Oracle by btarval · · Score: 4, Interesting
    "Sun wants to treat MySQL like a product. They want to give away the "free" version as a stripped down marketing tool.

    Yes, this is what Oracle does with Berkeley DB. On one project, we started out with using Berkeley DB. It wasn't meeting the needs, so we started looking at other options. Oracle had us hooked, and started reeling us in. Up until we got to the price tag. They wouldn't offer the support that we needed for their commercial version of Berkely DB, and instead wanted to push us towards their full Oracle DB. It sounded fine until we got to the price. They wanted, get this, 5% of the gross revenues of the product we were designing!!! Not a per-license fee, not a large finite sum for the product, but a full 5% of the revenues.

    Needless to say, we told them to take a hike.

    This is different than from a few years ago. Then they were willing to do a per license fee. But, of course, at an astronomical amount. Plus, this amount would literally change each time we talked to a different salesperson. There was a lot of confusion at the time. Now they've eliminated the confusion, but their greed knows no bounds.

    Sun is welcome in this space, IMHO. More competition is good, because frankly, all of the vendors have serious drawbacks in one way or another.

    The moral of the story is be real careful about the database you select, and your design. If you choose foolishly, you'll end up spending lots of money, when a better design could have saved you from this pain.

    --
    The best way to predict the future is to create it. - Peter Drucker.
  77. anyone.... by easyemail · · Score: 0

    anyone want to build me a free database. All i need is your total commitment to building this database that tracks everything on planet earth. Time need is everyday of your life. Your pay is 0 dollars. Anyone want to work for this. You need to devote 24 hours a day- and you have to earn your money otherways.....
    ANyone....anyone.

  78. don't rush to conclusions by bonefry · · Score: 4, Informative

    SUN is not closing parts of MySQL, instead it is introducing new features in MySQL Enterprise, a product which always had extra features.

    Not to mention that SUN is not the only one doing interesting things with MySQL ... for example at the conference I saw a presentation on Maria, a MyIsam-based storage engine that supports transactions.

    Also, the features in MySQL Enterprise can (at least currently) be enjoyed by most developers using alternatives ...

    1) the hot backup of myisam tables will be available in the open-source version
    2) the smart load balancer is a MySQL Proxy configured with filtering scripts that you can write yourself in Lua
    3) profiling can be done efficiently with Sun's DTrace

    Disclaimer: I am currently attending the MySQL conference, but I am not affiliated with Sun in any way.

  79. Re:Not that I begrudge them a right to make a buck by Anonymous Coward · · Score: 0

    Wow, 3 YO and already playing with the battery operated toy. Gee, kids these days grow up fast!

  80. Beryl by Gazzonyx · · Score: 2, Interesting

    What about the Compiz, Beryl, Fusion fiasco? That was a fork, merge, (branch?)... I've got svn repos with less confusing trees, for craps sake! Granted, it only lasted, what a couple of months or so, and I'm glad that every was able to humble themselves and work it all out... but it still was a fiasco!

    --

    If I mod you up, it doesn't necessarily mean I agree with what you've said, sorry.

    1. Re:Beryl by SL+Baur · · Score: 1

      What about the Compiz, Beryl, Fusion fiasco? ... Granted, it only lasted, what a couple of months or so You answered your own question. The poster that I responded to was looking at successful forks. What you describe is temporary project confusion that got resolved quickly.
  81. Re:You can't effectively close-source anything GPL by Anonymous Coward · · Score: 0

    X.org should be mentioned here as it was forked from xfree86 when it changed its license.

  82. Apple takes a similar approach by SuperKendall · · Score: 1

    I fully support what you are trying to do here, I wish MySQL to prosper in the years ahead as well.

    Another way to put this so people can better understand - it's somewhat how Apple works, basing a lot of stuff on open source projects they contribute to but then building more proprietary and advanced things on top that they sell.

    --
    "There is more worth loving than we have strength to love." - Brian Jay Stanley
  83. Re:Slasdot: useless. Commenters: the REAL story. by Danny+Rathjens · · Score: 1

    It's always been that way. Editors can't be experts at everything or even dabble in everything. And if you pay attention, a lot of real news media with professional journalists and editors can be just as misleading. The true value of /. - and the reason I have been here for the last 10 years - has always been the comments from people that know what they are taking about or are even directly involved in the story. e.g. the ex-mysql ceo posting in this thread or Dr. Lisi about his exceptionally simple theory or even ex-grad students of scientists' work being reported.

    Anyway, if every story - or comment - were perfectly true and accurate you'd never get to exercise your brain, just inhale the information blindly. I don't want to do that. :)

  84. sun by Anonymous Coward · · Score: 0

    never gets GPL anything
    any REAL thing is under CDDL
    only 0 sun resources will go GPL

  85. The time has come... by Anonymous Coward · · Score: 0

    ...for a fork. Call it OurSQL

  86. Re:Not that I begrudge them a right to make a buck by Daniel+Phillips · · Score: 1

    basically what they're doing is developing new features to be put in MySQL 6.0 enterprise, and these _new_ features won't show up in community. Obviously. The old features are GPLed and can't be retracted. But nothing about this makes it better for the community or smarter for Sun. Sun has forked MySQL, make no mistake about it. As a community, there are three correct responses:

        1) Fork MySQL (OurSQL anybody?)

        2) Switch to PostgreSQL

        3) Both of the above
    --
    Have you got your LWN subscription yet?
  87. Bad summary by headLITE · · Score: 5, Informative

    The /. summary is misleading. It isn't MySQL that is going to be closed-sourced, it's just that Sun will develop additional products that MySQL customers will be able to buy and use with their GPL MySQL server if they so choose. This isn't really news, MySQL AB has done so before, for example with the most excellent MySQL Enterprise Monitor.

    1. Re:Bad summary by GuyRCook · · Score: 1

      The /. summary is misleading. It isn't MySQL that is going to be closed-sourced, it's just that Sun will develop additional products that MySQL customers will be able to buy and use with their GPL MySQL server if they so choose. This isn't really news, MySQL AB has done so before, for example with the most excellent MySQL Enterprise Monitor. Thanks for the clarification, too bad the original words aren't as clear. My first read was doom and gloom, but now I'll sleep better. Thanks.
      --
      Guy Cook Internet Marketing and Consulting Solutions since 1995.
  88. FUD by fjollberg · · Score: 1

    This is nothing but FUD. Please keep your mind at least somewhat as open as you claim you want your source to be.

  89. Re:You can't effectively close-source anything GPL by mcguin · · Score: 1

    Sodipodi / Inkscape ?

  90. Plus ... some part are misleading ! by Anonymous Coward · · Score: 2, Insightful

    "Sun has had a very poor history of actually open sourcing anything."

    Really, is Java not under GPL ? What about OpenOffice ? What about Netbeans ? Glassfish ? OpenDS ? ...

    Can anybody name a company (nor a .org) with more opensourced project than Sun ?

    Please, correct/moderate this misleading part of the article too.

  91. This would be the same firebird by Anonymous Coward · · Score: 0

    Who sued the mozilla group for using their database trade mark in the nme of a browser?

    Y'know, forgetting that a trademark is for the SAME FRIGGING FIELD? So that people won't get confused and buy one product thinking it another.

    And how many people would say "well, this database sure looks nice, but it just wants me to look at html. how do I store my data in it?"?

    So, no, Firebird is NOT an option.

    1. Re:This would be the same firebird by TheRaven64 · · Score: 1

      They didn't sue Mozilla, they just pointed out that using a name for your open source software project that is already used for another open source software project is probably a bad idea.

      --
      I am TheRaven on Soylent News
    2. Re:This would be the same firebird by Slackwise · · Score: 1

      If anything, you should be upset at Phoenix Technologies, which did get into legal disputes over Firefox's original name: "Phoenix"

      --
      (define (reduce f l) (if (null? (cdr l)) (car l) (f (car l) (reduce f (cdr l)))))
    3. Re:This would be the same firebird by K.+S.+Kyosuke · · Score: 1

      OK, I am going to build and market a truck. And I would like it to be called Firebird, just because I happen to like it. And I don't care a bit if Pontiac does not like it, mine will be a TRUCK, not a puny pony car. How does that sound, hm? I am "sure" they will not object at all. ;-)

      --
      Ezekiel 23:20
  92. Re:Not that I begrudge them a right to make a buck by jimicus · · Score: 2, Insightful

    well, yes but, we wanna have all that new features OPEN too.. imagine RedHat tomorrow saying, "yo guys, RH engineers gonna add new advanced features closed source.."

    this is not good, not good at al... EVERY commercial Linux distribution has parts which may or may not be open source, but if they are open they're certainly open to the extent that the GPL is.

    Ubuntu has Landscape, a tool for managing a number of Ubuntu desktops. Only available if you're paying Canonical for support.

    SuSE plugs into ZenWorks - most certainly not F/OSS.

    RHEL has Fedora Directory Server (albeit rebranded as Red Hat). That one's open source but such an absolute dog to set up that you'd need your head examined if you tried doing it any way other than "throw money at Red Hat".

    End of the day, lots of F/OSS projects have "Free" and "Commercial" versions, where the commercial version costs money and comes with a few extra bells & whistles. Just off the top of my head, there's Smoothwall, KnowledgeTree, any number of Exchange alternatives (free but if you want full Exchange-like functionality complete with Outlook integration it costs money) and ZenOSS. It seems to work as a business model, I can well understand Sun adopting it.
  93. Re:Post / Gres / Queue /El by paulthomas · · Score: 1

    Not only Wikipedia's IPA, but also the FAQ which I mentioned. I noted in another reply that the z is probably unique to the way I've been saying it. Ah, the finality of /. posts.

    Speaking of, I pronounce Post in American English such that it rhymes with the German Prost. I'm not an expert on IPA, so I can't be of much help with the transliterated IPA for that particular sound.

  94. Emacs/XEmacs as fork example by Anonymous Coward · · Score: 0

    Since Lucid (and Sun?) bowed out, XEmacs went nowhere. So even though Emacs has moved at glacial speed, it has pretty much caught up featurewise, and is quite more usable by now.

    The XEmacs community is hardly doing any development at all anymore: they are mostly bickering about how to shrink-wrap what they have best.

    While the XEmacs fork is probably one of the most long-lived ones ever, nowadays it looks more like one of the longest-dying ones.

    In short: forks don't stay.

  95. like Always by leuk_he · · Score: 1

    The marketing of the free version community version has always been that you cannot distribute alteration it for commercial usage. They are always a bit vague about it to promote their enterprise version.

    However since the community version is gpl software, there is absolutely no problem to use it for commercial purposes, until you are actually changing mysql db , something you rarely really want to do.

    On their enterprise version they put all kind of claims for support and hot fixes, but for that kind of enterprice there are better commercial alternatives available ( Oracle/MS-SQL server). It is nice that good support is availaable for those who are more or less locked to the Mysql platform because their mission critical application was written in mysql by a programmer in his spare time. "Just because my sql works"

    1. Re:like Always by Tony+Hoyle · · Score: 1

      However since the community version is gpl software, there is absolutely no problem to use it for commercial purposes, until you are actually changing mysql db , something you rarely really want to do.

      Not true.

      Changing is irrelevant - gpl covers distribution and linking. The moment you distribute an application that uses mysql that is *not* GPL you violate GPL. You need to buy a mysql license (mysql seem to be unique in requiring that linking to the client libraries incurs a per-user license fee* - not even Oracle do that).

      * Confirmed by mysql themselves when we talked to them. They wanted $200 per user, for 100% of the copies, even the free ones! At 1.5 million free downloads we'd owe mysql 3 billion dollars!!! I really think they didn't think that one through.. or it was the salesmans first day or something... we merely did the obvious and dropped mysql support.

  96. Sun's admission of failure by Anonymous Coward · · Score: 0

    Interesting indeed - though MySQL was always a rather screwed-up "open source" company, with it's extraordinary interpretation of the GPL license, and it's attempts to extort money from it's users. Is this ultimately a confession that the acquisition & the open-source hype, (and the vastly inflated Web 2.0 price) was a mistake [ entirely predictably ] ?

  97. You are so 13e7 by emj · · Score: 1

    There is almost no difference between them. Though you feel confused when you com back to either system for after a year or two, then you have to ask yourself, was it route or netstat this time?

    BSD feels so enterprise and colossal.. ;-)

  98. Marten Mickos posts true insights regularly on /. by Qbertino · · Score: 1

    The simple fact that you regularly post substancial information on hot MySQL topics here personally tells me that using MySQL as the prime choice for the persistance layer can't be bad.
    I personally hate SQL as an additional language and would like it removed from the generic application stack ASAP, but all things RDBMS being more or less equal in the DB world, I choose the most frictionless DB which is MySQL in my view.

    Being someone who runs a small business around OSS myself I fully understand your position and reasoning, and personally think it's a good decision. It might even be a sustainable business model keeping SQL alive to bug people with it as long as possible and sell tools to avoid it for those who can afford them :-) .

    Thank you for staying commited and so close to the communtiy.

    A satisfied customer

    P.S.: One more thing: Could you *please* go down and tell the Workbench crew to finally finish up the .Net prototype and start with the versions that run on MacOS X and Linux? That would be nice. Thank you. :-)

    --
    We suffer more in our imagination than in reality. - Seneca
  99. Re:Post / Gres / Queue /El by zsau · · Score: 1

    Oh sorry, I didn't see it, on account of it not being moderated up. Apologies!

    I'm afraid I can't say whether the vowel in "Prost" is long or short --- I have begun taking German classes because I plan on going over there later this year (Christmas in winter? What a novel idea!), but after only one lesson it's no surprise I haven't come across that vowel yet. In any case, if it's long, it's /o:/ indeed, but if it's short it's // (a backwards c, if the Unicode gets stripped). But that would be its German pronunciation, or German-accent English, and not its English pronunciation.

    --
    Look out!
  100. Suns contribution to open source by Marcus+Green · · Score: 3, Interesting

    "Sun has had a very poor history of actually open sourcing anything"

    Get back in your hole Troll. According to the EU Sun is the No 1 contributor of code towards open source by a very, very wide margin.

    1. Re:Suns contribution to open source by TeknoDragon · · Score: 1

      While Sun does open source a lot of actual code I've seen them cannibalize projects they take commercial.

      Here's one example I love to bitch about: the JDIC (java desktop integration) project only recently recovered from a 1.5 year break in updates after being integrated into the JVM. A native desktop browser inside a Swing frame has been poorly supported or a commercial solution.

  101. Anonymous Coward by Anonymous Coward · · Score: 0

    Me think it's all M$'s fault.
    They disrupted trust between community and enterprise.

  102. Comment removed by account_deleted · · Score: 1

    Comment removed based on user account deletion

  103. Those bastards. by PontifexMaximus · · Score: 1

    Is this how all open source projects will end? With some for-profit company buying it and then trying to squeeze every last cent out of it? We'll be only left with the kernel and a handful of core utils that won't be hamstrung because of who own them?

    MySQL was my default choice for DB on *nix systems, it worked great and was pretty easy to maintain. Now that Sun owns it, and plans on destroying it with closing off the source (and the backup code, etc, is ONLY THE BEGINNING, I assure you) I'll have to go elsewhere. PostgresQL, here I come.

    This sickens me to no end. It makes me wonder is there is any hope for true FOSS in the long term.

    --
    Pax Vobiscum
  104. Question from a beginner by Nerdposeur · · Score: 1

    I'm coming in on this discussion late, and I have a question. I know nothing about mySQL yet, and just a little about PHP. I do know HTML, CSS, and some JavaScript and JQuery, and am looking to learn more server-side stuff.

    Amazon is supposed to be shipping me this book soon. What do these changes imply for me? If I learn mySQL now, will have to pay to use it? Would it be hard to switch over to some other flavor of SQL once I've got the basics down?

    Would appreciate any advice you can offer. :)

    1. Re:Question from a beginner by Anonymous Coward · · Score: 0

      You'll never have to pay for MySQL realistically speaking. All they're doing is adding a closed source database backup program. If they tried to close source the entire thing theres an almost certainty that the community would fork it.

      As for switching, as long as you're doing entry level stuff switching is easy. You don't really get 'database lock in' until you're doing really advanced DB-specific stuff like fully defined relationships, stored procedures, triggers, and all the other stuff most big companies pay a DBA to manage.

    2. Re:Question from a beginner by Micah · · Score: 1

      Just learn PostgreSQL. You'll be happier in the end. Trust me! :-)

      FWIW, PG is closer to the SQL standard than MySQL. Although the basics of SQL are roughly the same anywhere, with a PG background you'll have an easier time moving to Oracle or something else one day.

  105. Re:Marten Mickos posts true insights regularly on by martenmickos · · Score: 1

    Thx! I will pass your msg to the Workbench team. By the way, they just released the product as GA (Generally Available), as you may know.

    Marten

  106. Comment removed by account_deleted · · Score: 1

    Comment removed based on user account deletion

  107. Maybe not the lesson you intended? by mutube · · Score: 1

    I solved that with my 3 YO daughter by taking the batteries out of her toy and telling her that the toy is hers, but the batteries were mine. When she realised that the toy didn't work without the batteries, she understood the meaning of sharing.

    Lesson: When you share something you both end up with nothing worth having? :)
  108. Hardly any open source at all by tcampb01 · · Score: 1
    So...

    OpenSolaris, from which came features such as Dtrace and ZFS ,

    OpenOffice.org,

    GlassFish,

    OpenSSO, or

    OpenDS

    (and probably several others that I missed) aren't really open source?

    Thanks for enlightening me. After scratching all these projects off my list, it looks like you're right. Sun hardly open sources anything!

  109. Re:-1, Flamebait NOT: Prod Solaris is NOT opensour by eclectus · · Score: 1

    For Solaris 10 & below, this is true. Sun has repeatedly explained that they cannot open source those because they contain code that they do not have the legal license to open source. Solaris 11 & above will be completely based on OpenSolaris and more akin to what Fedora/RHEL is. If you need to SEE the source of older versions for your own development needs, that is available, just not openly published.

    --
    This signature is a waste of 42 characters
  110. fair comparison please by eratosthene · · Score: 1

    Can anyone here point me towards a fair, unbiased, RECENT comparison between MySQL and PostgreSQL? I hear fanboys on Slashdot always touting PG being oh-so-much-better, but I have yet to see a real comparison done on the most recent versions of each. I have done quite a bit of Google searching, but all I've turned up is articles written 3-4 years ago, comparing ancient or beta versions. My company is currently trying to decide between the two, and thus far, I haven't really found any reasons not to go with MySQL. I'm already familiar with it, it seems to have all the features we need built-in, there just doesn't seem to be any compelling reason for using PG besides the already discussed free-and-open vs. free-and-owned-by-Sun arguments. Help? Anybody?

    --
    -- There, everybody likes a gorilla.
  111. Question on porting by kanweg · · Score: 1

    How much resemblance is there between MySQL and Postgresql? In other words, would porting a web app be a time-consuming and complicated matter or well doable?

    Bert

  112. migrating to PostgreSQL by ChristTrekker · · Score: 1

    So...how hard is it to migrate my data to Postgres? Anyone have some pointers, or online references?

    1. Re:migrating to PostgreSQL by Arimus · · Score: 1

      Assuming you're using 'standard' sql types and nothing too MySQL specific just dump the tables, including the create table definitions and the insert statements, as SQL statements and run them into postgres...

      --
      --- Users are like bacteria -> Each one causing a thousand tiny crises until the host finally gives up and dies.
  113. Re:You can't effectively close-source anything GPL by Anonymous Coward · · Score: 0

    Inkscape is another successful fork, this time from Sodipodi. and it was a coup, too.

    most of forks are coups, actually.

  114. Wouldn't basic accuracy be nice? by crmartin · · Score: 1

    Let's see. First, I can't actually find anything in the article that says these new features/changes won't be open-source, just that they won't be in the Community Edition. The Enterprise Edition business is a service offering that already has proprietary tools, and has before Sun bought MySQL. So, either there's no change from MySQL's current policy, or there will be a different version open-sourced. Since Sun is open-sourcing more or less everything, I bet it's the second, but even if it's the first what's the point here? That nothing has changed?

    Second, let's just follow the links rom this statement: "Sun has had a very poor history of actually open sourcing anything."

    In the first one, the author says "yes, it really is open source, but being 'open soure' means having a community. And yes, Sun is building a community with all the trimmings, but it's not really a community because people have to get together, except Sun is running Solaris SIG meetings."

    In the second one, Sun is objecting to Google changing Java without running its changes back into the main source. That never happens in the open source would of course: there's never any controversy about companies making changes to a product and not releasing them back to the core.

    Can we have a Slashdot category for "prevarication"? Of it that word is too big, how about "lying"?

  115. Flamebait by cowwoc2001 · · Score: 1

    This is the most obvious flamebait I'm read in a while. I'm surprised that Slashdot's editors let this one through.

  116. Still, be cautious, Sun by unity100 · · Score: 1

    if you make mistakes with the mysql thing, we'll be easily jumping to postgres.

  117. This sucks! by nicc777 · · Score: 1
    I guess it's time for a new group of people to take the current GPL code base and start maintaining that in parallel... I know - before you get on your hind legs - it's a lot easier said then done.

    I will have to admit, postgres suddenly looks a lot more attractive :-(

    --
    Need an ISP in South Africa?
  118. RIP MySQL by Anonymous Coward · · Score: 0

    Most of Sun's software is available for community or hobbyist use. If you want support, this is where the enterprise versions come in hand. I hope Sun is a bit more careful about the actual code migration. XFree86 Project is now defunct due to a simple license change. My concern is especially regarding Sun owning the software. Sun has a tradition to say what is and is not included in a application. Such behavior has been exhibited on the OpenOffice.Org project. If that is the case, your coffin is ready because you just put the last nail and hammered it down. RIP MySQL.

  119. theirSQL? by engele · · Score: 1

    As a friend in my office mentioned earlier: thierSQL? We will just have to see I guess,

  120. See ya MySQL by mustardman123 · · Score: 0

    The reason I use MySQL is because of the GPL community and philosophy. You can't get a little bit pregnant. So no matter what SUN says, once they start down this path it will be a slippery slope. If this is true then see ya MySQL. My guess is there will be several open source branches of it shortly if at all possible (not sure of current licensing). Otherwise I guess PostgreSQL will become quite popular in a very short period of time.

  121. Your Sig (who's convenience? a lecture-free qn) by zsau · · Score: 1

    I have no desire to lecture you on the subject of base ten vs base two prefixes, nor to be lectured by you, but your sig strikes me as ambiguous. Is that the point, or do you have a preference for the 1000 or 1024 multiplier for bytes? Computational convenience for people would dictate the 1000 multiplier, and 1024 would be arbitrary to us; but 1024 would be computationally convenient for computers, and 1000 would be arbitrary to them. Obviously computers do more calculations with bytes than people do, but (lacking emotions) they can feel no inconvenience.

    --
    Look out!
  122. Apples and Oranges by ttfkam · · Score: 2, Informative

    If your referential integrity is in your application then your database engine is broken. His professor had it right. He wasn't writing to a product, he was writing to just about any modern relational database management system *except* for MySQL and SQLite. At least SQLite never pretended to have a complete feature set. MySQL lacked and blamed its lack on "avoiding bloat."

    And constraints in MySQL? Is that why CHECK constraints were silently ignored for so many years? What you call "constraints," I call "the vast subset of constraints that MySQL managed to support in a timely fashion." Big difference.

    You can simulate 3NF with application patches, but without actual DB support, it's smoke and mirrors. Without enforced foreign keys, it's not an ACID database. A database engine missing ACID is like an operating system with cooperative multitasking. Sure you can have multiple apps running at the same time, but don't for a second pretend that it's the same thing as preemptive multitasking as long as you have proper application support. To assert as much is missing the underlying point altogether.

    --

    - I don't need to go outside, my CRT tan'll do me just fine.
  123. Offtopic by AP31R0N · · Score: 1

    Verbification weirds the language.

    --
    Utilizing the synergization of benchmark e-solutions to pre-workaround action items!
  124. Sound and Fury, means nothing by Mark+Atwood · · Score: 1

    The software that was proposed to be closed source are portions of the online backup drivers. Each such driver has to be written in close cooperation with the developers of each storage engine. Well...

    InnoDB already has an online backup tool, and even if/when they revise their tool to use this new API, it's still going to be theirs, open or closed, not the property of the MySQL Group.

    Online backup of the engines for Archive, CSV, Blackhole, and Memcached doesn't even make sense, and even if it did, BrianA will flat out refuse to write crippleware into his own software.

    Similarly, while online backup makes sense for Maria, I don't see MontyW writing crippleware into his work.

    How about MyISAM? I think that work is already done, but, the horse is already out of the barn, in that the online backup drivers for it just went up on bkbits.

    Looking even closer, the part that was going to be closed was not even the entire online backup driver set, but just compression and encryption. Any halfway competent developer would be able to hook in the necessary calls to azio, zlib, and openssl, and replicate the work.

    So this is a big tempest over something that's not going to happen, and doesn't matter anyway.

    Plus, best practices for backup dont even use or want online backup. The Right Way to backup a real production MySQL instances is via filesystem snapshot, using something like LVM or ZFS.

    As a small aside, the headline was not entirely accurate. It wasn't Sun who did this. What the Sun CEO does in response to this, right on the heels of his keynote, remains to be seen.

  125. SUN and Java by centinall · · Score: 1

    I think SUN has done all they can do as far as open sourcing Java. From what I understand, they couldn't open source every component because some were proprietary and licensed for use in the SUN JVM. A couple of examples were the 2D/image libraries that were actually owned by Kodak, and sound libraries or codec libraries owned by ...? uh, can't remember. Anyway, what the OpenJDK project is seeking to do is fill in all these gaps left by the removal of the proprietary components and integrate the sum into a simple package. There should be plenty of options out there, like for example Cairo for 2D, OpenGL for 3D, etc... Please correct any mistakes I've stated.

  126. Fork it! by Anonymous Coward · · Score: 0

    That's the cool think about F/OSS code.

    Just fork it, and the new fork will move faster than Sun every could.

  127. Hey! by Anonymous Coward · · Score: 0

    Dumbass, read the other posts.

  128. Re:You can't effectively close-source anything GPL by Anonymous Coward · · Score: 0

    what about compiz / beryl / compiz-fusion?

  129. Today is a good day to fork... by Anonymous Coward · · Score: 0

    Does Sun even understand what free/open source is? They seemed to gave some understanding with Java, but this...

    You can't just control FOSS, because you don't hide the source, and the licence alllows ANYONE to tinker with it and release the result (why do you think M$ hates the GPL?)

    So let's just fork it, and if the closed stuff is worth anyrhing, independently create better versions-just for the free fork!