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?
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?
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
[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