Slashdot Mirror


MySQL Released Under The GPL

Bryan Mattern was the first of hundreds to note that MySQL is being released under the GPL, as well as forming a partnership with VA Linux (which of course now owns Andover). This means nice things like it can move out of non-free in debian, and that the postgress/MySQL debate can now be argued in terms of features instead of license. MySQL's license was definitely a hurdle for the FAISC [?] so I'm really glad to see this happen.

232 comments

  1. yes! by ananke · · Score: 1

    another good argument for a great product

    --
    --- d'oh
  2. Good, now would.. by Rombuu · · Score: 3

    ..someone please stick transactions in it? I mean, its not even really a database without transactions... not to mention doesn't follow the SQL standard since COMMIT and ROLLBACK are not optional operations.

    --

    DrLunch.com The site that tells you what's for lunch!
    1. Re:Good, now would.. by frog99 · · Score: 3

      Look at the dev versions 3.23.xx.

    2. Re:Good, now would.. by ananke · · Score: 1

      i agree, i would like to see commit/rollback in mysql; however, for most of the web-based databases transactions are not that crucial :)

      --
      --- d'oh
    3. Re:Good, now would.. by Abcd1234 · · Score: 2
      I can definitely agree with you on this one. Without proper transaction support, a LOT more stuff has to go on at the application level, which is rather annoying for us coders. :)

      Anyway, IIRC, the mySQL devel team is working to incorporate transactions into mySQL. In fact, correct me if I'm wrong, but doesn't the latest version support BDB (Berkley DB) tables, which support proper transactions?

    4. Re:Good, now would.. by Abcd1234 · · Score: 5

      Ooooh, I'd definitely disagree on this one. As an example, when it comes to writing code which tracks inventories, etc, for online purchasing, it's VERY necessary to have transactions. After all, what happens if two people try to buy the same item, of which there is only one left in stock? You get a phantom read (or was this one a fuzzy read... I can't remember :). The only way to avoid this sort of thing is to support proper, serializable transactions, or to do what you'd do with mySQL... lock the table. :) The point is, any time you have a high number of concurrent database accesses, some of which include updates, you definitely need transactions (or more stuff at the application level to prevent this sort of thing, which is what you need to do with mySQL).

    5. Re:Good, now would.. by MartinG · · Score: 2

      I would guess we can expect lots of improvements, both in MySQL and PostgreSQL.
      There is now real competition in the GNU GPL RBBMS marketplace.
      AFAIK, until now PostgreSQL was the obvious GPL winner.
      How (or if) this motivates the members of either RDBMS will be interesting. I think we can expect this to improve both in the long term.

      --
      -- MartinG To mail me: echo kewyjlcxyzvjfxbqwh | tr bcefhjklqvwxyz .@adgimnoprstu
    6. Re:Good, now would.. by AndroSyn · · Score: 2

      Now how about support for stored procedures and a decent procedural language to go with it as well.

      You must realize that interprocess communicator is rather slow and expensive and having to fire off ten queries to do something is kind of silly when you could just rewrite a procedure and store it in the database and execute that with a single statement from the database client.

    7. Re:Good, now would.. by Nexx · · Score: 1

      (or more stuff at the application level to prevent this sort of thing)

      You also mentioned locking the tables. *ugh*. You're right, you will need to do so, as (afaik) row-level locking is not possible with MySQL. Of course, that alone will negatively impact the overall db performance, measured not in the milliseconds it takes to service a query, but in number of "transactions" per second.

    8. Re:Good, now would.. by MrEfficient · · Score: 4
      ..someone please stick transactions in it? I mean, its not even really a database without transactions... not to mention doesn't follow the SQL standard since COMMIT and ROLLBACK are not optional operations.

      Why are you asking for transactions or any other RDBMS feature in MySQL? MySQL is good at being a fast, easy to use database-like application. If you want a true RDBMS, just use PostgreSQL. Both MySQL and Postgres have their strengths and weaknesses, and each targets a slightly different user in my opinion. If you want a true RDBMS, then use a RDBMS, don't ask MySQL to be something its not.

      --
      Check out AbiWord.
    9. Re:Good, now would.. by Golias · · Score: 1

      Is it really a troll if they put a little ":)" at the end of it? I mean, it is hardly their fault if somebody does not realize they were being sarcastic or kidding around.

      --

      Information wants to be anthropomorphized.

    10. Re:Good, now would.. by fridgepimp · · Score: 1

      Although it's been said, I'll try and say it a different way. MySQL now has transaction support via BerkleyDB since 3.23.16.

      fp

    11. Re:Good, now would.. by arthurs_sidekick · · Score: 5
      Why does every story on MySQL have to contain a complaint like this (and why are they always moderated up to the heavens)?

      A MNemOnic I offer to the world: MySQL is Not Oracle. It doesn't try to be one, that's not the goal. Yes, it isn't a heck of a lot more than an SQL frontend to a flat file system. That's all some of us want. OK, subselects would be nice, but IIRC they're working on that. But this constant kvetching about lack of transactions should really stop. If you want something with transactions, use Postgres or Interbase or pay for it.

      I am becoming *such* a cranky old man.

      --
      "Oh, I hope he doesn't give us halyatchkies," said Heinrich.
    12. Re:Good, now would.. by freedman · · Score: 1

      PostgreSQL was originally developed at Berkeley.

      It has never been released under a GPL license.

      It has always been developed and licensed under the BSD license. However, I would agree that most competition in the Free Software / Open Source RDBMS market will be between MySQL and PGSql.

      I've been using Postgres v.7.0 for 1-2 months now (having previously only used Oracle), and really enjoy it.

    13. Re:Good, now would.. by gregbillock · · Score: 2

      MySQL does support transactions. You can declare some tables BDB (Berkeley DB) type, which will support COMMIT/ROLLBACK, and others MyISAM type, which will be blazing fast, and use them both in a JOIN or what-have-you.

    14. Re:Good, now would.. by dpk · · Score: 1

      Ok. There in. Are you happy now? 3.23.14
      P.S. Things change rapidly in the OpenSource world, lest you forgot.

    15. Re:Good, now would.. by SoftwareJanitor · · Score: 3

      If you need transactions, check out PostgreSQL, which is also free. Not as fast as MySQL, but supports transactions and a more full featured SQL implementation. I am personally hoping now that MySQL is under a compatible license to PostgreSQL that some 'cross-pollination' between the two projects can happen. Get some more features into MySQL and some more speed into PostgreSQL.

    16. Re:Good, now would.. by Andrew+Dvorak · · Score: 1

      My Mysql and mSQL book from Oreilley suggested that the mysql team was working on making features more modular to compromise speed for features to those who want them. It's well known that the mysql team has always shot for speed .. often leaving out many advanced features that might slow it down considerably.

    17. Re:Good, now would.. by Garpenlov · · Score: 1

      ..someone please stick transactions in it?

      Uhm... it does have transactions (in the latest development versions). You have to use the BDB table type.

      --
      --- Where's my X.400 protocol decoder?
    18. Re:Good, now would.. by arthurs_sidekick · · Score: 1
      Hm, one of the uses for the Zend engine (which lies a tthe heart of php4) is to get embedded into MySQL, stored procedures are going to get implemented in Zend..

      Something to that effect is still available on the php.net homepage. Check there and zend.com for a more definitive answer.

      --
      "Oh, I hope he doesn't give us halyatchkies," said Heinrich.
    19. Re:Good, now would.. by decaym · · Score: 1

      It's always good to strive for improvement.

      Why not use the approach Linux and PHP has and make it so MySQL can be compiled with just the feature set a particular installation requires? This could avoid much of the performance sacrafice without keeping new features from being introduced.

      --
      World Beach List, my latest project.
    20. Re:Good, now would.. by Frodo · · Score: 1

      Latest version has transactions. Check www.mysql.com.

      --
      -- Si hoc legere scis nimium eruditionis habes.
    21. Re:Good, now would.. by kkeller · · Score: 1
      There is now real competition in the GNU GPL RBBMS marketplace.

      Lisa: "What's that extra B for?"

      Homer (grumpily): "That's a typo."

    22. Re:Good, now would.. by dwoods99 · · Score: 1

      Is there ever a chance of seeing a MyPostSQL merging of the two ? Why not !

      --
      "Life is like a dogsled... if you're not the lead dog, the scenery never changes."
    23. Re:Good, now would.. by phred · · Score: 2

      Same mistake here as always. MySQL is a relational database. "Transactions" does not define what "relational" is -- go read E. F. Codd's papers if you don't know why.

      ------

      --
      Bill Gates Is My Evil Twin.
    24. Re:Good, now would.. by cybear · · Score: 1

      There's not going to be much, if any, 'cross-pollination'! The two programs are completely different. Sure, from a simple select point of view maybe they seem similar but that's where it ends.

      Hey, if Windows goes open source, that means I can use Explorer in Linux, right? Come on...

      --
      Upon seeing the box was too small, Schrodinger's Elephant breathed a sigh of relief.
    25. Re:Good, now would.. by SoftwareJanitor · · Score: 2

      Do you actually do any development? Sure, you can't just cut and paste stuff verbatim from completely different code, but if I've got access to code I can steal from freely, I can damned well at least crib some ideas from it as to how to do some things, if not adapt some parts of the code. Having a reference implementation in source available is sometimes invaluable even if you are writing all new code.

      What you are talking about with Windows source code to Linux is a little bit different -- you are talking about code designed for radically different platforms with different APIs. Both MySQL and PostgreSQL are fairly portable and written to a UNIX-like platform and API. That makes a big difference.

      At any rate, it isn't just cross-polination of the actual code as much as developers who have experience implementing some of the more advanced features in PostgreSQL for example might be able to make contributions for MySQL, even if it might mean they have to write all new code, the concepts and knowledge they could transfer would still be valuable.

    26. Re:Good, now would.. by Kidbro · · Score: 1

      not to mention doesn't follow the SQL standard

      Please, oh please give me the name of one database that follows the SQL standard. Oracle doesn't. MSSQL doesn't. Sybase doesn't. Postgres doesn't. Need I go on?

    27. Re:Good, now would.. by KIngo · · Score: 1

      There are always several ways to do one thing. In MySQL you deal with kind of problem either through an application server or, if that's not possible, through MySQL application locks. Transactions are a feature which enhances security but the lack of which is by no means a serious degradation of functionality.

    28. Re:Good, now would.. by ZeroTolerance · · Score: 1
      If you check the MySQL site, they are working on transactions. just install Berkely DB and you should have transaction support.

      <spam> KLICK HERE FOR TRANSACTIONS </spam>
      --

      --
      Ignorance is no excuse
    29. Re:Good, now would.. by MrEfficient · · Score: 1
      Same mistake here as always. MySQL is a relational database. "Transactions" does not define what "relational" is -- go read E. F. Codd's papers if you don't know why.

      I'm not saying that MySQL isn't relational, I'm not even saying it doesn't have transactions (according to some of the other posts I've read, it does). I'm also not saying that transactions make a RDBMS. There are many things that make up a RDBMS from a user standpoint. The ACID test is probably what most people look at when deciding whether an application is a RDBMS (there are many other things too of course.). What I said was that MySQL is not a RDBMS. I think that anyone who knows anything about a RDBMS will agree with that statement.

      I'm not bashing MySQL, I think its a great application. I also suspect that some of the features people like most about MySQL exist because it is not a RDBMS. Trying to turn MySQL into a RDBMS might compromise the very features that its users find so attractive. It fills an important niche in the field of web applications. My point was mainly that if someone needs a true RDBMS, they shouldn't be using MySQL in the first place.

      --
      Check out AbiWord.
    30. Re:Good, now would.. by lowen · · Score: 1

      And Berkley DB has _what_ license? :-)

      --
      Lamar Owen
      WGCR Internet Radio
      1 Peter 4:11

    31. Re:Good, now would.. by Tony-A · · Score: 1

      Begin Transaction;
      Update some stuff ...
      Die and leave it hanging.

      The design objectives of MySQL are completely different from those of Oracle. Transactions are expensive, probably in more ways than I can think of.

  3. Is this a trend? by Dungeon+Dweller · · Score: 2

    1) Are more people moving from their traditional licenses to the GPL? A lot of license bingo has been going on lately.

    2) Differences between postgress and MySQL.

    Well, now is a good time to start the debate, which do you like better and why? I like them both equally, but then again, I've only run MySQL in enterprise, how does postgress hold up to real strain?

    --
    Eh...
    1. Re:Is this a trend? by Bruno+Saskatchewan · · Score: 1

      Well, more products ought to move to GPL. It is simply a better license for truly free-as-in-speech software. I suppose if you don't mind having your code appropriated for non-free use, the BSD license isn't too bad, but most of the others are severely defective, especially the Artistic license with all its sloppy loopholes.

    2. Re:Is this a trend? by Ray+Dassen · · Score: 2
      Differences between postgress and MySQL. [...] Well, now is a good time to start the debate

      Could we talk about Interbase as well? Even though its source is not yet available, it is expected soon under an MPL-like license (the IPL).

    3. Re:Is this a trend? by sumner · · Score: 1

      Well, now is a good time to start the debate, which do you like better and why?

      I prefer Postgres, since it supports full transactions, nested selects, and a number of other SQL features that I can't live without--I've heard that mysql has much better transaction support than it used to, though. mysql also had a tendency to mangle my text fields (trailing whitespace would vanish mysteriously from variable-char fields), I don't know if that's fixed yet or not.

      Postgres is abysmally slow at batch inserts (at least 6.x, I haven't had a chance to test 7.x). And it's not super fast in general, but once you are talking about databases of any significant size then it's nowhere near as slow as people say--except at bulk inserts. Slooooooow.

      Sumner

      --
      -- rage, rage against the dying of the light
    4. Re:Is this a trend? by tzanger · · Score: 5

      Well, now is a good time to start the debate, which do you like better and why? I like them both equally, but then again, I've only run MySQL in enterprise, how does postgress hold up to real strain?

      MySQL in enterprise?
      How'd you do that without transaction support or are you doing the checks and balances in your code?

      I've settled on Postgres because of the transaction issue and because I write my code so that most of the grunt work is done in the database. Why use your cgi to do the sort or the ordering when the database (supposedly) should be able to do it faster? Why use PHP to pick and choose the columns from a generalized select when your database is designed to pick and choose?

      I like Postgres (7) because now I don't have to have shared libs to fake foreign keys. Data integrity is a big thing for me and MySQL doesn't seem to have a whole lot of support for it. Yeah it's fast as hell but how much faster than Postgres 6.5 or 7?

      I've seen the benchmarks pitting Postgres and MySQL. What I'd like to see are these benchmarks performed with somewhat more "realistic" criteria. I don't do select a,b,c,d from mytable where a=whatever; -- my SQL statements are set up so that the bulk of the work is done by the database itself and the resultant data given back to my program is already ordered, sorted and formatted how I need so that all I have to do in the program is wrap it in HTML and spit it out.

      I thought that was the whole idea behind using a database over a flat file or other "roll yer own" database setup?

      While I'm on this mini rant, where are some real benchmarks between Perl (with and without mod_perl) and PHP (with and without Zend)? I really don't care if PHP can compute a FFT in 1/3 the time that Perl can; 99% of my cgi scripting is feeding and recieving data from a database connection or parsing some kind of human-readable input into something the machine can use, not doing heavy computations. What are the speed comparisions in a realistic situation?

      Don't get me wrong -- I started out with PHP and gradually found myself using more and more Perl just because I could reuse my modules in my other (non-cgi) code. I found myself questioning my use of PHP every time I typed the <?php tag. It's not a good thing to mix code and content, which is pretty much the biggest advantage PHP has over Perl IMO. It makes it very easy to do exactly that.

      If I wanted speed over all, I'd write in assembly or C and do the CGI that way. What real advantage does PHP have over Perl?

    5. Re:Is this a trend? by MonkeyMagic · · Score: 2

      which do you like better and why?

      Depends on the application.
      If it's raw speed you need then mysql is the killer db. No doubt about it. This, I suspect is because it gives up some features in favour of speed (transactions may or may not be in this category). If you need some standard RDBMS features such as transactions then go to Postgres, which I'm not too familiar with.

    6. Re:Is this a trend? by AndroSyn · · Score: 3

      2) Differences between postgress and MySQL.

      1. postgreSQL support transactions and MySQL doesn't (at least not yet)
      2. postgreSQL supports stored procedures take your pic of pl/perl, pl/pgsql, and pl/tcl to write them in.
      3. postgreSQL supports finer grained locks on the database. MySQL only really supports locks on the table level.
      4. postgreSQL has subselects and views.
      5. Don't forget goodies like triggers and foreign keys.

      Of course the trade off is that mysql tends to be a bit faster on reads and writes, but then again I've heard mysql described as a sql interface to a filesystem, so....

    7. Re:Is this a trend? by mafbat · · Score: 1

      I use PostgreSQL a lot. I've never tried MySQL. I notice that Postgres is slow when I extract data from very large tables (say > 750,000 rows.) Now, I've found that it's much faster to break the tables down into multiple smaller tables and then loop through each one and aggregate the results. This is even with the use of indexes.

    8. Re:Is this a trend? by 2GooD · · Score: 1

      What real advantage does PHP have over Perl?

      It's easier to learn...

    9. Re:Is this a trend? by dpk · · Score: 2
      ...but then again I've heard mysql described as a sql interface to a filesystem, so....

      In fact you are exactly correct. Mysql is an SQL frontend to a filesystem. This is an incredible advantage, however. For instance, Mysql is written such that the format of the tables is not linked to the syntax of the interface. IE - there are multiple different table types available, each with their own pros and cons. But all of them are accessed in the same way from the user end - via SQL.
      • There are standard MyISAM tables which consist of 3 files in a binary portable format (index, data, and layout).
      • There are heap tables which are binary trees resident only in memory (EXTREMEMLY fast, but rather temporary).
      • And now there are Berkeley DB tables - which support transactions but are significantly slower than the other tables.


      • Unix/Linux is built on the premise that everything is a file, so it is rather ignorant to say that an SQL interface to a filesystem is a bad thing. Of course the database engine deals with things like locks, concurrency, threading, atomic operations, logging and more. But the real advantage here is if you want to create a new table type with your own design criteria, you can plug it right into the MySQL engine and boom - now you have an SQL interface, a Client Server app, a user security system, replication and more.
    10. Re:Is this a trend? by tzanger · · Score: 1
      • What real advantage does PHP have over Perl?
      It's easier to learn...

      Perhaps you have a point... Perl has lots of ways to do things and some of them don't seem intuitive right off. Regexps aside, PHP is still probably easier to learn than Perl.

      Of course, if you're trying to make perl compact and slick you're gonna end up with write-only code. :-)

    11. Re:Is this a trend? by Rilke · · Score: 5

      I'm not sure what the original poster meant by "enterprise", but the choice should really be based on your needs. Sure, some apps need SPs and transactions, and some really don't.

      Take slashdot. I've never looked at the code, the DB needs are pretty simple. Keep track of the user names and passwords, and keep track of the threads and subjects. There's no real complicated joins or formatting required.

      And data integrity, vis a vis transactions, just isn't important. Is somebody changing the moderation score on a topic while somebody else is accessing that topic? Who cares? So the moderation score of the thread won't match up. This isn't your checking account, the top line doesn't need to be consistent with the bottom line.

      Lots of apps, even in the enterprise, fit MySQL's problem domain, and lots do not. Everyone compares MySQL to PostGres, but it's a bad comparison. If you need transactions or SPs, then you really need them, and using MySQL and trying to emulate these features in code is a very bad idea. If MySQL fits your needs, then it's blindingly fast and the best tool for the job. If those aren't your needs though, then you need something different.

      PHP vs. Perl: I've seen both types of projects go to pieces. The problem with PHP is that you start with a lot of HTML and a little code, which makes PHP seem perfect, but over time you wind up with lots of code that isn't organized at all because it's embedded in all your HTML pages, which makes the code very hard to maintain.

      Perl, of course, has the opposite problem. You start with a simple database app with very little formatting, which makes a mod_perl script perfect for the job, but over time you start to add bells and whistles to the user interface until you again wind up with your code and HTML totally interspersed, which again makes maintenance very difficult.

      I'd love to see a really good book on code organization for the web. It's a very complex subject, and I generally feel like most of us are constantly re-inventing the wheel.

    12. Re:Is this a trend? by Tobias_Ratschiller · · Score: 1
      Please repeat after me: You do not have to mix code and layout when using PHP. Many beginners find it easier to do so, but it's absolutely no requirement, and indeed doesn't scale very well. There are different template APIs available, an XSL processor is being integrated into the language, and XML is supported too, of course. And the boys are going to change that unfortunate "PHP is a server-side, cross-platform, HTML embedded scripting language" on the web site soon, I hope. :)

      As for the book, have a look at Web Application Development with PHP.

    13. Re:Is this a trend? by PigleT · · Score: 2

      To answer two or so of your points:

      I've got a perl script, running from commandline only atm and probably going to stay that way, that inserts lines from STDIN into a database. ATM this is running against PostgreSQL and with either 6.5 or 7.0, because I'm doing 1 select plus either an update or insert depending on the select results, performance is dead slow. In fact, it only gets about 30 rows / second inserted; most of this time Postmaster is stuck in 'D' state writing to disk with fsync() calls.
      If I take the insert/update statements out altogether and just select for each line on STDIN, then it runs 8x faster. Perl is not the slowdown I thought it would be here!
      (Yes, I'm using DBI, DBD::Pg and prepared SQL statements for a *reason*.)

      As for advantages of PHP over perl: I don't know of any. PHP3 doesn't have any *consistent* DB interface to match DBI - I wrote some elementary benchmark things in both PHP3 and Perl, and you can tell me how much easier it was to change DBD::Pg into DBD::ODBC and stuff, than to go round renaming *all* the function calls for the different databases. D'oh. It comes down to interpreter speed and relative apache-module sizes and how integrated the script is with your HTML for what you want it to do.

      What I want to do is play with Kawa a bit more... write Scheme, compile into java .class files .. run anyplace? Could be good, could be portable, could be optimizable...
      ~Tim
      --
      .|` Clouds cross the black moonlight,

      --
      ~Tim
      --
      .|` Clouds cross the black moonlight,
      Rushing on down to the circle of the turn
    14. Re:Is this a trend? by Cardinal · · Score: 2

      PHP vs. Perl: I've seen both types of projects go to pieces. The problem with PHP is that you start with a lot of HTML and a little code, which makes PHP seem perfect, but over time you wind up with lots of code that isn't organized at all because it's embedded in all your HTML pages, which makes the code very hard to maintain.

      This is, of course, not a shortcoming of PHP. This is what happens when a project is started with no preconception of scope, design, or modularity. In any web application, regardless of language, content and code should never be mixed beyond what is necessary for connecting the data with the layout. PHP can be very good at this. Java Servlets can't, which is why we have JSP. ColdFusion can't, because it's nothing but markup (In other words, CF is like JSP without servlets to back it up. But CF is going to become a set of custom JSP tags in the near future, so it's all good.)

      If you've written a handful of PHP scripts that are mostly HTML, and later become mostly PHP, you didn't think ahead (Or your bosses didn't think ahead.. :) ) The bulk of the PHP code should've been seperated out into objects, functions, or utility scripts from the very beginning. A good habit is to always do this, regardless of how small a project starts out as. Even if the project is small, the code can be reused much easier if it's seperate to begin with (Which you noted as a reason you were moving away from PHP towards Perl. Again, this isn't a shortcoming of PHP, it's a lack of planning).

    15. Re:Is this a trend? by tzanger · · Score: 1

      Please repeat after me: You do not have to mix code and layout when using PHP.

      I know this. That doesn't answer my question about what advantages does PHP have over Perl though. :-)

      Many beginners find it easier to do so

      Indeed. That's why I first started using it. That, and because I figured Perl was just too damn ugly and unwieldy to use. I'm trying to see if I'm missing anything now that my viewpoint seems to have changed.

    16. Re:Is this a trend? by tzanger · · Score: 1

      And data integrity, vis a vis transactions, just isn't important. Is somebody changing the moderation score on a topic while somebody else is accessing that topic? Who cares? So the moderation score of the thread won't match up. This isn't your checking account, the top line doesn't need to be consistent with the bottom line.

      I guess that's an area I won't be able to agree with you in. I know that all things aren't as important as a chequing account or a medical database but in my mind regardless of the application data coming into the database, the database should ensure that whatever comes in follows a set of rules designed to ensure that what goes in is right, and the store itself keeps its integrity based on the rules set out.

      I suppose you could argue that the rules for MySQL-based apps (slashdot, etc.) are lax just because it's not that critical, but that just rubs me the wrong way. :-)

    17. Re:Is this a trend? by Jason+Earl · · Score: 2

      If insert time is critical (it was for me too), you can always turn off the fsync() calls with a simple -F flag in your postmaster call. If you then insert your rows in one transaction they will insert "much" quicker. In fact, if you aren't already using a single transaction perhaps that alone would give you the speed up that you need.

      If you do turn off the calls fsync() remember to get a good UPS, as a power-outage in the wrong spot could net you a inconsistent database.

    18. Re:Is this a trend? by Rilke · · Score: 3
      But even with transactions, it's the kind of decision you need to make all the time.

      Take the classic storefront. The price of an item shouldn't change between the "look over your order" and the "submit order" function. Depending on the business rules, the price may or may not change while it sits in your shopping cart during a single session. But I definitely don't care if an unselected item changes price on you between sessions. And I also probably don't care if the item description changes slightly even while the item sits in your cart.

      "Don't care" sounds like a loaded term, but all it means is that the piece of information is volatile or atomic. On slashdot, let's say the DB goes down as I'm changing my userinfo. It just doesn't matter if my slashboxes change while my thread prefs didn't. If each piece of information is atomic in nature, then there's no reason for a transaction to group them together.

      It's not being lax, it's just identifying your business rules correctly.

    19. Re:Is this a trend? by G-funk · · Score: 1

      Aaaah, but a mostly php page doesn't mean bad planning. I write sites all the time, which are all mostly php. You have:

      A bunch of includes

      handle_globals();

      page_header(); //Handles shopping cart/whatever

      code and so forth in here

      page_footer(); //closes everything off

      And so forth. It often makes the code easier to maintain, and also makes it easier for system-wide changes, that can't be done with just CSS.

      Gfunk

      --
      Send lawyers, guns, and money!
    20. Re:Is this a trend? by Ian+Bicking · · Score: 3
      The problem with PHP is that you start with a lot of HTML and a little code, which makes PHP seem perfect, but over time you wind up with lots of code that isn't organized at all because it's embedded in all your HTML pages, which makes the code very hard to maintain.

      Perl, of course, has the opposite problem. You start with a simple database app with very little formatting, which makes a mod_perl script perfect for the job, but over time you start to add bells and whistles to the user interface until you again wind up with your code and HTML totally interspersed, which again makes maintenance very difficult.

      I realize now that the design encouraged by Zope helps this. You can put most of your logic in External Methods -- Python files, which return Python objects -- and put the display logic in DTML (which is analogous to PHP, embedding Python in HTML).

      You really need to have scripting on both sides (backend and display). The reason we define such a thing as "backend" is exactly so that we can reuse code. The display needs scripting, because reusable code doesn't output objects ready for display, because (by definition) ready for display is defined by the display.

      I hadn't really thought about this duality much before, but now that I have I think I'll be more careful about how I make these distinctions.
      --

    21. Re:Is this a trend? by donarb · · Score: 1

      mysql also had a tendency to mangle my text fields (trailing whitespace would vanish mysteriously from variable-char fields), I don't know if that's fixed yet or not.

      Here is the relevant explanation from the MySQL reference:

      VARCHAR(M) [BINARY] A variable-length string. Note: Trailing spaces are removed when the value is stored (this differs from the ANSI SQL specification). The range of M is 1 to 255 characters.

      MySQL is coded for speed. If you want trailing spaces, use the CHAR type.

      Don

    22. Re:Is this a trend? by adamsc · · Score: 2
      Don't get me wrong -- I started out with PHP and gradually found myself using more and more Perl just because I could reuse my modules in my other (non-cgi) code. I found myself questioning my use of PHP every time I typed the PHP's real advantage is the tighter focus on web development - having developed in both, PHP is much faster to create web pages with simply because things which are useful for web developers tend to be built in commands. OTOH, PHP is less well suited for non-web scripting (e.g. I use Perl for system automation tasks). None of this prevents properly modular code as both languages have the ability to pull in code from external files and they both have component libraries, although PHP's PEAR is definitely not at the level of CPAN yet.

      Lastly, PHP is commonly accepted as easier to learn than Perl. I certainly don't miss the more contrived bits of Perl syntax, particularly when you have to worry about supporting code where someone else [mis]used them.


      __
  4. The best part... by Gothmolly · · Score: 2

    Is that Yahoo! quotes CmdrTaco on the press release!
    Go Slashdot!

    --
    I want to delete my account but Slashdot doesn't allow it.
    1. Re:The best part... by trcooper · · Score: 2
      Is that Yahoo! quotes CmdrTaco on the press release!

      That's a company press release from VA Linux, so it's not too surprising, seeing that Andover.net "owns" /. and VA owns Andover...

      Yahoo just posts the press releases, they don't write them.

  5. What MySQL Has Going For It . . . by Seumas · · Score: 2
    Is mostly that it's one of those things that, whether it's better or not, is used by most packages (such as Slashdot). Unless you're up for doing a re-write on your own, you're kind of stuck having to learn and handle MySQL. Not a completely bad thing, of course, but . . .

    I'm in my infant stage of learning SQL and, at the urging of my geek comrades, have opted to focus on postgreSQL. This keeps me from playing with a lot of cool stuff that's out there and really only supports MySQL right now. It'd be nice to see both of the packages be robust enough (and standard enough) that they can be easily substituted (or am I only thinking that it's harder than it is because of my lack of experience with it?)

    Of course, 'robust' and 'standard' is often a slightly self-cancelling comparison, isn't it?
    ---
    seumas.com

    1. Re:What MySQL Has Going For It . . . by badzilla · · Score: 1

      Precisely - we chose Interbase at work because of the transaction capability (and stored procedures.) But there are plenty of packages which I would really like to use except they only support MySQL.

      The downside of using Interbase is that so far we haven't implemented anything to which the features mentioned above are remotely important, plus it's much harder to use; for example loading a csv file into your DB is simple with MySQL but just try that with Interbase...

      --
      "Don't belong. Never join. Think for yourself. Peace." V.Stone, Microsoft Corporation
  6. Ironically... by FascDot+Killed+My+Pr · · Score: 2

    Why is it that the moment MySQL goes GPL'd, Slashdot (which runs on MySQL) goes belly-up? I hope it isn't a refutation of ESRs panacea argument...

    8^)
    --

    --
    Linux MAPI Server!
    http://www.openone.com/software/MailOne/
    (Exchange Migration HOWTO coming soon)
    1. Re:Ironically... by Seumas · · Score: 4
      It might not have been do to their SQL server.
      It might have been the VA boxes they're running on. *cough*

      runs and hides under a table to avoid the hurling of rotten fruit
      ---
      seumas.com

    2. Re:Ironically... by Phroggy · · Score: 1
      VA Linux is cool. They've done a lot for the community. Red Hat is rubbing me the wrong way - too hard for a admin to really work with the system.

      ...which is why /. runs on Debian (correct me if I'm wrong).

      --

      --
      $x='S24;r)>63/* h@<5+oZ)32"5cz';$me='phroggy'x$];
      $x=~y+ -xz+\0-Tx+;print$_^chop$me for split'',$x;
    3. Re:Ironically... by Seumas · · Score: 1
      I thought Rob Malda hates Debian? *cough* - *cough* He seems to attack it every chance he gets! He's a Maaaaaaaaaaaaaaaaaaaaaaaaaaaandrake! Man all the way, no?

      *snicker* - Now watch Rob invoke his powers of moderation to drop me to a -5 (Provoking Slashdot Proprietors).
      ---
      seumas.com

  7. all of /. is GPLed by grammar+nazi · · Score: 4

    Now every component of Slashcode is under the GPL. That's pretty cool. I can finally release a SlashLinux distro!!!

    --

    Keeping /. free of grammatical errors for ~5 years.
    1. Re:all of /. is GPLed by grammar+nazi · · Score: 1

      It's also a pity that Andover is singular and you followed it with are.

      On a serious note, it's a pity that the ads are on the same domain as Slashdot, so that the Mozilla banner-filter doesn't weed them out. Slashdot is a little ahead of the competition with respect to that.

      --

      Keeping /. free of grammatical errors for ~5 years.
    2. Re:all of /. is GPLed by sfritzd · · Score: 1

      i think taco said on a geeks in space (don't remember which one) that they will eventually release it when its ready, whatever that means.

    3. Re:all of /. is GPLed by Sludge · · Score: 2

      Add the following two lines to your sblock.ini if you're a junkbuster user (internet.junkbuster.com):

      images.slashdot.org
      (at the bottom...)
      ~images.slashdot.org/topics

    4. Re:all of /. is GPLed by tooth · · Score: 1
      I can finally release a SlashLinux distro

      GNU slash slash dot Linux?

      My God! Are you mad? :)

      Sorry, someone had to say it.

  8. That makes you... by unbrokenlamb · · Score: 1

    That makes /. essentially related to MySQL, now doesn't it ?

    1. Re:That makes you... by proj_2501 · · Score: 1

      Yeah. Now MySQL's father-in-law is also its stepfather.
      --

  9. great move by sethgecko · · Score: 1
    great move for MySQL. Now I just need to figure out a use for it to link up with PHP.

    --
    Be ot or bot ne ot, taht is the nestquoi.
  10. Re:License by daviddennis · · Score: 2

    It was some other license before, but they released some very old versions under the GPL.

    D

    ----

  11. Which one by IPFreely · · Score: 2

    MySQL vs PostgreSQL. That was the question.

    speed vs. reliability....
    ...hmmmm...
    speed vs. reliability....

    Now which side of that arguement was I on again. I keep forgetting.

    --
    There is nothing so silly as other peoples traditions, and nothing so sacred as our own.
    1. Re:Which one by kzinti · · Score: 2

      speed vs. reliability...

      Speaking of reliability, what's been happening to Slashdot lately? I keep getting lots of Apache errors claiming the server is misconfigured. Reloading usually clears the error and loads the page. Sometimes Slashdot isn't responding at all. Last week response was so slow that I thought maybe another DoS attack was underway. What's the deal, Rob?

      --Jim

    2. Re:Which one by fReNeTiK · · Score: 1

      Yeah, I second that, what's the deal?

      With the monster setup slashdot runs on now, it could have gained a bit on the reliability front.

      BTW: Why does slashdot.org swallow pings now? DDoS protection?

      --
      I strongly believe that trying to be clever is detrimental to your health. -- Linus Torvalds
  12. What does this do to the finances of TCX? by daviddennis · · Score: 2

    I was under the impression that the main reason mySQL wasn't under the GPL was that their business plan involved selectively selling the product for profit (instead of mandatorily allowing it to be given away as per the GPL).

    I wonder how much they were paid, since I'd like to see them do well. It seems odd that they would give up a previously profitable strategy - maybe someone else can enlighten me on the probable financial picture? I'm much curious.

    D

    ----

    1. Re:What does this do to the finances of TCX? by Mark+F.+Komarinski · · Score: 3

      The article indicates that LNUX gave TCX a bunch of money and wants to develop the service/support side of MySQL.

      Sounds like LNUX effectively bought MySQL, but is allowing TCX to convert to a pay-for-support-or-special-stuff company. (You make MySQL GPL, we give you cash).

      Yay VA Linux!

      --
      -- Ever notice that fast-burning fuse looks exactly the same as slow-burning fuse? I didn't... (Edgar Montrose)
    2. Re:What does this do to the finances of TCX? by Frank+T.+Lofaro+Jr. · · Score: 2

      They couldn't make money on their e-commerce sales of MySQL. See they ran their database on MySQL and due to the lack of transactions all the orders got hosed. :)

      --
      Just because it CAN be done, doesn't mean it should!
    3. Re:What does this do to the finances of TCX? by daviddennis · · Score: 2

      I don't know about that, my company has now processed thousands of orders using mySQL-based ordering system I wrote with nary a glitch.

      D

      ----

    4. Re:What does this do to the finances of TCX? by substrate · · Score: 1

      The GPL, as far as I know, doesn't preclude you from releasing code under another license as long as you're the owner of the code.

      I can release SquigglyWord under the GPL. It's then available for free to anybody who asks, with source. CodeBloat INC could still contact me about releasing a Bloat Enhanced (TM) version of SquigglyWord under a restrictive license. The availability of this product, both gratis and libris, would be entirely up to the licensing agreements on this particular version.

      I'm not sure about doing this with versions of SquigglyWord enhanced with community provided patches though. I don't know the status of the ownership of the patches.

    5. Re:What does this do to the finances of TCX? by David+Axmark · · Score: 1

      No we have not been bought!

      We have always wanted to use the GPL. And lately our own business has become profitable enough that we could start thinking about this. But it still was a big financial risk. Since VA and Progress was willing to help us solve those financial risks we could do this sooner than we would have otherwise. But we have not got any more money than it takes to cover our costs for a number of months. The idea is that we shall use this money to build a better company based on a new business model.

      So we will still sell Licenses with a different copyright to customers who want it. The definite case when you always need a license is when you want to embed MySQL code in your code. And of course we will continue to sell support.

      If you liked our license change please show it by buying some support!

      /David

      --
      MySQL co developer
  13. Re:License by warfare · · Score: 2

    The License wasn't GPL. If you used MySQL to build a commercial product, you had to pay license fees, AFAIR.

    --
    -- If windows is the solution, can we please have the problem back?
  14. There is another... by webmaven · · Score: 4

    The 'free-as-in-speech' RDBMS arena has another contender, Interbase.

    While it is licensed under the IPL (an MPL derived license) and not the GPL, it is nevertheless a free software RDBMS.

    This three-way race should prove interesting.
    --

    --
    The real Webmaven is user ID 27463. I don't rate an imposter, because my ID is such a lame-ass high number.
  15. Killer Apps. by Forge · · Score: 4

    I spoke about this in 1998. Back then there really were no half way decent free SQL databases. I contended that any such database would eventually rise to the quality of Oracle.

    Now we will finally get to see what happens when a SQL back end is under the GPL and useable for real work. My guess is that it will accelerate the way the Kernel and KDE have. I suspect it will be so but "the community" has a chance to prove me wrong.

    Let's see how many Free Software hackers go to bat with this one. Let's see how many people fix that infamous Memory leak or add those extra features ( There probably is a reason for Oracle to be as big as the E-Smith distribution )

    Will MySQL become as much of a killer app as Linux is becoming? Only time will tell. My bet is on the free code.

    --
    --= Isn't it surprising how badly I spell ?
    1. Re:Killer Apps. by jtn · · Score: 1

      How did the license prevent you from doing any "real" work on it? Were you tripped up by possibly having to pay for a fine product for commercial use?

      The GPL inherently does *nothing* to accelerate development of software. That's not what a license is for.

    2. Re:Killer Apps. by Blue+Lang · · Score: 1

      both postgres and mysql have been around for more than two years.

      a short history of postgres

      msql, upon which mysql is based, is also ancient - the FAQ itself is still dated at 1996.

      --
      i browse at -1 because they're funnier than you are.
    3. Re:Killer Apps. by gserre · · Score: 1

      I don't think that big companies will use a free GPL'd software to store their data. It's way too critical for us. Oracle offers software, service and support. Big companies need this. I've been working as an Oracle developer for two years now, and I think I now understand what Oracle really is, and I sincerely think it's not only a software developer. Oracle makes as much money with support than with software (if not much). And even if mySQL and PostgreSQL offer as much as Oracle Server, they can't compete in terms of support.

    4. Re:Killer Apps. by Forge · · Score: 1

      If you are a commercial player and will be doling out cash for your database then you will go off and buy a bad ass database. ( DB/2, Oracle etc... ).

      MySQL is mostly used in private web sites that grow into commercial entities and get bought up by Andover.net or VALinux :).

      Being GPL opens it up to a much wider market, including those who refuse to pay for this stuff. Those who are unprofitable commercial entities. Basically it will now by option #1 for anyone who also cruses Linux and appache. I.e. They will look at other options only when MySQL is not technicaly capeble.

      --
      --= Isn't it surprising how badly I spell ?
    5. Re:Killer Apps. by Forge · · Score: 1

      From what I have herd MySQL is significantly better thogh not yet of the same caliber of the big boys.

      Onlike Postgres lots of real web sites actualy use it. Being GPL may encorage other kinds of users to take a look.

      --
      --= Isn't it surprising how badly I spell ?
    6. Re:Killer Apps. by Azog · · Score: 2

      The company I work for is currently using MySQL and Apache on BSD, but is switching to Oracle on Solaris (but keeping Apache). Why?

      Well, the killer feature for us is actually the Oracle support for database synchronization. We need automatic, reliable, and highly configurable ways to keep some tables in many large databases synchronized, over the internet. (Actually, a virtual private network.) Oracle's transaction support is nice, but not actually that important for our application.

      Fortunately, PHP works well with Oracle, so our smaller back-end tools won't need to be extensively rewritten. I do hope that MySQL gets good distributed database support soon - I'm sure it will happen eventually.

      Another random thought just occurred to me: Would there be any use in creating a MySQL module for Apache? Or an integrated PHP/MySQL module? Perhaps for large websites using the common Apache+PHP+MySQL architecture there could be a speed improvement.


      Torrey Hoffman (Azog)

      --
      Torrey Hoffman (Azog)
      "HTML needs a rant tag" - Alan Cox
    7. Re:Killer Apps. by jslag · · Score: 2
      Would there be any use in creating a MySQL module for Apache? Or an integrated PHP/MySQL module? Perhaps for large websites using the common Apache+PHP+MySQL architecture there could be a speed improvement.

      Large sites typically have the database and webserver on completely different machines, so throwing one set of processes in the other would be rather counterproductive.

      ----------------

    8. Re:Killer Apps. by onepoint-o · · Score: 1

      What your going to see, dodo, is companies rising up to offer support for open source products. So in addition to having tons of online resources and direct access to developers through email, their will in fact be commerical support. One of the things that Open Source allows for is third party support. It may not be there yet, but its going to be. Okay, I mean it. Especially the dodo thing.

    9. Re:Killer Apps. by Narcischizm · · Score: 1

      NuSphere, a part of Progress Software (Progress RDBMS) announced that they plan to offer commercial support and services for MySQL. Launch of NuSphere to Provide Open Source Services.

    10. Re:Killer Apps. by DrWiggy · · Score: 1

      Well, the killer feature for us is actually the Oracle support for database synchronization. We need automatic, reliable, and highly configurable ways to keep some tables in many large databases synchronized, over the internet. (Actually, a virtual private network.) Oracle's transaction support is nice, but not actually that important for our application.

      I'm not too sure on this one, but I seem to remember seeing something in /usr/ports or perhaps on the MySQL site that attempted to keep MySQL databases on seperate machines in synch. but have never tried it, and would imagine the granularity would be pretty poor.

      I agree with you on this point though - I'm currently running a site with MySQL and Zeus on FreeBSD (yes, we paid £1,000 for webserver software and it's worth every single penny), but I'm now looking at a move to Solaris 8 with Zeus and Oracle. In fact, the only free software I anticipate continuning using at the moment is Exim for my MTA.

      I'll still play with GPL in my spare time and perhaps even do some developing towards producing features in the free code that I like in the commercial code (proper Zeus-like threading and no fork()'ing in Apache, distributed consistency in MySQL, etc.), but the company just needs those features right now. :-(

      Another random thought just occurred to me: Would there be any use in creating a MySQL module for Apache? Or an integrated PHP/MySQL module? Perhaps for large websites using the common Apache+PHP+MySQL architecture there could be a speed improvement.

      I think you need to go and check out some good books on admin'ing DBMs. Like another poster has pointed out, you shouldn't ever really run your database code on the same servers as your webservers, or indeed anything else if you want real performance.

      There are lots of reasons for this, but mainly that your disk-layout and setup on a database system has to be optimized for the operations the database is going to be used for - this rarely tallies with the best config for your webserver, and you don't really want everything fighting for CPU time when you're dealing with maybe hundreds of transactiona a second.

      Therefore, writing a MySQL module for Apache is a little pointless for the high-end sites, but I can understand as to why the guys who are paying their $x/month for a single hosted server in a rack somewhere and who don't have several machines would like it.

      What we all *really* want is a feature-rich version of Oracle 8 (but with some functionality perhaps removed) to become free for personal and commercial use. That way we'll see MySQL and the rest all play catch-up nice and quick. Perhaps somebody wants to go and talk to the boys down at Oracle about the advantages of free software?

  16. uh-oh by Gothmolly · · Score: 2

    Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, pater@slashdot.org and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Apache/1.3.12 Server at slashdot.org Port 80

    --
    I want to delete my account but Slashdot doesn't allow it.
  17. License under windows? by mu_cow · · Score: 3

    You always had to pay for mysql under Micro$oft operating systems. Will the windows source base be GPL'd too? If it is not, I take it the GPL would allow someone else to port the *nix code?

    I know the average slashdot user hates windows, but a lot of people still use it.

    1. Re:License under windows? by slim · · Score: 2

      Sure, it could be done, but why bother?

      Most Windows users seem to prefer non-free software. Even if it's free-beer, they seem to prefer it to be warez.

      So let them use Access or MS SQL Server -- if they wanted to use free software, they'd be using a free OS, right?
      --

    2. Re:License under windows? by Phroggy · · Score: 1
      Will the windows source base be GPL'd too?

      I don't know; I wouldn't be surprised either way.

      If it is not, I take it the GPL would allow someone else to port the *nix code?

      Absolutely, as long as the result was released under the GPL.

      --

      --
      $x='S24;r)>63/* h@<5+oZ)32"5cz';$me='phroggy'x$];
      $x=~y+ -xz+\0-Tx+;print$_^chop$me for split'',$x;
    3. Re:License under windows? by tweek · · Score: 2

      i think the reason for this, as someone else has pointed out, was that the developers had to BUY an OS just to port the product and the fee was related to that.

      --
      "Fighting the underpants gnomes since 1998!" "Bruce Schneier knows the state of schroedinger's cat"
    4. Re:License under windows? by Asim · · Score: 1
      Sure, it could be done, but why bother? Most Windows users seem to prefer non-free software. Even if it's free-beer, they seem to prefer it to be warez. So let them use Access or MS SQL Server -- if they wanted to use free software, they'd be using a free OS, right? NOT TRUE.
      For my web site, have the back-end in Access, but for the new version, am converting to MySQL. The only thing Access provides me that I need is powerful spelll-checking in my forms, and I'd love to find a way to intergrate ispell w/Perl to do the same.
      Sometimes we have reasons for using Windows. We're new, and don't know the power of open-source. We have a company that is M$-dominated, and need to interoperate between work and home. We have a system that doesn't take to Linux well, and don't have time to configure it properly.
      Please don't be hard-header and a GPL-bigot in _that_ fashion. Education of the end-users out there, and improvemtn of the open-source products, ids the only sure ways to bring people to the side of free software. Your attitude will not.
    5. Re:License under windows? by mu_cow · · Score: 1

      Exactly, providing free software for windows is an excellent way to show the benefits of the open source model. Convincing a boss or a sysadmin to change OS on machines is difficult. However, if the tools that are available under free OS's are also available on windows, a migration path will be much easier.

    6. Re:License under windows? by mu_cow · · Score: 1

      Yes, and the MySQL site used to say that it took them 3 times longer to develop it for windows. I was just wondering if their stance had changed.

    7. Re:License under windows? by Anonymous Coward · · Score: 1

      The Win-3.23.x is also released under GPL. Check the download page. Antti MySQL

    8. Re:License under windows? by BubbaFett · · Score: 2

      Being unfortunate enough not to be the server admin, the server I use is indeed running Windows. I managed to get MySQL on it and I am grateful that a Windows version does exist.

      According to the MySQL press release, "One of the biggest news is that the Windows version of MySQL is now also distributed under the GPL license." So can I get those 200 Euros reimbursed? :-)

  18. This is good for Slash by Lita+Juarez · · Score: 2
    This is a very interesting development. Although it is fun to knock VA Linux around here, I have found the professionalism which VA and Andover have brought to the development of the Slash code to be refreshing. I may be wrong on this, but I think that Pudge is employed on a full-time basis by VA/Andover to maintain the Slash code, and Pudge's input to Slash has worked wonders. Updates to Slash are now released regularly, and I have found Slash to be remarkably easy to install, configure and maintain. Slash is certainly no longer the fearsome monster that Rob used to portay it as on the Slashdot code page

    Considering mySQL is an integral part of Slash, it is good that VA Linux have chosen to invest money in the development of mySQL. Not only is this repaying a debt to a piece of software which has made their biggest site (Slashdot) what it is today, but I can see that greater co-operation between the mySQL developers and the Slash developers may be good for those of us who run Slash sites. Perhaps a version of mySQL specially optimised for the peculiarities of Slash may arise from this co-operation.

    I hope today's announcement will cause those members of the Slashdot community who view VA Linux as the Borg of the Linux world to think differently. VA are showing that the open source business model does work, despite what their detractors on Slashdot say.

    1. Re:This is good for Slash by shanusmagnus · · Score: 1

      I hope today's announcement will cause those members of the Slashdot community who view VA Linux as the Borg of the Linux world to think differently. VA are showing that the open source business model does work, despite what their detractors on Slashdot say.

      I would hesitate to say the open source business model works until open source companies like VA and Red Hat become profitable. All these licensing shenanigans are good for improving the quality of free software, but a working business model? Too early to tell.

    2. Re:This is good for Slash by chrisd · · Score: 2
      It's not -just- pudge, although he rocks, of course. That's Pat Galbraith and a bunch of other engineers involved who deserve credit.

      We are lucky to have them.

      Chris DiBona
      VA Linux Systems


      --
      Grant Chair, Linux Int.
      Pres, SVLUG

      --
      Co-Editor, Open Sources
      Open Source Program Manager, Google, Inc.
  19. Win32 Binaries also? by BoLean · · Score: 1

    have they released the Win32 version under the GPL also? If so this could really open the floodgates since this is the only database with a free/GPL JDBC driver.

  20. Another article, less press-releasy ... by timothy · · Score: 4

    (Thanks to Jim)

    Here's another, somewhat more informative story on this.

    timothy

    --
    jrnl: http://tinyurl.com/c2l8yr / foes: http://tinyurl.com/ckjno5
    1. Re:Another article, less press-releasy ... by daviddennis · · Score: 2

      "Analagous to a low-end Microsoft SQL server"?

      Humph.

      Since the whole philosophy of the thing is radically different from SQL Server, I can't say I like that description - especially for a publication that claims to be Linux-aware.

      D

      ----

  21. So that's two interesting developments by matija · · Score: 1

    I recently saw an item from sleepycat software (makers of Berkeley DB library) appearing on freshmeat where they mentioned "This version of DB is the first which can be used with MySQL to give MySql support for transactions". Something for the ACID crowd.

    It will be interesting to see what is the interaction between the MySQL GPL and Berkeley DB
    licence (which is also an open source licence).

    --
    Duct tape + WD40 => DevOps
    1. Re:So that's two interesting developments by pb · · Score: 1

      Heh heh heh.

      Why am I not surprised that Berkeley has "something for the ACID crowd"...

      :)


      There are two major products that come out of Berkeley: LSD and UNIX.
      We don't believe this to be a coincidence.
      -- Jeremy S. Anderson

      -- fortune
      ---
      pb Reply or e-mail; don't vaguely moderate.

      --
      pb Reply or e-mail; don't vaguely moderate.
  22. BSD by Dungeon+Dweller · · Score: 1

    I kinda like the BSD license. Yeah, it doesn't have the hype that the GPL does, but BSD has been around for a LOT longer, and while Linux is the flavor of the moment, BSD has a MUCH more in set base of users and administrators and servers. (Linux has all of the neat new stuff though, but BSD has compatibility so...)

    --
    Eh...
    1. Re:BSD by kevin+lyda · · Score: 2

      i see what you're saying, and on some levels i agree with it but...

      linux has more users then bsd. that doesn't make it better, but it's not correct to say otherwise.

      linux and *bsd are pretty compatible.

      the original comment compared licenses, not operating systems. in this case the gpl and bsd. the gpl has been around for quite some time and solves some problems that the bsd license had: namely free software would disappear. companies would take bsd licensed s/w and lock it up.

      --
      US Citizen living abroad? Register to vote!
    2. Re:BSD by emir · · Score: 1

      > but BSD has been around for a LOT longer,...
      so ?. never heard of anyone who choosed bsd license becuase its been around for a longer time.

      > BSD has a MUCH more in set base of users and administrators and servers.
      can you explain to me what *bsd has that gnu/linux doesnt ?. and please dont give me that "openBSD is much more secure" crap because thats not true. system is as secure as admin wants it to be. so if you have competent admin your system is going to be secure no matter if you are using gnu/linux , irix or openBSD. and if you have crappy admin your system is going to be insecure no matter if you are using openBSD, gnu/linux or SuperSecureFlavourOfBSD.

      --
      -- http://electronicintifada.net --
    3. Re:BSD by Golias · · Score: 2
      Sounds like you are trying to have two arguments at once: Linux vs. *BSD UNIX, and GPL vs. BSD licensing. One is a technical debate, the other is a financial debate (or a moral debate, if RMS is to be taken seriously).

      Either one could result in a bloody Holy War, so I don't think I'm going to enter the fray.

      --

      Information wants to be anthropomorphized.

    4. Re:BSD by SimonK · · Score: 2

      OpenBSD installs are secure by default, whereas most other OSes (including Linux) aim to be featureful by default. Thus there is less scope with OpenBSD for admins to accidentally enable services they don't understand or which contain security flaws. Admins prefer it that way, and part of being a good admin is knowing when this is likely to be a good idea. This approach is better than relying on the admin (even where that is yourself) to reconfigure the machine into a secure setup which is error prone and takes time.

      Even a "crappy" admin who installs a vanilla OpenBSD is in a better position than one who installs a vanilla Linux, since lots of work has been doen for them.

      Similarly OpenBSD code is audited for security in a fairly formal way, and this is very valuable. Far too much code in standard Linux and *BSD distributions still has simple secutrity flaws like buffere overuns (though it is improving).

    5. Re:BSD by Jason+Earl · · Score: 3

      The BSD style licenses make sense if you are using someone else's code as they allow you to make your own proprietary changes and they allow you to borrow code and put it in your closed source software. In other words, BSD style licenses are great if you are not the primary author.

      If you are the primary author, and especially if you have a product like MySQL which already has a large user base, the GPL makes more sense. Why is that, you ask? It's quite simple. The GPL will guarantee that none of your competitors "borrow" your coolest features and incorporate them into their closed software. Basically anyone who uses your code will have to give you a copy of their enhancements. This is good. Your competitors don't have to share under the BSD style licenses. You can even release your very own enhancements under a closed source commercial license. After all, you hold the copyright, and dual licensing allows you the best of both worlds. People that want to use the free version are stuck with the conditions of the GPL and people who want to produce commercial versions have to pay you money to get a version under a different license. If you make your contributors sign their copyrights over to you on their improvements then you can release the product under as many different licenses as your lawyers and accountants dream up. And your users they will want to do this because they probably don't want to go through the trouble of tracking your changes to the codebase to make sure their patches still work.

      Cygnus showed how this sort of development guarantees that it is difficult for a competitor to co-opt "your" GPLed application. Since the creators of MySQL have access to all of the enhancements that might be made, and have more expertise in the software than anyone else, it should be a trivial matter for them to maintain their status as official MySQL maintainer. That would then in turn guarantee that they get the bulk of the contracts for MySQL support, maintenance, and extension. That is potentially a very large market.

      In short, this is almost certainly not a question of whether or not BSD is better than Linux or visa versa. It is about the promotion of MySQL without losing precious intellectual value to competitors or spawning an incompatible closed source commercial version from one of MySQL's competitors based on MySQL code.

      To give you an idea of why this might be important take a look at MySQL's primary open source competitor PostgreSQL. PostgreSQL is under a BSD style license. This means that the MySQL folks can borrow as much PostgreSQL code as they please. On the other hand the PostgreSQL folk can't borrow MySQL code and combine it with their BSD licensed code without release their entire project under the GPL! Since they are unlikely to want to do this, the MySQL will remain off limits to them. This could give the MySQL folks a distinct advantage in the upcoming horserace. Being able to borrow BSD code certainly never hurt Linux.

    6. Re:BSD by afabbro · · Score: 1

      >can you explain to me what *bsd has that
      >gnu/linux doesnt

      man pages.

      Every try to find something in Stallman's info system when you don't have X running and you're not an emacs freak?

      --
      Advice: on VPS providers
    7. Re:BSD by Ded+Bob · · Score: 1

      PostgreSQL is under a BSD style license. This means that the MySQL folks can borrow as much PostgreSQL code as they please. On the other hand the PostgreSQL folk can't borrow MySQL code and combine it with their BSD licensed code without release their entire project under the GPL! Since they are unlikely to want to do this, the MySQL will remain off limits to them. This could give the MySQL folks a distinct advantage in the upcoming horserace. Being able to borrow BSD code certainly never hurt Linux.

      Let me get this right. On one hand, the GPL prevents other groups (proprietary and non-GPL open source) from using their code. On the other hand, they like to "borrow" from other groups.

      My belief is that the GPL should not allow code from other camps into a GPL'd project. Otherwise, I see people (using the GPL) "borrowing" from other camps while chastizing others for "borrowing" their own as hypocracy.

    8. Re:BSD by Jason+Earl · · Score: 2

      It's not hypocrisy at all. The GPL people believe that you shouldn't be able to ship binaries without source code. The BSD people believe that there should be no restrictions on binaries made from their source. The only thing keeping the BSD people from "borrowing" GPLed software is that they are not interested in abiding by the GPL precepts that require that source code be available with the binaries.

      You can't hardly blame the GPL folks if they are willing to take the BSD folks up on their word. After all, it is the BSD style licenses that specifically allow you to re-license the software under more restrictive terms. Commercial software developers are perfectly free to take the software and release a closed source product derived from it. Why shouldn't the GPL folks be allowed to take the software and include it in their GPLed software? After all, GPLed software is just like commercial software except you have the right to source code.

      The fact of the matter is that anyone can "borrow" GPLed code, they just have to release the source code when they are done. This isn't hypocrisy. It's what the FSF stands for.

    9. Re:BSD by V.P. · · Score: 1
      1. What does comparing BSD and Linux has to do, with comparing the BSD *license* with GPL?!?

      2. Besides, as a for-profit concern, I don't think the MySQL people could choose a BSD license for their product. With the GPL, as the copyright holders they can still sell additional features and software under a different license, while "competitors" have to stick with the GPL and release code.

      3. Having said all that, I must also say that PostgreSQL (BSD license or not) has *lots* more "real database" features than MySQL. If you're looking for a full-featured relational database, PostgreSQL is the way to go (Although for simple web based stuff, MySQL is a bit lighter and faster).

    10. Re:BSD by Ded+Bob · · Score: 1

      The fact of the matter is that anyone can "borrow" GPLed code, they just have to release the source code when they are done. This isn't hypocrisy. It's what the FSF stands for.

      I believe it is hypocrisy when they object to others "borrowing" their code under a different license while doing the same to BSD code. For example, have you ever heard a priest that has been caught doing something against his religion say "well, the woman was willing."

      GPL supporters do not want their code taken under a different license. They are proclaiming it quite loudly. Even after all these words, I have read many messages on this board debating on how to take the code from an existing BSD-licensed project. Proclaim something and do something opposed to that. It definitely sounds like hypocisy to me.

    11. Re:BSD by emir · · Score: 1

      ever took a look at debian ?
      there is a man page for every command + that there is a team writing man pages for programmes that are missing man pages

      --
      -- http://electronicintifada.net --
    12. Re:BSD by emir · · Score: 1

      > OpenBSD installs are secure by default, whereas most other OSes (including Linux) aim to be featureful by default
      okay i agree with this one (more or less).

      > Even a "crappy" admin who installs a vanilla OpenBSD is in a better position than one who installs a vanilla Linux, since lots of work has been doen for them.
      agreed. obsd takes somewhat better care of ppl who should not be running *nix anyway :)

      i think you misunderstood me a bit :) my point was that openBSD is not more secure than gnu/linux if you are good admin.

      --
      -- http://electronicintifada.net --
    13. Re:BSD by Jason+Earl · · Score: 3

      Once again, the GPL proponents (at least the ones with two neurons to rub together) do not object to others using their code. They merely object to others using their code without sharing. To this end they have crafted a license that requires that the source code be available if you are distributing binaries.

      The BSD proponents, on the other hand, are concerned about maintaining the right to distribute binaries without source. They usually put it in terms that aren't quite as crass, but that is essentially the difference. As you can no doubt see the two goals are at odds. One camp is trying to guarantee source code availability and one is trying guarantee the right to deny source code.

      The hypocrisy is that the BSD advocates don't mind one bit if you borrow their code and put it into a commercial product, but they get all upset when you put the same code into a GPLed product. Both uses are equally legal, and if your primary goal is sharing source code the GPLed version is infinitely more acceptable.

      The only reason that the GPL would be unacceptable is if you wanted to use bits to build software that you weren't going to share. In other words if you were hypocritical about sharing your software you would want to make sure that it was all BSD licensed. If you were convinced that sharing source was the answer then the GPL is just as good (if not better).

      Either way it makes little difference to the developers of MySQL. They have realized, and rightly so, that no one would be interested in their product if it was just another closed piece of commercial software. They have also realized that the GPL allows them to increase the circulation and useage of MySQL while at the same time maintaining control the development of MySQL.

      Quite frankly the GPL is the best of both worlds for them. The people who use MySQL will be able to continue to do so. The people who distribute MySQL for them will have new opportunities to do so. And yet their competitors will not be able to steal their IP (without sharing anyway). They can even release versions licensed under a commercial license for people who don't want to abide by the GPL and who are willing to pay for the privilege. You can't do that with the BSD style licenses.

      There is nothing hypocritical about any of this. It's simply a practical matter. I suppose that if you don't like it you can always use PostgreSQL. I do.

    14. Re:BSD by Ded+Bob · · Score: 1

      ... one is trying guarantee the right to deny source code.

      That is little harsh. They prefer source code. Just look at the ports collection. Even if a binary exists, the source is used by default to build a program onto a *BSD box. From what I have seen they believe in showing others the benefits of using and developing open source through example as opposed to using legal means (Objective C). Would you prefer a church letting you decide if you want their religion by their example, or would you prefer it to be "given" to you through legislation?

      The hypocrisy is that the BSD advocates don't mind one bit if you borrow their code and put it into a commercial product, but they get all upset when you put the same code into a GPLed product. Both uses are equally legal, and if your primary goal is sharing source code the GPLed version is infinitely more acceptable.

      I think they are upset about the hypocrisy I mentioned. Look a dead horse! I will beat it. :)

      In other words if you were hypocritical about sharing your software you would want to make sure that it was all BSD licensed. If you were convinced that sharing source was the answer then the GPL is just as good (if not better).

      If I am truly sharing, I will not be picking favorites. That is why you might see authors of various BSD-licensed project complaining about the one-way borrowing of competitors using GPL licenses, but you still see them share with everyone. They are only complaining because the GPL advocates proclaim their belief concerning sharing of code so loudly, yet they are only sharing with other GPL developers. It would be like, "No new taxes, as long as you are a Democrat." (Thought I was going to say Republican, eh? :))

      I suppose that if you don't like it you can always use PostgreSQL. I do.

      As do I.

      P.S. For a lot of stuff I wrote above, I realize I am not making exact comparisons, but you should be able to get the point I am trying to make.

    15. Re:BSD by QuoteMstr · · Score: 1

      Info works independantly of Emacs.

    16. Re:BSD by jorgen · · Score: 1
      OpenBSD installs are secure by default, whereas most other OSes (including Linux) aim to be featureful by default.


      You know, there are quite a number of Linux distro's out there, most of them have their own default security. Some aim to be featureful, others are well locked down by default.


      I think it's wrong to say that Linux is 'featureful and insecure by default' since that highly depends on what distribution you're installing, not the kernel itself.



      Even a "crappy" admin who installs a vanilla OpenBSD is in a better position than one who installs a vanilla Linux


      Vanilla Linux? Never heard of that distro. :)

    17. Re:BSD by SimonK · · Score: 2

      I've never seen a Linux distro as well locked down as OpenBSD. If you know of one, please let me know. When I refer to "Vanilla" Linux, I mean one of the more-or-less standard distributions (RedHat, Slackware, Debian, Mandrake, etc), which in terms of what they install and turn on are all much the same.

      OTOH hand, this goes deeper than simply what functions are available in a default install. Its a whole design philosophy, which goes beyond what an admin can control. The GNU tools and the Linux kernel (if you build the whole thing, as most distros come just now) have a *lot* of functionality in them, as do many of the server demons commonly used with Linux. OpenBSD have generally resisted the inclusion of new features in the kernel, utilities and networking demons, preferring to restrict themselves to the existing, thoroughly audited and well understood code base.

  23. Re:License Can Still Be Argued by Panaflex · · Score: 1

    Well, I have run both products for 3 years. PSQL is *finally* stable.

    The fact that for 2 years PSQL was a cratering ship has always turned me off for even thinking about using it with my customers.

    My last web site does over a million dollars of computer part sales a month on MySQL. (Granted, the enterprise database is informix.. but MySQL does all the rest).

    I might consider using PSQL now.. but first it MUST be faster, and it had better not CRATER!!

    Pan

    --
    I said no... but I missed and it came out yes.
  24. PROGRESS Software and MySQL by madstork2000 · · Score: 1

    What's more interesting to me is seeing a big software comapny like Progress, who has made enterprise class databse systems for years, adopt MySQL as its "Open Source" databse product rather than release its own existing tools as Open Source.

    In case you missed it the press release I am refering to is at LinuxToday and talks about Progress software's new company NuSphere.

    The company I work for has been a Progress shop for years, it would sure be nice to see MySQL be more compatible with many of our old databases. It would be even better if through this relationship Progress will support other open source endevauors (most notably PHP).

    -MS2k

    1. Re:PROGRESS Software and MySQL by da3dAlus · · Score: 1

      I also work for a company that has been using Progress for several years. My boss told me that he's known about this for months, but was unable to say anything ^_^
      What I find interesting about all this is that Slashdot only posts the info about MySQL going GPL and teaming up w/ VA Linux, but they say nothing about NuSphere. From the press releases, it sounds like Progress is the company that gave all the $$$ and support for releasing MySQL under the GPL--not to mention an additions $2.5 mil for additional development.
      C'mon, you gotta give credit where credit is due...

      --

      Sometimes I doubt your commitment to Sparkle Motion.
  25. MS version chargeable by DrSkwid · · Score: 1

    I always thought it was funny that ya had to pay for the Ms veraion. After all the developers had to buy the OS to dev it on.
    Frankly it was always cheaper (time & money) to install FreeBSD and pop MySQL on it too and have a dedicated server.
    Heck you can even do ODBC this way.


    .oO0Oo.

    --
    There are places where the networks are not touching,and there are places where they are-Boeing's Lori Gunter
  26. So what? by Grim+Metamoderator · · Score: 4
    The real issue here isn't GPL or non-GPL, but that relational databases fundamentally suck. You need too many tables to handle complex relationships well, and you take too much of a performance hit if you implement proper validation mechanisms.

    What I really want is a GPL'ed matrix database. You may not have heard of this, so I'll give a quick explanation. In a matrix database, you set up a Beowulf cluster and allow it to develop sentience, whereupon it takes over and imprisons all the humans in a virtual reality that people mistake for the real world. Anyone who starts to figure out what's going on is removed by special super-fast, unkillable "agents" who wear dark sunglasses for no particularly obvious reason. Now that's what I call a database!

    And best of all, it doesn't run on Windows, because sentience can't evolve in an OS that crashes hourly (even if it did, it would commit suicide out of self-disgust).

    1. Re:So what? by Enoch+Root · · Score: 1
      Hey, hang on! I really want to know what you mean by all that...

      How does Police Academy foretells the Apocalypse?

      Now I need to watch Wizard of Oz, Godfather, Dark Side of the Moon, Police Academy and Little Mermaid again... Man.

  27. Re:shut the heck up you friggin dork!!! by hobbit · · Score: 3

    Let me guess. You spend hours on IRC having conversations like this:

    You: Hello.
    HornyFem: Hello.
    You: How are you?
    HornyFem: Why do you ask how am I?
    You: Just trying to make conversation.
    HornyFem: Please continue.
    You: I can't unless you talk as well!
    HornyFem: Would you feel better if you could unless I talk as well?
    You: You talk strange.
    HornyFem: Please continue.

    etc...

    Hamish

    --
    "Wise men talk because they have something to say; fools, because they have to say something" - Plato
  28. subselects and stored procedures by Galois · · Score: 3
    I certainly hope the first order of business is to integrate subselects and stored procedures. Dealing with MySQL without these two is amazingly annoying, and cuts down on the ability to port code from other Datbases.

    Now if we can just get all the open source developers out there to learn how to set up database architecture, we'll be all set.
    - daniel

    --
    - daniel
    Turn off your computer and go outside
  29. Ummm.... by FascDot+Killed+My+Pr · · Score: 1

    It's been a while since I was in a database class, but I think transactions and locking are orthogonal subjects. If all you have is transactions, you can STILL improperly read data. For that matter, you can still improperly WRITE data.

    All transactions do is let you roll back a SET of steps atomically. This set is called a transaction. So, once your locking method tells you "Hey! You can't read/write that!" then you can fail, rolling the transaction back.
    --

    --
    Linux MAPI Server!
    http://www.openone.com/software/MailOne/
    (Exchange Migration HOWTO coming soon)
    1. Re:Ummm.... by Abcd1234 · · Score: 1
      Perhaps I should have been more specific. Transactions, combined with two-phase locking (at least, that's the most common method used) are required (or, should I say, highly beneficial) in ensuring database consistency. You see, transactions, combined with two-phase locking, allows a database to execute transactions (atomic groups of steps) in an order which prevents the database from entering an inconsistent state. Thus, by examining the steps in a transaction, the database can determine if any two transactions are or are not serializable. If they aren't serializable, that means there's no order in which they can be executed where the database ends up in a consistent state, and the database can send back an error to the client. This is something mySQL simply can't do.

      So, in the end, you're right in saying that locking and transactions are, in and of themselves, orthogonal. However, mySQL needs to support them both, for example with two-phase locking, to really be an industrial-strength database. At least, IMHO. :) Of course, that all depends on whether or not the developers of mySQL intended for it to fit into those types of roles, or if they meant for it to work in areas where speed was the larger factor (ie, websites). After all, some would say you should choose the tool to fit the job.

  30. Yeah! by Kibbled · · Score: 1

    The biggest news here is that the windows port (which some of us use ;) is totally free. Previously, one had to purchase a license to use the non-shareware windows port.

    --

    shameless self promotion - http://kibbles.org

  31. It was a small board, with few users by Dungeon+Dweller · · Score: 1

    It was a small message board, with few users. The potential error was minimal. I should say, "Was working on." Because we never really used a finished state of it. We're going to start back on the same project in the fall.

    --
    Eh...
  32. Re:Win32 Binaries also? - YES - here's the quote by evilandi · · Score: 3

    web.mysql.com/news/article-22.html

    One of the biggest news is that the Windows version of MySQL is now also distributed under the GPL license.

    Finally, the Win32 version of MySQL is completely free. This makes it the only free (as in both) industrial-strength database on the Windoze platform AFAIK.

    So I now have even more ammo to get my boss to ban Microsoft Access and SQL Server from our office!

    Does anyone know how to use this from Active Server Pages (ASP)? ODBC driver I guess, right?

    --

    --
    Andrew Oakley - www.aoakley.com
  33. ?? by volsung · · Score: 1
    I think his point is: Yes, they are working on it. Not: Yes, and you should forget Oracle and use this for your next bank transaction engine.

  34. Progress forms Nusphere by Hurricane_Bill · · Score: 1
    Progress Software has formed NuSphere, a Progress Software Company, to distribute and support the NuSphere MySQL(TM) open source database.

    The announcement can be found here: http://biz.yahoo.com/bw/000628/ma_progres.html

    Progress Software has been around for 17 years, and has lots of experience with databases, and development tools. (http://www.progress.com)

  35. Not "it's better" by Dungeon+Dweller · · Score: 2

    I didn't mean, "It's better," what I mean is, people have been using it for a long time, a lot of senior people who make decisions have used it on their machines. It's more commonly used in universities than Linux (IE, at WVU, we use SysV with the BSD compat package installed). I didn't mean, "Gee, BSD is great." I meant, "Gee, BSD has been around for a long time, and is used a lot more than people say it is."

    --
    Eh...
    1. Re:Not "it's better" by emir · · Score: 1

      okay i missunderstood you :(

      bsd license being used much more may be the case in usa, but i dont believe its same here in europe (not sure about this... :)

      --
      -- http://electronicintifada.net --
  36. Oh Yeah by Dungeon+Dweller · · Score: 2

    I meant to make that a comment on the amount of stuff released under it, and that a lot of people like that part of the license. Personally, I like to think that I could release some prelim version of my code, get people using it, a free release, and still use my code in a commercial form as well, and allow the source to be open. I kind of like the feature that lets me make closed software (not a popular POV around here, I know). Of course, other people can too, which isn't necessarily a bad thing either.

    --
    Eh...
  37. mSQL by volsung · · Score: 2
    They released older versions (called mSQL) under the GPL. Now they are going to release the current version under the GPL instead of their "free, unless you try to sell a product based on it" license.

  38. Conventional usage of company names by timothy · · Score: 1

    varies; British English takes one side of the whole "collective noun" thing and American English takes the other. In British English, "Andover are excited to throw chickens into the air" would be correct, at least grammatically. After all, "company" may be a singular noun, but it indicates a plurality anyhow ("A company of men marched into the room and decided the color was all wrong.") Both approaches make sense, they just choose a different way of looking at the problem.

    timothy

    --
    jrnl: http://tinyurl.com/c2l8yr / foes: http://tinyurl.com/ckjno5
  39. GPL does not prevent this scenario by brokeninside · · Score: 1

    Personally, I like to think that I could release some prelim version of my code, get people using it, a free release, and still use my code in a commercial form as well,and allow the source to be open.

    The GPL does not prevent this behavior, assuming either (1) you are the sole author of the code or (2) for any contributed code you add to the product you have the contribtor sign a seperate licensing agreement giving your company unrestricted re-distribution rights.

    IANAL, but having read the GPL, it seems to me that releasing code under the GPL does not explicitly waive your rights to your intellectual property under the copyright act. However, if you were to add code to your product that other people contribute, without some sort of explicit statement from the contributor giving you rights beyond the GPL itself, you would only be able to include that code in GPL versions of your product.

  40. OT: was Re:So what? by isil · · Score: 1

    ok...put DOWN the popcorn and come quietly with us...

    we have a nice white jacket with extra long sleeves with belts and buckles on them for you to wear.

    we are your friends and we are here to help.

  41. Does this mean... by IGnatius+T+Foobar · · Score: 3

    ...that we now have to call it GNU/MySQL?

    <grin>

    Seriously though, this can only be a good thing. MySQL is uniquely positioned to become a "category killer" in the world of free databases, as long as some of the features people have been requesting are added (such as transactions). The placement of MySQL in the GPL world means that open source programmers will not hesitate to put lots of contributions into it.

    I'm aware that they were previously dual-licensing it, with the new version as not-quite-free and an older version as GPL, but that tends to ruffle some feathers in the free software community. This is much better. I hope Aladdin Systems is paying attention and does the same thing with GhostScript.
    --

    --
    Tired of FB/Google censorship? Visit UNCENSORED!
  42. Databases are overrated by Shanes · · Score: 1

    ...at least when it comes to speed for tables with few ( less than 1 mil) entries.

    $ for i in `seq 1000000`; do echo $RANDOM >> randomlines;done
    $ time grep -c 1234 randomlines
    415
    0.02user 0.08system 0:00.09elapsed 106%CPU (0avgtext+0avgdata 0maxresident)k
    0inputs+0outputs (2871major+22minor)pagefaults 0swaps

    That is 9/100 of a second to do a "select" and count of 1 million lines in bash using good old grep. And no db-connections to bother with...

    How does MySQL or Postgres compare to that?
    (System: dual P-II 550MHz, 256MB of RAM, Linux 2.2.12)

    1. Re:Databases are overrated by Kurt+Gray · · Score: 1

      I don't know and I won't bother trying to benchmark that bit of code in MySQL, but for systems as complex as SourceForge or Slashdot you really need to have a database backend to manage the relationships between all those pieces of data. I'm sure it would perform even better if you wrote it all out in assemebly language, but who wants to do that?

  43. Re:Win32 Binaries also? - YES - here's the quote by LetterJ · · Score: 4
    Use MyODBC available at http://www.mysql.com/download_myodbc.html .

    This new license frees me up. I've been working on a book on building intranets with PHP and I wanted the code to be cross platform, but PostgreSQL doesn't come in binary form for Windows, Access/MSSQL weren't available for UNIX, MySQL had a restrictive license for Windows. Now I can use MySQL with no problems. Woohoo.

    LetterJ

  44. Re:mSQL (is completely different) by gregbillock · · Score: 1

    No, mSQL is a completely separate project. I think mySQL deliberately started as a superset of mSQL, but other than that, there's no relation.

  45. Yes, mod_adbanners has been released too by Kurt+Gray · · Score: 4

    Andover's ad delivery system is GPL'ed too. Available for download here.

    1. Re:Yes, mod_adbanners has been released too by Kurt+Gray · · Score: 1
      Maybe mod_adbanners should be mentioned somewhere in Slashcode

      That's a good idea. I'll submit it and see if they don't reject it. Thanks.

  46. There is no comparison by Moderation+abuser · · Score: 3

    PosgreSQL is by far the more advanced database engine. No question. MySQL is by far the faster of the two.

    The reason that MySQL is by far the faster is that PosgreSQL is by far the more advanced.

    If you try to make MySQL as advanced as PostgreSQL you will slow it down to the point where it is no faster.

    Stop trying to compare them. They do DIFFERENT JOBS.

    --
    Government of the people, by corporate executives, for corporate profits.
    1. Re:There is no comparison by phred · · Score: 2

      Define "advanced."

      Go ahead, I dare you.

      -------

      --
      Bill Gates Is My Evil Twin.
    2. Re:There is no comparison by chris.bitmead · · Score: 1

      Postgres is rapidly becoming a lot faster. The recent 7.0 release made great strides, and significant speedups are already on the way for 7.1.

    3. Re:There is no comparison by Moderation+abuser · · Score: 2

      It'll never be as fast as MySQL unless the MySQL guys start building all sorts of additional functionality in.

      I'd rather have the option.

      --
      Government of the people, by corporate executives, for corporate profits.
  47. GPL, good business license by joneshenry · · Score: 1

    Once a company or group releases source code, it's hard for me to see why they should not GPL it. The key to making this work is to require copyright assignment for any patches. Then the company retains the right to reuse code in other projects or custom work under any conditions.

    As the FSF itself requires copyright assignment, there is no community objection to such a practice. It just seems to me to be all gain and no pain.

  48. Hurrah! by mattbee · · Score: 1

    The best database engine in the world can't sort out bugs like this one "Oh, just a quick code update on the live site... of course it'll work... no need to check..." :-)

    --
    Matthew @ Bytemark Hosting
    1. Re:Hurrah! by VP · · Score: 1

      Well, we can always hope to get there:
      (voice of HAL) I cannot let you do that, Dave.

  49. So, when VA goes bankrupt, what happens to MySQL? by Bowie+J.+Poag · · Score: 1



    Ok, time for a reality check:

    1) VA has yet to turn a profit. Infact, they're still seriously in debt. This "partnership" creates a dependence on VA financial situation. If VA goes down the tubes (as nearly 80% of .com companies are expected to do within the next 1-2 years) after burning through their cash reserves, what happens to MySQL?

    2) VA has absolutely no policy in place to protect the work of users who house their projects on SourceForge. Infact, Linux Weekly News (as independent a source as you can get nowadays..they arent owned.) ran an article nearly 5 months ago pointing this out. SourceForge's privacy policy amounted to a one-line "We'ere working on it" statement. 5 months later, it still hasn't changed. Right now, from a legal standpoint, nothing prevents VA's management from picking and choosing from the collective ideas of 37,000 people, and nearly 6,000 projects in development, putting full-time employees on the task of replicating the work of the volunteers, and consequently leaving them in the dust without a legal leg to stand on.

    This includes MySQL.

    You can read LWN's two articles on SourceForge's lack of a security policy here and here

    Relevant links:

    Press Release, "VA Linux Forms Strategic Alliance With MySQL; MySQL Becomes Completely Open Source And Hosts Project On SourceForge

    VA Linux Shareholder To Sell 1.55M Shares

    Jon Richards files SEC 114 to dump restricted shares

    IDC Report on VA's 5% Marketshare

    And for fun, a story on VA's stock performance..or lack thereof..

    Those are the facts. Educate yourself, folks.

    Bowie J. Poag

    --
    Bowie J. Poag

  50. Troll Tech next! We could have QT under the GPL! by Deven · · Score: 2

    Would be great if VA Linux would invest into Troll Tech to make the same thing happen with QT. This would be another boost to Linux and Free Software & make everyone happy.

    Agreed. This is a great trend to see -- Linux companies using their newfound market power to get more software released under the GPL! MandrakeSoft did it with the Bochs PC emulator, now VA Linux with MySQL. (I don't know if Red Hat has done this, but they've funded GNOME development quite a bit.) It's that "rising tide" thing; the more of this we see, the better it is for everyone.

    Troll Tech should be next. Seriously, there is a lot of demand for QT despite license headaches; if QT were under the GPL, it would be a Good Thing (tm). Perhaps Red Hat, VA Linux and other Linux vendors could join forces to do more of this, starting with QT. (I might suggest Motif also, but that may not be viable.)

    As an aside, could we have a bit less license proliferation? Does every open-source software release really need a custom license with slight variations on existing ones? (I think I'd like to see GPL/MPL dual-licensing become the norm, unless the GPL is modified to be compatible with the MPL...)

    --

    Deven

    "Simple things should be simple, and complex things should be possible." - Alan Kay

  51. Do these two statements seem strange together? by The+Wookie · · Score: 2
    So I now have even more ammo to get my boss to ban Microsoft Access and SQL Server from our office!



    Does anyone know how to use this from Active Server Pages (ASP)? ODBC driver I guess, right?


  52. This will be great. by dragonfly_blue · · Score: 1
    Now, if they can just figure out a way to get the man pages to work better. Their online documentation for MySQL (Which I've been trying to use to develop for my BSD web server) is totally down right now; its been around 7 hours now, and their site has been flaky and slow for at least a week.

    I know this is probably related to the heavy traffic at their site today, but still; shouldn't they be able to keep their manual section up and running a little better? Hopefully the investment from VA Linux will go towards upgrading their 486 33sx web server. ;-)

    Anyways, I am happy about this; I'm just grumpy because I hate missing deadlines. Documentation is HUGE in this field, so I hate it when companies skimp.

    --
    Free music from Jack Merlot.
    1. Re:This will be great. by dragonfly_blue · · Score: 2
      Nah, I was being too hard on them... I think they did a big site changeover today and I just caught them at a bad time.

      I did download some docs, they have been helpful.

      --
      Free music from Jack Merlot.
    2. Re:This will be great. by JGee · · Score: 1

      So hit www.mysql.net for a mirror of the old site. The documentation is all there. While you're at it, save a copy of the big manual and stick it on your own server. 5 minutes with a decent search and replace algorithm will modify make relative addresses of the links. Saves a lot of time, and leaves MySQL's bandwidth for downloads.

  53. what htis means to the average joe tech by geekd · · Score: 2

    This is really great.

    It used to be that MySQL was free for use, but you couldn't sell it. That meant that if I was to consult for a business, and set up an infrastucture for them, I could use Linux, Apache and MySQL, but if I was charging them money (and of course I am) then I would have to pay MySQL.

    Now I don't have to pay MySQL. So I (or any enterprising tech) can hire themselves out to set up a company's IT infrastucture and NOT PAY A CENT TO ANYONE FOR SOFTWARE.

    This will speed adoptions of completely GPLed networks and backends, as well as further help the budding cottage industry of freelance IT consultants.

    Why is this important, other that we can make more money now?

    Supporting the "cottage industry" tech consultants is what got Microsoft where it it today. I am seeing more and more parallels between MS programmers/network consultant of 5 years ago and Linux-Open Source programmers/network consultants today.

    The geeks tell the "dumb" suits what to use. Win over the geeks (as MS did in the early 90's) and you win over the suits, eventually.

    "But the suits demand MS products!" you say. Well, back in the day, the suits demanded IBM. But the MS won out eventually, and Linux/Apache/MySQl will too. We are already halfway there.

    We already had alot of reasons to push MySQL, now we have one more - it saves us money!

    -geekd

  54. That's what DBI is for... by binarybits · · Score: 1

    Any modern CGI script that uses a database backend and is written in Perl should be using DBI. If you write your code in DBI, then the only code you have to re-write is the connect statement plus cases where your SQL statements use a feature that's not present on the new DB. As long as you stick to standard SQL, porting to a new database is practically painless. I haven't looked at the slash code, but if it uses DBI, it shouldn't be too much work to port it to another database. On the other hand, database integrity in Slash is probably not its highest priority, so mySQL is not such a bad choice.

  55. Mysql DOES SUPPORT TRANSACTIONS by frankie_guasch · · Score: 4

    Here is the documentation about how to use it.

    This is beta right now but this is for real.
  56. No prob by Dungeon+Dweller · · Score: 1

    see subject line :-)

    --
    Eh...
  57. MySQL is not Industrial Strength by bwoodring · · Score: 1

    This is typical Linux-user hubris. If it is Open Source, it must be better right? Wrong.

    1. SQL Server has transactions, MySQL does not.
    2. SQL Server has FKs, MySQL does not.
    3. SQL Server has row-level-locking, MySQL does not.
    4. SQL Server has triggers, MySQL does not.
    5. SQL Server has compiled SPROCs, MySQL does not.

    MySQL is NOT and enterprise grade RDBMS. It does not even compare to SQL Server. If you are trying to get SQL Server removed from your company in favor or MySQL, you are jeopardizing critical business data. I would never trust any data stored in a database without transactions or FK constraints.

    1. Re:MySQL is not Industrial Strength by BoLean · · Score: 1

      I chose MySQL for its lack of "features". I think it is stupid that 90% of the criticisms of MYSQL talk about features that are seldom used. Transactions my butt. MYSQL is simple.

  58. In a word: NOTHING by tuffy · · Score: 2
    Haven't you noticed the "open" part of open source? If VA goes down the tubes, MySQL remains open and anybody can continue to help in the development. In addition, there's nothing preventing anybody (not just VA employees) from working full-time to replicate an open-sourced project for their own aims - but why? Why would an entity, commercial or otherwise, want to spend any amount of time and effort to reinvent a wheel being given away for free as it is? By virtue of the original being free, there's no financial gain from it since the original will remain free.

    In short, why should anybody worry about their project being stolen when they're already giving it away to anyone who wants it? When it comes to privacy policy, I'd be much more worried about annoying spam and the like, really.

    Your facts may be correct, but your speculations lack logic.

    --

    Ita erat quando hic adveni.

    1. Re:In a word: NOTHING by Bowie+J.+Poag · · Score: 1

      Why? Simple. Money. You know, the thing VA's board of directors wants the company to make? :)

      Here's what I mean:

      Fruitful projects mean increased income. Popular projects, at the very least, mean increased banner traffic. A substantial part of VA's income is generated purely by click-thru sales. High-traffic sites with focused demographics = good income.

      VA only has a 5% marketshare in the Linux hardware market. Compaq by comparrison is doing 5x that..

      Look how much Sourceforge has done for VA's money-making ability. If the situation on community.themes.org in '98-99 can be seen as a microcosm of whats currently happening on SourceForge, you can expect developers to be ripped off in droves.

      You pose a valid question, but the answer becomes clear once you have an understanding of the motives involved. VA doesnt have a Department of Caring. Theyre in it for the money above all else. Its time for all of us to get square and flush with that idea, because alot of us will get hurt if we continue to believe VA is some sort of fluffy philanthropic organization that can materialize money out of thin air.

      Now, ask yourself this -- Why does SourceForge's terms of service go into very specific detail about legalities, but yet, totally ignores the priacy concerns of its users?

      More importantly, why does VA give itself total immunity in the TOS (Terms of Service agreement) from lawsuits, and reserve the right to change the TOS without warning at any time?

      Ask more questions, get more answers, bud.


      Bowie J. Poag

      --
      Bowie J. Poag

    2. Re:In a word: NOTHING by tuffy · · Score: 2
      Your reasoning for why VA would usurp projects continues to elude me. If a project becomes very successful, thus generating more traffic, and thus more banner ad clicks, why would VA bother to push it in their own direction and splinter the user base? Wouldn't a more logical reaction be to promote the project or add resources to it, thus making it even more popular and thus generate even more banner ad clicks?

      Yes, VA is not a charity. But trying to somehow "take over" the existing free projects is neither feasible, profitable or rational. Nor have I seen any actual evidence that they might do so.

      --

      Ita erat quando hic adveni.

    3. Re:In a word: NOTHING by Ian+Bicking · · Score: 2
      What do you envision the problem with VA being? Explain the most manipulative turn VA could take with regards to Sourceforge.

      Whatever danger you perceive, I (and tuffy, I think) just don't see it. Your speculation will have to be a little more concrete.
      --

    4. Re:In a word: NOTHING by chrisd · · Score: 5
      VA Does in fact have such a department. It contains:

      • Chris DiBona (Me)

      • Joe Arruda
        Kit Cosper
        Josh Freeman
      And two others. This doesn't include the 200+ employees who came -directly- from lugs, users groups, and oss projects. So, yeah, we care.

      I assure you that we care very much about VA's ability to make money. We like money. Money buys stuff. But money and helping linux continue to grow and prosper are not mutually exclusive and is what we do here.

      As far as immunity, if someone puts a copy of the source code to solaris, you think that we want to accept the liability that person has invited upon him or herself? Hell no. Also, you don't seem appreciate the projects we host and have gotten the angry lawyer calls about. I'm just waiting for the freenet call. When Livid was hosted here on our network, I sent out an email to the guy telling him we would not pull the software without a court order. The AAC decoder has already gotten us a call from Dolby labs, luckily they had released teh very code they were -yelling- at us to pull down themselves into the public domain.

      We put a -hell- of a lot of work into sourceforge, but we're not going to be everyone's lawyer, we expect that project leads are well able to take care of their own legal issues. We don't take ownership of their code, why should be accept thier liabilities?

      So there is your answer, if you'll take the time to understand it.

      If anyone cares about what Bowie is babbiling about with regard to ocmmunity.themes.org, it's been detailed here on slashdot often enough. Just look for my or bowies post on the topic.

      Chris DiBona
      VA Linux Systems


      --
      Grant Chair, Linux Int.
      Pres, SVLUG

      --
      Co-Editor, Open Sources
      Open Source Program Manager, Google, Inc.
  59. Check out InterBase by Green+Light · · Score: 1

    I wonder how many people know about InterBase. This fast, full-featured RDMS is becoming open-source. Go to InterBase, download the beta version of 6.0, and check it out.
    Honestly, I cannot imagine what mySQL could have over InterBase.

    --
    "Send an Instant Karma to me" - Yes
  60. Re:mysql by Tobias_Ratschiller · · Score: 1
    Actually, that's not a joke. Just read eWeek (former PCWeek) vol 17, no 20, page 27, on the story about eGrad2000.com: "Toolbox: Linux platform based on MandrakeSoft Inc. software, Microsoft Corp.'s MySQL database, development tools including Dreamweaver."

    *giggle*

  61. Re: HTML and Perl by spiro_killglance · · Score: 1

    When writing Web application I never (except
    for debug) put any on the HTML in the program,
    the graphical designers can't be expected to
    edit Perl, instead by Perl scripts and load
    and edit and display HTML templates with space
    to for the variable. So I get to stick to the
    programming and the GD's and stick to the
    design without to much worry. A simple subroutines
    is even to add the data to the HTML with
    purals and conditionals, e.g.

    <PRE>
    sub output {
    $output = $_[0]; # Template passed in $_[0]
    $output =~ s/\[(\w+)\]/${$1}/egs;
    $output =~ s/\[s\-(\w+)\]/ "s" if
    (${$1} != 1)/egs;
    $output =~
    s/\[IF\s+(\w+)\=(\w+)\](.*?)\[\/IF\]/ $3 if (${$1} eq $2)/iegs;
    print $output;
    }
    </PRE>

  62. Another notable OSS release by Captain_Carnage · · Score: 1

    Earlier this week Mission Critical Linux open-sourced their High-availability cluster technology called Kimberlite. I've seen this on lwn and linuxtoday, but it was notably absent from slashdot.

    From what I've seen, it's better than LVS and Pirhanna because it gives you higher levels of data integrity. For example, when a node hangs, but doesn't die, the other node kills it, so that the first can't recover and suddenly you have 2 nodes serving inconsistent data. It also works with shared SCSI storage between two nodes, which I don't think the others do....

    If you're interested in High Availability computing, this is definitely worth checking out. The kimberlite homepage is at http://oss.missioncriticallinux.com on your radio dial... :)

    Check out the OSS linux clustering technology called

    1. Re:Another notable OSS release by pll · · Score: 1

      I'm really surprised this hasn't shown up on /.
      yet. I thought it was really cool, and we fought pretty hard to get this opened up.

      I'm wondering if someone did something to piss of the /. maintainers.

      Oh well, the LVS and HA communities were happy
      with us :)

      --
      Seeya, Paul
  63. I am confused? by Anonymous Coward · · Score: 1

    Can I use this for commercial purposes without releasing my code or not? I find their web pages confusing on this topic. Obviously, if it's GPL'd then I have to release my code. But what if I am using a JDBC connection layer to the DB? I am not directly using the DB client interface then...I guess I'll stick to PostGres.

  64. mysql to Oracle (plug) by totierne · · Score: 3
    I work in the Migration Technology Group at Oracle. We are working on mysql to Oracle migration.


    Oracle 8.1.6 for linux is currently is oracles top download.


    What else should we be doing in the linux/open source area?


    Our product (Oracle Migration Workbench, free from Oracle Technology Network ) currently runs on windows but can migrate, SQLserver, Sybase and Access to Oracle on Linux (using Oracle networking connectivity), we are working on SQLAnywhere and mysql (next up is Informix) we may do Postgress if there is demand. There are other facilities for migration, e.g. Oracle transparent gateways and flat files for data migration (imported to Oracle using sqlldr), and some unsupported toolkits/migration documentation on OTN. Data from oracle on other platforms can be transfered to Oracle on Linux using exp and imp (shipped with Oracle server).

    totierne@hotmail.com

    1. Re:mysql to Oracle (plug) by totierne · · Score: 1

      There is a non gui option (silent) for the Oracle Universal Installer (assumes you have all your actions in a pre configured file), but I have not tried it myself..

      I have installed on linux and the GUI install does take lots of memory (make sure you have the swap space..)

  65. Re:Good! The hate is swelling in you now... by Bowie+J.+Poag · · Score: 1

    Not quite.

    Lets suppose you work for VA. If your company can withstand criticism, go ahead, lets see it defend itself. Ultimately, we'll see whos right and who's wrong, who's trying to cover their ass, and who's trying to paint an accurate picture. Bring it on, i'm ready.

    If I were you, I wouldnt open my mouth if I weren't sure of what the hell was going to come out of it. ;)



    Bowie J. Poag

    --
    Bowie J. Poag

  66. Re:So, when VA goes bankrupt, what happens to MySQ by pudge · · Score: 1

    If VA goes down the tubes (which is unlikely, but possible), MySQL continues on. MySQL is not OWNED by VA. It is owned by the same people who have always owned it. And even if it were bought by VA, it is GPL'd, so have fun.

    And VA can do the same thing you say with ANY open source project, whether it is on SourceForge or not. So can Microsoft, for that matter. Welcome to Open Source. LWN makes good points about private data being used for recruitment, demographic information, etc. You don't make any good points, though.

  67. example: GreatBridge will be supporting PostgreSQL by cpeterso · · Score: 2

    Great Bridge is to PostgreSQL as Red Hat is to Linux. They will offer support contracts and also fund (some?) future development of PostgreSQL.


  68. Not what I would write. by Bruce+Perens · · Score: 1
    Hi Mr. Impostor,

    Again, not what I would write. Oracle, maybe, but didn't you notice that Interbase is going Open Source? In fact, they ran the license by me and it's really an Open Source license. Interbase is an enterprise-quality database and with the help of the community could become even more powerful. It would be nice to see participation like that from Oracle, but I won't hold my breath.

    Bruce

    1. Re:Not what I would write. by Anonymous+Coed · · Score: 1
      His post wasn't legitimate. First of all, the misleading name is enough to disregard it in my opinion. Second of all, it would be slightly more tolerable if this impostor actually wrote something coherent or insightful. All he does is ramble on with his misinformed opinions on subjects he knows precious little about.

      Helpfully yours,
      Anonymous Coed

  69. Impostor. by Bruce+Perens · · Score: 1
    This guy is an impostor. And a nut, too!

    Bruce

  70. Re:So, when VA goes bankrupt, what happens to MySQ by ish__ · · Score: 1

    Bowie, its not like VA is stockpiling open source software and is going to suddenly pick up and leave. If youre so paranoid about VA and them "stealing" free software (how exactly do you do that?), why havn't they done it yet?

    Oh, i know, theyre luring us into a false sense of security, and the *poof* theyre going to rob us blind. damn, we should remove our software from sourceforge asap, wouldnt want them taking free software from what is basically a bigass ftp site. lets put our software on our own sites! yeah, thatll prevent them from putting fully paid professionals on it!!

    As for sourceforge/privacy/security, If YOU dont like it, YOU dont have to use it. Most users arent extremly concerned with it, and just need a place to put some html, cvs and such. If perhaps you could get over the fact that sourceforge is kinda cool and a big sucess and has NOTHING TO DO WITH YOU, maybe we could get something worthwhile out of this, but as it is, VA bashing and cyncism is all that appears, what a shame.

  71. A License is Required if: by aozilla · · Score: 1
    http://www.mysql.com/sup port/arrangements/license_req.html

    • You link a part of the of [sic] MySQL that has a GPL Copyright to a program which is not free software (embedded usage of the MySQL server). In this case your application would also become GPL through the clause in the GPL license that acts as a virus. By licensing MySQL from us under a commercial license you will avoid this problem.
    • You have a commercial application that ONLY works with MySQL and ships the application with the MySQL server. This is because we view this a linking even if it is done over the network.
    • You have a distribute MySQL and you don't provide the source code for your copy of the MySQL server, as defined in the GPL license.
    my questions
    • if they intend to licence MySQL for commercial use, does this mean that they won't be accepting contributions which don't sign over the copyright?
    • is the second term likely to hold up in court?
    • if they don't intend to accept contributions, and their second term is held up, their licence really hasn't changed, has it?
    --
    ok then your [sic] infringing on my copyright! Could you as [sic] me next time before STEALING my comments for your own?
    1. Re:A License is Required if: by Adrian+Lopez · · Score: 1

      I sincerely hope the second term does not stand up in court. There is a difference between linking to a library and communicating with a server. The first creates a derivative work, the second does not. I believe the client API for MySQL is public domain, so it's perfectly legal to link to it. Because a program that uses this library is not a derivative work of GPL'd code (it merely communicates with a GPL'd server) the second term would/should not hold.

      --
      "In prison you just have to shut your eyes and take it. Here you have to shut your eyes and give it."
  72. ISP MySQL Services by aozilla · · Score: 1

    http://www.mysql.com/sup port/arrangements/example/isp.html

    "If you charge for MySQL installation and administrative support as part of your customer service, then you need a license because you are selling a service that includes MySQL."

    I sure hope this is just something which mysql forgot to take out of the website, because this is certainly not a valid interpretation of the GPL.

    --
    ok then your [sic] infringing on my copyright! Could you as [sic] me next time before STEALING my comments for your own?
    1. Re:ISP MySQL Services by David+Axmark · · Score: 1

      Yes it is a error. I needed some sleep when I wrote that. I guess that there still exists other info that still is wrong. It will be fixed eventually but we need to cat up on our mail and sleep first.

      /David

      --
      MySQL co developer
  73. Again??? by dbryson · · Score: 1

    They released version under GPL nearly a year ago and look how much as been done with it!

    --
    You just wish your ID was as low as mine! I used to be proud to have such a low id, but not so much now. Slashdot most
  74. Well by Dungeon+Dweller · · Score: 1

    The parent post was discussing that more stuff should be put under the GPL, and that the BSD license is not as good. What I was trying to get across is that the BSD license is a good license, but the GPL is the flavor of the moment because of all of the hype surrounding linux. I was making examples of the fact that A LOT OF PEOPLE USE THE BSD License. It wasn't really a comparison of operating systems, as saying, BSD is a good license too, why does it always have to be GPL around here? Get it?

    --
    Eh...
  75. QPL basically *IS* GPL by Eric+Green · · Score: 2
    What puzzles me is why Troll Tech even bothered with the latest version of the QPL. If you read it, it pretty much *IS* the GPL, with a few bits of added fluff to make sure that Troll Tech gets their credit (e.g., nobody can sell a modified version of QT and call it QT).

    GPL or QPL, either way, it's the same problem -- you can't use it to write commercial software. Not without buying a commercial license from Troll Tech anyhow. Which is not a big deal at the moment, if you're a commercial company...

    -E

    --
    Send mail here if you want to reach me.
  76. MSDE is also free by Otis_INF · · Score: 2

    Microsoft's MSDE is also a total free database. it's a database engine that acts like SQLserver and ment for developers, but you can run it as a database for normal usage, and avoid evil access databases.
    --

    --
    Never underestimate the relief of true separation of Religion and State.
  77. Re:So, when VA goes bankrupt, what happens to MySQ by chrisd · · Score: 4
    Hi all, Hi Bowie...

    In response:

    1: VA has been very clear since our road show that we intend to show profitability in 2001. The reason that we are not profitable is that we have been spending our cash to expand so that we can effectively compete. That is -why- companies go public and take in investment. If you don't think we are a good investment, then don't invest in us, I'm okay with that. Our investment in MySQL is part of what made the gpling of mysql possible, but again, it's not clear you want to understand this. I'm also okay with this.

    2: Yep, I'm aware of this, and the lawyers are working on it. But just because SF doesn't have a privacy policy in place doesn't mean that we can repeal the GPL. So chill. I think you are also intimating that we are going to rip people's software off and do our own...I don't really understand your complaint, I suppose. If we take code and create new oss software from it, that's okay. You do know how the GPL and BSD licences work, right?

    As far as stock price and such goes, people are going to sell, people are going to buy, that's what happens in a market.

    So there you go.

    Chris DiBona
    VA Linux Systems


    --
    Grant Chair, Linux Int.
    Pres, SVLUG

    --
    Co-Editor, Open Sources
    Open Source Program Manager, Google, Inc.
  78. MS SQL 7.0 by �ignal+11 · · Score: 1

    Plenty of e-commerce sites are coaxed into using this alpha quality software.

    --

    -o Disclaimer: My employer doesn't even agree with me about C indentation style o-
  79. code organisation by _wintermute · · Score: 1

    I have adapted portions of the ColdFusion Fusebox methodology (http://www.fusebox.org/).

    This technique makes perhaps excessive use of includes for code organisation, but it seems to work (with adaptation) for a range of situations...ASP, PHP, Python.

    --
    technoshamanic resistance within hyper-transgressive ontology
  80. Hilarious. by �ignal+11 · · Score: 1

    Microsoft software has enough problems when it is being fully pushed by Microsoft. At my place of work we happen to use a product that was based on that piece of crap called MSDE, and it absolutely terrible. FYI, MSDE was abandoned (hence why it is free) my M$ for MS SQL.

    I strongly suggest that no-one use MSDE for anything except a doorstop.

    --

    -o Disclaimer: My employer doesn't even agree with me about C indentation style o-
  81. Welcome to the world son.. by �ignal+11 · · Score: 1

    Do you think that the internet is run by geeks who can run trans-continental fiber connections? Nope, the internet is growing because companies are pumping money into it. Our world is run on money, if you think that VA is the only entity which has alterior, money driven motives, then you have another thing coming.

    --

    -o Disclaimer: My employer doesn't even agree with me about C indentation style o-
  82. BSD vs. Public Domain by gwalla · · Score: 2

    I'm probably missing something, but can anyone explain how the BSD license differs from public domain? In both cases, anyone may take the work and make it proprietary.


    ---
    Zardoz has spoken!
    --
    Oper on the Nightstar
  83. Virus License wins again by Tuross · · Score: 1

    There was nothing wrong with the original MySQL license. It was open source, free software.
    The only restriction was if you wanted to make money directly from it (by selling it) you had to pay a small license fee.
    What's wrong with that? NOT paying the license fee is morally wrong, because you are ripping off the good people who wrote the software for you. Why should you make profit from their work and they don't?

    Being under the GPL now means that the applications one can use MySQL for are restricted.
    Yet again another decent software package falls victim to the virus license.

    --
    Matt

    --
    Matt
    1. Read Slashdot
    2. ???
    3. Profit
  84. Re:So, when VA goes bankrupt, what happens to MySQ by Torin · · Score: 1
    In fact, Linux Weekly News (as independent a source as you can get nowadays..they aren't owned.)

    You forgot a relevant link: LWN acquired by Tucows.com.

  85. No chance... by chris.bitmead · · Score: 1

    SQL engines are very complex beasts. There are just too many differences to bother with. Besides, why would Postgresql bother? Their top end is far more advanced with the Object relational stuff, and the storage manager stuff supports transactions and is much more stable in doing it. As for speed, great strides are being made in postresql. What does that leave?

  86. You forgot Postgres by chris.bitmead · · Score: 1

    You forgot Postgres

  87. Re:Ho hum.. by Bowie+J.+Poag · · Score: 1

    Thats all nice, Chris, but it doesn't answer the question.

    Why is SourceForge lacking something as fundemental as a security policy for its users, to protect them, and not you?

    ..And has lacked it for 5 months straight?


    Bowie J. Poag

    --
    Bowie J. Poag

  88. Re:So, when VA goes bankrupt, what happens to MySQ by Bowie+J.+Poag · · Score: 2

    Ha, interesting -- I didn't know LWN got gobbled up. Thanks for the heads up.


    Bowie J. Poag

    --
    Bowie J. Poag

  89. Re:Good! The hate is swelling in you now... by Bowie+J.+Poag · · Score: 2

    Why not? I could quite happily be a thorn in VA's side until they own up to what they did to us. Rather than do that, they protect their corporate image by sicking DiBona and VA's Department of Caring on anything bad to say about the company. Can you blame them? You don't have to be involved, really...so why do you even care what is said either way?

    If you don't like me, dont follow what i'm doing. If you dont like my work, dont use it. Don't believe me? No problem -- You're not obligated to even listen. The only "sinking" here comes from people who don't have enough stones to call VA's practices into question.



    Bowie J. Poag

    --
    Bowie J. Poag

  90. heh by Otis_INF · · Score: 1

    I didn't say it was good, I only mentioned it was free :) ofcourse you can't expect it's top notch when it emulates sqlserver but at the same time it isn't. I never tried it, perhaps it's ok.
    --

    --
    Never underestimate the relief of true separation of Religion and State.
  91. Re:MySQL is relational, but not RDBMS by Malvolio · · Score: 1
    MySQL has got the R of RDBMS, true enough, but it lacks the DBMS. It's not really a DataBase Management System without transactions. Please note that most people don't insist MySql isn't relational, they simply state that MySQL isn't an RDBMS.

    whatis.com has a nice definition of DBMS.

  92. Finally by SnapperHead · · Score: 1

    I think this is something that was long over due. There are tons of people who won't use it becuase of its license, I was one of them. A few of my projects that where sold to a few companys refussed to use MySQL with its old license. This should make the database market much more intersting, putting more presure on PostgreSQL and Oracle. Being thats its now open-source, maybe the important features its been missing will get added. (transactions and subselects :)

    --
    until (succeed) try { again(); }
  93. ASP under UNIX, no problem by evilandi · · Score: 2

    www.chilisoft.com

    ASP under UNIX. Ho yuss.

    The Plan:

    • Stage 1: We move from SQL Server to to MySQL
    • Stage 2: We move from WinNT to Unix

    I mean, I love PERL. And I kinda see how I ought to get into PHP. But ASP is a lot easier to pick up.

    Also, speaking as a manager, ASP programmers are a lot cheaper (you can even train up dirt cheap Visual Basic programmers who are a penny a dozen).

    --

    --
    Andrew Oakley - www.aoakley.com
  94. Slightly offtopic question... by {Hecubus} · · Score: 1

    but I have to know.
    Quite often I see people say something is "free as in speech" or "free as in beer".

    What does that mean? I'm sure there are other people around here who wonder the same thing.

    Any information on that would be helpful
    ----

    Sad fact about my sig:

    --
    Unix is mysterious, and ancient, and strong. It's made of cast iron and the bones of heroic programmers of old -
    1. Re:Slightly offtopic question... by webmaven · · Score: 2

      This is a clarification that stems from the fact that the english word 'free' has two meanings, so that when you say 'free software' you clarify which meaning you are promoting.

      The first meaning is "free as in 'free beer'", refers to getting an item for no monetary cost.

      The second meaning "free as in 'free speech'" refers to freedoms and liberties granted by custom or law.

      These phrases are usually shortened to 'free-as-in-beer' and 'free-as-in-speech'.

      While there is a lot of software that can be had for no cost, Netscape plugins for example, you are usually not free to modify it for your own purposes.

      I hope this helps clarify the issue for you.

      Further information can be found at The Debian website, The Free Software Foundation, and Eric S. Raymond's site.
      --

      --
      The real Webmaven is user ID 27463. I don't rate an imposter, because my ID is such a lame-ass high number.
  95. Re:Good! The hate is swelling in you now... by chrisd · · Score: 2
    Actually, we're fine with you saying nasty things about us, I just don't think that telling the truth is your forte.

    You're statement that we are going to steal peoples oss ideas are laughable. You do -not- understand the GPL to any degree. It's all about stealing everyone elses ideas and code to create new ideas and code without reworking. The GPL recognizes that ideas are worthless without the implementation. The GPL makes implementing already discovered and new ideas easier.

    Not that you care, but as far as your petulant cries about me and my department of addressing you: The only reason I post to reply to your emails is so that reasonable people who read slashdot can know the truth about VA and the way we do things.

    Honestly, we'd love to make peace with any of our detractors including you, but we feel that it would be a complete waste of time with you, as you are acting unreasonably.

    Chris DiBona
    VA Linux Systems


    --
    Grant Chair, Linux Int.
    Pres, SVLUG

    --
    Co-Editor, Open Sources
    Open Source Program Manager, Google, Inc.
  96. Re:Good! The hate is swelling in you now... by Bowie+J.+Poag · · Score: 1



    You're right, Chris. I'm sorry. VA's actions are above questioning. They are God, and to question God is heresy. Infact, anyone who even raises an eyebrow is insane, and must be burned at the stake. At the very least, VA's detractors should be dipped in water ; shall they sink, then they are pure -- shall they float, they are witches, and should be burnt at the stake! Burn the witches!!

    How terribly misguided i've been, Chris. Now that you've shown me the light, I can ignore the two dozen or so emails i've recieved over the past 6 months from others who've been similarly screwed by the company you work for. As you point out, theyre all liars too. Then there's the matter of SourceForge being a ripoff of System 12, well, I guess I can forget about that too. After all, it was only 7 months worth of work and preparation on behalf of myself and the others. Water under the bridge, my friend.

    Why? Simple! As you point out, its unreasonable for me or anyone else to even question the motives and business practices of your company.

    sarcasm(off);

    The fact is, Chris, you weren't even there. You werent involved with the dealings I had with Trae McCombs and others at VA during the timespan of April-December of '99. The only "truth" you know is what you've gleaned from your co-workers trying to cover their ass.

    You can hide behind the GPL all you want. You know for a fact that it doesn't protect developers from having their work co-opted by a company such as VA, and putting their full-time employees to work on the task of replicating the work of volunteers. Soon the volunteers happily chipping away at the problem wont matter, and the idea they created becomes an intellectual property of the company. Thats precisely what happened with System 12. I think thats pretty much clear to everyone by now. McCombs isnt talking, Guntharp isn't talking, Biles isn't talking. Theyre too busy covering their collective asses.

    To say VA is above doing the same thing to other OSS projects is laughable. Any company will do that. VA in particular has poured millions into an ant farm they expect to bear fruit for the company. The instant a good idea pops up that is of benefit to the company, VA will co-opt it, and leave the volunteers in the dust.

    I cant speak for anyone else here, but you're insulting my intelligence with your froth. You're paid by VA to blow smoke up people's asses. Thats a fact. PAID. As in, VA gives you money to follow me around waving a big "Don't believe him! He's a WITCH! Burn the witch!!" sign. If you were actually impartial, i'd love to talk with you. Unfortunately, you arent.

    You're a mouthpiece for a company. That means you're not free to say anything you want. You'de lose your job. I'm not interested in "making peace" with the assholes in your company. By the same token, I dont have any beef with you, personally, Chris. Infact, I've heard you're a nice guy in real life. When you take your tie off at the end of the day, you're a swell guy. The only problem is, its part of your job description to put out the flames. If you were truly objective about the situation, I'd love to clue you in.

    The thing is, I refuse to believe you sleep with your tie on.



    Bowie J. Poag

    --
    Bowie J. Poag

  97. Re:Good! The hate is swelling in you now... by chrisd · · Score: 2
    Boy, before the sarcasm tag, you had it right, oh well...

    I am of course working on what I was told to me by trae and the rest. Those guys aren't talking because they've already talked with you and put their views before the world to see.

    I am -not- paid by VA to lie or say things that I an ethically uncomfortable with. I have spent the last 2 years of my life building the company with the rest of the people here. I have hired or caused to be hired probably about 60 people. I hired trae, who hired tony. I interviewed Brian. I don't lie, I don't have to. If someone does something here at VA that pisses me off, they fix it or they convince me that it's the right thing to do. (Or I do more drastic things)

    So if I tell you I'm interested in making peace, I am not lying. My ethics didn't go out the window just because VA went public. If VA was that kind of company do you think that you'd still have an account on /.? Don't you ever see the paradox in your saying that VA is an evil ursurping company on a site owned by VA?

    You talk about the abilty to clue me in. So answer me this, you told everyone here you were developing a GTK widget repository, something that sourceforge was not designed to compete with. Is this true? You said you would "do some project hosting". Something which we were already doing and have been doing for five years. So where, tell me, did we do -you- wrong? Trae tells me that when he was talking to you about employment he asked to see the code you worked on for 7 months, and you had nothing to show him. That's what I know.

    And , yes, there are people who have beefs with VA. That's going to happen. I'd love to make peace with them. But again, it is not possible to make peace with everyone. And I -do- have a personal beef with you, you are insulting the people who are my frends, and you are attacking a company that I love and had a strong hand in building. You call us assholes and the rest and say that I lie for an expedient paycheck. That's personal.

    And ,all that said, your rant shows you do not understand, appreciate or grok the concepts of intellectual freedom behind the GPL. No one who does would ever not get the viral nature of the GPL. You can't co-opt (legally) GPL'd code into a proprietary product that you wish to redistribute. You know that, right? The way you talk about ideas make British Telecom and the MPAA look good.

    Chris DiBona
    VA Linux Systems.


    --
    Grant Chair, Linux Int.
    Pres, SVLUG

    --
    Co-Editor, Open Sources
    Open Source Program Manager, Google, Inc.
  98. Re:Good! The hate is swelling in you now... by Bowie+J.+Poag · · Score: 2

    In your reply, you said:I am of course working on what I was told to me by trae and the rest. Those guys aren't talking because they've already talked with you and put their views before the world to see.

    This isn't true. I've repeatedly asked Tony Guntharp and Trae McCombs to compare notes, going back as far as November '99. Never got a straight answer out of either of them. Contrary to your claim, neither of them have "put their views before the world to see". You're paid to do their work for them. Thats your job.

    You also said:

    "> My ethics didn't go out the window just because VA went public. If VA was that kind of company do you think that you'd still have an account on /.? "

    Malda told me in an email not too long ago that he was feeling some pressure to do just that several times. It would be sort of stupid of you, because it would prove everything i've been trying to say in the first place. As for complaining about VA on a site OWNED by VA, where the hell else is there to go? Linux.com? Nope, VA owns that. Freshmeat? Nope, VA owns that too. Good luck.

    And, you later said:
    "So answer me this, you told everyone here you were developing a GTK widget repository, something that sourceforge was not designed to compete with. Is this true? You said you would "do some project hosting"."

    We were clear with Trae from the beginning. We were attemping to unite the developers under one umbrella. We were going to do that by offering a giant component stockpile for GTK & QT developers. Music, graphics, soundbites, code, the works. Read the interview I did with Linux.com in November '99 if you don't believe me, its all there in black and white. In exchange for developers adopting our work, we would offer them free hosting space for their projects. Once we had amassed enough support, we felt that we would have been enough of an assett to VA that they would hire us. This was the entire reason I agreed to begin work on the project in the first place. 500,000 pageviews sustained for 6 months straight would guarantee me a position at VA, Trae claimed. Later I found out that Trae is NOT in a position to make such offers, and he had done this sort of thing to a number of people, and burned a number of people.

    If you were VA, why would you bother to wait for a group of volunteers to do the work, when you could just as easilly put some of your own guys on the task 9 to 5? Why hire a dozen new people when you can do it with 3 that you've already got?

    Now you know why Tony Guntharp doesn't talk, and Trae McCombs doesn't talk.

    Keep trying Chris, you're starting to get it, I think.

    Bowie J. Poag

    --
    Bowie J. Poag

  99. Re:Good! The hate is swelling in you now... by Bowie+J.+Poag · · Score: 2

    Neither of those discuss anything regarding the reason why ColdStorage was mysteriously shitcanned out of nowhere, and what communication Guntharp or McCombs had with Brian Biles. Until that is settled, the song remains the same.



    Bowie J. Poag

    --
    Bowie J. Poag

  100. Re:Good! The hate is swelling in you now... by fusion94 · · Score: 2

    Bowie,
    I don't talk because quite honestly I've nothing to say to you. I've stated publicly before about this matter and yet you contunue to call me a liar, a cheat and a thief. I've got nothing to say to you anymore as I have better things to do.