MySQL 4 noobs

[Kevin_J_Baird]

Honestly, I’m not familiar with PostgreSQL. Looks interesting, I’ll read up on it.

K

[AndrewMyers]

@Igor Murashkin

For MySQL it’s only commercially free if you are using it with PHP (because their licenses are “incompatible”).

Huh? You can use MySQL for whatever the hell you want – the GPL’s viral restrictions only kick in if you plan to distribute your code (as opposed to use it to drive your website).

@Kevin_J_Baird

Honestly, I’m not familiar with PostgreSQL. Looks interesting, I’ll read up on it.

It’s solid. Historically, MySQL has made raw speed the primary focus, while PostgreSQL has aimed for feature-depth. MySQL has a much larger userbase, as it’s wicked fast, and easy to get rolling with – if you don’t care about transactions or referential integrity, MySQL is generally the best choice. (If you do care about that stuff, it’s a ton better than it used to be, and still a worthy contender – however, PostgreSQL is very mature in that regard).

[XPav]

@Igor Murashkin

For MySQL it’s only commercially free if you are using it with PHP (because their licenses are “incompatible”).

Uh, no Igor.

You can use it all you want without giving anyone crap. Hell, you can hack it up and as long as you don’t give it to anyone, you don’t have to do crap.

[Igor_Muravyev]

@Andrew Myers

[quote=Igor Murashkin]For MySQL it’s only commercially free if you are using it with PHP (because their licenses are “incompatible”).

Huh? You can use MySQL for whatever the hell you want – the GPL’s viral restrictions only kick in if you plan to distribute your code (as opposed to use it to drive your website).[/quote]

Andrew, I did say commercial license :). Their regular one is GPL,
links:
http://www.mysql.com/company/legal/licensing/commercial-license.html
http://www.mysql.com/company/legal/licensing/opensource-license.html

As opposed to the PostgreSQL license:
http://www.postgresql.org/about/licence

@Andrew Myers

It’s solid. Historically, MySQL has made raw speed the primary focus, while PostgreSQL has aimed for feature-depth. MySQL has a much larger userbase, as it’s wicked fast, and easy to get rolling with – if you don’t care about transactions or referential integrity, MySQL is generally the best choice. (If you do care about that stuff, it’s a ton better than it used to be, and still a worthy contender – however, PostgreSQL is very mature in that regard).

What’s actually sad is that the two databases are slowly converging. MySQL is planning to add things like triggers, stored procedures, views, to name a few. PostgreSQL is getting faster and faster with every version. Ultimately the difference will be the licensing and not much else.

[AndrewMyers]

@Igor Murashkin

Andrew, I did say commercial license :).

Could you parse out your original sentence for me, please? I’m stupid and can’t figure out what the hell you’re talking about.

[Igor_Muravyev]

@Andrew Myers

[quote=Igor Murashkin]Andrew, I did say commercial license :).

Could you parse out your original sentence for me, please? I’m stupid and can’t figure out what the hell you’re talking about.[/quote]

No need to be touchy :roll:

[AndrewMyers]

@Igor Murashkin

No need to be touchy :roll:

I’m not being touchy, I just don’t understand what you’re talking about re: MySQL licensing and PHP (and I don’t feel like reading up on all their licensing terms to figure it out).

[Igor_Muravyev]

Ok, if you are being serious…

@MySQL.com

What is the GPL License Exception for PHP?

Because PHP and MySQL use different incompatible open source licenses, we have created a special exception to encourage and promote the use of MySQL in the PHP community. MySQL AB gives permission to distribute derivative works that are formed with GPL-licensed MySQL software and with software licensed under version 3.0 of the PHP license. You must obey the GNU General Public License in all respects for all of the code used other than code licensed under version 3.0 of the PHP license.

There is also a more general exception which enables developers releasing software under other Free and Open Source software (“FOSS”) licenses to include the MySQL client libraries. This is known as the FOSS License Exception.

[XPav]

Of course, in all cases, the GPL only applies if you’re distributing the software with your own modifications to other people.

If you just want to use the damn thing, you can do whatever you want.