Server license question

Hi,

If I install a mysql community server on my home computer only one time for any of my clients who work with my app to connect sporadically and remotely to that server, is mysql then totally for free and gratis? Or must I pay or do something uncommon in that case?

if you derive income from this usage then you may be subject to the mysql requirements to own a commercial license
http://www.mysql.com/about/legal/licensing/oem/

its one reason I don’t tend to use mysql - postgresql literally says “free for any use” - commercial, open source they don’t care

IF I had a say in this thats what I’d tell you to use
https://www.freebsd.org/doc/en/articles/bsdl-gpl/article.html

This is a pity.

I will have to switch to postgresql from mysql then. But I like mysql because it’s easy to work.

I have to check if I can backup mysql data and restore in postgresql.

I once installed postgresql on my Mac, but it seems complicated, because it created another user account on my Mac. I don’t know if I did anything wrong.

Is it true that postgresql is native to Mac? How can I connect to postgresql then with Xojo. I must check out if it works if I enter 127.0.0.1 in Xojo.

Do you know if I can connect to postgresql from the Terminal on any Mac?

Payam - this seems very relevant to your question:

http://stackoverflow.com/questions/225987/can-someone-explain-mysqls-license-and-what-it-means-to-closed-source-developme

[quote=116771:@Payam Arzani]This is a pity.
I will have to switch to postgresql from mysql then. But I like mysql because it’s easy to work.
[/quote]
Postgresql is quite straight forward now as well
http://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Maybe

This is actually a reasonable security measure
But you don’t ever have to use that account

It is
I use it all the time

I download their package & just use the tools for postgres admin
No terminal required
But once you installed there is also a cmd line client you can use

Postgresql should be straight forward to install, especially with the enterpriseDB install package.

I found a nice video that goes over the install process link.

as far as connecting to it from Xojo, the doc’s provide a nice example link.

in addition, you will find the PGAdmin tool very helpful administrative and maintenance tool.

Also, if you’re looking to try out Postgres, I’m told this is a very easy way to “get your feet wet”.

http://postgresapp.com

I am now installing postgresql. Goodbye mysql!

Thanks everyone for your help!

Postgresql has some VERY nice features that mysql doesn’t - and the simple “for any use license” is really clear & easy to understand :stuck_out_tongue:

There is also a book written to program PostgreSQL with Xojo for the Desktop at Desktop PostgreSQL Xojo Book

I would suggest that You check out MariaDB: https://mariadb.org/

The people who created MySQL now develop MariaDB. The knowledge of MySQL can be applied to MariaDB.

Stop! Isn’t MySQL LGPL? The GNU Lesser General Public License allows you to mix closed-source with open-source?

http://dev.mysql.com/doc/refman/5.7/en/license-gnu-lgpl-2-1.html

[quote=116863:@Tomas Jakobs]Stop! Isn’t MySQL LGPL? The GNU Lesser General Public License allows you to mix closed-source with open-source?

http://dev.mysql.com/doc/refman/5.7/en/license-gnu-lgpl-2-1.html[/quote]
That’s just for third party components which are included in MySQL.

[quote=116854:@Dennis Wallentin]I would suggest that You check out MariaDB: https://mariadb.org/
The people who created MySQL now develop MariaDB. The knowledge of MySQL can be applied to MariaDB.[/quote]

It has many of the same licensing issues as MySQL
And, IMHO, PostgreSQL is a much more capable database at any rate