Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!

 



Forgot your password?
typodupeerror
×
Databases Programming Software GNU is Not Unix

Is MySQL Planning a Change of Tune? 403

Iggy writes "After reading the article on 'The MySQL License Question' by Timothy R. Butler at Open for Business I just have to wonder, is this company's wording on the MySQL site indicating the company is backing away from Free Software, specifically, the GPL? Great reading and certainly thought provoking."
This discussion has been archived. No new comments can be posted.

Is MySQL Planning a Change of Tune?

Comments Filter:
  • First Useful Post (Score:3, Insightful)

    by HappyPerson ( 525201 ) on Monday August 16, 2004 @08:59PM (#9986671)
    Consistency in licensing is important, whatever they choose I hope they stick with it.
  • by cbrocious ( 764766 ) on Monday August 16, 2004 @08:59PM (#9986672) Homepage
    I disagree. I think that they're using legalese to try and mask that they're moving away from true F/OSS. It's been happening for a while now.
  • Strange really.... (Score:3, Insightful)

    by tarquin_fim_bim ( 649994 ) * on Monday August 16, 2004 @08:59PM (#9986673)
    This has been in the offing for sometime now, why would anyone chose MySQL over PostgreSQL if they had to pay for it? It may be faster but it does little more than can be done with a flat text file and Perl. Suicide.
  • by angst_ridden_hipster ( 23104 ) on Monday August 16, 2004 @09:02PM (#9986691) Homepage Journal
    Those were more or less my first thoughts as well.

    If the F/OSS world loses MySQL, and there isn't a satisfactory fork of the GPLed version, why wouldn't we all switch over to the superior power of PostgreSQL?
  • PostgreSQL (Score:4, Insightful)

    by thammoud ( 193905 ) on Monday August 16, 2004 @09:03PM (#9986698)
    People will switch to PostgreSQL faster than the MySQL folks can type GPL back into the license. They will be crazy.
  • by Jack9 ( 11421 ) on Monday August 16, 2004 @09:04PM (#9986704)
    So how long before you give me a MySQL equivalent Perl script? Right. People would choose MySQL for speed and ease of administration (not hard to "administrate" a flat text file over a RDB), like always.
  • by Anonymous Coward on Monday August 16, 2004 @09:06PM (#9986713)
    If they change the license, can't we just fork from the last GPL release?
  • Well... (Score:5, Insightful)

    by joseph schmo ( 223532 ) on Monday August 16, 2004 @09:07PM (#9986718)

    I can't get to the article (/.), but assuming this is not FUD:

    With all the "Postgres is so awesome" stuff I keep reading (well okay, mostly on here), if MySQL backs away from open source, it could be the beginning of the end for them with "the geeks" (ie. us).

    I'm not that familiar with Postgres, but I just checked and their website says:

    The above is the BSD license, the classic open-source license. It has no restrictions on how the source code may be used. We like it and have no intention of changing it.

    Sounds good to me!
  • Re:Please stop (Score:1, Insightful)

    by Anonymous Coward on Monday August 16, 2004 @09:11PM (#9986747)
    We'll start seeing more PostGre projects when more webhosts start offering it with their services. But we won't see that until there's more demand for it. Etc, etc.

    Plus the fact that for 98% of all websites, either option is equally acceptable, are really going to inhibit development of PostGre vs MySQL.
  • by the_mad_poster ( 640772 ) <shattoc@adelphia.com> on Monday August 16, 2004 @09:11PM (#9986750) Homepage Journal

    Ah yes... you ask the question that can only be answered in a way that must be marked as Flamebait...

    Because, unlike MySQL, PostgreSQL is a real RDBMS. It didn't kludge things into the main system like the InnoDB/MySQL fiasco. It supports a MUCH, MUCH more powerful, rich subset of SQL. It does, basically, what a RDBMS should do, whereas MySQL only does as much as it needs to get by.

    Interestingly, this gave MySQL a niche in the small/medium website market. People who couldn't justify the complexity of earlier builds of Postgres jumped on MySQL because - although it makes the hard things impossible - it makes the most common tasks in a dynamic environment manageable for even the most clueless n00b. As people graduated to a more detailed understanding of things, MySQL offered them the power they needed to grow.

    Unfortunately, eventually you will outgrow MySQL and hit the things where MySQL fails miserably at. Then, you need a "real" RDBMS. Alas, most folks using MySQL didn't need to do that, so they're used to the bizarre quirks of MySQL (18 nestings of SELECT anyone?) and struggle with PostgreSQL and other "real" RDBMSs as a result.

    That's why.

  • Great! (Score:4, Insightful)

    by The AtomicPunk ( 450829 ) on Monday August 16, 2004 @09:13PM (#9986761)
    PostgreSQL gets another boost! :)

    Seriously, if you haven't used PostgreSQL, consider it for your next project. I use both, but have ended up using PostgreSQL a lot more. It's a much more serious database, and really isn't any more difficult to setup and manage than mySQL.

    8.0's introduction of point-in-time-recovery is going to be a huge boost to enterprise applications of PG!
  • License of MySQL (Score:2, Insightful)

    by shawn_f ( 620177 ) * <wicked.vertigoNO@SPAMgmail.com> on Monday August 16, 2004 @09:18PM (#9986789) Homepage Journal
    Well, if MySQL decides they need to change the license, then fine...I am sure they will loose some users, but it will not be their downfall. Perhaps they could something like http://www.bb4.net/ [bb4.net] has done, where they have a fairly functional free, version, which is still open source, and a "professional" version which has some additional features and support. Really not a bad idea...

    MySQL is a great product, as well as Postgres, but a change in licensing for MySQL will not be as bad as it may sound...
  • by Tassach ( 137772 ) on Monday August 16, 2004 @09:18PM (#9986790)
    Because there are a whole lot of stubborn idiots out there who think that MySQL is the be-all and end-all of databases and refuse to learn anything else. Fanboy mentality instead of solid engineering practices.
  • Error in Logic? (Score:2, Insightful)

    by Anonymous Coward on Monday August 16, 2004 @09:21PM (#9986799)
    Wait, wait.

    MySQL is licensed with a "dual licensing scheme":

    1. If your product talks to MySQL, you must release it as GPL.
    2. If you don't want to GPL your product, pay MySQL $450.

    So... according to the GPL, can't I fork the GPL version of MySQL, not change a thing, and allow companies to use "HerSQL" for free, keeping "HerSQL" as GPL?

    Further, don't a lot of web applications that are not GPL interface with MySQL? Doesn't this violate their license?
  • by RWaye ( 778934 ) <rmw998@gmail.com> on Monday August 16, 2004 @09:22PM (#9986803)
    Now, I am not sure if this is true, but since MySQL is GPLed, doesn't that mean that they have some freelance programmers that contribute to the project? If they leave the GPL, that may encourage a devolper move to Postgre, helping it become a better DB.
  • by ttfkam ( 37064 ) on Monday August 16, 2004 @09:23PM (#9986807) Homepage Journal
    It went on and on about how much they like the GPL over all other licenses. I'm no MySQL fan, but for fuck's sake...

    That said, this statement made me chuckle a bit:
    The main point he made to us is that his company believes "strongly in Open Source." The company has actually tried to increase the freedoms provided by the GPL, Urlocker asserted, with the "MySQL FOSS exception" that allows some Open Source Initiative approved licenses, that are incompatible with the GPL, to still make use of the GPL licensed version of MySQL.
    Let me get this straight. Because it allows linking with PHP and Apache -- two systems which incidentally are fundamental to MySQL's continued success -- this is proof of their love of free software and freedom? Call me cynical, but it sounds more like proof of their love of avoiding irrelevance.

    Can you imagine?

    MySQL AB: We are pure GPL!
    Developer1: Isn't the GPL incompatible with the Apache/BSD style of license?
    Developer2: According to the FSF it is.
    Developer 1: Aren't the Apache web server and PHP under Apache/BSD styles of license?
    Developer 2: PHP used to be GPL, but yeah, now they're both like that.
    Developer 1: So if I sell a complete package with all three, I'm legally in trouble?
    Developer 2: Looks like it.
    Developer 1: Well, I guess I'll install PostgreSQL then.
    MySQL AB: MySQL FOSS exception!
    Developers 1 and 2: Wow! What nice guys. They're really sticking their neck out for us on that one. Thanks!
  • by fishdan ( 569872 ) * on Monday August 16, 2004 @09:24PM (#9986817) Homepage Journal
    I'm not saying that MySQL is the greatest thing since sliced bread, but Open For Business [ofb.biz] makes their living off of commenting on FREE software, which MySQL is not, nor has every really claimed to be. They sell advertising. They have a financial incentive to claim that

    the sky is falling

    MySQL is going to screw everyone.

    Just because one person's twist on that interview says that MySQL is about to turn evil, doesn;t mean it's true. Read the article, not just the /. headline

    I actually think that the article is very fair, but it's considerably more in depth than most people who only read the /. headlines will know.

  • by offpath3 ( 604739 ) <offpath4@ya h o o . c o .jp> on Monday August 16, 2004 @09:26PM (#9986828)
    Once they've released code under the GPL, it is always under the GPL. But, because they are the original copyright holders, they may also release it under any other licenses as they see fit (and in this case, MySQL does just that). They could also make a newer version using the old code and not release it under the GPL, since again, they are they copyright holder.

    Where this gets dicey, though, is if MySQL contains any code which is owned by someone else. For example, if I make an improvement to MySQL, and they incorporate it into a newer version, they could not release it under any license other than the GPL without my approval, unless they were to remove my code. Strange quirks like this are one of the reasons why the FSF asks people to give the copyright of code over to them rather than to have all of the individual programmers retain copyright.

  • by EvilTwinSkippy ( 112490 ) <yoda AT etoyoc DOT com> on Monday August 16, 2004 @09:26PM (#9986835) Homepage Journal
    It's not that I "refuse" to learn anything else. It's that 3 years ago when I started my project I needed replication THEN. I needed a windows port THEN. I needed TCL bindings THEN. And I'm not going to re-write 250,000 lines of code because someone tells me my perfectly working system is inferior.

    And you guys are yelling awful loud to have anything meaninful to say.

  • by Unknown Relic ( 544714 ) on Monday August 16, 2004 @09:27PM (#9986843) Homepage
    Let's not forget about the recent changes of the MySQL client to use the GPL instead of the LGPL, since such a change hardly suggests that they're looking to dump the GPL. This change was widely publicised, as it caused issues (which have now been resolved) with other non-GPL open source applications which previously shipped with the client software - PHP being the prime example.

    On the other hand, I do think MySQL really wants to push their commercial license as they "recommend" it for everyone who use MySQL in a commercial environment, even though their dual licensing scheme only requires the purchase of a license if you plan to be distributing MySQL itself. It'll be interesting to see how this all unfolds, but I don't think the GPL version of MySQL is going to go anywhere, at least not for non-commercial users. While commercial users may face stronger "recommendations" to purchase licenses, I don't see any actual changes to the license requiring a license for commercial use without distribution. Doing this would shut out millions of entry level hosting providers, and it wouldn't be long until MySQL's massive market share fell to alternatives such as Postgres or SQLite.
  • Re:PostgreSQL (Score:5, Insightful)

    by BiggerIsBetter ( 682164 ) on Monday August 16, 2004 @09:28PM (#9986845)
    There's only one thing that I like about MySQL... SAP-DB. - er, MaxDB, and even that's sufficiently different from MySQL database to avoid the whole PHP/FanBoy mess. However, Postgresql is "good enough" for 90% of apps. Oracle is certainly good enough for the remaining 10%.

    I reckon that now that MySQL is dealing with one of the big boys (SAP) they think they're the shiznit. They think they have the PHP and web server-side arena sewn up, so now they're trying to assert themselves in the larger market.

    Roughly put, they're setting themselves up for a fall. MySQL database might be owned by a company, but it was tested and supported by the wider community. If MySQL starts screwing with their supporters they'll lose them to Postgresql, Firebird, or whatever. Much of the software using MySQL is opensource, and it can be ported to another database just as soon as the need is there.
  • by Anonymous Coward on Monday August 16, 2004 @09:30PM (#9986858)
    As far as I know, the X.Org split was mostly influenced by a desire to get away from feature stagnation and politics in the Xfree community, not just licensing.
  • Re:Error in Logic? (Score:3, Insightful)

    by EvanED ( 569694 ) <{evaned} {at} {gmail.com}> on Monday August 16, 2004 @09:32PM (#9986871)
    So... according to the GPL, can't I fork the GPL version of MySQL, not change a thing, and allow companies to use "HerSQL" for free, keeping "HerSQL" as GPL?

    Yep.

    Further, don't a lot of web applications that are not GPL interface with MySQL? Doesn't this violate their license?

    It's in the gray area. A bit closer to the "okay" side than, say, Java's dynamic binding (which is another 'can we combine GPL and nonGPL code). That's what the guy is talking about in the article about developers should abide by the GPL and not try to find loopholes.
  • by Anonymous Coward on Monday August 16, 2004 @09:34PM (#9986883)
    I'm not sure what I've misconceived here.

    A project released under the GPL stays under the GPL. No retroactive licensing may be applied to the code. This does not prevent me (the author/copyright owner) from re-licensing the code under any other license that I deem useful.

    In the situation that I released under GPL and then took the code back immediately before anyone had a chance to gain access to it, my GPL'ing of the code is essentially moot. It would be as if I had never released the code under the GPL.
  • by rhaas ( 804642 ) on Monday August 16, 2004 @09:39PM (#9986908) Homepage
    I think the change from the LGPL to the GPL was designed precisely for the purpose of forcing more people to purchase commericial licenses. Unless I'm misunderstanding the situation, under the LPGL, you can link your (propriety) code against their libraries without having to distribute your source code. Under the GPL, this is not the case - linking is not "mere aggregation" and you now have to distribute the source, cough up $$$, or stop upgrading MySQL. If they were distributing the code ONLY under xGPL, the change would clearly be an endorsement of F/OSS, but because of the dual license, it seems more like an attempt to restrict what users can do with their software.
  • all the better (Score:2, Insightful)

    by ryane67 ( 768994 ) on Monday August 16, 2004 @09:40PM (#9986920)
    ill be happy if they change the license away from the GPL and it happens to run their marketshare to nothing.

    Honestly I never understood what people saw in mySQL other than the FREE aspect, and if that was the only thing they were looking for Postgres, Oracle (for personal use), and MSDE (MS sql server free ver) are all much better tools for the same price.

  • by davidwr ( 791652 ) on Monday August 16, 2004 @09:46PM (#9986944) Homepage Journal
    On my last project, I used OBCD specifically so I could use one DBMS today and I or my in-house customers could replace it with another one later with minimal effort.

    There are other ways of doing the same task, such as using wrapper functions for your DB calls.

    This approach isn't appropriate for every project, but before you start coding, you should ask yourself "will this ever be used on another DBMS, what can I do now to save myself work later, and what will it cost me in terms of schedule, functionality, performance, etc."
  • Re:Please stop (Score:5, Insightful)

    by OmniVector ( 569062 ) <see my homepage> on Monday August 16, 2004 @09:50PM (#9986965) Homepage
    i'd rather everyone stop coding strictly towards one database api, and use abstracted interfaces like PEAR, ado.net, jdbc, odbc, etc.
  • by DAldredge ( 2353 ) <SlashdotEmail@GMail.Com> on Monday August 16, 2004 @09:54PM (#9986982) Journal
    Why in the hell did you write 250k line of database dependent code?
  • by nkh ( 750837 ) on Monday August 16, 2004 @10:01PM (#9987054) Journal
    Atomic commits seems to be called transactions in PostgreSQL. More info can be found in the tutorial [postgresql.org].
    PostgreSQL also has support for Ruby (and Python) which is sufficient to write a lot of useful scripts.
  • by justins ( 80659 ) on Monday August 16, 2004 @10:04PM (#9987074) Homepage Journal
    I don't think it would be overstating the case to say that "Zack Urlocker, MySQL's vice president of marketing" is either a liar or doesn't understand the application of the GPL with regards to client/server software:
    On the other hand, while Urlocker said the company is not adding restrictions on to the GPL, he felt that attempting to, as he put it, "circumvent" the GPL by communicating with the database using a third-party tool and TCP/IP or another protocol was a gray area and while perhaps following the letter, it was not following the spirit of the General Public License.

    Communicating with a database via "TCP/IP or another protocol," such as ODBC, is not in any way a circumvention of the GPL. This is what ODBC is for, for heaven's sake, there's nothing sneaky about it.

    Following MySQL's moronic licensing innuendo, you would be required to use GPLed software to talk to a GPLed web server. Unfortunately even the unixODBC guy who was quoted didn't make the point that connecting to a database server from a client program (on a remote machine or on the same machine) using ODBC is morally equivalent to connecting from a client program to a web server using HTTP, and so the same rules must apply. The FSF guy didn't make that point either. I can understand why these free software folks feel some need to stick up for each other but someone needs to drive a stake through the heart of all this licensing idiocy, it doesn't help anyone.
  • by conradp ( 154683 ) on Monday August 16, 2004 @10:09PM (#9987124) Homepage
    IANAL, but...

    Firstly, certainly all previous versions of the software licensed under the GPL can continue to be used under the GPL.

    Secondly, if the copyrights to the software are all solely owned by one company or by a small group of people then they can re-release the software under as many different licensing schemes as they want. They own the copyrights to the code, so they could decide to make all future versions of the code closed-source, or whatever. Anyone in the free software community would be free to create a "forked" version of the software based on the last GPL version and continue to develop it independently and release it under the GPL.

    Thirdly, if the developers have accepted contributions from GPL folks without also getting ownership of the copyrights to the contributed code, then they probably are not allowed to take the current code based and make a version of it with any license that's more restrictive than the GPL, since the only license they have to the other people's code is the GPL itself, which forbids adding restrictions.

    Finally, this is all a red herring in this particular case because the MySQL folks are just publishing their take on what the GPL means on their web site - they're not actually adding any restrictions. Of course, any company that sells software for a living will bias the explanations of the GPL on their web site as far as they can towards making you think that you have to buy their software, but the real license is still the GPL, and their "interpretation" of the GPL holds little or no legal standing.
  • by Anonymous Coward on Monday August 16, 2004 @10:40PM (#9987374)
    There's not actually any concept of 'internal use' in the GPL, you know... there's no line to be crossed. The requirement is simply that those who receive the binary from the distributor are entitled to the corresponding source.

    As far as leaked binaries are concerned, good luck. As far as the developing company or individual is concerned, they haven't released binaries, so they've no obligation to release sources either.

    And I doubt any court would see binaries obtained illegitimately as forcing the release of source - you might well find yourself under attack for breach of copyright by possessing them.
  • by Daniel Dvorkin ( 106857 ) * on Monday August 16, 2004 @10:59PM (#9987508) Homepage Journal
    Aaargh. Can we get rid of this stupid meme, please? I've been making a living as a DBA for almost five years now. I'm 2/3 of the way to a CS Master's. I've used Oracle, Sybase, and PostgreSQL. And I prefer MySQL. The idea that the only people who use MySQL are those who don't know any better has to die.
  • by lspd ( 566786 ) on Monday August 16, 2004 @11:13PM (#9987606) Journal
    This parallel licensing, where projects are released under the GPL and then sublicensed to private entities under non free licenses in exchange for bling is probably ( imho ) the best way to make money on a free software project.

    Horse-puckey...

    It's a conflict of interest that consistently leads to abuses.

    In the present case MySQL is pretending that GPL software is basicly non-commercial use only. It's a straight out lie, no matter how they dance around the issue. The Free Software Foundation is being very kind in stating that MySQL "marketing literature" isn't their concern.

    MySQL AB isn't alone though.... Trolltech advances the idea that software you create using the GPL version of QT can't be reused in a commercial product. Their wording is careful, but the idea is wrong. You own the code you write, regardless of what libraries you used. Remove those libraries and you can do whatever you want. Their dual-licensing has also resulted in Linux PDAs which can't be synced to Linux desktops. Way to go...

    PHP-Nuke has tried to pretend that various bits of code and advertising constitute a license declaration under the GPL. Basicly, GPL == adware. It's nonsense. Moreover, the PHP-Nuke advertising makes no mention that PHP-Nuke is itself a fork of Thatware.

    ReiserFS, like PHPNuke wants to pretend that GPL software is adware for commercial products. Hans flipped out when Debian trimmed the marketing spiel out of mkfs.reiserfs. It's obviously not the intent of the license text clause of the GPL to advertise the benefits of non-free versions of GPL software.

    Dual licensing is a bad idea. The only way you sell the commercial version is to make the GPL version unfriendly to business. Since the GPL was intended as a business friendly license, you're forced to misrepresent the GPL to sell licenses. If you want a dual-licensing business, don't use the GPL as the free license. Pick something that lets everyone know, from the get-go, that you're a commercial house intent on selling commercial software.
  • by Xenographic ( 557057 ) on Monday August 16, 2004 @11:14PM (#9987615) Journal
    Well, for them to change the license, they must have the copyright on that code (or the consent of all those who do hold copyright on it).

    From then on, they can license it however they please under any license they see fit.

    However, what was GPL'd *stays* GPL'd, so you can restart a fork of it with all new developers if you so choose. Also, if you have many copyright holders (e.g. as with Linux), you effectively cannot change the license, because it would probably be impossible to get the consent of enough of the copyright holders.

    IANAL, but I've spent a lot of time reading US copyright law [cornell.edu] and Groklaw [groklaw.net].
  • by ttfkam ( 37064 ) on Monday August 16, 2004 @11:15PM (#9987627) Homepage Journal
    I had thought about that, and the more I thought about it, the more it seemed like a bad idea. Why?

    The bad habits people learned on MySQL would perpetuate. After all, why code for database abstraction if the two main OSS databases share the same API?

    I'd much rather MySQL tightened things up a bit. Optionally of course as I understand they have a large installed base, but I'd like to see the MySQL version of Perl's "use strict". If MySQL did that, I hereby proclaim to all around me that I will no longer bash MySQL. I won't necessarily prefer it to PostgreSQL, Firebird, or SQLite, but I won't flat out trash talk it for being a loose piece of crap data trashcan that silently ignores obvious errors in the name of efficiency while blaming the programmer even though one of its primary selling points is that it's easy for beginners.

    'The fuzzy elephant' is NOT a valid integer nor is it a valid timestamp nor is it appropriate for a varchar field constrained to 10 characters! NOT NULL means "I require a value," not "I'll put the non-specified default in there despite you passing a NULL." It's not like these checks require a great deal of processing power after all. If it made more than a blip on the speed of MySQL, I would be truly astonished.

    Once MySQL's "use strict" is in there, I will accept the mantra that it's the programmer's fault for not using it.
  • by vandan ( 151516 ) on Monday August 16, 2004 @11:20PM (#9987662) Homepage
    Sure.

    That's like saying that Linux can only do a little more than you can do with an abacus and a piece of chalk.

    If you want to use Postgres, fine. Use it. But you make yourself look very small when you go out of your way to put down such a fine project as MySQL just because your Postgres can do ... what ... oh yeah - you didn't even mention.

    What I find really strange is the level of hate that Postgres users feel justified in showering on MySQL users. And then you wonder why you get it back. Personally I don't give a flying fuck what database you use, but once you say you are a Postgres user, my estimation of you automatically goes down a couple of notches because of the number of noxious posts by your clan.
  • by danharan ( 714822 ) on Monday August 16, 2004 @11:33PM (#9987740) Journal
    I remember a few years ago, a total nOOb, trying to figure out what's what in the database world. I had read about how we don't really need all those complex features that slow down databases, and believed it.

    Then I worked for a company that required Oracle for its database, because nothing else on the market could possibly handle what they needed done. And they put me to work on some of their stored procedures. ouch.

    I learned what I needed about database normalization, and I realized just how much of a toy MySQL was.

    That they added essential features is great, but that they still think they're unnecessary shows they have NO CLUE what challenges you get in big developments. And if they flip-flopped on the features, will they change the license?

    The most promising db right now for people like me is obviously PostgreSQL. No license hassles is just gravy.
  • by fitten ( 521191 ) on Monday August 16, 2004 @11:37PM (#9987763)
    Heh... I'd be surprised if your system works "perfectly".

    If you have to rewrite 250,000 lines of code just to change to a real RDBMS, your code must particularly aweful. We typically isolate all database specific code in appropriate classes and stored procedures (after all, that's one of the things stored procedures are for... to help abstract the database specific code from the rest of your code) and it isn't bad at all to port to a new RDBMS, as long as it has the features we need (referential integrity, transactions, etc.)

    In fact, in most cases, we can port to a new RDBMS without recompiling our source, just by providing the appropriate stored procedures on the new system.
  • by FLEB ( 312391 ) on Tuesday August 17, 2004 @12:10AM (#9987931) Homepage Journal
    The counterpoint to that, though, is that the employee is working as an agent of the company, not as an agent of themselves. If they have been disallowed, as an agent of the company, from distributing the software outside the company, then the company has not "distributed" the software.

    Not that I'm a lawyer, or even have an iota of a clue about this subject (hey, this is /.), but I'd imagine that would be the most likely counterpoint.
  • All the more reason to use FirebirdSQL or PostgreSQL
  • by joeykiller ( 119489 ) on Tuesday August 17, 2004 @12:50AM (#9988145) Journal
    Strange quirks like this are one of the reasons why the FSF asks people to give the copyright of code over to them rather than to have all of the individual programmers retain copyright.
    I think the FSF only asks this for GNU products, not for every GPL product that exists.

    Isn't FSF's asking people to give them the copyright just the same as MySQL does, the only difference being thar MySQL is a commercial entity?
  • by Anonymous Coward on Tuesday August 17, 2004 @01:02AM (#9988209)
    Nothing new here.

    Well you're right about that, the GPL hasn't changed. It has always taken away the ability of original developers to make money from developing original software, forcing them to either make money by offering support or by flipping burgers during the day to fund their open source coding at night. Nothing new there, it has always slanted the playing field away from original developers and in favour of redevelopers.

    What's new however is that PHBs have now discovered open source, and so companies that previously employed talented original programmers to develop new inhouse products from scratch now realize that they can hire fewer people than before because there is so much great code out there available for free. Furthermore, the quality of the people they hire can be lower because they only need to be relatively inexperienced redevelopers instead of original designers. All of this translates into paying less money for development. They love it.

    Meanwhile, professional developers are getting screwed left, right and center, their earning potential and careers going right down the pan. After all, code hackers for redevelopment are two-a-penny, and there is little extra benefit from hiring a highly educated and experienced professional when all that an inhouse project needs is some existing open sources to be hacked around a little.

    And it gets worse. Small software businesses used to be very common, able to survive the hardships of birth and early growth because software development scaled very well, ie. a small group of developers could create a novel product and sell a huge number of copies, with near-zero incremental cost per copy sold. In contrast, making money from support doesn't scale, because support requires people-time to handle every additional customer needing support, and those people require salaries --- the incremental cost is very high unless you're outsourcing support overseas. It's pretty much impossible to launch a professional software business from your garage in these circumstances, unless you abandon open source.

    The sad thing is that those professionals were the grassroots developers who helped open source spread in the first place, but who now find themselves shafted by it. It's not surprising that some are changing their views now, when faced with mounting bills and no income.
  • by jadavis ( 473492 ) on Tuesday August 17, 2004 @04:11AM (#9988823)
    If stored procs are a bad thing, wouldn't the following features also be bad?:

    (1) triggers
    (2) constraint triggers
    (3) functional indexes using a user-defined function, or indexing a user-defined data type
    (4) user-defined aggregate function
    (5) user-defined data types

    Those are very difficult problems to simply work around. For #3 you just have to take the performance hit and not use the index. For #4 you have to read the entire amount of data into the application and post-process it to get the data you actually need. #1, 2, and 5 all speak for themselves, being basic principles of an RDBMS.

    And PostgreSQL 8.0.0beta1 has PITR (point in time recovery) meaning that it should be reasonably simple to revert to a previous state. Hopefully that makes it easier for you to fix it when someone screws it up.

    I'd also like to point out that a very advanced replication system, Slony-I [slony.info], was developed for PostgreSQL using triggers and stored procedures (to work with the replication daemon). So I'm not speaking in abstract terms about potential usefulness, but real-world business needs. What would you do to implement such a replication engine in MySQL? Write some code in the MySQL server and recompile I suppose. Slony actually works across PostgreSQL versions and works on versions of PostgreSQL that were released before Slony was ever conceived. That's the power of stored procedures.

    I understand that these features need to be used with care. I understand that some people don't need these features (unfortunately, some people realize they are needed too late). What I don't understand is how software can be missing these features and still call itself an RDBMS. What surprises me even more is when people make a blanket statement condemning these features with absolutely no acknowledgement of their actual uses.

8 Catfish = 1 Octo-puss

Working...