Slashdot Mirror


MySQL Writes Exception for PHP in License

ryanjensen writes "According to an article on News.com, MySQL wrote an exception into its license to allow PHP to use its libraries. From the article: 'Because MySQL owns copyright to all the MySQL code, it can include additional license provisions to its software. The new provision, called the Free and Open Source Software License Exception, enables people to use MySQL client libraries with other open-source projects under other open-source licenses other than the GPL.'"

313 comments

  1. A response to X? by TwistedSpring · · Score: 5, Insightful

    This is good news for all those PHP kids out there. It is nice to see some licenses being made specifically more lenient, and I don't doubt this has had something to do with the recent change in the XFree86 license and how people reacted to that. Well done MySQL, your domination is secured :)

    1. Re:A response to X? by Homology · · Score: 0, Interesting
      Why not use PostgreSQL with it's much more liberal BSD license?

      MySQL AB claims that the server is released under GPL, but then they add a restriction on distribution that hardly is compatible with GPL, as can be seen on MySQL download page :

      You need to purchase commercial non-GPL MySQL licenses:

      * If you distribute MySQL Software with your non open source software,

    2. Re:A response to X? by Anonymous Coward · · Score: 0

      In fact, I've been known to [INSERT DAUNTING TASK HERE]...

      Yeah, we ACs have a tendency to do that but never show anything to back up the claim. I'm glad I'm not the only one who does this.

    3. Re:A response to X? by /ASCII · · Score: 4, Interesting
      How is that not GPL-compatible?

      The GPL does not permit you to distribute GPL:ed code together with a prorietary product. If you want to do this, you obviously cannot use the GPL:ed version of MySQL, so this is not a restriction as much as a clarification.

      If you do want to distribute MySQL with your OS, you can simply buy a copy of MySQL under a different license, which obviously MySQL AB can provide since they are the copyright holders of the code and can relicense it as they see fit.

      --
      Try out fish, the friendly interactive shell.
    4. Re:A response to X? by LostCluster · · Score: 5, Informative

      The copyright holder of a product that is released under the GPL is not required to use the GPL as the only license. It's hard to attach a license more restrictive than the GPL to already GPLed software, but it's very easy to attach a less restrictive license.

      The copyright holder can also craft exceptions to the GPL simply by making an add-on license that promises a certain violation of their GPL rights will be tolerated, and that includes a situation under which distribution without the GPL is allowed. :)

    5. Re:A response to X? by Homology · · Score: 2, Insightful
      The GPL does not permit you to distribute GPL:ed code together with a prorietary product. If you want to do this, you obviously cannot use the GPL:ed version of MySQL, so this is not a restriction as much as a clarification.

      What are you talking about? And the moderatores are modding this as +5 Insightful/Interesting. Jeez.

    6. Re:A response to X? by KarmaMB84 · · Score: 1

      I believe they intend commercial use of the source to be binary only sourceless distributions with proprietary changes by the customer. The GPL doesn't allow this but the copyright holder has the power to sanction such activities under whatever terms they choose.

    7. Re:A response to X? by /ASCII · · Score: 2, Insightful

      Ok, given the tone, the grammar and the use of words you don't understand in your post, you are probably a troll, but I've seen a lot of non-idiots make the same claim so I'll reply:

      Basically, you're wrong.

      This is a quote from the LGPL:

      When a program is linked with a library, whether statically or using a shared library, the combination of the two is legally speaking a combined work, a derivative of the original library. The ordinary General Public License therefore permits such linking only if the entire combination fits its criteria of freedom.

      In other words, if you compile a GPL:ed program on a proprietary operating system, all the operating systems base libraries must be GPLed or you may not distribute it. So you can't distribute the GPLed MySQL with Solaris or Windows without GPLing the entire system. That is why we also have the LGPL.

      --
      Try out fish, the friendly interactive shell.
    8. Re:A response to X? by sqlrob · · Score: 3, Informative

      Yes, read the fucking gpl.

      The libraries for MySQL are GPL *NOT* LGPL. Anything linking those in must therefore be GPL compatible. I don't see the point of including MySQL if you can't say, oh, link the libraries to let your code put data in tables.

      It has the same issues as QT.

    9. Re:A response to X? by /ASCII · · Score: 3, Informative

      Already explained this in this post.

      The LGPL states that:

      "When a program is linked with a library, whether statically or using a shared library, the combination of the two is legally speaking a combined work, a derivative of the original library. The ordinary General Public License therefore permits such linking only if the entire combination fits its criteria of freedom."

      Which is pretty much what I said...

      --
      Try out fish, the friendly interactive shell.
    10. Re:A response to X? by Anonymous Coward · · Score: 0

      Why the h... does this Anonymous Coward user reply to his own comments? schizophrenia?

    11. Re:A response to X? by /ASCII · · Score: 2, Insightful

      Both MySQL and Postgres use the SQL language. Rewriting an application to use one instead of the other in a well-designed application simply means changing the database driver. So if you've rewritten applications from scratch because they use MySQL, you've been wasting a LOT of time.

      --
      Try out fish, the friendly interactive shell.
    12. Re:A response to X? by ctr2sprt · · Score: 1

      You're right, but you are unclear in how you describe it. You may not distribute MySQL as part of the operating system in that case. You can distribute it as a clearly-distinct product. From the GPL, "If identifiable sections of that work are not derived from the Program, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works." Clearly Windows and Solaris are not derived from MySQL, so all you need to do is package them such that a reasonable person would consider them independent and separate works. In the case of Windows, this would mean you put the MySQL installer in, say, the "EXTRA" folder on the install CD. Or you could include an extra CD labeled "Additional Non-Microsoft Software" that has MySQL on it.

    13. Re:A response to X? by E_elven · · Score: 2, Interesting

      MySQL does not (although the obscure fbn builds are a bit better nowadays) implement SQL properly and is not ACID compliant. Many developers have had to rely on hacks to get their stuff working -or then have written bad code because MySQL allowed it. This is why some things need more extensive rewriting. In addition, I believe there are some proprietary products that use MySQL -to achieve the same effect, one would need to write a program from scratch, presumably.

      --
      Marxist evolution is just N generations away!
    14. Re:A response to X? by Mr.+Slippery · · Score: 1
      So if you've rewritten applications from scratch because they use MySQL, you've been wasting a LOT of time.

      Especially in PHP, with it's PEAR::DB database abstraction class.

      --
      Tom Swiss | the infamous tms | my blog
      You cannot wash away blood with blood
    15. Re:A response to X? by sydb · · Score: 2, Informative

      That is not what you said at all. You said distribute together, not link. These acts are worlds apart.

      I'm surprised that a 5-digit UID should exhibit 2-digit IQ.

      --
      Yours Sincerely, Michael.
    16. Re:A response to X? by Homology · · Score: 2, Informative
      That is not what you said, and your other post in response to the AC clearly shows that you do not understand difference between distributing a program versus linking with respect to GPL license compliance.

      It is entirely within the GPL license for me to distribute a GPL program along with my propertiary application and don't open source my application, as long as I don't link with it. So how do I communicate with said GPL program? I can use TCP/IP, sockets, or even plain old text files.

    17. Re:A response to X? by jallen02 · · Score: 3, Insightful

      Sorry, I don't buy it. Even with the SQL hacks in any application of even moderate size you can hide your data layer from your application well enough that you would still only be rewriting the data access layer of your app. That is what abstraction is all about.

      I know that you will invariable have to optimize for your current DB platform to take advantage of unique optimizations and features of that platform, but that still does not mean you can't do it in a way that keeps all of the optimization details hidden from the rest of the system. This is true in almost all cases where you are using a SQL server as your data storage layer.

      Trivial apps will often not even bother with abstraction. It just seems silly to me given the handy abstraction tools via PEAR and Native libraries in PHP that anyone would not use them in a new project (versus the native calls). The only reasons (performance reasons) can still be architected away with just a little extra effort and some careful planning.

      Jeremy

    18. Re:A response to X? by ooh456 · · Score: 1

      How many times are you planning on changing the database your application runs on?

      Since MySQL is open source and cross-platform independent... I cant see why you would plan on changing it unless you picked the wrong one to start with.

      And if God forbid you DID have to change the database... it might take a few days at most. And if you wrote the application using PEAR... then it would take 5 seconds.

      I am sick of people blaming MySQL for faults that are true of every other database. I have developed for years on MySQL and never suddenly needed to change the database. Who does this and why?

    19. Re:A response to X? by Anonymous Coward · · Score: 0

      Suppose the server administrator decides to uninstall all obsolete DBMSs. It's happened before.

    20. Re:A response to X? by Anonymous Coward · · Score: 0

      You tell me.

    21. Re:A response to X? by Bromrrrrr · · Score: 2, Informative

      With MySQL it is a bit more then just an abstraction problem. Untill fairly recently MySQL did not support foreign keys and it still doesn't by default.

      So take a:
      client -< order -< parts
      relationship.
      On deleting the client you'd have to select all orders and delete the parts involved, then delete the orders and then delete the client.

      Now exchange MySQL for a real RDBMS. The RDBMS will take care of everything upon deleting the client. There is no real harm in your application trying to delete records that have already been deleted, but I hope you can see the need or at least the urge to rewrite it.

      This is just a simple example. if you take into account the multitudes of 'programmers' who've never heard of transactions and were first exposed to databases with MySQL then the agony is endless :)

      Bottom line is: when porting from MySQL, expect rewrites!

      --

      What a rotten party, have we run out of beer or something?
    22. Re:A response to X? by ooh456 · · Score: 1

      When lightning fast, cross platform, free, RBDMs become obsolete Ill worry about that or move my app to another server who still appreciates them.

    23. Re:A response to X? by Samrobb · · Score: 2, Insightful
      So you can't distribute the GPLed MySQL with Solaris or Windows without GPLing the entire system.

      Bzzt. You can't distribute the GPLed MySQL with Solaris or Windows without violating the license. (Never mind that as other posters pointer out, the GPL specifically allows linking with standard OS libraries, etc.)

      One possible way to resolve a GPL license violation is to place your code under the GPL as well, but it's not the only possible resolution. In some cases (for example, MySQL) the same version of the code my be under an enitrely different license that the author(s) will allow you to use instead. In other cases, the violator might decide to not release their source code, but instead stop shipping their product and pay any damages that might be awarded for the license violation.

      Putting the code under the GPL is a possible solution; but it's not the only solution. Unless you take the issue to court, the ultimate resolution remains a matter of negotation and agreement netween the authors of the GPL code and those who violated their license.

      --
      "Great men are not always wise: neither do the aged understand judgement." Job 32:9
    24. Re:A response to X? by Shaklee39 · · Score: 1

      Untill fairly recently MySQL did not support foreign keys and it still doesn't by default.

      Yes, it does. InnoDB comes as the default DB as of mysql 4.0 and it supports foreign keys.

    25. Re:A response to X? by Anonymous Coward · · Score: 0

      Yeah, but it did the original programmer use them?

      From my brief survey of open source mysql apps, there appears to be all sorts of horrid stuff -- denomalized tables, client-side join logic, disregard for keys. You can't fix that stuff with an abstraction layer.

      (not the same AC)

    26. Re:A response to X? by T-Ranger · · Score: 2, Insightful
      MySQL with InnoDB tables is ACID compliant. InnoDB tables are the default with 4.x, which has been out for 2+ years.

      There is a SQL standard. Exactly 0 databases conform to (any version of) the standad, implement all of the features, and dont have extensions. All vendors implement things slightly different, and have their own extensions. Some of these diversion from the standard be compatable with other vendors , but such comptability is luck.

      Many feel that this is intentional by DB vendors for customer lock in.

      While it may be theoritecly possible to build a cross vendor compatable DB, the tempation to use usefull extensions is great. It happens all the time.. Any non-trivial database / SQL program will not be cross vendor comptable. For a bunch of reasons, a lot of MySQL code has been written by people who are unaware of the state of DB incompatibilties, and thus make little effort to use portable code. Or some people just dont care about portability. It is not MySQLs fault that ignorant or apathetic users rely heavily on its extenstions/incompatabilities.

    27. Re:A response to X? by fritzfingers · · Score: 1
      In other words, if you compile a GPL:ed program on a proprietary operating system, all the operating systems base libraries must be GPLed or you may not distribute it. So you can't distribute the GPLed MySQL with Solaris or Windows without GPLing the entire system. That is why we also have the LGPL.

      Your interpretation is incorrect. Operating systems base libraries form an exception to the GPL.
      To quote the GPL:

      The source code for a work means the preferred form of the work for making modifications to it. For an executable work, complete source code means all the source code for all modules it contains, plus any associated interface definition files, plus the scripts used to control compilation and installation of the executable. However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable.

      This means you can safely distribute GPL programs for propietary systems such as Windows or Solaris

    28. Re:A response to X? by fritzfingers · · Score: 1
      Why does this get a 3 insightfull? This is just plainly wrong! The moderators are clearly not doing their job, or they don't know anything about the GPL.

      GPL quote:

      However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable.

    29. Re:A response to X? by tiger99 · · Score: 1
      I think that would make the GPL invalid, and so there would be no way that others could distribute the code, as the only licence for them to do so would be invalid. It gets complicated.....

      Of course the copyright holder is entitled to do anything they want, and despite some very careless or stupid remarks by both McBride and Ballmer, nothing forces anyone to apply the GPL anyway. It does not try to take over all your code of its own volition, as they have implied on a number of occasions. But, once you have GPLed the code, you can't take it back, although as the copyright holder, you would be able to make new versions that were not GPL.

      If you wanted GPL with some restrictions removed (as is your right as copyright holder), you would really need to write your own licence, or dual-licence under GPL and BSD for example, but if you do this, beware of forking, and others who will make the BSD licenced version proprietary, effectively stealing your hard work.

      Another problem occurs when someone using the GPL code fixes a problem, adds a feature, or just changes it in some way. If you have applied the GPL, that work is yours as well as his and everyone else's, to do with as you wish, while complying with the GPL, but if you have allowed exceptions, you may well have no rights to the modified code, based on what you wrote. It is far, far safer for everyone to stick to the GPL in full, or use an entirely different licence such as BSD if you really must.

      To clarify, it is safer to dual-licence, the user selecting which licence on offer that he wishes to comply with (one might be commercial), or to write an entirely new licence, rather than trying to graft exceptions on to the GPL, which is purposely designed to prevent these types of exception.

      It is of course perfectly permissible for the copyright holder to offer to negotiate other licencing arrangements with anyone who needs something different, but they can then only include their own code, or get specific permission from each and every other person who has contributed to the GPL code, which would at best be difficult.

    30. Re:A response to X? by lewp · · Score: 1

      Me no not wut UID have to do with IQ.

      --
      Game... blouses.
    31. Re:A response to X? by Anonymous Coward · · Score: 0

      What part of "fairly recently" you did not understand?

    32. Re:A response to X? by Anonymous Coward · · Score: 0

      "Real" RDBMS doesn't require foreign keys even if it supports them, so if you don't want to rewrite, you don't need to use the features that warrant one.

    33. Re:A response to X? by Anonymous Coward · · Score: 0

      depends. instead of "fairly recently"

      why don't you just give us the number of months you fucking moron.

      then we won't have to dance around the definition, find out that you meant 12 months ago, and call you a moron.

      you could state directly, the length of time, and we'd call you a moron straight away and be done with it.

      cause unless "fairly recently" means 5 days ago, in computer time, 2 months ago is a decade. 10 real years, is two computer lifetimes ago.

      nice way to switch to AC when the going gets rough eh?

      you moron.

    34. Re:A response to X? by jadavis · · Score: 1

      Last time I checked, SQL was supposed to be an abstraction. What prominent SQL database is the furthest from the SQL99 standard?

      So, your magic solution is an extra layer of abstraction. Those are very helpful when forced to work with a database that refuses to pay attention to the SQL standard.

      However, everything has a cost. What's the cost of an extra layer of abstraction? More code, and more rewriting of parts of your application when you change the way that data needs to be accessed. Sure, if you know what data you need and it will never change in a certain place, abstraction is great. But when version 2 needs to join with an extra table and return a list of records rather than one, you've got a problem, and you need to do a lot more rewriting than if you had used plain SQL.

      In some cases it's worth the price, in some cases not. In some cases the only reason it's worth the price is because one database vendor decides to make the cost of NOT making an abstaction layer so high (by not following the original standards) you've got no choice.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    35. Re:A response to X? by Yakman · · Score: 1

      And if you wrote the application using PEAR... then it would take 5 seconds.

      You're making the assumption that your SQL would still work with the new RDBMS. Unless your app is just "SELECT * FROM Wherever" your SQL is more that likely going to need to change.

      And if your SQL is "SELECT * FROM Wherever" then MySQL is probably good enough for what you're doing anyway :)

    36. Re:A response to X? by jadavis · · Score: 1

      I had a payment processing app on MySQL because of a shared hosting environment that only supported MySQL.

      I moved it to my own server and ported to PostgreSQL for several reasons. First, I was working with several timezones, and MySQL just drove me crazy there. Maybe I missed something, I don't know, but it seemed simple enough in PostgreSQL. MySQL would not report all errors to me, so I would assume that something was working as expected, like when I did "SELECT ... WHERE orderdate<'2003-06-06 01:02:03 PST'", when in reality it would just ignore my timezone and give me whatever rows it felt like. Similar case with other "minor" errors like a wrong date (MySQL thinks that february 31st exists), which would just go silently through. I think there is also some weirdness about how it handles strings.

      I ported to PostgreSQL in no time (it had simple database access) and had exactly 0 problems after that. Everything worked as expected, or gave me a big error so I could correct the problem before it became a real problem.

      Bottom line: I trust PostgreSQL. With MySQL, I have to trust, but verify.

      But yeah, MySQL does work. I imagine if you really know how it works in detail you can avoid the gotchas.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    37. Re:A response to X? by sydb · · Score: 1

      Hahahahaha!

      Post 996. Four to go! Then I kill myself.

      --
      Yours Sincerely, Michael.
    38. Re:A response to X? by E_elven · · Score: 1

      How many -even commercial- projects using MySQL use innoDB instead of the default?

      In any case, most of MySQL's main selling points, speed, ease, etc. become moot if you have to A) install innoDB and B) use innoDB. At that point you should just have gone with something better.

      >For a bunch of reasons, a lot of MySQL code has been written by people who are unaware of the state of DB incompatibilties, and thus make little effort to use portable code.

      Right. But that's because MySQL implemented a crippled version. You can't blame that on the customers.

      --
      Marxist evolution is just N generations away!
    39. Re:A response to X? by jallen02 · · Score: 1

      That isn't a very creative approach to dealing with problems in modern web applications.

      Whether its one record of twenty I don't see how it really affects the data layer. If your application layer is written properly it won't matter about the data layer so much. Your application layer expects a recordset with certain data. Of course having n records instead of 1 you will have to change the way the application layer deals with it. That doesn't mean you still can't view the data from a SQL server in a very generic way (a recordset, or multiple recordsets). Your application layer should be smart enough to convert SQL data types into native types. And if your application is properly normalized and you aren't using any properitary column types it will be that much easier. You can take an OO view to your recordsets or a procedural view.. whatever fits best with the application layer's current design model.

      Yes, abstraction has a cost. However in a practical sense there are platforms out there that already provide this level of abstraction and they support some incredibly busy sites. (Like ColdFusion powering the Macromedia site). So I think for all intents and purposes the abstraction is just fine for all but the most intense applications. In the real world having a flexible architecture is often more important than raw performance. I stand by my statements that abstracting SQL database access down to recordsets that have only native types to the language dealing with the data is the way to go with most applications. There are always exceptions. I am not really talking about those specific exceptions, just in general.

      One final point of yours I would like to address is that you say it will take more time when you change the way the data needs to be accessed. It depends, if we are talking changing SQL platforms and optimizing for another SQL platform.. then no it is much easier to have a specific data access layer that you change. That is the ONLY place you should have to change code when changing SQL servers (save things like stored procedures and triggers). Your application layer should see the SQL server as a black box and have no inherent knowledge about the data access layer. If we are talking a complete paradigm shift over to something like an XML database or some other different data paradigm, yes you would be talking about changing your data access paradigms in the application layer as well.

      I know its not quite so clear cut in a lot of cases, but simple SQL server abstraction is good. If you don't abstract your data access layer you are making your code that much more DIFFICULT to modify when you have to change database platforms.

      The one big area of optimization that this kind of misses is stored procedures and triggers and such. You just can't abstract away something that is IN the database layer of your app. When you need the raw performance of a stored proc that is an optimization choice you must make. When you move logic away from your application layer and towards your data layer I think you need to have specific performance reasons to do so, because.. again.. most apps don't really need that much power. You should definitely be aware of the full range of such optimization techniques, because if you don't know about them you won't have knowledge of what they are and how they work in your application design phase.

      I think we both agree on the pragmatic aspects of this, and that is such a heavily architected approach is not always required, especially for small projects that need to be done quick and fast. As your requirements grow larger so, typically, does your need for better and more flexible architecture. The bigger the app the more important it is to perform risk analysis. The more important it is to have a more defined and developed architecture. Most apps, especially open source apps that aim to have borad appeal, can benefit from an abstracted data access layer with very few data access platform specific optimizations. (And if you DO have such optimizations it makes sense to provide an un-optimized application layer only version of code in stored procs and such).

      Jeremy

    40. Re:A response to X? by rycamor · · Score: 1

      And in fact it is a _lot_ more than just transactions and foreign keys. SQL92 and SQL99 specify much of the abstract capability that forms the core of the relational model, such as views, declarative constraints, domains, user-defined functions (procedures) and more.

      No simple abstraction layer, or even a complex one, will bridge the gap between a DBMS that has these features and one that doesn't, unless you "dumb down" the more capable DBMS.

      In a serious application, the only way to achieve a cross-db implementation to this dumbed-down level is to implement many of these relational features in the application code, in which case you have just tripled the amount of code you need to write.

    41. Re:A response to X? by pyite · · Score: 1

      Huh? By that logic, anything that uses SQL does not care what database it's talking to. That's patently false. I cannot take an Oracle application, and on Windows, for instance, change the ODBC driver and say "Hey, all's good." Each database has it's own quirks and implementations. This is why people use database abstraction layers or choose a database and use it to its fullest potential.

      --

      "Nature doesn't care how smart you are. You can still be wrong." - Richard Feynman

    42. Re:A response to X? by T-Ranger · · Score: 1
      InnoDB is a sepearate project from MySQL proper, yes. But it comes with MySQL. It is the default. You have to do nothing special to install it (well, maby if your compiling it). Unless you specifiy something else in your CREATE TABLE statements, you get it by default for new tables..It is a distinction with out a difference.

      Did you read my previous post? All database vendors implement a crippled version of the spec. If all I ever use is Oracle, then I will write SQL that works only on Oracle. If all I ever use is MSSQLServer then all the SQL I write will work only on MSSQLServer. It doesnt really matter who is closest or who is furthest away from the spec; they are all different enough to be incompatable.

      What MySQL lacks is specific advanced features. You can live with out them, building the functionality with simple features into your app. This should be forwards compatable with new versions of MySQL, and cross compatable with existing SQL servers. That it is not, is not because MySQL is paticularly wrong, but that they are all wrong.

      The argument could be made that by not implementing many SQL features you implicitly force your uses to be aware of the state of incompatabilities. MySQL docs are very clear on where and how they diverge from the standard. They are very clear that they DO diverge from the standard.

    43. Re:A response to X? by jadavis · · Score: 1

      Yes, abstraction has a cost. However in a practical sense there are platforms out there that already provide this level of abstraction and they support some incredibly busy sites.

      I wasn't talking about performance cost. I would expect that a well-written abstraction layer would have negligible cost. I am talking about cost in terms of extra code and lesser maintainability of code.

      If you add an extra layer of abstraction (above and beyond the already-existing SQL99 standard), then it requires more code changes when you change the interface between your app and your data. If you add a feature, and the feature requires a different result set to be returned in a different way, than you not only have to change your code, but now the data abstraction layer as well.

      I wasn't even really disagreeing with you, but I'm just trying to warn that abstraction does have tradeoffs. It's more code, and more code is harder to maintain. In many situations it's a clear net win. However, it's frustrating when an abstraction layer exists, and then to make something work in a maintainable way you have to add another abstraction layer.

      That's what MySQL is doing when they trample SQL99. They make it extra work for anyone to use any other database. Even Microsoft Access makes some attempt at following standards, if for no other reason than so MS can upsell someone SQL Server.

      Think about the metric system. I'm a U.S. citizen, and I'm not the type to criticize our cultural ways all the time, but come on... time to use metric. We have measurement unit abstraction layers built into everything so that we can convert. However, look at how much that costs? What if the worlds #1 economy got on board with a standard that makes more sense? Wouldn't that be so much better? What if MySQL followed the standards?

      You can make the same argument for anyone who doesn't follow standards that other people "just need an abstraction layer".

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    44. Re:A response to X? by E_elven · · Score: 1

      Mm.. innoDB is enabled by default but I thought CREATE TABLE still defaults to myISAM? Could be wrong. I'm using SQLite, anyway :)

      The most problems in MySQL these days spawn from the abysmal concurrency, I thinks.

      --
      Marxist evolution is just N generations away!
  2. Quid pro quo by Space+cowboy · · Score: 3, Insightful

    Or, in this case no quids were involved (a quid is UK slang for a British pound...)

    It restores my faith in people when something like this happens - MySQL and PHP are the joint foundations on which a huge number of OS projects depend. Way to go MySQL :-))

    Simon

    --
    Physicists get Hadrons!
    1. Re:Quid pro quo by srcosmo · · Score: 1
      MySQL and PHP are the joint foundations on which a huge number of OS projects depend.

      You sir, can try writing an operating system in MySQL and PHP, and see how it turns out.
      Valuing my sanity, I'll have no part in it.

      --
      free speach
      Did you mean: free speech
  3. What about me? by Anonymous Coward · · Score: 2, Funny

    I'm a Python guy and I feel fucked over.

    1. Re:What about me? by Anonymous Coward · · Score: 0, Funny

      Concider outsourcing your python to Phpistan.

    2. Re:What about me? by Anonymous Coward · · Score: 0

      I'd feel fucked over, too, if my language didn't have some sort of database abstraction layer. Enjoy.

  4. I don't see a problem with it... by robslimo · · Score: 5, Interesting

    ...but I'm sure some GPL zealots might.

    To me, it looks like an issue of pragmatism and the MySQL folks apparently aren't hung up on religious adherence to GPL principles.

    It's an issue of maximum applicability, to me.

    1. Re:I don't see a problem with it... by AndroidCat · · Score: 1

      It's pragmatism, but it does lead to more patchwork licencing worries when you include code from several sources. It's not at the Fizbin or Dragon Poker level yet, thank Ghod.

      --
      One line blog. I hear that they're called Twitters now.
    2. Re:I don't see a problem with it... by Tablizer · · Score: 2, Funny

      It's not at the Fizbin or Dragon Poker level yet, thank Ghod.

      Fizbin! An obscure OS Trek reference where Kirk makes up a phoney "Earth game" to confuse warring factions on a planet that copied the 1920's earth styles, including Chicago gangs. It was fun watching spock trying to learn to bullshit, an activity that he clearly did not like......at first. Classic.

    3. Re:I don't see a problem with it... by Anonymous Coward · · Score: 2, Informative

      The thing about MySQL's GPL licensing nonsense is that it cannot be used from within libgda the GNOME data access system -- and so the backend for MySQL ends up being removed. This probably applies to other systems as well.

    4. Re:I don't see a problem with it... by _|()|\| · · Score: 2, Interesting
      [MySQL] cannot be used from within libgda

      While I disagree with MySQL's decision to GPL the client libraries, I don't think it's a significant problem. Libgda is LGPL, which is explicitly GPL compatible. Maintain the GPLed MySQL backend separately (which is easy to do with libgda's modular back ends), so the user has the choice to build a GPLed libgda with MySQL support.

      Incidentally, I agree with other posters that MySQL's FOSS exception is practically worthless, due to the aggregation clause.

    5. Re:I don't see a problem with it... by Anonymous Coward · · Score: 0

      Yeah, but anyone getting a distro isn't going to be recompiling their libgda just to use MySQL... so that that leave MySQL with LFS and Gentoo users.

      IMO, they are cutting their own throats.

    6. Re:I don't see a problem with it... by bangular · · Score: 1

      I don't see a problem with companies making money. Espically when it comes to large projects like MySQL. If you make money off your project, shouldn't MySQL AB make some cash too? There seems to be this bitterness against dual licenses on slashdot. Same goes for QT. MySQL and QT are both great software. If you write open source software you can use their software for free, 100% no charge. If your software is closed source and you are trying to make money off of it (also trying to make money off of mysql) MySQL AB folks should be paid for their hard work. It's what makes the world go round.

    7. Re:I don't see a problem with it... by Telex4 · · Score: 2, Interesting

      but I'm sure some GPL zealots might.

      What is wrong with being fanatically committed to the GPL and its principles? Seriously, it is all too easy to suggest that somebody who makes a stand is an extremist, when you yourself declare no standards and bend with the wind.

      Maximum applicability is pretty vague. I'm guessing you mean that individuals, groups or for-profit organisations ought to use whatever licensing terms are most applicable... but to what end? Do you value the quantity of software, the technical quality, the economic/technical/social accessibility of software, the freedom of the user in relation to software, or perhaps something else?

      You see, I'm what you might call a GPL zealot, and I'm of the opinion that as a technical tool with important social and political dimensions, the applicability of software stands in relation to its benefits to society. The GPL is a matter of pragmatism in that sense, but you're sticking to the narrow conception of value that I'm guessing is native to your culture, and labelling anyone who disagrees as a zealot. Isn't that just being irrationally and fanatically committed to a set of values without justification?

  5. It had to happen. by James+A.+J.+Joyce · · Score: 4, Insightful

    PHP and MySQL are very close. One can't really thrive without the other, so if one adopts a more restrictive license, both lose out. And considering the massive penetration of PHP and MySQL, neither can risk this kind of thing.

    1. Re:It had to happen. by confuse(issue) · · Score: 3, Informative

      One can't really thrive without the other

      In the webspace this may be true. However, MySql is far more than a backend to a web database (OK I'll admit PHP is more than access to a database as well) both projects are used independently of each other in numerous ways.

    2. Re:It had to happen. by Nuclear+Elephant · · Score: 2, Insightful

      Quite the contrary, I develop several applications using MySQL and none of them are PHP-based, but rather C. Why should PHP get any special attention? It's just another tool, one that I choose not to use, and certainly some PHP scriptkiddie doesn't deserve any better licensing than I do.

    3. Re:It had to happen. by DarkSarin · · Score: 4, Informative

      Not really...

      PHP, though most commonly used in conjunction with MySQL, cerainly has many other uses, and can connect to a number of other databases, even that *other* open source db, postgre.

      Sorry, but while it might hurt php to lose mysql, it wouldn't kill it.

      --
      "We don't know what we are doing, but we are doing it very carefully,..." Wherry, R.J. Personnel Psychology (1995)
    4. Re:It had to happen. by gbjbaanb · · Score: 1

      I don't know - there are a great many PHP projects out there that offer the use of PostgreSQL instead of MySQL.

    5. Re:It had to happen. by Anonymous Coward · · Score: 0

      If programmers would starting using PEARS Database object or wrap all their database calls up in a class of their own ... porting exisiting PHP apps using that currently use MySQL to use other DB's really wouldnt be much of an issue

    6. Re:It had to happen. by Nuclear+Elephant · · Score: 1

      I hate to burst your bubble, but my C web apps run circles around any PHP apps I've seen. PERL was recently benchmarked by Yahoo I believe as much faster than PHP. The reason I don't code PERL anymore is because of all the arrogant dumbasses on the scene...something that is about ten times worse in the PHP scene - kiddies who can't even write HTML but think they know a real language.

      My point, however, is that there are many other languages that use MySQL just as much if not more than PHP, and adding in a special provision for PHP in the MySQL license is just spitting in other developer's faces...if MySQL wants to ride their cow to the farm, fine - but if they want any shot at being a real database tool, they need to open up to all languages and treat them all equally.

    7. Re:It had to happen. by w3weasel · · Score: 1

      Thats probably true, but you'll find incompetent coders under any language. In the right hands, PHP is a *very* fast and powerful language to use. So many people love to hate PHP, but knowing the right tool for the right job is what makes for 'genius' level programming.

      --

      Just as irrigation is the lifeblood of the Southwest, lifeblood is the soup of cannibals. -- Jack Handy

    8. Re:It had to happen. by scragz · · Score: 5, Informative

      RTF license exception page. It doesn't only apply to PHP:

      Academic Free License 2.0
      Apache Software License 1.0/1.1/2.0
      Apple Public Source License 2.0
      Artistic license From Perl 5.0.8
      BSD license "July 22 1999"
      Common Public License 1.0
      GNU General Public License (GPL) 2.0
      GNU Library or "Lesser" General Public License (LGPL) 2.1
      Jabber Open Source License 1.0
      MIT license -
      Mozilla Public License (MPL) 1.0/1.1
      PHP License 3.0
      Python license (CNRI Python License) -
      Python Software Foundation License 2.1.1
      Sleepycat License "1999"
      W3C License "2001"
      Zlib/libpng License -
      Zope Public License 2.0

    9. Re:It had to happen. by Bromrrrrr · · Score: 2, Insightful

      but my C web apps run circles around any PHP apps

      Yes, I'm sure your guestbook is really nice :)

      Ok, that was a cheapshot and I apologize, but writing web apps in C sounds like either boasting or pure insanity to me.

      Do you write your shell scripts in assembly??

      --

      What a rotten party, have we run out of beer or something?
    10. Re:It had to happen. by Nuclear+Elephant · · Score: 1

      Web apps written in C generally run much faster - and i'm talking about real apps here, where speed is important. Sure, PHP and PERL have their place, and can "fake it" real good in some areas, but a good, solid web-based application in C is not difficult to accomplish and provides much more polished results than PHP or PERL. Blah blah string processing blah blah...you can do all of that in C just as easily as they tout regex's in perl. If you need direct integration with Apache, it's not hard to write an Apache module to manage dynamic objects that can be served right from the process (although this is hardly really necessary). With the added speed and more importantly granular control over the application, I would never go back to writing PERL apps. It's a night and day difference. You should try it sometime - the myth that PERL or PHP are better for web apps was started by PERL and PHP programmers who needed to justify not knowing a lick of C.

    11. Re:It had to happen. by Bromrrrrr · · Score: 1

      the myth that PERL or PHP are better for web apps was started by PERL and PHP programmers who needed to justify not knowing a lick of C.

      Ok I'm gonna start here so you know who's talking. I am a (mainly) PHP programmer and whatever your feelings may be I am VERY much a programmer and I feel no need to justify my not knowing C.

      Web apps written in C generally run much faster

      I can imagine they do.

      and i'm talking about real apps here, where speed is important.

      As opposed to what?? Fake apps?? Wannabe apps?? Imaginary apps?? Anyway are we talking about the same thing here? Differences in speeds between interpreted languages and compiled languages are measured in microseconds, not a meaningful difference when talking about web applications.

      Sure, PHP and PERL have their place, and can "fake it"

      Fake what? I'm not gonna argue that you should use Perl or PHP for your work, but what the hell do they fake?

      ...and provides much more polished results than PHP or PERL.

      How does it provide a more polished result. In what way? does the code look better? Is it easier to maintain?? What??

      Sincerley, I don't mean to troll, but you're arguments don't make sense.

      Cheers

      --

      What a rotten party, have we run out of beer or something?
    12. Re:It had to happen. by iminplaya · · Score: 2, Insightful

      Jeez...a chicken in every pot and a different license for every program. Soon, a program will be 70% license and 30% code. I definitely have to find a way into the license business. Licenses...get 'em cheap right here...GPL, LGPL(Ladies GPL), GNU, Wildebeest(?), Sleepycat, Copycat...we got 'em all!

      --
      What?
    13. Re:It had to happen. by PyromanFO · · Score: 4, Funny
      Jeez...a chicken in every pot and a different license for every program. Soon, a program will be 70% license and 30% code.

      So the open source community is finally catching up to the propietary software business!
    14. Re:It had to happen. by Anonymous Coward · · Score: 0

      Don't bother with this troll. He's just got an inferiority complex.

    15. Re:It had to happen. by Erik+Hollensbe · · Score: 2, Informative

      POSTGRES

      Founded on Ingres (not Ingre). Sorry, it's a pet peeve of mine... I've known people for years that call it that, and it drives me nuts.

      On your other comment.... It'll hurt MySQL more to abandon the OSS community than the opposite.

      Take a look at all the PHP apps that are tied to MySQL. I know there's (I think it's called) ADODB for PHP now, which for the uninformed is like perl's DBI for PHP, but it's PEAR and not everyone has it. DBI is pretty much the de-facto way to access databases in perl, and there's an easy way to write simple SQL that works for the 3 most popular UNIX databases (Oracle, MySQL and PostgreSQL), save sequence manipulation. OF course, when you start getting into more advanced SQL you're looking at a further abstraction. And forget stored procedures.

      The reason that this could have hurt PHP is that MySQL and PHP are both fast, easy to use and have little learning curve allowing junior programmer-types to get a lot done in little time.

    16. Re:It had to happen. by jadavis · · Score: 1

      In my experience MySQL is much more expendable than PHP. For that matter, databases in general are more expendable to most people, since they can just pick another DB. They don't want to rewrite the entire app though. I care a lot about my database of choice (PostgreSQL), but most people don't (rightly or wrongly).

      However, most people are much more hesitant to swap out php for something like mod_perl if they don't know it very well.

      I personally don't think MySQL would attract enough attention if it's not used in PHP.

      I think PHP would still go on without MySQL more readily.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    17. Re:It had to happen. by Anonymous Coward · · Score: 0

      I don't doubt that you found many arrogant dumbasses in the Perl world, especially since you feel compelled to make it into an acronym. It is Perl or perl, not PERL.

      Of course, there is no dumbass quite as arrogant as the dumbass who uses a phrase like "real language."

    18. Re:It had to happen. by SUB7IME · · Score: 1

      That's a reference to Herbert Hoover's pre-Depression campaign, btw.

    19. Re:It had to happen. by DarkSarin · · Score: 1

      As far as Postgres (which I had no idea was based on anything other than the SQL standard, so I'm sorry for the slip), I do think that it is a great db, and AFAIK, the php functions for it are just as good as the PHP functions for MySQL.

      I was looking at some of the support for other dbs, and I think that PHP would survive just fine. I am definitely one of the "junior programmer-types" to which you so lovingly refer, and I don't see any reason I couldn't learn Postgres, IF I need to. Of course, I like where I am because its comfy, and I am not making a living off of my m4d skillz. If I ever did, then I would have to learn a lot more than I know, but I would probably want to use postgres, based on what I have heard.

      I am generally a MySQL apologist, but I recognize that other choices are probably more appropriate for some situations. As far as PHP is concerned, I haven't ever heard a good argument against it as a server-side language.

      If you know of a reason that some other language is better, I would be interested in hearing it. Personally, I am getting really interested in PDF export, and Ming creation, which are both offered in PHP. Do other languages (such as python) support these functions?

      --
      "We don't know what we are doing, but we are doing it very carefully,..." Wherry, R.J. Personnel Psychology (1995)
    20. Re:It had to happen. by D'Sphitz · · Score: 1

      Uhh, it is an acronym.

    21. Re:It had to happen. by Erik+Hollensbe · · Score: 1

      If you know of a reason that some other language is better, I would be interested in hearing it. Personally, I am getting really interested in PDF export, and Ming creation, which are both offered in PHP. Do other languages (such as python) support these functions?

      I didn't say any other language was "better", anyone who tells you that one language is better than another unilaterally is a fool and should have their keyboard ripped out of their hands. :)

      Anyhow, I'm not a big fan of lots of bundled special-case library functions, especially the way that PHP delivers them. That's one of it's biggest drawbacks IMNSHO. Too large of a standard library that might exist or might not - very hacky and hard to predict without a lot of extra code. Other languages tend to minimize or completely eliminate this, and it's generally because of cross-platform issues.

      However, you can get hte functionality that you want for PDF's at least by using texi2pdf for TeXinfo on the command line - although it depends on what you mean by "export". If you're talking about HTML you might have to use another program or library. I really don't know what you would use in that situation. As for TeXinfo, If you don't already know, TeXinfo is a powerful yet simple markup language made for making documentation - it exports to tons of formats including PDF and info files.

      Ming, again, not sure what you're talking about, but I'm going to assume MNG since you probably aren't talking about mingw32, the win32 compiler. ImageMagick could probably do what you wanted it to do. Perl has PerlMagick which is fairly good and I believe Python and PHP have interfaces as well. Worst case you can always use the command line.

      So, no solid answers, but a lot of places to look. Of course, I think if you were that interested in finding out what else is out there you would be looking yourself. Not a jab, just a reasonable observation.

    22. Re:It had to happen. by You're+All+Wrong · · Score: 1

      As someone who uses MySQL within C, Perl and PHP, I find your split amusing. If I were to split them into 2, I'd put Perl and C together as being usably efficient, and stick PHP way out in a different field entirely. I'm a compromise man - by default I'd probably chose Perl for everything, and only if speed or minimal startup time was utterly crucial would I hit C. I only do PHP because that's what the customer wants, I'd never actively chose it.

      The best thing about Perl scripted tasks - you can get it to patch itself on the fly. I've had a server which has had almost every function rewritten, and yet it's had no downtime in 2 years! It really is like the 20 year old broom which has had the handle replaced a few times and the brush replaced a few times, but it's the same broom, honest!

      YAW.

      --
      Your head of state is a corrupt weasel, I hope you're happy.
    23. Re:It had to happen. by haggar · · Score: 1

      ..get 'em cheap right here...GPL, LGPL(Ladies GPL), GNU, Wildebeest(?), Sleepycat, Copycat...we got 'em all!

      I thiught of getting that Ladies' GPL for my wife. How much is it?

      --
      Sigged!
    24. Re:It had to happen. by DarkSarin · · Score: 1

      agreed, it is reasonable to assume that I would be looking.

      And, since I'm not really, you may also assume that I think PHP is good for what I do.

      I appreciate your answers--they are the kind of thing that I like to hear--especially from some one on /., since there are so many here that just want to fight, or argue a single position to death:)

      I am mostly doing web-related stuff, since my professional (well, semi-pro: I'm a grad student) area is Industrial/Organizational Psychology (go to www.siop.org for an explanation of what that is). So my primary interest in programming is as a hobby, though I have found it useful on occasion.

      --
      "We don't know what we are doing, but we are doing it very carefully,..." Wherry, R.J. Personnel Psychology (1995)
  6. hm? by bagel2ooo · · Score: 1

    So how is it that people were not allowed to bundle/redistribute the libraries with their own GPL/LGPL'd projects? I read through the article but don't have any of this back information. Could anyone post for me and any others curious about what these revisions were over exactly?

    --
    ( o ) one could say I'm rather baked
    1. Re:hm? by leviramsey · · Score: 2

      MySQL changed the license of the client libraries to GPL from LGPL. This meant that anything which linked to the client libs had to be GPL. The non-GPL crowd (including PHP) got in a huff about this.

    2. Re:hm? by kasperd · · Score: 3, Insightful

      MySQL changed the license of the client libraries to GPL from LGPL.

      Then how come nobody forked the libraries? You could take the new server (where it doesn't matter if the license is GPL or LGPL as you are not going to link it against anything) and the old libraries that were released under LGPL. Then modify those libraries as much as necesarry to work better with the new version of the server. And release the modified libraries under LGPL.

      --

      Do you care about the security of your wireless mouse?
    3. Re:hm? by jadavis · · Score: 1

      that's an interesting idea.

      It makes me cringe to think of the issues that might be involved there, though. Having different maintainers for the libraries and the product seems difficult, and makes me think of projects like samba where they have to constantly chase a protocol.

      The forkers would have access to the MySQL server source code, but there may be copyright infringement issues depending on how they used it.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
  7. MySql by ultrabot · · Score: 3, Interesting

    Why do people still keep using MySQL, in spite of their atrocious license changes? Or does everyone insist to keep on using the old version?

    Postgresql is there, and is as free as can be.

    BTW, why can't people just fork the old version of MySQL and use any license they want? Lack of skills?

    --
    Save your wrists today - switch to Dvorak
    1. Re:MySql by westcourt_monk · · Score: 1
      That is what we have been doing (using old MySQL) but I really want to use the latest MySQL.... Now, I think, we can install it.

      Postgresql would be nice. That was being looked in to.

      --
      I am going to hell and I am going to take all of you with me.
    2. Re:MySql by RLiegh · · Score: 4, Insightful

      Probably for the same reason that they don't switch to PostSQL -- massive investment of time in learning MySQL (we're talking years, here) which makes them hesitent to switch to an incompatible technology, and unable to do the heavy programming required to create a new branch from old MySQL code.

    3. Re:MySql by Neophytus · · Score: 1

      because most people install and use it for free

    4. Re:MySql by moosesocks · · Score: 4, Insightful

      The same reason millions of people continue to use windows and OS X.

      Everyone knows how to use it, it's well-documented, It works, and (in the case of OSX), it's pretty damn good at what it does.

      --
      -- If you try to fail and succeed, which have you done? - Uli's moose
    5. Re:MySql by Anonymous Coward · · Score: 2, Insightful
      Postgresql is there, and is as free as can be.

      Postgresql is too complicated to administer. Unless you want to hire a full time DBA then just stick with MySQL for your small projects. Much easier to setup and learn.

    6. Re:MySql by Anonymous Coward · · Score: 0

      You obviously haven't tried to use 10.3 in a heavy server scenario yet. At least Windows crashes, rather than going into pathological spin states.

    7. Re:MySql by kris · · Score: 2, Insightful

      Because Postgresql cannot compete with MySQL in terms of features that count for the target scenarios.

      Postgresql is underdocumented, the MySQL online documentation simply excels.

      There is no readily available workforce that has actual Postgresql knowledge. There are on the other hand buttloads of people available that can drive average sized MySQL installations for cheap money.

      Postgresql does not support shared scenarios as good as MySQL. That's sharing the same machine with a web server, and that's sharing multiple logical databases as in a hosting environment (including putting the actual data files into each customers chrooted environment). MySQL does this very well.

      Postgresql replication is regarded mostly experimental and is not properly integrated with the server. In larger MySQL deployments, replication is often used for load sharing (direct read only queries against any replica), and for backups.

      Postgresql already has many features MySQL either just got with 4.1 or is planned to get in 5.x. That is useless, though, if you do not need these features, but need to deploy in a hosted standard environment, relying on the available workforce.

      Still, this is a large window of opportunity for Postgresql, if Postgresql plays this correctly. So where are the MySQL migration guides, the "Hosting with Postgresql" Setup-Howtos, and where is the "Using replication in Postgresql" tutorial?

    8. Re:MySql by Anonymous Coward · · Score: 1, Informative

      In my opinion, the PostgreSQL documentation is much superior. If you mean there are a lot of books available for MySQL, well, that's true, but having to buy a 3rd party book is not my idea of a well-documented product. And PostgreSQL's command line client has much better help than MySQL's (which basically has none, forcing you to have a Web browser open if you forget the syntax to some query you want to run).

    9. Re:MySql by /ASCII · · Score: 4, Insightful

      Because MySQL is GPLed?

      Since the license of several open source scripting languages are not GPL-compatible, MySQL grants these projects additional rights above those already provided through the GPL.

      So these 'atrocious license changes' are like the TV-sales people who when you order you new set of stake knives insist on also giving you a juicer and a can opener for free.

      --
      Try out fish, the friendly interactive shell.
    10. Re:MySql by AftanGustur · · Score: 1


      Because Postgresql cannot compete with MySQL in terms of features that count for the target scenarios.

      Or as economics say it: "The quality of a product is determined by the consumer of the product."

      --
      echo '[q]sa[ln0=aln80~Psnlbx]16isb572CCB9AE9DB03273snlbxq' |dc
    11. Re:MySql by Phidoux · · Score: 1

      "massive investment of time in learning MySQL (we're talking years, here)"

      But SQL is SQL and apart form the usual database specific extensions, it is standard. So applications built on top of SQL compliant database engines should port with ease.

      Probably has more to do with comfort zones than anything else.

    12. Re:MySql by Bromrrrrr · · Score: 2

      Because Postgresql cannot compete with MySQL in terms of features that count for the target scenarios.

      Bullshit! If your scenario is 'having an RDBMS' then it's MySQL who cannot live up to the task, Transactions, subqueries and data constraints are more then just 'nifty features' you know.

      There is no readily available workforce that has actual Postgresql knowledge. There are on the other hand buttloads of people available that can drive average sized MySQL installations for cheap money.

      Yes but you get what you pay for. Database theory IS NOT hard to learn, but if you prefer your neighbourhood 'computer expert' who's never looked further then his various cookbooks, then MySQL is your database :).

      Agreed though, Postgres replication is crap at best and it's documentation is horrible. If I recall correctly most user contributed notes on postgresql.org are either complaints about how lacking the documentation is or contributions that SHOULD have been in the docs themselves.

      Sorry if this came out as a bit of a troll, I've just seen to many Perl|PHP|WhatHaveYou 'hackers' poor their awful code on an unsuspecting world *shudder* and MySQL, even though not at fault, has been a major catalyst in this. Certainly not your fault though, so sorry :)

      Cheers

      --

      What a rotten party, have we run out of beer or something?
    13. Re:MySql by ultrabot · · Score: 1

      So these 'atrocious license changes' are like the TV-sales people who when you order you new set of stake knives insist on also giving you a juicer and a can opener for free.

      By atrocious license changes I meant the original change of putting client libraries under GPL instead of LGPL.

      --
      Save your wrists today - switch to Dvorak
    14. Re:MySql by jockm · · Score: 2, Informative

      But SQL is SQL and apart form the usual database specific extensions, it is standard. So applications built on top of SQL compliant database engines should port with ease.

      Every RDBMS out there has their own extentions to the SQL language, and none of them implement the entire SQL-99 spec. So every system is both a subset and a superset of the standard. Robust dtatabase applications end up tailoring their SQL to the paticular database system they are using, and porting away can be a non-trivial task.

      --

      What do you know I wrote a novel
    15. Re:MySql by gr8_phk · · Score: 1
      "why can't people just fork the old version of MySQL and use any license they want?"

      You can't just take software under a GPL license and change to "any license you want". The GPL does not permit that, nor does the LGPL (which does allow you to change to GPL). They changed license to GPL because people were abusing the LGPL. The only people who were legitimately upset were other open source (not free) software projects. MySQL now offers them a specific OK to use their product. I don't see any reason to call this "atrocious" and I don't understand how this gets modded up to 5.

    16. Re:MySql by Billly+Gates · · Score: 2, Funny

      Because Linux cannot compete with Windows in terms of features that count for the target scenarios.

      The Linux how-to's are underdocumented, the MSDN online documentation simply excels.

      There is no readily available workforce that has actual Linux knowledge compared to MCSE's. There are on the other hand buttloads of people available that can drive average sized Windows installations for cheap money.

      Linux does not support shared ole/com business apps as good as Windows. That's sharing the same machine with a active directory, and that's sharing multiple logical MS-SQL server databases as in a hosting environment (including putting the actual data files into each customers profiles). Windows does this very well.

      Unix LPAD replication is regarded mostly experimental and is not properly integrated with the server. In larger Windows/Active directory deployments, replication is often used for load sharing (direct read only queries against any replica), and for backups of profiles.

      Linux already has many features Windows2k3 either just got with 4.1 or is planned to get in longhorn. That is useless, though, if you do not need these features, but need to deploy in a hosted standard shared environment, relying on the available workforce.

      Still, this is a large window of opportunity for Linux, if Linux plays this correctly. So where are the Windows migration guides, the "Hosting with Linux" Setup-Howtos, and where is the "Using LPAD/Kerbos replication how-to's" tutorial?

    17. Re:MySql by ultrabot · · Score: 1

      You can't just take software under a GPL license and change to "any license you want".

      No, but you can take an LGPL library and link it to a software with any license you want.

      They changed license to GPL because people were abusing the LGPL.

      Care to elaborate?

      The only people who were legitimately upset were other open source (not free) software projects.

      Different people have different views on who is "legitimately" upset when he is upset.

      I don't see any reason to call this "atrocious" and I don't understand how this gets modded up to 5.

      Suppose that you invest lots of effort in a non-GPL (proprietary) software that uses a library that is LGPL. Suddenly, the lib changes to GPL, therefore you cannot use it (new versions anyway) without forking some cash. Some people might legitimately feel screwed. They have the option of sticking to the old version or paying up. In many occasions neither is acceptable.

      Forking the client libraries from the last non-GPL version might be a reasonable strategy here, with the option of paying up if it's desirable to have the "official" libs.

      I don't use MySQL so I don't care all that much, though. I can just imagine the remorse many a coder-wannabe feels when they tell their bosses that this stuff they were so eagerly pushing is not free anymore.

      --
      Save your wrists today - switch to Dvorak
    18. Re:MySql by kris · · Score: 2, Insightful

      Bullshit! If your scenario is 'having an RDBMS' then it's MySQL who cannot live up to the task, Transactions, subqueries and data constraints are more then just 'nifty features' you know.

      I know. Even MySQL knows, or otherwise they wouldn't build them into their current versions.

      Still their importance is overestimated - the bottom 80% of all applications are just fine with MySQLs MYISAM "autocommit style nontransactions" and deal without subqueries just fine. MySQL just totally owns that market because a) it serves up these 80% of customers blindingly fast, b) it implements stuff that does not have to do with databases in the first place, but with management issues such as being drop dead easy to administer and fit into a hosted environment just nicely.

      Sorry if this came out as a bit of a troll, I've just seen to many Perl|PHP|WhatHaveYou 'hackers' poor their awful code on an unsuspecting world *shudder* and MySQL, even though not at fault, has been a major catalyst in this. Certainly not your fault though, so sorry

      I know databases, and I know the past and current limitations of MySQL. They do not concern me in the vast majority of cases where I do need a database. By using MySQL for such projects, I can be sure that just about everybody will be able to maintain the end result, which again, is not a database, but a management issue.

      And this is probably the main gripe I have with the Postgresql people. The almost certainly are the better database people, but they are completely lacking vision regarding analysis of target market requirements (MySQL excels here!) and their marketing/community communication department is next to nonexisting.

      So they do have the better database, but nobody cares. That's a shame, and it should be changed. Remebering last years Linuxtag, I just don't know how. These people are hopeless geeks.

    19. Re:MySql by CJSpil · · Score: 2, Insightful

      Would you care to give some examples as to how PostgreSQL is harder to administer than MySQL? Having used both, I would say they are both fairly easy to administer.

      If you want something that can be really nasty to administer, use Oracle or DB2

      As far as I am concerned, it's all about selecting the right tool for the job. My last project needed subqueries and enforced relational integrity and at the time MySQL couldn't handle this, PostgreSQL could!

      Unfortunately for MySQL that means that I'm unlikely to consider it for another project, unless it can offer something that I need that PostgreSQL can't (Hasn't happened yet)

      --
      For people who like peace and quiet. A phoneless cord!
    20. Re:MySql by yerfatma · · Score: 1
      That's really all there is to it. Postgre is built to be secure, which makes it hard to get started if you're new. MySQL's ease of install, setup, administration and use have made it a self-fufilling prophecy . I'd like to start using (the existing user base creates a lot of support online for newbies) Postgre more often when we build apps at work (though our PHP stuff is always on MySQL, we abstract the data layer (or at least those of us who care do) to the point where the switch would be trivial), but our clients who want PHP/ Linux only provide us with a MySQL option. We could certainly fight for PG, but if we succeed, what did we do besides lower our margins by taking the time to argue, port and setup on PG?

      That's a rhetorical question, so let's take the zealot response as read.

    21. Re:MySql by Anonymous Coward · · Score: 0

      Hi, I'm an admitted idiot. I'm openly acknowledged to be so at work -- I survived the layoffs by being the only guy in the IT department willing to learn how to program new phone extensions into the PBX, it was so boring everyone else wouldn't bother, and it was hard as hell for me. When the cuts came, the managers knew they had to talk to me about every extension change, and they wouldn't lay me off.

      Anyway, an idiot like me has found no difference in the administration of postgresql and mysql. Just read the nice pretty html docs on the web and cut and paste the commands. Just so you know.

      Who modded this as insightful ?

    22. Re:MySql by Cecil · · Score: 2, Interesting

      Postgresql replication is regarded mostly experimental and is not properly integrated with the server. In larger MySQL deployments, replication is often used for load sharing (direct read only queries against any replica), and for backups.

      Perhaps PostgreSQL is not as unreliable as MySQL, so it doesn't need replication nearly as badly. I have yet to see a slashdotted site running postgres fall over and die (although it does get slow). MySQL, on the other hand, how often have you seen it return blank screens, database-refused-connect errors?

      How people get off calling MySQL "enterprise level" boggles my mind. It might as well be a fucking flat file that supports SQL. Speed at what cost?

      Sorry. I just get so frustrated when my employer needs a database, everyone suggests "MySQL is the greatest" and then my employer goes to use it, finds it doesn't support referential integrity, doesn't support transactions, crashes or locks up or misbehaves under strain, doesn't do anything a database should do, gives up, and BUYS ORACLE INSTEAD.

      MySQL is a toy, not enterprise level. It's nice, it's cute, it's relatively fast, but it's not always the best damn tool for the job. MySQL and PostgreSQL both have their niches. Learn them both, use them both.

      There is no readily available workforce that has actual Postgresql knowledge.

      Sadly true. There are too many MySQL zealots out there that see MySQL as the only possible solution to any problem.

      Disclaimer: I am not a PostgreSQL zealot, though I may sound like one. I'm just fed up with the general consensus that MySQL is "the only serious open source database" while Postgres is basically ignored except as a curious sidenote.

    23. Re:MySql by noda132 · · Score: 1

      Why do people still keep using MySQL, in spite of their atrocious license changes?

      Some people wouldn't call a switch from LGPL to GPL "atrocious." They've been arguing for ages that the GPL is better. And since they wrote both licenses, they must know what they're talking about.

    24. Re:MySql by Megasphaera+Elsdenii · · Score: 1

      uh ... why do people still keep using MySQL, in spite of their atrocious adherence to the relational model and standards? No integrity to speak of, no sub-selects, no set operators, no triggers ... Seriously, there is just no excuse for MySQL. And don't get me started on speed ...

    25. Re:MySql by Bromrrrrr · · Score: 2, Interesting

      Still their importance is overestimated - the bottom 80% of all applications are just fine with MySQLs MYISAM "autocommit style nontransactions" and deal without subqueries just fine.

      No, in fact they are not fine with it, and unless you want to compensate me for every unnecessary line of code I had to write for using MySQL I will not agree with you :).

      By using MySQL for such projects, I can be sure that just about everybody will be able to maintain the end result, which again, is not a database, but a management issue.

      Quality, Price, Time. Pick any two. I can't blame you for going the route that gives you the most return and I won't, but I prefer quality in my work and I like to take pride in my work, MySQL as it is now won't give me that.

      And this is probably the main gripe I have with the Postgresql people. The almost certainly are the better database people, but they are completely lacking vision regarding analysis of target market requirements (MySQL excels here!) and their marketing/community communication department is next to nonexisting.

      And still, you know about postgress, you claim to know about databases and you tell your clients to go with MySQL?

      --

      What a rotten party, have we run out of beer or something?
    26. Re:MySql by vandan · · Score: 1
      Dude you need to decrease the amount of time between joints. From what I can tell, you are one of the very few yet very vocal Postgres zealots who take great pride in rocking up to every MySQL story and bombarding us with bullshit such as:

      doesn't support referential integrity


      or

      doesn't support transactions


      or

      crashes or locks up or misbehaves under strain


      All of those claims are false. I would be surprised if you had used MySQL at all. But you continual stream of lies suggests that either you:

      a) Have no idea what you're talking about, or
      b) Know that what you are preaching is utter bullshit, and have no intention of listening to reason, as it undermines your opinion that Postgres is the all-powerful database god, and that fucking elephant is our idol.

      Next time you go on the anti-MySQL rampage, you should note that you will convince more people if you stick to facts.

      Fucking Postgres zealots...
    27. Re:MySql by kris · · Score: 4, Insightful

      Perhaps PostgreSQL is not as unreliable as MySQL, so it doesn't need replication nearly as badly. I have yet to see a slashdotted site running postgres fall over and die (although it does get slow).

      Replication is not limited to reliability issues, in fact, even in MySQL it is not used for that most of the time. It is instead being used for scalability, and for convenience.

      When MySQL sites fail, they usually fail due to the MySQL connection pool being exhausted - MySQL has a configureable limit for this, and your webserver has a configureable limit for the number of concurrent connections (each using a number of database connections) it serves. If these numbers do not match, any database server will return errors.

      And just for the record, where I work, I have seen Oracle servers fall over and die. Not due to connection limits, but due to plain and simple errors inside the code. Then again, where I work we tend to exercise our machines quite a bit.

      MySQL is a toy

      Actually, I'd tend to call MySQL a tool. One that's has been vastly different from Postgresql and Oracle in the past (3.x versions), and one that served the target market much better than either Postgresql or Oracle could - there is simply no way to build shared hosting for webshop/weblog/guestbook/cms/ad-hoc type applications based on Oracle for a competitive price.

      And even if you managed to get the licenses for free, the hardware and administration costs would have forced you out of the market. Using Oracle here would be like using the sledge hammer for motherboard maintenance.

      Similar situation with Postgresql: At the time the LAMP hosting market was created, the Postgresql team did not offer their product in a packaging that was usable for the job - no neat distribution, no documentation that a hoster could have handed to the end user, no proper support for shared hosting environments.

      MySQL addressed all these needs, had a matching deployment model and the price was right. Using this as a vehicle, MySQL grew with the market and created a vast number of people using MySQL as a household name.

      That was possible, because this was a new market far below what the established database vendors saw as their target markets, and with much smaller requirements. There was no need at all for "enterprise level" in webhosting environments.

      But consider what MySQL did to the unwashed masses: Before the advent of the LAMP combination, SQL knowledge was expert knowledge, and hard to find. MySQL, not Postgres nor Oracle - both older than MySQL! - , changed this and today every script kiddie has basic MySQL syntax knowledge and would rather chose a MySQL database than a flat file to store a high score list.

      MySQL 4.0 and 4.1 are the first steps MySQL, the company, takes migrate their market upwards into "enterprise" regions. 5.0 will take them there, read the feature plan and try out the Alpha. They are arriving in their new market segment right now, and they are not alone. They are bringing masses of people that grew up on MySQL and that grew with MySQL.

      That does two things: It commoditizes databases, gnawing at the market from below. MySQL does to the SQL market what Linux did to the Unix market, only that MySQL is now where Linux was in 1994 in terms of market development. It also popularizes knowledge, in this case knowledge about relational algebra and data modelling, about SQL, replication, storage management and related issues, just as the advent of Linux popularized knowledge about Unix, about TCP/IP networking and a lot of related topics.

      Any yeah: Linux was not "enterprise level" in 1994 as well and got badmouthed by the established Unix vendors. Didn't help them much: It is Linux that's still around, while the rest is either vanishing, sueing themselves to death or is frantically becoming Linux compatible.

      MySQL could become the Linux of the database market. If - and that's a big if - if the MySQL management avoids getting into the way of such a development.

      Chances are that they fuck it up. There is to much venture capital involved - these people want to see 3-5 year returns on their money, but we are talking a 10-15 year development here.

    28. Re:MySql by kris · · Score: 1

      Quality, Price, Time. Pick any two. I can't blame you for going the route that gives you the most return and I won't, but I prefer quality in my work and I like to take pride in my work, MySQL as it is now won't give me that.

      Any responsible management person will pick Price and Time, then use the return to invest in quality. In Open Source, we call that "release early, release often", but the motivation and reasoning behind it is just the same.

      Any irresponsible management person will pick Price and Time, then take the return and vanish. In Open Source, we call that "abandoned projects". There are plenty of them.

      That being said, MySQL 4.x will give you the qualities you are looking for.

      MySQL, the company, just did what the responsible management person would have done: They created an early release, and brought it to market as early as possible. They created the userbase, they worked on the product, and they listened to the wishes of their user base.

      They are now slowly working their way upwards, as their user base begins to integrate their web server databases more tightly with their higher developed backend databases. So it is only natural that their MySQL server is getting a more Postgresql like feature list in their 4.x series and that they are maintaining SAPDB as an Oracle 7.x/8.x level database.

    29. Re:MySql by Cajal · · Score: 1

      "Probably for the same reason that they don't switch to PostSQL -- massive investment of time in learning MySQL (we're talking years, here)"

      But I thought MySQL's claim to fame was how easy it was to use?

      Why not just use PostgreSQL and avoid all of this nonsense? It's BSD licensed, free for everyone, there's a very good user and developer community built up around it, the docs are excellent and it just plain works.

    30. Re:MySql by Mr.+Slippery · · Score: 1
      Postgresql is underdocumented, the MySQL online documentation simply excels.

      I've found the Postgres documentation entirely adequate. What do you find lacking?

      There is no readily available workforce that has actual Postgresql knowledge.

      You don't need much "Postgres" knowledge - your SQL knowledge applies. MySQL requires more of a seperate body of knowledge.

      --
      Tom Swiss | the infamous tms | my blog
      You cannot wash away blood with blood
    31. Re:MySql by doom · · Score: 3, Insightful
      kris wrote:

      And just for the record, where I work, I have seen Oracle servers fall over and die. Not due to connection limits, but due to plain and simple errors inside the code.
      Acutally, I've worked places where this was happening with Oracle now and then for reasons that were hard to determine. There was some sort of load-related "spiral-of-death" happening. A shutdown and restart would "fix" everything, until the next time... (the solution they came up with was to just reduce the query load on the Oracle database by using distributed Postgresql databases with copies of read-mostly data).

      Actually, I'd tend to call MySQL a tool. One that's has been vastly different from Postgresql and Oracle in the past (3.x versions), and one that served the target market much better than either Postgresql or Oracle could - there is simply no way to build shared hosting for webshop/weblog/guestbook/cms/ad-hoc type applications based on Oracle for a competitive price.
      But suddenly you're not talking about Postgresql anymore... Most of the stuff people do with MySQL you could easily do with Postgresql instead (hell, *most* of it you could just use BDB).

      This seems a little confused:

      Similar situation with Postgresql: At the time the LAMP hosting market was created, the Postgresql team did not offer their product in a packaging that was usable for the job - no neat distribution, no documentation that a hoster could have handed to the end user, no proper support for shared hosting environments.
      I can't imagine what you're talking about, really. When web apps were adopting MySQL Postgresql had a number of genuine technical problems that turned people off, but these don't sound like them. For example, there was an 18K limit on row size.

      (And also during that period, MySQL had the market cornered on bullshit. Like "Transactions??? Aww, you don't need that shit." And MySQL boosters than -- and now -- seem to regard mysql.org as the fountain of truth... for example, "MySQL is *fast*" appears to be an article of faith, but the people who say that rarely do their own benchmarks, never worry about what happens under heavy load, etc.)

      Any yeah: Linux was not "enterprise level" in 1994 as well and got badmouthed by the established Unix vendors.
      And they all laughed at Christopher Columbus, but many people who seem crazy genuinely are crazy, and some things that experts sneer at as toys may in fact really be toys.

      Chances are that they fuck it up. There is to much venture capital involved - these people want to see 3-5 year returns on their money, but we are talking a 10-15 year development here.
      Yup. Usually venture capital is the death of anything worthwhile (it's amazing google has held on for so long).

      Anyway, I should explain that I don't keep up with the state of MySQL's code. For all I know the MySQL defenders are right when they say they're got all the features you could want now... I gave up on following MySQL a long time ago, but I did it as much for social reasons as for technical ones.

      MySQL has always been a little too cute in the way they pose like one of the guys to keep their mindshare in the free/open world. Remember the old not-exactly-free license that penalized people for running on Microsoft? It's sounds like they're trying to play the same kind of games with their sort-of-GPL'ed libraries.

    32. Re:MySql by Billly+Gates · · Score: 1

      .. and postgreSQL would be BSD. Not as cutting edge or popular but has more advanced server features.

      Linux right now with 2.6 finally has caught and surpassed it.

      But PostgresSQL today can do all the things of mysql and more.

      If you need data integrity, scalablility, and learning sql with features more in common with Oracle, sybase, and MS-SQl, then Postgresql is the way to go.

      I surely would feel more comfortable using that on a e-commerce site with credit card orders then designing the site with mysql.

    33. Re:MySql by Billly+Gates · · Score: 1

      I use postgresql as well. It was a pain to find an isp that used that rather then mysql which is why Mysql is popular.

      But remember Microsofts first versions of SQL-server for OS/2 and NT 3.5?

      They sucked quite badly, but now SQL server is about to overtake Oracle in being the defacto database standard in marketshare. Of course IBM's DB2 and mysql are in combination stealing from Oracle which is tipping the marketshare to Microsoft, but my point is that overtime they improve.

      Linux sucked but now is better and same is going to happen with Mysql.

      In 5 years perhaps it can take on postgreSQL, Oracle, and SQL-Server. The poster does have a point.

    34. Re:MySql by jadavis · · Score: 1

      Postgresql does not support shared scenarios as good as MySQL. That's sharing the same machine with a web server, and that's sharing multiple logical databases as in a hosting environment (including putting the actual data files into each customers chrooted environment). MySQL does this very well.

      Sure you can. "CREATE DATABASE username LOCATION='/home/username/pgdata'". This has been around for a while (since 7.1 at least which was several years ago; we're now on 7.4).

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    35. Re:MySql by doom · · Score: 2, Insightful
      Billly Gates wrote:
      I use postgresql as well. It was a pain to find an isp that used that rather then mysql which is why Mysql is popular.
      You've got a cause-and-effect problem going here. MySQL became popular at a critical time, hence it became ubiquitous. It's not particularly *difficult* for an ISP to provide Postgresql support, but it would be just one more thing to hassle about, and the market is relatively small...

      I think part of the trouble there is that if you're half-way serious you want to set up your own boxes anyway... the small fry that want to run web apps on someone else's box are either (a) unlikely to need a real RDBMS like postgresql or (b) unlikely to know why they need it, take your pick.

    36. Re:MySql by RogerWilco · · Score: 1

      At my former employer we used MySQL for two reasons:
      It's free and it runs on windows.
      IIRC if you need tht your only option is MySQL.

      --
      RogerWilco the Adventurous Janitor
  8. Distros cannot take advantage of this by tepples · · Score: 5, Interesting

    This license exception is BS. It requires that "The Derivative Work does not include or aggregate any part of the MySQL Server" where "the term 'include or aggregate' means to embed, integrate, bundle, aggregate, link, distribute on the same media or in the same packaging, provide with instructions to download or automate any of the preceding processes." This effectively means that any non-GPL program that links to MySQL client libraries cannot be distributed in an operating system distribution with the MySQL server. It also means that the documentation for such packages can't even mention "www.MySQL.com" because that would count as "provid[ing] with instructions to download".

    1. Re:Distros cannot take advantage of this by Homology · · Score: 3, Interesting
      This license exception is BS.

      Indeed, and PHP users caring about GPL should worry about the tight coupling with a database server that has restrictions on binary distribution.

    2. Re:Distros cannot take advantage of this by gumbi+west · · Score: 1
      I'm sorry, I'm really confused, they are granting an additional privilege. "As a special exception to the terms and conditions of version 2.0 of the GPL: You are free to [...]"

      I don't understand how you can complain about them granting additional privileges. Please explain.

    3. Re:Distros cannot take advantage of this by gumbi+west · · Score: 1

      I don't understand, MySQL is changing the GPL to grant additional privileges of license. What should people we worried about?

  9. At what point do you devalue your use of the GPL by RLiegh · · Score: 1

    If your intent is to foster contributions to your project, then aren't you in danger of losing that by allowing more liberal (and potentially, more closed) licenses to be used with your project?

    MySQL seems to be working well with perl, I don't see why they should encourage PHP (unless the developers of PHP want to play source with us in OSS land)

  10. Good Company Policy by Un0r1g1nal · · Score: 1

    It's companies like this that really have the confidence and trust of the 'mass' market. By openly supporting and helping people that will for the most part not give them any return they really show up the likes of SCO with all the crap they have been shovelling out of their head office.
    And of course, even though they don't see any actual profit or return of investment by this good will gesture it makes people like me have a greater desire to support the company by buying their products over their rivals.

    --
    If at first you DON'T succeed, Skydiving is NOT for YOU!!
  11. LGPL by X-Nc · · Score: 1

    Kinda makes me think they should have stuck with the LGPL. Not that I don't understand why they went to GPL (it's all about the Benjamin's).

    --
    --
    If I actually could spell I'd have spelled it right in the first place.
    1. Re:LGPL by IntergalacticWalrus · · Score: 1

      Kinda makes me think they should have stuck with the LGPL. Not that I don't understand why they went to GPL (it's all about the Benjamin's).

      Trolltech-style business model: release your libraries freely as GPL, and sell commercial licenses to those who don't want to be restricted by Stallman's fascist pet license.

    2. Re:LGPL by Anonymous Coward · · Score: 0

      stallman is not fascist
      and gpl is not only the rms's pet licence.

      that previous comment don't worth a score of 1.

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

      And yours isn't worth the score of -1.

  12. Love PHP! by tarzan353 · · Score: 4, Interesting

    I really enjoy using PHP for web development. I find that you can't beat scripting languages for ease of maintenance, quick turnaround time, and tweakability.

    One of the big reasons I chose PHP was the availability of "LAMP": Linux, Apache, MySQL, PHP. I know these technologies have been around for years and will be around for many more years, so it's an easy sell to management. There's plenty of talk on the newgroups if you ever get stuck and PHP's online documentation with user comments is priceless. I think more documentation should follow this example.

    That aside, the pure performance and reliability of the above is excellent. These technologies were made to work together, and from what I hear the teams even collaborate to make sure their stuff stays working together. It really shows.

    Years ago I worked on ASP/SQL Server solutions and where you had to go with native code for high-performance with ASP, I find that with PHP it is high performance on its own.

    Great job to everyone who has helped put together these technology solutions. A shining example of the high quality that can come out of the collaborative efforts of many.

    1. Re:Love PHP! by botzi · · Score: 1
      I find that you can't beat scripting languages for ease of maintenance, quick turnaround time, and tweakability.

      What are you talking about??? The design of your projects usually has very little to do with the type of language. I've done *VERY BIG*(enormous??) PHP works and IMO, the easiest way not to lose yourself in the code is the use of an OO approach (even if the PHP implementation is still incomplete).
      As for maintenance, once again it depends on your desing abilities, nothign easier than writing ugly code.

      --
      1. No sig. 2. ???? 3. Profit!!!
  13. correction to the above: by Anonymous Coward · · Score: 0

    the developers of PHP want to play source with us in OSS land) should read the developers of PHP want to play nice with us in OSS land)

    1. Re:correction to the above: by Anonymous Coward · · Score: 0

      you = linux/GPL zealot

    2. Re:correction to the above: by Anonymous Coward · · Score: 0

      Yeah? So...what's your fucking point?

  14. Old news? by Richard_at_work · · Score: 4, Interesting

    Im sure i saw this within the Mysql license over 2 months ago. Its good to see mysql making exceptions for other opensource projects, and acknowledging that there are other non gpl licenses. I wonder if the PHP crew will reevaluate the decision to remove mysql client from php5?

    1. Re:Old news? by caluml · · Score: 1
      Old news?
      Im sure i saw this within the Mysql license over 2 months ago.

      So did you submit it?

    2. Re:Old news? by Richard_at_work · · Score: 1

      No, because im not addicted to license changes like some people seem to be.

    3. Re:Old news? by caluml · · Score: 1

      Me neither - I couldn't care less, as long as I can install it, and anything I make with it belongs to me.

  15. Python is included too by attonitus · · Score: 5, Informative

    FOSS license Exception. Scroll down for the table.

  16. Will this boot MySQL from Debian? by Mr.+Darl+McBride · · Score: 4, Interesting
    Debian prohibits discriminatory licenses. The exception makes this become a discriminatory license.

    Will Debian now remove MySQL or move it to non-free?

    ~Darl

    1. Re:Will this boot MySQL from Debian? by Anonymous Coward · · Score: 1

      No, it will stay with older version, just like all the rest of the software in debian (Don't mention unstable, that is out of date too)

    2. Re:Will this boot MySQL from Debian? by Anonymous Coward · · Score: 0

      RICHARD ASSMAN WOOOOOOOOOOOOOOOOOOOOOOOOO

      Lameness filter encountered. Post aborted!
      Reason: Don't use so many caps. It's like YELLING.

    3. Re:Will this boot MySQL from Debian? by saforrest · · Score: 3, Informative

      Will Debian now remove MySQL or move it to non-free?

      Well, whether or not MySQL happens to allow this exception themselves, I don't see any reason why Debian couldn't simply redistribute MySQL and remove the exception.

      Presumably MySQL is offering a specific non-GPL licence to select 'friends', of which PHP is one. This does not change the fact that MySQL is also distributing its product under the GPL. Thus, Debian can simply choose to only use the GPL for redistribution.

    4. Re:Will this boot MySQL from Debian? by Anonymous Coward · · Score: 0

      Parent is a troll. For fuck's sake, moderators - look at the poster name before you mod up.

    5. Re:Will this boot MySQL from Debian? by interiot · · Score: 5, Insightful
      Debian Free Software Guidelines (DFSG):
      • 5. No Discrimination Against Persons or Groups
      • The license must not discriminate against any person or group of persons.

        6. No Discrimination Against Fields of Endeavor

        The license must not restrict anyone from making use of the program in a specific field of endeavor. For example, it may not restrict the program from being used in a business, or from being used for genetic research.

      Debian Free Software Guidelines (DFSG) FAQ:
      • Q: What about licenses that grant different rights to different groups? Isn't that discrimination, banned by DFSG#5/6?
      • A: For Debian's purposes, if all the different groups can exercise their DFSG rights, it's OK if there are other people who can do more. For example, if a work were distributed to everyone under the GPL, but elementary school teachers were given the extra right to distribute binaries without distributing the corresponding source code, it would still be DFSG-Free.

      Makes a whole lot of sense to me.
    6. Re:Will this boot MySQL from Debian? by Anonymous Coward · · Score: 0
      I don't see any reason why Debian couldn't simply redistribute MySQL and remove the exception.

      You are missing the entire point.

      Debian is about "free software", not "free software as long as we turn a blind eye". The very fact that debian would have to modify things in order to MAKE it free goes against the reason they exist, to PROMOTE free software. To do this would give justification for people who make obscenely restrictive licenses.

    7. Re:Will this boot MySQL from Debian? by saforrest · · Score: 1

      Debian is about "free software", not "free software as long as we turn a blind eye".

      But they're not modifying anything. MySQL is distributed under two licences; Debian can simply redistribute it only under only one of these two.

      Let's suppose I contribute something to the Debian distribution, licensing it under the GPL. People like my code, use it all over the place, but for whatever reason, nobody else actually modifies it. So I retain complete copyright to the code as it exists in the Debian distribution.

      Several years later, Microsoft comes along, and offers me a million dollars to grant them a non-free licence to use my code deep within the guts of Windows, where no one will ever see it. I do so, since as the sole copyright holder, I have this right. They incorporate it into Windows.

      Should Debian now remove my package, even though it's established, and even though the only public licence I've ever released it under is the GPL? How is this different from the MySQL case?

      Here's a slightly less direct, but more true-to-life example. Many of the original BSD tools were licensed under the BSD licence, which is less restrictive than the GPL. Now, presumably they're licensed under the GPL when incorporated into Debian, because the BSD licence is GPL-compatible, but this doesn't mean these same tools aren't also available under licences that are compatible with BSD, but not with the GPL (in closed-source variants of Unix, for example).

      Does this mean these tools should be stripped from Debian's distribution? Why?

      The moral is that you can never make someone release something under only the GPL, but that it's always possible to redistribute a GPL'ed product available under other licences solely under the GPL. And that should be good enough for most circumstances.

    8. Re:Will this boot MySQL from Debian? by juhaz · · Score: 1

      Huh? It's GPL.

      If they also open it up a bit for someone else, it suddenly becomes somehow "discriminatory"?

    9. Re:Will this boot MySQL from Debian? by Mr.+Darl+McBride · · Score: 1
      If they also open it up a bit for someone else, it suddenly becomes somehow "discriminatory"?
      Yes, for the people they haven't opened it up for. Saying "Only Bob can do X" is the same as saying "Nobody can do X except for Bob."
    10. Re:Will this boot MySQL from Debian? by juhaz · · Score: 1

      Well, it's been like that all along.

      Before it was like your: Only GPL-Bob can do X.

      Very obviously discriminating against non-GPL people. Why do those damn debian folks not only include these discriminatory licenses but base their distro around it! Bloody murder.

      Now it's: Only GPL-Bob, PHP-Joe and Python-Matt (+shitload of other people) can do X.

      Yeah, it's still got severe restrictions (otherwise it would be BSD, or in public domain) but against less people then previously. This is obviously more open, not less.

  17. ok, but... by hak1du · · Score: 5, Insightful

    I have no problem with the making such a license change per se--they have the right to do it and it doesn't limit the existing license in any wqy.

    But, the approach itself strikes me as unnecessarily complex and short-sighted. There is a growing list of compatible licenses in there--who is going to keep that up to date? What's going to happen when MySQL disappears and nobody can make such little changes to the license anymore?

    A fairly straightforward compromise would be to put them under the LGPL license. I think that would also make sense because it would get vendors of commercial tools to incorporate the client libraries into their software. But it seems like MySQL's business strategy is getting into the way there because they appear to want to make money from licensing even the MySQL client libraries that way.

    This situation seems vaguely analogous to Qt's GPL license: in both cases, a commercial owner of an OSS project is choosing the GPL license as an encumbrance in order to be able to get money from some class of commercial users. In the case of MySQL, they are trying to limit the "collateral damage" to non-GPL compatible OSS projects by making exceptions. But in both cases, I suspect that having these libraries under the GPL is itself a suboptimal strategy because it limits the adoption of OSS. For things like GUI toolkits and database client libraries, it seems best for OSS if companies incorporate them into their commercial software as much as possible, and that means choosing a license more liberal than the GPL. But, again, commercial interests prevent that in these cases.

    Well, I personally had just assume that the MySQL client libraries were LGPL or BSD. Thanks for bringing this up. Not the license change itself, but the fact that it has brought the MySQL license situation to my attention, is a reason for me to think about using SQLite and PostgreSQL more seriously.

    1. Re:ok, but... by kris · · Score: 2, Informative

      Well, I personally had just assume that the MySQL client libraries were LGPL or BSD.

      The MySQL Client Libraries 3.x are LGPL. The MySQL Client Libraries 4.x are GPL. In order to talk to a 4.x server, you need 4.x client libraries. 4.x client libraries are downward compatible and can talk to 3.x servers.

    2. Re:ok, but... by Anonymous Coward · · Score: 2, Insightful

      The GNU Project has two principal licenses to use for libraries. One is the GNU Lesser GPL; the other is the ordinary GNU GPL. The choice of license makes a big difference: using the Lesser GPL permits use of the library in proprietary programs; using the ordinary GPL for a library makes it available only for free programs.

      Which license is best for a given library is a matter of strategy, and it depends on the details of the situation. At present, most GNU libraries are covered by the Lesser GPL, and that means we are using only one of these two strategies, neglecting the other. So we are now seeking more libraries to release under the ordinary GPL.

      Proprietary software developers have the advantage of money; free software developers need to make advantages for each other. Using the ordinary GPL for a library gives free software developers an advantage over proprietary developers: a library that they can use, while proprietary developers cannot use it.

      Using the ordinary GPL is not advantageous for every library. There are reasons that can make it better to use the Lesser GPL in certain cases. The most common case is when a free library's features are readily available for proprietary software through other alternative libraries. In that case, the library cannot give free software any particular advantage, so it is better to use the Lesser GPL for that library.

      This is why we used the Lesser GPL for the GNU C library. After all, there are plenty of other C libraries; using the GPL for ours would have driven proprietary software developers to use another--no problem for them, only for us.

      However, when a library provides a significant unique capability, like GNU Readline, that's a horse of a different color. The Readline library implements input editing and history for interactive programs, and that's a facility not generally available elsewhere. Releasing it under the GPL and limiting its use to free programs gives our community a real boost. At least one application program is free software today specifically because that was necessary for using Readline.

      If we amass a collection of powerful GPL-covered libraries that have no parallel available to proprietary software, they will provide a range of useful modules to serve as building blocks in new free programs. This will be a significant advantage for further free software development, and some projects will decide to make software free in order to use these libraries. University projects can easily be influenced; nowadays, as companies begin to consider making software free, even some commercial projects can be influenced in this way.

      Proprietary software developers, seeking to deny the free competition an important advantage, will try to convince authors not to contribute libraries to the GPL-covered collection. For example, they may appeal to the ego, promising "more users for this library" if we let them use the code in proprietary software products. Popularity is tempting, and it is easy for a library developer to rationalize the idea that boosting the popularity of that one library is what the community needs above all.

      But we should not listen to these temptations, because we can achieve much more if we stand together. We free software developers should support one another. By releasing libraries that are limited to free software only, we can help each other's free software packages outdo the proprietary alternatives. The whole free software movement will have more popularity, because free software as a whole will stack up better against the competition.

  18. moral: don't contribute to copyright holder by Anonymous Coward · · Score: 3, Insightful

    The moral of the story is clear: don't contribute to dual licensed projects, or any project where there is a clear single copyright owner. They have the ability to re-license at will, profiting from your work as you please and not having to offer in return what the original distribution license intended (e.g. GPL).

    1. Re:moral: don't contribute to copyright holder by Anonymous Coward · · Score: 0

      They have the ability to re-license at will, profiting from your work as you please

      Ummm, no. If you contribute your code under the GPL, they can't use it under any other license scheme. If they do, sue them for copyright infringement.

    2. Re:moral: don't contribute to copyright holder by saforrest · · Score: 3, Insightful

      The moral of the story is clear: don't contribute to dual licensed projects, or any project where there is a clear single copyright owner. They have the ability to re-license at will, profiting from your work as you please and not having to offer in return what the original distribution license intended (e.g. GPL).

      I know little about copyright law, but this seems wong to me. When you contribute code, you must have some expectation of how the code will be distributed.

      The ownership of collaborative projects cannot be determined uniquely by the initial copyright owner. For example, I don't think Linus Torvalds has the right to release Linux under a non-GPL licence.

      MySQL has always been available under more than one licence, so calling the GPL the 'original distribution license' is wrong. Contributors to MySQL must have known their work would be released commercially as well as under GPL, and contributed code with this belief.

      So, the reason MySQL has the power to release code under a non-GPL licence without breaking faith with their contributors is because they have always reserved that right to themselves, have informed contributors of this fact all along, not because they are the 'original copyright holder'.

      That said, you're quite right that if you believe strongly in the GPL as the one true licence, contributing to dual-licensed projects, especially ones in which the second licence is proprietary, might be setting yourself up for betrayal.

      A better idea than not contributing at all is forking, redistributing only under the GPL, and contributing to the new forked project. Since the original project would still be GPL'ed, you could incorporate later revisions, while keeping your own changes, but all this work would probably get tedious after awhile unless you really believed in the goal (using the GPL exclusively).

    3. Re:moral: don't contribute to copyright holder by ChopsMIDI · · Score: 3, Insightful

      Once a release has been distributed and licensed under the GPL (or any license for thaty matter), you can't "un-license" it later.

      --

      How could I say to men: "Speak louder, shout! For I am deaf!"? -Ludwig van Beethoven
    4. Re:moral: don't contribute to copyright holder by Talrias · · Score: 0

      But one can change the license of future versions as they see fit - a very important difference.

      --
      aterr - an open source threaded discussion board.
    5. Re:moral: don't contribute to copyright holder by ChopsMIDI · · Score: 1

      But one can change the license of future versions as they see fit - a very important difference.

      Yes, but that release's license cannot be changed. That was merely my point. I realize you can do whatever you want to future versions.

      --

      How could I say to men: "Speak louder, shout! For I am deaf!"? -Ludwig van Beethoven
    6. Re:moral: don't contribute to copyright holder by Anonymous Coward · · Score: 0

      So ? We can always revert to the previous version, as RedHat did in there latest release with MySQL, or revert to the last Free release and fork, as what happened with ssh -> openssh and is happening now with X.

  19. Here me now, believe me later by freelunch · · Score: 5, Informative

    MYSQL just received $19.5 million in venture capital funding.

    While this could and should be great, it remains to be seen what impact the influx will have.

  20. OurSQL fork... by turnstyle · · Score: 3, Funny
    "...unable to do the heavy programming required to create a new branch from old MySQL code."

    What heavy programming? After all, can't you just take it, change a few lines and call it OurSQL?

    --
    Here's what I do: Bitty Browser & Andromeda
    1. Re:OurSQL fork... by RLiegh · · Score: 1

      um, no. and that's not even factoring in maintence, either (which would be time-consuming as well).

    2. Re:OurSQL fork... by turnstyle · · Score: 1

      Why not? Who's to say how much of a project needs to change in order to consider it forked? Obviously to keep it moving forward would take serious ongoing work, but it seems like releasing it as a simple fork would be trivial.

      --
      Here's what I do: Bitty Browser & Andromeda
    3. Re:OurSQL fork... by rifter · · Score: 2, Funny

      Why not? Who's to say how much of a project needs to change in order to consider it forked? Obviously to keep it moving forward would take serious ongoing work, but it seems like releasing it as a simple fork would be trivial.

      It's not so much that as adding (and rewriting) the features and patches developed since the old version of MySQL was released. Then you have to maintain this new fork without the benefit of all the coders who disagree with your need for the fork and are currently working on the real MySQL as opposed to WankerSQL :).

  21. MOD PARENT UP! by Anonymous Coward · · Score: 0
    It saved us for XFree86, and now it will save us for MySQL.

    The Debian way is the Right way once more!

  22. Attention span too short to RTFM... by Anonymous Coward · · Score: 0, Troll
    which would take them about a day in the case of PostGreSQL, which is a far finer database as well.

    Go figure...

    1. Re:Attention span too short to RTFM... by AKnightCowboy · · Score: 1
      which would take them about a day in the case of PostGreSQL, which is a far finer database as well.

      What exactly is better about it? I'm just starting out with database programming and I was considering going with MySQL and PHP... Why would I choose PostgreSQL instead? PHP seems to favor MySQL as the database of choice.

    2. Re:Attention span too short to RTFM... by MadChicken · · Score: 1

      Last I checked (which probably has changed somewhat by now)...

      MySQL does not support views, stored procedures, transactions (InnoDB does, but this is an additional product) and a bunch of other developer's friends. Check out the comparison at www.sql-info.de.

      I also seem to remember replication was superior on PgSQL. Feel free to correct me.

      MySQL's big draw was simplicity and speed. Not sure if that's really relevant, in the big picture, since PG has sped up quite a bit recently, and adding InnoDB kills the speed advantage, from what I've heard.

      Also check this awesome comparison. This guy is amazing: http://www.phpbuilder.com/columns/tim20000705.php3

      --
      SYS 64738 NO CARRIER
    3. Re:Attention span too short to RTFM... by Anonymous Coward · · Score: 5, Informative

      Lots of reasons.

      Scales better with large numbers of simultaneous connections, larger tables, etc.

      Mature transactions. MySQL just gained these, but they aren't in heavy use. For applications where consistency matters, you need either transactions or locks. In MySQL you spend a lot more time coming up with locks and resolving deadlocks.

      Stored procedures. Sometimes it's useful to put code right in the database that can abort an invalid transaction or perform some other automated action. With MySQL you have to put this code in your PHP application, everywhere you access the database, rather than just once in the database. Much more code, much more debugging, and often much less efficient. The primary procedural language (PostgreSQL supports several) is Pl/PgSQL, essentially the same as Oracle's Pl/SQL. If you learn Postgres, you're well on your way to learning Oracle.

      Multi version concurrency, like the big commercial databases.

      A query optimizer that gets much better performance as your queries get complex. MySQL often can't do the same complex queries at all, and when it can does them naively at unusable speeds.

      Rule system, implementing views and other big-iron features, allowing applications to be simpler.

      Correct behavior under crash scenarios or disk full. I've never had PostgreSQL corrupt a database. MySQL will occaisionally, so your backups will get more exercise, and you'll have lost some data.

      subselects. You can often contort your MySQL queries to work around the lack of full subselects, but again, you do more work, and there isn't always a workaround.

      Foreign keys (implemented using triggers). These allow you to ensure that your data follows certain relationship rules (every sale points to a valid buyer for instance) at the database level. In MySQL you just have to make sure in PHP (outside the database) that you always generate good data.
      Mistakes happen, Postgres lets you program more defensively.

      Temporary tables. Very useful when building a complex operation inside a transaction.

      Security and authentication. Postgres has a very wide array of authentication methods, ranging from allow these IPs to do anything to local sockets, with SSL available to use to encrypt and authenticate as well.

      postgres is not as good at altering tables in production, especially if you've used the advanced features like triggers and rules (you may end up copying the data, deleting the tables, and reloading them, all inside a transaction of course).

    4. Re:Attention span too short to RTFM... by BlueCodeWarrior · · Score: 0

      What about for those of us who don't know what 'support views, stored procedures, transactions (InnoDB does, but this is an additional product) and a bunch of other developer's friends.' are? I've only ever used a little bit of SQL, and I've used MySQL because that's what I was taught... Someone else brought this kind of thing up, but since I (and everyone else in my boat) don't know what those things are or how or why to use them, what is the difference?

    5. Re:Attention span too short to RTFM... by Anonymous Coward · · Score: 0

      > Also check this awesome comparison. This guy is amazing: http://www.phpbuilder.com/columns/tim20000705.php3 [phpbuilder.com]

      Good review, but almost four years old; take with a grain of salt since a comparison of current versions of both DBs would give different results. The methodology is worth reusing, though, for doing such an updated test.

    6. Re:Attention span too short to RTFM... by Anonymous Coward · · Score: 0

      > What about for those of us who don't know what 'support views, stored procedures, transactions (InnoDB does, but this is an additional product) and a bunch of other developer's friends.' are? ...

      Google is your friend, you la-z-boy.

    7. Re:Attention span too short to RTFM... by Bromrrrrr · · Score: 1

      What about for those of us who don't know what 'support views, stored procedures, transactions (InnoDB does, but this is an additional product) and a bunch of other developer's friends.' are?

      Don't write DB apps! Simple huh? :)

      Seriously though, db theory is not at all hard to comprehend and if you can learn to program you can learn it easily.

      Do yourself a favor and learn, or if you don't want to, do everyone else a favor and stay away from databases. :)

      --

      What a rotten party, have we run out of beer or something?
    8. Re:Attention span too short to RTFM... by Beek · · Score: 1

      If you keep learning, you'll see why these things are absolutely necessary. If the integrity of your data is a must, and you have to update multiple tables, you'll see why transactions are a must. And then you'll see why stored procedures make life so much easier.

      Do a little reading about transactions. When you have to start using them, then you'll see how powerful a real DBMS is, and why MySQL stinks.

    9. Re:Attention span too short to RTFM... by MadChicken · · Score: 1

      > Also check this awesome comparison. This guy is amazing: http://www.phpbuilder.com/columns/tim20000705.php3 [phpbuilder.com]

      Good review, but almost four years old; take with a grain of salt since a comparison of current versions of both DBs would give different results. The methodology is worth reusing, though, for doing such an updated test.


      Yeah I know, salt-shaker is handy. I thought the heavy load response aspect of this was very telling, and possibly still valid...

      --
      SYS 64738 NO CARRIER
    10. Re:Attention span too short to RTFM... by BlueCodeWarrior · · Score: 0

      Yes, and I do plan to keep on learning, but I don't neccesarily mean just me.

      What about those people who only need the most basic db functions, and aren't going to use the more industrial-strength features?

      So I guess what I mean is, is MySQL sort of a 'beginner's db' that'll do basic stuff but doesn't have advanced features, and Postgre is where it's at?
      I'm no db junkie, and I've heard both sides saying that both dbs are the end all be all of databases...

    11. Re:Attention span too short to RTFM... by BlueCodeWarrior · · Score: 0

      Google is my friend for finding out what those are, but I'm sure that Google has many a link to tell me that .NET is the best application framework ever, too...and I've heard many opinions to the contrary.

    12. Re:Attention span too short to RTFM... by bangular · · Score: 1

      I don't know why everyone still insists MySQL doesn't support transactions. BDB and InnoDB tables have supported them for awhile, and myisam tables now have transaction support. BDB is more mature though and has been supported by MySQL for quite awhile.

    13. Re:Attention span too short to RTFM... by gonk · · Score: 1

      MySQL does not suport views or stored procedures. It does support transactions and replication.

      PostgreSQL does not support replication[1]. It does support transactions, views and stored procedures.

      Both are fine tools. Both have been used by many people that have achieved their goals.

      robert

      [1] There are 3rd party tools that provide PostgreSQL with transactions.

    14. Re:Attention span too short to RTFM... by Beek · · Score: 1

      I don't know if I'd call MySQL a beginner's DB... It's just not feature complete yet. Neither is Postrgres, but it's heading in a better direction (IMHO, of course).

      Really, neither of them are where it's at. Oracle and DB2 are where it's at.

    15. Re:Attention span too short to RTFM... by You're+All+Wrong · · Score: 1

      Amazing?

      "Anyway, foreign-key support is now in Postgres 7.0+, which means that when you insert a row, the database can do some fairly impressive validation checks. Same if you delete a row - it just plain won't let you delete a row if another table is depending on it. I love this idea and can envision rewriting entire websites just to take advantage of this feature."

      That's it. The interview's over. He's not got the job.
      He can envision _rewriting entire databases_?
      Sorry, we wanted someone in the real world.

      YAW.

      --
      Your head of state is a corrupt weasel, I hope you're happy.
    16. Re:Attention span too short to RTFM... by timmyf2371 · · Score: 1
      I realise you're probably kidding, but I would say MySQL is the type of database suitable for someone such as myself.

      I think an important thing to remember is that each database has a particular target market - Access, MySQL, MS SQL Server, Oracle, DB2, etc.

      I'd consider myself an amateur web developer - I develop ASP, PHP with MySQL in my spare time as a hobby and run the servers off my SDSL connection (yes I do know how to secure my box) and it's perfect for someone like me who just needs a simple DB server without the bells and whistles which make the likes of Oracle etc expensive.

      As for the PHP/Perl "argument" mentioned on other threads - as a full time employee in a non-IT role, I don't have the time to learn C or Perl. PHP/ASP are easier for me to learn, and suit me just fine as a hobbiest.

      --

      Backup not found: (A)bort (R)etry (P)anic
  23. Idiot by Anonymous Coward · · Score: 0

    You actually think thats the real Darl McBride of SCO?

    1. Re:Idiot by Ralph+Yarro · · Score: 1

      You actually think thats the real Darl McBride of SCO?

      It'd better be. He's been charging overtime for making some of these posts.

      --

      The real Ralph Yarro posts as Anonymous Coward. Anyone else is an impostor.
  24. How about Red Hat? by Bender+Unit+22 · · Score: 4, Informative

    The RH enterprise 3, releases has all MySQL v3.
    The MySQL changelog says:

    * Thu Jul 03 2003 Patrick Macdonald 3.23.57-1
    - revert to prior version of MySQL due to license incompatibilities
    with packages that link against the client. The MySQL folks are
    looking into the issue.

    1. Re:How about Red Hat? by LostCluster · · Score: 1

      I think MySQL realizes that their license is restricting some distributions that they'd rather allow, and they're working on ways fix their license so such things are allowed. Nice to see a license-writer who's admitting mistakes and patching up the damage...

  25. Commercial Open Source? by Anonymous Coward · · Score: 1, Interesting

    So, suppose I work on a community website using PHP/MySQL and I'd like to sell this, what are my options? Could I go with the GPL license, be sure to include all source code in the package (hey! PHP is a interpreted language anyway!) and get paid for installation support and distribution? What if I didn't sell it, but only used it on my own homepage?

    1. Re:Commercial Open Source? by ChopsMIDI · · Score: 3, Informative

      As for use on your own website, if you aren't planning on selling it or seling it unmodified, you can do whatever you want to it, regardless.

      But if you plan on selling it packaged, even before this add-on license, as long as you distribute the code with it, thus adhering with the GPL, you're in good shape.

      Selling it with a PHP solution is fairly straightforward...you are more or less just selling the PHP code, and telling them that it needs to run on a MySQL database. That's kinda like writing a program that runs on Linux, and telling them that they need to install linux (or you'll gladly install it for them) to run this program. You aren't really "Selling" the database.

      But even if you are, as long as the GPL is upheald, you're right as rain.

      --

      How could I say to men: "Speak louder, shout! For I am deaf!"? -Ludwig van Beethoven
  26. Popular != Better by Tassach · · Score: 0, Flamebait
    It's a shame that people waste years learning an inferior tool like MySQL and then refuse to take that knowledge and apply it to a real database. Not only that, because MySQL lacks essential features like triggers and stored procedures, people who use MySQL never learn *why* you need them. MySQL teaches people bad habits that they then refuse to unlearn; all too often, they cop an attitude rather than face the reality that they're wrong.

    As relational databases go, MySQL is utter crap. Even in the realm of open-source databases, there are better choices. Just because it's *possible* to do some jobs with MySQL, doesn't mean that it's a good idea. Anything that can be done with MySQL could be done as well or better with MS-Access. No one in their right mind would consider building a serious web application around Access, but people think using MySQL is ok for some bizarre reason.

    --
    Why is it that the proponents of "one nation under God" are so eager to get rid of "liberty and justice for all"?
    1. Re:Popular != Better by RLiegh · · Score: 2, Interesting
      Even in the realm of open-source databases, there are better choices. ... Anything that can be done with MySQL could be done as well or better with MS-Access.


      Since the first example you reached for was Microsoft that makes me wonder if there really are better choices in the OSS/database world.
    2. Re:Popular != Better by Tablizer · · Score: 1

      Just because it's *possible* to do some jobs with MySQL, doesn't mean that it's a good idea. Anything that can be done with MySQL could be done as well or better with MS-Access. No one in their right mind would consider building a serious web application around Access, but people think using MySQL is ok for some bizarre reason.

      MS-Acces (Jet) is a P.O.S. If MySQL is really that bad, it is screwed. Access has quality problems up down and all around, many that MS refused to fix because they had no competition.

    3. Re:Popular != Better by Kent+Recal · · Score: 1

      There is a new LAMP: Linux, Apache, Magic, PostgreSQL

      By my expirience PgSQL helps to scale your magic while MySQL rather prevents it from happening. ;-)

    4. Re:Popular != Better by Bromrrrrr · · Score: 1

      I think he was alluding to neither being suitable for any real DB work.

      Untill fairly recently MySQL lacked most basic RDBMS features that even MS-Access has, and it still lacks a lot of them. I would imagine that MySQL does hold up a little better then Access in a heavy production environment though :).

      I have some hope for MySQL however. They are getting there in their own timeframe. They are a company and obviously listen to their customers and take care of their bottom line first. But they do share the results with the wider community and for that they have my sympathy.

      For now however, the parent post is right. Don't use it if you can avoid it.

      --

      What a rotten party, have we run out of beer or something?
    5. Re:Popular != Better by Anonymous Coward · · Score: 0

      Why is the above modded flamebait ?

      I see a lot of pro-mysql moderation going on in this story. Obviously false comments such as "postgresql is harder to administer" are modded up. I wonder if checking the IP logs might so a few moderators from MySQL ?

    6. Re:Popular != Better by gumbi+west · · Score: 1

      "Anything that can be done with MySQL could be done as well or better with MS-Access." Uh, I have SQL queries that don't run correctly in Access...

    7. Re:Popular != Better by Anonymous Coward · · Score: 0

      It might not have been moded flamebait except that he compared MySQL to Access which puts the comment clearly int the realm of baiting for flame...

    8. Re:Popular != Better by Zontar+The+Mindless · · Score: 1

      > Not only that, because MySQL lacks essential
      > features like triggers and stored procedures

      False. I am running MySQL 5.0 and using stored procedures and user functions right now, and have been since the first of the year.

      It can be argued that triggers are not necessary, but whether you agree that they are or not, they're coming in 5.1.

      > As relational databases go, MySQL is utter crap.

      Also false. MySQL is in many cases faster than any other RDBMS in common use, including Postgreas and Oracle. And it complies with SQL-99 better than either Oracle or SQL Server.

      > Even in the realm of open-source databases,
      > there are better choices.

      That's entirely subjective (at best, since you're offered no evidence to back up this claim).

      And comparing MySQL with Access is like comparing a jet fighter with a kids' model of one.

      --
      Il n'y a pas de Planet B.
    9. Re:Popular != Better by You're+All+Wrong · · Score: 1

      I the face of the fact that I have SQL queries that don't run correctly on MySQL, it's obvious that your argument is fatuous.

      Anecdotes make extemely poor arguments.

      YAW.

      --
      Your head of state is a corrupt weasel, I hope you're happy.
    10. Re:Popular != Better by gumbi+west · · Score: 1

      Okay, how's this, I can't get 12 tables to join correctly in Access. Worse yet, it returns a subset of the actual results and throws no error--so it looks like I got a legit result set, and it takes major debuging to findout that I don't have one.

    11. Re:Popular != Better by Anonymous Coward · · Score: 0

      MySQL 5.0 is the 'Development tree.' It's not even alpha quality; 4.1 is currently the alpha release. (see www.mysql.com/downloads/index.html)

      Postgres, by contrast, has had reliable support for transactions and triggers for six or seven years now.

    12. Re:Popular != Better by Zontar+The+Mindless · · Score: 1

      I've been running 5.0.0 nonstop (with a few reboots not related to MySQL) for the last 3.5 months and I've found it quite stable. It handles the crash-me's pretty well, too.

      Postgres is a general pain to install and configure, and requires the Big "V" as well.

      MySQL is also faster and has less resource requirements.

      And, as I mentioned previously, the usefulness of triggers is debatable in any case.

      --
      Il n'y a pas de Planet B.
  27. Re:Who moderated this insightful! Its flamebait! by Anonymous Coward · · Score: 1, Funny

    Where did the poster say that installing Linux was hard or didn't work? It sounds like you are suffering from a spontaneous auto-wedgie.

  28. Check out Python Server Pages by ultrabot · · Score: 0, Offtopic

    When you start feeling that PHP doesn't have the muscle to do what needs to be done, you might want to check out PSP (Python Server Pages) which is a standard feature of new mod_python, and very much like PHP, with the exception of using a more sophisticated language for scripting.

    An article with example code can be read here

    --
    Save your wrists today - switch to Dvorak
    1. Re:Check out Python Server Pages by OmniVector · · Score: 1

      or, you might want to check out an even more superior combo: mod_ruby and eruby which does the same thing as mod_python but it isn't as crappy of a langauge as python.

      --
      - tristan
    2. Re:Check out Python Server Pages by Anonymous Coward · · Score: 0

      or, you might want to check out an even more superior combo: mod_ruby and eruby which does the same thing as mod_python but it isn't as crappy of a langauge as python.

      They are not the same thing - PSP provides PHP-like functionality.

      As far as crappiness goes, Ruby is a misguided attempt at reinventing the wheel that is Python. If you think Python is crappy, Ruby is crappy too because it's mostly the same as Python, with some bad design thrown in to please the Perl crowd.

    3. Re:Check out Python Server Pages by Anonymous Coward · · Score: 0

      Ruby idiots are almost as bad as gentoo morons these days. Or maybe they're same crowd twice... small but damn LOUD

      Guess the only way to tolerate yourself and pos you're using is to yell at all the other languages and call them "crappy" without ever bothering with a line of proof.

  29. what do you want to say exactly ? by Anonymous Coward · · Score: 0
    Just want to make a title with Python inside ? And python zealots mod this up :/

    1. Re:what do you want to say exactly ? by E_elven · · Score: 1

      Yes, it is truly a sad day in the history of ./ when personal opinions affect the otherwise-unbiased moderators. It may be contagious. Should we call Tom Ridge?

      Anyway, ROOOOBY ROXXXORZ!!1

      --
      Marxist evolution is just N generations away!
  30. Re:At what point do you devalue your use of the GP by ultrabot · · Score: 2, Insightful

    If your intent is to foster contributions to your project, then aren't you in danger of losing that by allowing more liberal (and potentially, more closed) licenses to be used with your project?

    Umm... no. For example, if the client libs were LGPL, any improvements to them would need to be public, but any program using those libs wouldn't need to be. Obviously, even with the new clause, improvements to client libs would need to be public.

    Licensing a library as GPL is motivated purely by the prospect of profiting from dual-licensing the library to companies that can't release their code under GPL.

    --
    Save your wrists today - switch to Dvorak
  31. Phrase by macdaddy · · Score: 4, Funny
    ...hung up on religious adherence to GPL principles.

    I think the phrase you're looking for is "GNU Dogma." Correct?

    1. Re:Phrase by Anonymous Coward · · Score: 0

      Please, GNU/Dogma

  32. Bloody ASP by ChopsMIDI · · Score: 2, Funny

    Years ago I worked on ASP/SQL Server solutions and where you had to go with native code for high-performance

    Let's not forget that oh so common feature of Formatting Dates in ASP, you need to link native code for the "Format" function in VB (since FormatDate gives you a whopping 4 options) to get some even remotely as close to the power of the simple "date" function in PHP. Pretty shitty. God I hate ASP.

    --

    How could I say to men: "Speak louder, shout! For I am deaf!"? -Ludwig van Beethoven
  33. The GPL is not perfect by LostCluster · · Score: 2, Insightful

    As much as there are some FSF fans wish that the GPL was the only software license, it's not the one-size-fits-all solution for everybody. That's why the LGPL exists. That's why Creative Commons exists. That's why many common open-source programs have forked the GPL to make it their own.

    We can debate the finer points of whether such changes should be made or not, but let's not treat the GPL like it's a religion. It's not perfect.

    1. Re:The GPL is not perfect by Anonymous Coward · · Score: 0
      That's why many common open-source programs have forked the GPL to make it their own.

      Normally I applaud a good troll, being regular monthly reader of The Assmaster's List, but in this case I have to correct a dangerous mis-statement.

      The GPL has never been forked, and it is copyrighted and not offered under terms that allow it's modification. You can append exceptions to it as Linus and now MySQL, Inc. have done, but not modify it and re-distribute it.

  34. Re:At what point do you devalue your use of the GP by Bromrrrrr · · Score: 1

    It's really a good thing to know what you are on about before posting you know. Reading the article can help.

    This is not about PHP not working with MySQL and certainly not about any restrictive license on PHP's part.

    MySQL enjoyed a special status with PHP as being bundled with PHP by default. MySQL changed the license for their libraries from LGPL to GPL. As a result the PHP people felt they could no longer bundle the libraries with PHP.

    MySQL now added a clause to their license so that they can retain their 'preferred' status.

    unless the developers of PHP want to play source with us in OSS land

    Well I'm not a PHP developer, but I'll play source with you any day :)

    Cheers

    --

    What a rotten party, have we run out of beer or something?
  35. FAPP by Anonymous Coward · · Score: 0

    LAMP sounds good, what about FAPP?

    FreeBSD, Apache, PostgreSQL, PHP?

    Or is that only good for porn servers?

  36. a little history by aint · · Score: 4, Informative

    MySQL client libraries have been included/bundled with PHP for a long time now, and MySQL support was enabled by default. As of PHP 5, these client libraries are no longer bundled, and MySQL is not enabled by default. This essentially makes MySQL support like any other PHP extension, nothing special. To install, simply download MySQL and configure PHP with --with-mysql. Not a big deal. You do the same for PgSQL, CURL, TIDY, GD, etc.

    An official FAQ on this issue can be seen here:
    http://us2.php.net/manual/en/faq.databases.php#faq .databases.mysql.php5

    You'll notice that the license issue isn't the only reason PHP 5 stopped bundling these MySQL libraries so I assume despite this license change PHP 5 will not bundle MySQL by default. One might say the marriage continues to exist...but that it's no longer "forced" onto people.

    1. Re:a little history by Permission+Denied · · Score: 4, Informative
      MySQL client libraries have been included/bundled with PHP for a long time now, and MySQL support was enabled by default.

      This was always a bad thing actually. If you actually used the library distributed with php, you'd often get subtle breakage because your server was a different version.

      Another thing to note is that MySQL may drop in popularity as PHP 5 increases in popularity. PHP 5 comes bundled with SQLite. SQLite does not require a server but works directly on database files, yet it provides most of the SQL features needed by most projects. SQLite recently added a last_insert_id() function for auto_increment fields; along with that, the only other mysql-specific features I commonly use are the SQL date arithmetic functions.

      Working directly on portable database files opens up a lot of possibilities: projects can simply distribute a tarball of php+sql databases and users can just untar it into a web directory to install without creating database users or running a table creation script. This is also great for web hosting as a provider can just say "store your databases in your home directory" and they don't have to worry about managing database users or moving around table files. Users can set up read-only mirrors of a site just by copying files rather than setting up replication to new sql server. This means that database-driven php sites can be mirrored as easily as html-only sites. SQLite can also be useful in this same way for non-php projects: you can create a database application using QT/GTK/WX in C/C++/Python/Perl and simply distribute source or binaries with a traditional installer or package manager. Users no longer have to set up a database server to use a simple database application.

  37. SQLite by ChopsMIDI · · Score: 2, Informative

    Well for those of you that don't like MySQL's restrictive licenses and want a quick little SQL db, PHP 5 is shipping with SQLite.

    An interesting little database to say the least.

    --

    How could I say to men: "Speak louder, shout! For I am deaf!"? -Ludwig van Beethoven
  38. Embedded MySQL? by randomErr · · Score: 2, Interesting

    So does this mean we could see an embedded version of MySQL in PHP? With PHP 5 embedding SQLLite MySQL stands to lose a good market share.

    --
    You say things that offend me and I can deal with it. Can you?
  39. Re:HELP! by Anonymous Coward · · Score: 0
    I accidentally cut off my penis while chopping up food, naked. What do I do? Please HELP!

    Wrap it up and put it in the refrigerator. And oh yeah, pick up your penis, too.

  40. Re: OT on programming by E_elven · · Score: 3, Insightful

    Writing good HTML -especially XHTML & CSS- is entirely different from writing code. HTML is a markup language, not a programming language, and excelling in it requires an entirely different skillset -it's more akin to designing a database than coding.

    Being able to write a hashing algorithm doesn't make you suitable for all coding jobs.. in my experience, there are high-level coders and low-level coders and both are necessary.

    This is not to say there aren't a lot of completely useless people out there -probably more doing ASP, VB and such than anything else, but a lot of PHP users, too. However, many if not most of the incompetent PHP coders are not making a career of it, unlike the ASP/MCSE people, but rather making their hobby/personal sites.

    --
    Marxist evolution is just N generations away!
  41. Re:Will this boot *nmap* from Debian? by Anonymous Coward · · Score: 0

    Debian Free Software Guidelines (DFSG) [debian.org]:

    5. No Discrimination Against Persons or Groups

    The license must not discriminate against any person or group of persons.

    6. No Discrimination Against Fields of Endeavor

    The license must not restrict anyone from making use of the program in a specific field of endeavor. For example, it may not restrict the program from being used in a business, or from being used for genetic research.

    Given the wording above, will nmap be removed / moved to non-free due to its exclusion of use by The SCO Group?
  42. Your Rights Online? by miketang16 · · Score: 1

    I don't quite see how this is about My Rights Online. Sounds like mySQL is just making useful allowances for open source software...

    Perhaps I'm just used to the normal bad "Your Rights Online" articles. =p

    --
    -------
    "In times of universal deceit, telling the truth becomes a revolutionary act."
    -- George Orwell
  43. PHP and GPL by JohnQPublic · · Score: 1

    Indeed, and PHP users caring about GPL should worry about the tight coupling with a database server that has restrictions on binary distribution.

    PHP users caring about GPL should worry about the fact that PHP is not licensed under the GPL. In fact, if it was, then MySQL AB wouldn't have had to grant an exception to allow use of MySQL with PHP.

    GPL vs. Apache/MIT/whatever license wars aside, MySQL AB's license exception appears to be a Good Thing.

    1. Re:PHP and GPL by tepples · · Score: 1

      The point is that the exception doesn't work if one is not even allowed to mention MySQL's download page if one distributes PHP+MySQL. This half-donkeyed license exception will drive users to PostgreSQL just as effectively as if it didn't exist.

  44. Very sad situation by biwillia · · Score: 5, Insightful

    For me the situation with MySQL's licensing shenanigans is quite sad. For small commercial software development shops who have been loyal to MySQL over the past few years, it's sad to have to say goodbye.

    It's fine that I have to pay money for a database server and all, but the GPL-licensed client library makes light usage of MySQL impossible for small software vendors. Even Microsoft SQL server has LGPL client libraries available (like freetds)! I can't see how MySQL can compete with other commerical software vendors that have less restrictive client-library licensing.

    For the MySQL folks to claim that the GPL is binding through a regular socket connection is quite a strech at best, and a slap in the face to those of us who write [L]GPL-licensed software.

  45. You're either trolling, or you're an idiot. by kyz · · Score: 2, Informative

    I can also quote. From the GPL, this time:

    However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable.

    This quite clearly states that core operating system functionality provided by the vendor is exempt from the GPL's linking clause, provided it's a de-facto part of the vendor's operating system. So, you can use all Win32 calls and all system DLLs on Windows in GPL software. You can compile and link against Solaris's non-free libc without worry.

    --
    Does my bum look big in this?
  46. bullshit by RelliK · · Score: 4, Informative
    The parent post is a troll.

    Postgresql is underdocumented, the MySQL online documentation simply excels.

    Complete and utter bullshit. How is this for documentation? There are also excellent books about it.

    There is no readily available workforce that has actual Postgresql knowledge. There are on the other hand buttloads of people available that can drive average sized MySQL installations for cheap money.

    That's a circular argument: everybody uses MySQL because everyone else does. (I can name a certain OS that benefits from this situation...) A good DBA would have no problem picking up PostgreSQL in a matter of days. I don't care about trained monkeys.

    There is no readily available workforce that has actual Postgresql knowledge. There are on the other hand buttloads of people available that can drive average sized MySQL installations for cheap money.

    Again bullshit. PostgreSQL supports multiple databases per server very well, including separate access controls for each db.

    Postgresql replication is regarded mostly experimental and is not properly integrated with the server. In larger MySQL deployments, replication is often used for load sharing (direct read only queries against any replica), and for backups.

    Replication (in both MySQL and PostgreSQL) is mostly useless since it is asynchronous. That is, when you commit a transaction you can not be sure if/when it gets propagated to the slaves. Therefore, if you read from a slave you can never be sure that it's up to date. I'll grant you that there are certain situations where this can be tolerated, but for high availability mission critical sites, it's useless. For that you need distributed transactions. The only open source DB that supports them is firebird.

    BTW, I'm glad you mentioned backups. PostgreSQL , just like any real database, can do on-line backups. However, to back up MySQL, you need to read-lock all the tables! The only way to get around that is by setting up replication and backing up the slave.

    Postgresql already has many features MySQL either just got with 4.1 or is planned to get in 5.x. That is useless, though, if you do not need these features, but need to deploy in a hosted standard environment, relying on the available workforce.

    Yeah, I'm sure you don't need transactions, subselects, triggers, stored procedures, or even *gasp* correct and predictable behaviour.

    But you are right about one thing: everybody uses MySQL because everybody else does.

    --
    ___
    If you think big enough, you'll never have to do it.
    1. Re:bullshit by Anonymous Coward · · Score: 0

      A good DBA would have no problem picking up PostgreSQL in a matter of days. I don't care about trained monkeys.

      You should. Because most of the people using the software are those exact same "trained monkeys" you just dismissed. Ease of use shouldn't be dismissed, and it doesn't matter whether that's due to some inherent superiority of the program or just to plain familiarity.

    2. Re:bullshit by jadavis · · Score: 2, Insightful
      Postgresql is underdocumented, the MySQL online documentation simply excels.


      Complete and utter bullshit. How is this for documentation? There are also excellent books about it.


      I am a strong advocate of PostgreSQL. However, to say that Postgres' docs are perfect is false. This has been discussed on the advocacy mailing lists before. PostgreSQL has great docs for people who need a reference and pretty much know where to look, and what they're looking for.

      In my opinion, PostgreSQL docs could be improved by:
      (1) Better search functionality
      (2) More tutorial-oriented material throughout the docs, like more examples at the end of sections, and more descriptions about why you'd find that particlar feature useful.
      (3) The website needs to be more portal-like, introducing you to all the postgresql resources available, and helping you get going.

      MySQL has paid maintainers to take care of all of that. PostgreSQL doesn't. PostgreSQL only really has coders, and if I'm not mistaken, only one major advocacy coordinator, Josh Berkus, who I met at Linuxworld in SF, who does a great job, but is only one person.

      It just takes some more people that know the database well and have some basic web experience to put together some great things.

      PostgreSQL is, in my opinion, the best database for most RDBMS tasks. However, I know how I feel when I go to a software site and i just want to check something out. I don't know whether it's the best or not, so I want to try it. It can be imtimidating when nothing has context. Lots of context is what makes docs easy to understand for a beginner.

      That takes people that PostgreSQL doesn't currently have yet. Public relations and marketing are expensive, but MySQL can pay those guys.

      Of course PostgreSQL is doing just fine by attracting users away from Oracle and SQL Server, and the people that have serious enough database requirements to actually look. The code quality, and the quality of the coders and the steering, and the project management is amazing. And it attracts more coders because they retain copyright on their work, unlike MySQL coders.
      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    3. Re:bullshit by RogerWilco · · Score: 1

      At my former employer we used MySQL for 2 reasons:
      It's free and it runs on Windows.
      If I'm right MySQL is currently the only DB that does both.
      Oh, and it had the added advantage that it could be used by people with virually no programming skills.

      --
      RogerWilco the Adventurous Janitor
    4. Re:bullshit by jadavis · · Score: 1

      Look at Firebird SQL. I haven't used it, but it runs on windows, and I also hear it's a good database even from the PostgreSQL list people (I don't have a quotation at the moment, but when it comes up the perception of Firebird is usually good).

      As far as being used by someone with no programming skills, it would be more helpful to all parties concerned if you would itemize some things that should be improved in PostgreSQL or firebird.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
    5. Re:bullshit by aztracker1 · · Score: 1

      Yeah, I'm sure you don't need transactions, subselects, triggers, stored procedures, or even *gasp* correct and predictable

      Which is why I for one, have been looking more closely at firebird.. the project has worked hard on cleaning things up, as well as extending for a more broad support, including .Net interfaces, which work in mono, as well as MS's version.

      --
      Michael J. Ryan - tracker1.info
    6. Re:bullshit by RogerWilco · · Score: 1

      I will check Firebird, that you for pointing that out.

      I have no PostgrSQL experience (as it does not run on Windows) I can only comment on Oracle, MS SQL Server, dBase(5 for DOS, so old) Access and Paradox.
      All of these are more expensive as even a comercial license for MySQL, and Oracle, MS-SQL and dBase are much more difficilt to set-up and use, while Access and Paradox, lacked a couple of options we needed, like replication (AFAIK) and overall robustness and scalability.

      We did bundle MySQL with one of our client-server applications, and paid the commercial licence for those install's. The only thing MySQL did not provide and we build ourselves was a Windows installer Merge Module.
      This would allow our customers to install both out application and MySQL by pressing 'OK', 'I accept', 'Client' or 'Server', 'Finish'. My mom could succesfully install both client and server of our software, that used MySQL as DB.

      As my comment on programming skills, I had collegues use MySQL by only giving them the installer, and "SQL in 10 minutes", anf they were up and running in minutes.

      One of the things I liked most about MySQL is it's documentation. Compared to Oracle, that I use at my current employer, it excells.

      Oh, in closing, another bonus for MySQL was that it did ran on linux, so that we could also offer solutions on linux. (and we did, it was only that most of our users were windows only shops) We chose PHP/Apache for the same reason over ASP/ISS (and it's good interaction with MySQL)

      --
      RogerWilco the Adventurous Janitor
    7. Re:bullshit by jadavis · · Score: 1

      Well, sounds like PostgreSQL needs a windows port to be as widely adopted as MySQL. I guess we'll just have to wait, they're working on it.

      --
      Social scientists are inspired by theories; scientists are humbled by facts.
  47. Exception? by lpangelrob2 · · Score: 3, Funny
    Crap, I knew this was gonna happen....
    catch (Exception $mysqlException) {
    echo $mysqlException->getMessage();
    }
    All right, should be fixed. :-)
  48. Re:Will this boot *nmap* from Debian? by _|()|\| · · Score: 1
    will nmap be removed / moved to non-free due to its exclusion of use by The SCO Group?

    While I don't think Fyodor has made his case, he claims that SCO's public assault on the GPL constitutes a refusal to accept its terms, which is a prerequisite to enjoying its grants.

  49. Problem with PHP License by bellings · · Score: 3, Insightful

    So, MySQL is distributed under the GPL, and PHP is distributed under a license incompatible with the GPL.

    How is this MySQL's problem?

    --
    Slashdot is jumping the shark. I'm just driving the boat.
    1. Re:Problem with PHP License by The_DOD_player · · Score: 3, Insightful

      Well.. It is because MySQL recently changed its license to GPL from LGPL, because PHP can do very well without MySQL, (yes, there are severel good alternatives to MySQL around), and because (and MySQL A/B KNOWS this) it might even be fair to say, that MySQL owes its current marketshare to PHP.

    2. Re:Problem with PHP License by Geoffreyerffoeg · · Score: 1

      Because PHP 5 is currently being distributed with SQLite and no bundled MySQL client (separate download).

  50. Capitalization nazi by Anonymous Coward · · Score: 0

    It's "Qt" you fool, unless you're talking about some GPL version of QuickTime.

  51. RMS'es drivel by iamacat · · Score: 1

    He can think whatever he wants, but I wish he should stop assuming most other free software developers have a political agenda. Most people release free software because they wrote something for their own use, have no plans to make money off it (one has to be disturbed to try making money of everything he or she does) and don't want good work to go to waste. GPL and LGPL help to enforce respect for the original author - if I have a free game on my home page, I don't want other people to sell a trivial modification as their own.

    But with the way things are going, I am tempted to use another license next time I release a free program. If anything I don't want to write that my program can be used under "GPL version 2 or later", because I am scared of what RMS might put in version 3.

    I am looking for an existing license that lets a closed-source project take my code, use it for some fixed time (say 5 years) and then they have to release their changes to the public. This would be an equivalent of the original copyright law, modified for specific requirements/development speed of software.

    1. Re:RMS'es drivel by Anonymous Coward · · Score: 0
      Do what Linus did for the Linux kernel: license your code under only the GPL 2.0 .

      from /usr/src/linux/COPYING:

      Also note that the only valid version of the GPL as far as the kernel
      is concerned is _this_ particular version of the license (ie v2, not
      v2.2 or v3.x or whatever), unless explicitly otherwise stated.

    2. Re:RMS'es drivel by hak1du · · Score: 1

      I don't get what your point is. My own point was simple: I think the GPL is a bad license for Qt and the MySQL client libraries. I think it's bad not for some abstract philosophical reason, but because it reduces the chance for the long term survival of these projects. In part, that's because there are less restrictive alternatives available, both commercially and freely. And the expected chances of long-term survival of a project have a profound influence on my choice of software: I don't want to invest effort in a piece of software if it's going to disappear or change unpredictably and uncontrollably after a few years.

      I am looking for an existing license that lets a closed-source project take my code, use it for some fixed time (say 5 years) and then they have to release their changes to the public. This would be an equivalent of the original copyright law, modified for specific requirements/development speed of software.

      That sounds like an LGPL license with a time provision. That would work for the MySQL libraries and Qt. So would the BSD license or many other OSS licenses. However, I think formulating such a license so that it does what you want is hard. I'd just go with one of the existing licenses. I do agree with your unease about the "or later version" provision and don't use them myself in the OSS I write.

  52. What people fail to mention is.... by bangular · · Score: 1

    First off, almost all those things you mention aren't an issue in MySQL anymore. Maybe back in 3.23, but as far as 5.0 and 4.1 go, they've disappeared. MySQL has always been built with speed in mind. It deviates from the SQL standard when necessary and has been slower to implement all of the standard, but! Everything that's implemented is done with speed in mind. So it has a huge speed advantage over almost every database out there.

    Also consider this, historically postgre supporters have had a history of omiting problems with it. There have been a lot of Postgre limitations in the past that the postgre crowd has n't exactly been forthcoming with. I compare it to the FreeBSD crowd, many of them are quick to bash Linux, but are also quick to omit their own limitations. Not to say that FreeBSD or Postgre are bad, but don't make your decision of what to use based on slashdot posts.

    Not saying just use MySQL either. It really depends on what you need. The reason MySQL has become so popular for the web is it's speed. Each connection also has a very tiny footprint so you can have many connections without a huge penality (for comparasion Oracle uses almost 10 times as much ram for each connection that MySQL).

    I'd like to compile a list of what Postgre has omitted over the years to show you why so many people have been burnt by it! The random data corruption was enough to piss off many!

    1. Re:What people fail to mention is.... by scheme · · Score: 2, Interesting
      First off, almost all those things you mention aren't an issue in MySQL anymore. Maybe back in 3.23, but as far as 5.0 and 4.1 go, they've disappeared. MySQL has always been built with speed in mind. It deviates from the SQL standard when necessary and has been slower to implement all of the standard, but! Everything that's implemented is done with speed in mind. So it has a huge speed advantage over almost every database out there.

      Why do mysql supporters always bring up how version 4.1 or 5 will support a feature. It's utter bs to compare features that are available on a stable release that have been around for several years with features that are in either in alpha code (mysql 4.1) or a future version (mysql 5.0). Not to mention that features that were supposed to have been in mysql 4.0 have been pushed back to 4.1 and may get pushed back again.

      By that logic, postgresql has point in time restore (PITR) support which mysql hasn't even mentioned. PITR lets you restore the database to a given point in time. E.g. your program went crazy and deleted a bunch of entries that you need. With PITR you restore the database back to just before the data was deleted. Postgresql 7.5 is going to support this.

      Incidentally, mysql's speed seems to be missing if you start looking at performance with multiple clients querying the database or when queries get more complicated. Mysql also tends to be okay with incorrect or wrong behaviour if that increases speed.

      --
      "When you sit with a nice girl for two hours, it seems like two minutes. When you sit on a hot stove for two minutes, it
    2. Re:What people fail to mention is.... by bangular · · Score: 1

      4.1.x has been out for a long time. New installations should use 4.1.x. 5.0 is also already out. 5.0 was released in 2003. I'm using 5.0 on a new installation. I stressed tested it, benchmarked it, done everything I reasonably could to try and make it crash, drop data, or otherwise behave badly. It had no problems, so I decided to go with 5.0. These features are here. But like I mentioned before, MySQL has always been built for speed; thus it has been slower to implement certain features.

    3. Re:What people fail to mention is.... by Anonymous Coward · · Score: 0

      Uh, no? 4.1.x is the development series. 5.0.x is the preview series. Only 4.0.x should be considered for production if you want data security. Well, you shouldn't be running MySQL at all if you want data security, really. But you're just running a blog on your site anyway, I suspect, so it doesn't really matter. If not, I weep for your customers.

    4. Re:What people fail to mention is.... by bangular · · Score: 1

      That was the whole point of stress testing it. 5.0 passes MySQL's testing suite and passed mine. It's proxy log analysis software. Roughly 300,000 rows added daily. I inserted a few months worth of logs and compared to original logs to see if there were any failed inserts. MySQL data matched original data exactly. I also stress tested selects, updates, etc. etc.

    5. Re:What people fail to mention is.... by Cajal · · Score: 2, Insightful

      Why do so many MySQL zealots keep claiming that 4.1 and 5.0 are ready for production? Even MySQL AB doesn't make such a claim. Their web site clearly states:

      Production 4.0.18
      Development 4.1.1
      Preview 5.0.0

      So saying that "new installations should use 4.1.x" is like saying that everyone should have run Linux 2.5.x, or the latest CVS version of Apache.

    6. Re:What people fail to mention is.... by bangular · · Score: 1

      I would compare MySQL 4.1.x to Linux 2.6. Though 2.6 isn't really considered stable yet, if you stress test it and it works for you, there's no reason to hold back.

    7. Re:What people fail to mention is.... by Anonymous Coward · · Score: 0

      No reason to hold back until you find one.

      That's the difference. There's a strain of developer out there that wants to use the new stuff and thinks that it's good enough if you've stress tested it, then there's the database guy who's been around the block and sweated through a few career-threatening downtimes. If the manufacturer says it's not production, that's because they know why. I *deeply* don't care how fast a database is, if my transactions get lost or data loses integrity. Heck, I don't even trust Oracle until they get to X.2 or better. And then I watch my back.

      Databases fail. All of them. What matters is: how often, how bad, and how hard is it to get the data back? The "enterprise" db's all have good answers to those questions. "I can't make it crash" is an incomplete statement -- it misses the "yet" at the end. Users will do horrible, inconceivable things to your program that will amaze and terrify you. You need to have a way to recover from a sudden, inconsistent stop.

      I personally trust PostgreSQL more tham MySQL because the code and the authors have shown signs of understanding database programming and design. MySQL's programmers took a long time to admit that they didn't have ACID compliance, and to show an understanding of why some folks said it was important. I'm deeply skeptical when they make claims about production readiness and data integrity.

      There might be good answers as to why MySQL is a safe place to put my data, but I haven't seen them. I'm willing to be persuaded, but it'll have to be by showing me the failure modes and the recovery procedures, not by claiming it works and that you can't crash it.

      Oh, and when Oracle started claiming to be "unbreakable" I started worrying about those programmers too...

    8. Re:What people fail to mention is.... by davegaramond · · Score: 1

      Well said. And to add to these: * it supports Win32 natively (coming in 7.5 or perhaps 8.0); * it supports nested transaction (coming in 7.5); * it supports 2-phase commit (coming in 7.5); * it supports tablespaces (coming in 7.5 or 8.0);

    9. Re:What people fail to mention is.... by stor · · Score: 1

      No reason to hold back until you find one.

      *applause and chuckling*

      I couldn't have said that better myself.

      Cheers
      Stor

      --
      "Yeah well there's a lot of stuff that should be, but isn't"
    10. Re:What people fail to mention is.... by Anonymous Coward · · Score: 0

      Dude, if you need to test a DBMS for possible data issues. You probably shouldn't be using it for production. You should only use a development version if you don't care about the data. I have to admit I've never considered testing my DBMS for possible data loss. The possibility just never even occurred to me. I

    11. Re:What people fail to mention is.... by Cajal · · Score: 1

      The big difference here is that the Linux developers themselves consider 2.6 to be the stable, current production version. The MySQL developers do not consider 4.1 to be stable or production-quality. Their own web page says this.

  53. MySQL writes exceptions for PHP by Anonymous Coward · · Score: 2, Funny

    So that explains all those exceptions I see on articles linked from here.... And all this time I just thought they were slashdotted!

  54. Schizophrenia=/=Dissociative Identity Disorder by Douglas+Simmons · · Score: 1
    Hey asshole. Schizophrenia is a psychotic disorder, usually supplemented by major mood malfunctions. It is not the Hollywood multiple personality disorder you're suggesting. What you're thinking of is called Dissociative Identity Disorder. Someone may have both Schizophrenia and DID, but that would be the same as someone having diabetes and cancer. Some comorbidity perhaps, but they are separate diseases.

    Yeah I know this is off-topic from an already off-topic post but if you're going to make wisecracks using references to psychological diseases, at least one of which by the way is possessed by roughly 17% of us, use the fucking correct terminology.

    Also, be thankful you don't have a major personality or mood disorder like Schizophrenia, Schizoaffective Disorder, Bipolar, and so on. It's a real pain in the ass, having one of those, and you don't get nailed with it for sharing needles or banging a cheap hooker. You're born with it, and it's likely your children will be too.

    Insensitive clod.

  55. This licensing stuff is getting ridiculous by TheLink · · Score: 3, Funny

    Is anyone tempted to release some cool software/music/stuff/work with a default restrictive licenses (must pay etc etc), but have some exceptions like:

    You are free to distribute Derivative/Identical Works as long as:
    1) Every Feb 1st and August 17th you go to a public area with at least 20 strangers present, stand on one leg and yell "foobar bubble bubble!" including the double quotes.
    Or
    2) Every full moon you infringe the MySQL and Microsoft software licenses, and email them a goatse.cx/tubgirl pic.
    Or
    3) You do an anonymous, random (and different) quirky good deed to a random (and different) stranger every month - only counts if the target will likely think it is good.

    AND you claim that Al Gore is the actual author of the works.

    Sheesh.

    --
  56. Actually money grubbing by scheme · · Score: 3, Informative
    It's companies like this that really have the confidence and trust of the 'mass' market. By openly supporting and helping people that will for the most part not give them any return they really show up the likes of SCO with all the crap they have been shovelling out of their head office.

    What are you talking about? MySQL AB changed the client libs from LGPL to GPL. That messed up a lot of things but it theoretically generates more commerical licenses for MySQL AB.

    Add in the unusual gpl interpetation by MySQL AB where programs that use mysql for commericial use are required to get the commericial license and where distribution is interpeted to be copying the program between servers even within the same company and you have a company that is doing it's best to create FUD and force companies into buying commericial mysql licenses.

    Oh yeah, the developers made vague noises about how people reverse engineering the client/server protocol and creating an alternate license may get sued by MySQL AB.

    How's that for good company policy?

    --
    "When you sit with a nice girl for two hours, it seems like two minutes. When you sit on a hot stove for two minutes, it
  57. Re:Will this boot *nmap* from Debian? by Anonymous Coward · · Score: 0

    I think Fyodor is still too busy hacking the machines of 16 year old mail "linux booth babes" to think very clearly about licenses.

  58. P stands for Perl by Anonymous Coward · · Score: 0

    The P stands for perl. You know, like the ".pl" in the URL by which you posted that comment ?

    PHP is very slow compared to perl, and lacks the extensive libraries that are in CPAN. PEAR cannot approach it.

    The problem with Perl is it allows for nasty syntax that looks like it is all punctuation. This scares people off. Most Free Software projects have enemies who are spreading FUD against them, but Perl spreads it's own.

    Thankfully, perl does not have to be written in that horrible syntax. You can write clean perl code as readable as any other language.

    The reason why fresh newbies like yourself think the P in LAMP stands for PHP is because they read Linux Magazine and Linux Journal, which push PHP very hard, having at least one article on it in every issue.

  59. mod parent up by Douglas+Simmons · · Score: 2, Funny
    right on man, i hate jerkoffs like this guy. The stigma gets perpetuated when people separate psychological from somatic diseases, make dumbass jokes, etc.

    By the way, bipolar disorder has a mortality rate of 20% which is higher than those of most heart diseases and cancer. In other words, if you have a bipolar kid and a kid with cancer, it is likely that the crazy kid will outlive the cancer boy. And manic depression is a much easier disorder to deal with than schizophrenia, despite what you may have deduced from watching A Beautiful Mind. If you're schizo, you're basically fucked.

    1. Re:mod parent up by Anonymous Coward · · Score: 0

      heh whoops, forgot to check Post Anonymously. Thought it'd be funny to respond to myself like the original parent complained about :)

    2. Re:mod parent up by Anonymous Coward · · Score: 0

      Manic depression isn't so bad, it gets better/it gets worse.

    3. Re:mod parent up by Anonymous Coward · · Score: 0

      By the way, bipolar disorder has a mortality rate of 20% which is higher than those of most heart diseases and cancer. In other words, if you have a bipolar kid and a kid with cancer, it is likely that the crazy kid will outlive

      W?
      bd mort > cancer mort
      but bd kid outlives cancer kid?
      Do I not know what mortality means or what?

  60. Let's improve the discussion by citing specifics. by jbn-o · · Score: 3, Insightful

    Comparing anything to perfection is unproductive; it serves to reinforce our biases by presenting us with a false dichotomy (you can have whatever argument is being proposed or you can have perfection, which is never available). Let's look at specific claims.

    As much as there are some FSF fans wish that the GPL was the only software license [...]

    Please name who these people are and cite the evidence that gives you this impression.

    [...] it's not the one-size-fits-all solution for everybody. That's why the LGPL exists. That's why Creative Commons exists. That's why many common open-source programs have forked the GPL to make it their own.

    That explanation barely gets into why the LGPL exists. The Creative Commons doesn't recommend their licenses for software. The GNU project started over a decade before the open source movement began and the GNU project was founded to talk about software freedom, not a development methodology. I'd also be interested to learn who, besides the Affero General Public License has "forked" the GNU GPL. The Creative Commons has listed the GNU GPL, not forked it.

    [...] but let's not treat the GPL like it's a religion. It's not perfect.

    Who, exactly, is doing this and what, exactly, are they saying?

  61. workaround by fat32 · · Score: 0, Troll

    The MySQL extension has been debundled because MySQL has changed its licensing policy and, effective 4.0, the library is now distributed either under the GPL (which is incompatible with the PHP license) or by purchasing a commercial license. You can still link to the MySQL library by downloading it separately from PHP, installing it and the configuring PHP to point to it. This will work both with 3.x and 4.x. However, technically you can't link against 4.x unless you have a commercial license from MySQL.

    1. Re:workaround by Anonymous Coward · · Score: 0

      Bullshit. If your project is GPL, you can link to it all you want. If it is not, then pay mysql. What is good for the goose is good for the gander.

    2. Re:workaround by Graff · · Score: 1
      The MySQL extension has been debundled because

      Yep, this is yet another plagarism by this troll. You can find the original here.
  62. Re:A response to X? (Correction) by fferreres · · Score: 1

    "With MySQL it was a bit more then just an abstraction problem. Untill fairly recently MySQL did not support foreign keys and it still doesn't by default."

    --
    unfinished: (adj.)
  63. Re:The answer: by claar · · Score: 1

    OK, I realize this is 80% Flamebait and 15% troll, but the 5% truth hiding in there is what prompts me to reply.

    You mention PostGreSQL as an alternative to MySQL. That's fine. But then you bash PHP without mentioning an alternative. What's a good, easy-to-use open source tool to make dynamic web pages besides PHP? No other language I've used is so simple to use and well documented, so I'm curious if you (or someone else) has a decent PHP replacement in mind..

    --
    I'd give my right arm to be ambidextrous...
  64. Nice guys? by Insurgent2 · · Score: 1

    I think they want you to think they are being magnanimous but they really aren't. You won't see the same thing applying to MaxDB (the *real* db :) ).
    That was the big stink when SAP turned SAPDB over to MySql. SAP originally had the libraries under LGPL but when turned over to MySql, they are now GPL which means for continued use, either stay with the original SAPDB or use MaxDB and open source your project.
    Personally I have nothing against then making money off of MySql. I just think in thier case, the whole GPL thing is a pretense.

  65. Er but can't that be side stepped by PurpleWizard · · Score: 1
    by saying our license is our own, but in accepting it you accept it's terms as if it was the GPL in every way....

    Or words to that effect?

  66. Offtopic by unmuzzled+and+mean · · Score: 1
    I know a lot of none native English speakers/writers contribute valuably to /. but...

    The basic quality of English in the postings is routinely so poor that I think I am going to give up reading the feedback and just scan the headlines (which are often riddled with flaws to but at least in most cases you can follow the link!)

    All those who say it isn't important are idiots, the simple example being computers and ambiguity. If you don't write the code to do exactly what you want (understanding all those areas that are "undefined") whose fault is it?

    Can the machine be expected to understand what you meant rather than what you said. Now apply that to the less predictable realm of humans in their individual vagueness and variance attempting to understand each others writing. Clarity and precision is essential.

  67. hmm.. bsd license... by ShadowRage · · Score: 2, Interesting

    isnt the bsd license opensource?

    because.. this could be a loophole in the license.. since a company can take bsd source code and close source it.. thus using mysql libraries in their proprietary works.. right?

    correct me if I'm wrong.. I dont focus on licensing issues much.

  68. Re:The answer: by Pseudonym · · Score: 1

    Python and Perl users would argue that those languages are just as "well documented" as PHP, and have a better set of client libraries to boot, and are GPL'd so don't suffer from the licensing problems. I suppose that "simple to use" is a debatable point, but in my experience, Perl at least is no harder to integrate with Apache to get the same "embedded code" functionality as PHP is. I suspect that people who have tried it with Python would agree.

    I'd like to avoid a language war here. PHP definitely hits a "sweet spot" on the web backend language tradeoff curves. Particularly if your web application doesn't need much "business logic", and only needs to use the specific bindings that PHP supports, using PHP can often make your rapid application development more rapid than with Python or Perl. I would hardly say that it has no adequate replacements, however.

    --
    sub f{($f)=@_;print"$f(q{$f});";}f(q{sub f{($f)=@_;print"$f(q{$f});";}f});
  69. Re:The answer: by claar · · Score: 1

    You know, I was nodding my head as I read your comment, and wondered if perhaps I had given up on Perl too quickly... then I read your signature and went back to my PHP code ;-).

    --
    I'd give my right arm to be ambidextrous...
  70. This additional privilege is worthless by tepples · · Score: 1

    I'm sorry, I'm really confused, they are granting an additional privilege.

    I recognize that the GNU GPL itself has value. However, this additional privilege has much less value than some make it out to have. Distributions of GNU/Linux could not distribute both MySQL and a GPL incompatible app linked to MySQL. In fact, the only way anybody can distribute a GPL incompatible app linked to MySQL under this license exception is if that person never mentions the MySQL web site at all, as the exception prohibits redistributors who rely on it from "provid[ing users] with instructions to download" the MySQL server. Heck, even mentioning MySQL at all might violate this privilege because anybody can use Google.com to transform the name "MySQL" into "instructions to download" the database server.

    I don't understand how you can complain about them granting additional privileges.

    MySQL AB granted a license exception that applies in no case in practice. I don't complain about that grant per se. Rather, I'm complaining about those who advertise that this additional privilege has any appreciable value.

    1. Re:This additional privilege is worthless by Anonymous Coward · · Score: 0

      Thanks, that makes your point clear. -Gumbi West

  71. Pot... meet Kettle by Anonymous Coward · · Score: 0

    I found 3 cases of misleading imprecision in your diatribe:

    ---

    I know a lot of non-native English speakers/writers contribute valuably to /. but...

    The basic quality of English in the postings is routinely so poor that I think I am going to give up reading the feedback and just scan the headlines (which are often riddled with flaws too, but at least in most cases you can follow the link!)

    All those who say it isn't important are idiots, the simple example being computers and ambiguity. If you don't write the code to do exactly what you want (understanding all those areas that are "undefined") whose fault is it?

    Can the machine be expected to understand what you meant rather than what you said? Now apply that to the less predictable realm of humans in their individual vagueness and variance attempting to understand each others writing. Clarity and precision is essential.

    ---

    I think we all understood what you meant better than how you said it. Our unpredictability makes us more than computers, not less.

    And, relax a little...

  72. Open Source, GPL and multiple licenses by greggman · · Score: 2, Interesting

    Someone explain to me how this all works.

    One of the big supposedly pluses to GPLed code is that many people can contibute. So, if I GPL the code AND try to release it under another license then the non-GPLed version can not have any of the benefits of contributions, bug fixes, etc from the GPLed version since those contributions are GPLed and not available under the other license. Those contributions belong to the individual contributors, not the person or team that made the original code.

  73. the other way around by Anonymous Coward · · Score: 0

    you know what i meant ..

  74. Re:Will this boot *nmap* from Debian? by Anonymous Coward · · Score: 0

    They didn't exclude SCO from using it under the GPL, they claimed that SCO is not accepting the GPL and *as a result* has to right to use nmap. This was, of course, misstated on Slashdot.

  75. Re:Let's improve the discussion by citing specific by Anonymous Coward · · Score: 0

    RMS.

  76. Your unclear response. by jbn-o · · Score: 1

    I asked multiple questions. I don't understand which question you're responding to nor do I see a specific quote to indicate what was said. It's not reasonable to drop a name someone might recognize and expect them to fill in all the blanks for you.