Earlier quoted context omitted.
Well you can almost get there (completely if you're not changing schemas): mysqldump --single-transaction This option sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.
Unfortunately, mysql still doesn't have transactional DDL, I believe...
MySQL Editions
81–90 of 99 posts
Re: MySQL Editions
#82Somebody please fork mysql and get rid of oracle once and for all. I bet the whole community will support the new sql.
Re: MySQL Editions
#83You have got to admire the evil villany we're up against. Buying the 'M' in LAMP and then exploiting that position. Business first, not the heart and minds of developers. Luckily the 'L' + 'A' + 'P' cannot be bought. LAPP stack anyone?
I take it the extra P is for PostgreSQL? As far as I could ever tell, the only advantage MySQL ever had over PostgreSQL 10 years ago is that it ran on Windows, and Postgres did not, back then. Oh, and by skipping ACID features, MySQL was faster. So, back in the day, that drove me to conclude that all the MySQL fans were crazy, and I decided to use Postgres at home, since Windows != server, and having done quite enoug…
Re: MySQL Editions
#84Re: MySQL Editions
#85Earlier quoted context omitted.
You publish a benchmark that says how inefficient this makes MySQL, and then that "feature" goes away.
I was more concerned about the copyright repercussions on clean-room reverse engineering the protocol. Obviously the protocol includes copyrightable information, now.
In fact if you spend much time thinking about this it isn't at all hard to come up with a lot of scenarios that law doesn't have an answer for, in theory or in practice.
Re: MySQL Editions
#86Earlier quoted context omitted.
A nice fiction. The reality is that copyright covers verbatim copying. If you read a book and write a review, the term "derived work" makes English sense, but not legal sense. Similarly, if you read the MySQL code looking for magic words to say to the server to get it to give you data, saying those words is not copyright infringement. It's "learning", not "copying". If anyone used MySQL, I would write a BSD-licensed…
> Similarly, if you read the MySQL code looking for magic words to say to the server to get it to give you data, saying those words is not copyright infringement. It's "learning", not "copying". What would happen, if the protocol would require sending a picture of a picture of Mickey Mouse with each request (or some copy-righted novel)?
In short, it's fair use.
Re: MySQL Editions
#87Earlier quoted context omitted.
MySQL is dual-licensed. If you download the community server, it's GPL licensed. If you want to distribute MySQL as part of your application, then your application may have to be GPL licensed as well, which is often undesirable. ISVs and others that need to distribute MySQL can buy one of the commercial editions to get it under a non-GPL license. If you're worried about the future, Oracle agreed to maintain the dual-…
If my PHP connects to a mysql database on the same host, and I sell that host as a product, I need to release that php code?
If you are redistributing it (you ship it to your customers and they deploy it on their servers) I would find a lawyer.
Re: MySQL Editions
#88Time to start boning back up of Postgres, I guess.
Re: MySQL Editions
#89Earlier quoted context omitted.
> Similarly, if you read the MySQL code looking for magic words to say to the server to get it to give you data, saying those words is not copyright infringement. It's "learning", not "copying". What would happen, if the protocol would require sending a picture of a picture of Mickey Mouse with each request (or some copy-righted novel)?
That's been tested in court before, in Sega v. Accolade ( http://en.wikipedia.org/wiki/Sega_v._Accolade ). (You had to display a Sega logo before your game could run, so you had to have their logo in your code) In short, it's fair use.
Re: MySQL Editions
#90Embedded Database6
6 MySQL Classic Edition is not available as an Annual Subscription. ISVs, OEMs and VARs can purchase a license to use as an embedded database.