Slashdot Mirror

← Back to Stories (view on slashdot.org)

MySQL-XML Released

Posted by chrisd on from the xtremely-modest-language dept.

Brandon Niemczyk writes "MySQL-XML version 1.12 was finally released (GPL) publicly. MySQL-XML is a set of classes to streamline XML to MySQL and MySQL to XML. It comes with an automatic PHP class generator so the developer can quickly create classes to customize utilizing databases and keeping the flexibility of XML. MySQL-XML homepage is http://www.capableweb.com and it can be downloaded at http://sourceforge.net/projects/phpsqlxml/"

33 comments

  1. Now its time by Anonymous Coward · · Score: -1, Offtopic

    Anyone who doesnt "get" XML post here. :-)

  2. w00p! by Anonymous Coward · · Score: 0

    The docs don't say whether this requires a recompile of PHP with XML support? I hope not, as I use a generic web host so we get a stock standard PHP build :(

    1. Re:w00p! by Anonymous Coward · · Score: 0

      Well unless you supply your own MySQL server, it's not going to help you much!

    2. Re:w00p! by Anonymous Coward · · Score: 0

      I've got MySQL 4 and PHP 4.something, and that's it. Can I use this?

    3. Re:w00p! by Anonymous Coward · · Score: 0

      yes, of course you can, it is only a set of PHP classes to help

  3. soo... by Anonymous Coward · · Score: 1, Interesting

    So this is essentially a wrapper for MySQL? How does this software deal with malformed XML in the database?

  4. One question... by Anonymous Coward · · Score: 1, Funny
    What's up with capableweb.com? Does the MySQL+XML combo not allow capital letters?

    for developers:
    this site is built with with the mysql-xml set of classes using mysql you can download these classes here. there is a class generator to auto build classes that use these libraries here or it is available in the download package. if you have any ideas or would like to contribute please email us at contribute@capableweb.com.
  5. So? by ntr0py · · Score: 3, Insightful

    Am I the only one thinking, "So what, 440 lines of PHP"?

    Big deal.

    1. Re:So? by bgelb · · Score: 1

      I wonder why this is so important. Whats it doing on slashdot? Somebody came out with a somewhat un-exciting open source project, and they used the GPL in a questionable manner. What else is new?

  6. Creative use of GPL? by nick_danger · · Score: 1, Interesting

    From the site: It is open-source (under the well know GPL) and available for non-commercial use. If you need a commercial license please email...

    Ok, so someone enlighten me: Can a GPL'd program be released for non-commercial use with a separate license for commercial use, or does the GPL pretty much cover all use of the code? I checked the GPL FAQ, and the only case that comes close says that the license under which you received the code is the license that controls how you use the code. But that doesn't really cover the case where "This code is GPL for non-commercial use." Does the GPL permit that?

    1. Re:Creative use of GPL? by Anonymous Coward · · Score: 0

      Copyright holders (usually authors) decide the licence and can release a version under the GPL, a version under the OPL, and the PantsPL.

    2. Re:Creative use of GPL? by Anonymous Coward · · Score: 1, Informative

      Sorry, that's a tad unclear. By this I mean copyright holders can release software under as many licences as they want. The consumer has to choose only one though.

    3. Re:Creative use of GPL? by eht · · Score: 1

      suppose i am employee of some company that wants to use it under the gpl, if it's strict gpl i can license it to my company with only the restrictions of the gpl, now if he's using a modified gpl that another thing, i suppose he means that if you want a different license so the commercial company doesn't have to release the code

    4. Re:Creative use of GPL? by Anonymous Coward · · Score: 0

      I believe MySQL itself is licensed like that - it is GPL but if you want it for some closed commercial purposes you can pay and receive it under some other closed license.

      They are able to do it because they are developing all the code themselves. Some questions could potentially arise when someone sends in a patch expecting it to be included in MySQL under GPL and it trickles in to these "paid" licensees.

    5. Re:Creative use of GPL? by e8johan · · Score: 2

      "Does the GPL permit that?"

      The author(s) may licens their product(s) anyway they want, even in different versions.

      For another example of this, look at Qt (www.trolltech.org). I'd say that it is a nice way to make money, while still contributing to the open source community.

    6. Re:Creative use of GPL? by sultanoslack · · Score: 2
      Ugh, after reading the other replies I must chime in with a resounding, NO, NO, NO!

      It does not matter what they say on their page; if they have in fact released the project under the GPL, it can be used for commercial projects royalty free -- as long as those commercial users also uphold the GPL.

      It is true that the copyright holder can release it under any license that they want to. This has nothing to do with that. If however they make their software available under an unmodified GPL -- which does permit commercial use -- then they can not modify that with another statement. Again, if they're releasing it under the GPL, it can be used for commercial use.

      Trolltech was [mis-]used as an example. Trolltech, by releasing their code under the GPL does allow Qt's commercial use, royalty free, so long as the software that links to it conforms to the GPL -- in this case meaning that said software is also under the GPL.

      However, said programmers can dual-license the code under the GPL (which allows for GPL compliant commercial use) and anything else. In this case, what Trolltech does is makes it so that owners of commercial licenses do not have to release their code in compliance with the GPL -- i.e. they don't have to release their code at all.

      Oh, did I mention that the GPL allows commercial use? ;-)

    7. Re:Creative use of GPL? by laa · · Score: 2, Interesting

      This is basicly the business model that MySql uses. You can use MySql for free as long as you use it within the limitations of GPL, otherwise you'll have to acquire a commercial license. Kind of neat idea, even though I'm not sure what RMS thinks of it... :)

      --
      Why does the kernel go through stable and then unstable forks? Can't it always be a stable build, like with Windows?
  7. woohoo! by Anonymous Coward · · Score: -1, Flamebait
    great, xml is the missing feature we needed to migrate off legacy db2 and oracle dbs (and save a shitload of $$$ from licensing and hardware!)

    Oops, did i say xml? I meant transaction support. Mysql still doesn't cut it.

    1. Re:woohoo! by Anonymous Coward · · Score: 2, Informative

      yadda yadda

    2. Re:woohoo! by Anonymous Coward · · Score: 1, Informative

      mysql has transaction support, you need to use the Berkley-DB tables (you may have to recompile)

    3. Re:woohoo! by Anonymous Coward · · Score: 2, Informative

      Try SAP DB. It seriously competes with Oracle and DB2 and is a helluva lot cheaper, not to mention being available under the GPL/LGPL.

  8. Not ready yet... by ProfKyne · · Score: 5, Funny

    It says that the site was built with MySQL-XML. Does MySQL-XML eat punctuation or something?

    --
    "First you gotta do the truffle shuffle."
  9. Well... by camusatan · · Score: 3, Interesting
    It's easier to download the source and just read that than it is to read the comments and documentation about this project. I just did. My take is that it's more of an XML application, not really any kind of fundamental change to XML, PHP, or MySQL. It seems to be a set of table definitions and some PHP stuff to take in XML, throw it in the MySQL DB.

    It doesn't seem to take advantage of any of the high-speed MySQL features - this could work with any DB, I'd bet.

  10. So... by Pseudonym · · Score: 2

    When do we get Z39.50 support, then?

    --
    sub f{($f)=@_;print"$f(q{$f});";}f(q{sub f{($f)=@_;print"$f(q{$f});";}f});
  11. paradigm fuss by Tablizer · · Score: 1

    It comes with an automatic PHP class generator

    What, no functions? What about us who don't like OOP?

    --
    Table-ized A.I.
    1. Re:paradigm fuss by Anonymous Coward · · Score: 0

      here is a patch for you:

      ", "_");
      ?>

      now all your class->methods() will look like global functions. The *WHOLE* point of OOP is that you can use objects transparently. Alot of people have forgotten this.

    2. Re:paradigm fuss by Tablizer · · Score: 1

      The *WHOLE* point of OOP is that you can use objects transparently.

      What do you mean by "transparently"?

      --
      Table-ized A.I.
  12. ouch by Per+Wigren · · Score: 3, Funny

    Black text on dark-dark-blue background. This must be great stuff!

    --
    My other account has a 3-digit UID.
    1. Re:ouch by Anonymous Coward · · Score: 0

      What black text?

    2. Re:ouch by Anonymous Coward · · Score: 0
      In standards compatible browsers the style and CSS will be inherited by the IFRAME. So it inherits the TABLE bgcolor (dark blue) and text (black). BTW, your CSS file shouldn't have style tags in it. It can just contain what's in the style tags.

      Maybe you should get a web programmer to fix those. I don't think this is your field. I like your PHP though :)

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

      thank you for the suggestion, i appreciate constructive criticism.

  13. GPL Question by Jezral · · Score: 1

    ...open-source (under the well know GPL) and available for non-commercial use. If you need a commercial license...

    Did I miss something, or did he not, by using GPL, just void the non-commercial restriction?

    1. Re:GPL Question by Anonymous Coward · · Score: 0

      no, he effectively wrote a new license that contains the GPL as a superset. The intent is clear. For non-commerical use, the restrictions and benefits of the GPL are clear. For commercial use, they are not.