B4J Question MS Sql or MySql/Maria DB?

[LucaMs]

Which of the two do you prefer to use?

 

[Star-Dust]

On april 27th I'll be 67. Better to stop programming, I'm outdated ???. W95 application...

You are experienced not obsolete

 

[MrKim]

I'm afraid to install new stuff on a HD that is 12 years old (I'm shaking ? because I know that in not long - a few weeks? - it will die )

Trusting a 12 yo hd - now that is optimism!

 

[MrKim]

I use SQL server because I am used to it and the tools are great. I have an online DB for an app that is MYSQL and I found it cumbersome to set up and use. I installed MySQL a long time ago (15-20yrs?) and found working from the command line impossible.
So let me ask this. If I were to set up MySQL on my local computer for testing what are the steps? What tools would you use? Is there now an equivalent to SSMS for mySQL? Can I setup and test a DB locally and then script the schema and maybe some of the data to transfer to the net as easily as I can do these things in SQL Server?

 

[LucaMs]

If I were to set up MySQL on my local computer for testing what are the steps? What tools would you use? Is there now an equivalent to SSMS for mySQL?

XAMPP (or WAMP)

Can I setup and test a DB locally and then script the schema and maybe some of the data to transfer to the net as easily as I can do these things in SQL Server?

"as easily as" I don't know; as you wrote:

because I am used to it

 

[josejad]

Can I setup and test a DB locally and then script the schema and maybe some of the data to transfer to the net as easily as I can do these things in SQL Server?

Sure, use HeidiSQL

You have another XAMPP or WAMPP alternative I tested thanks to aeric and I like it¡¡ Laragon¡¡¡

 

[aeric]

Sure, use HeidiSQL

You have another XAMPP or WAMPP alternative I tested thanks to aeric and I like it¡¡ Laragon¡¡¡

Yes, it is a cheat using Laragon and single adminer PHP file as a web based management tool. It’s lightning fast!

 

[tigrot]

Scripting is Easy with every SQL Engine.

 

[TILogistic]

You don't need any web server to test Mysql or Mariadb, this installs independently of the web server.

Only if you want to test some web programming language with MySQL, you need a web server.

Also you have many GUI tools for RDBMS MySQL / MariaDB

example:

10 Best MySQL GUI Tools - {coding}Sight

An oveview of 10 best GUI tools for developers and DBAs that allow to design, create, and manage MySQL databases as effectively as possible.

codingsight.com

 

[TILogistic]

Installation guide:

MySQL :: MySQL Installation Guide :: Preface and Legal Notices

dev.mysql.com

Getting Started with MariaDB

This section helps you get started with MariaDB by providing you with the easy-to-follow steps of installing and connecting to MariaDB server.

www.mariadbtutorial.com

 

[TILogistic]

web server:

How to Install Apache Web Server on Windows — SitePoint

A step-by-step guide to manually installing the Apache Web Server on Windows, with links to further reading and resources.

www.sitepoint.com

How to Install IIS on Windows 8, 10, or 11

IIS is important for web developers, but it doesn't come installed by default. Fortunately, that is easy to remedy.

www.howtogeek.com

How to Install Jetty Application Server - Java Code Geeks

Jetty is an open-source Servlet container and Application Server which is known to be lightweight, portable, robust, flexible, extensible and providing

examples.javacodegeeks.com

Apache Tomcat® - Welcome!

Node.js — Download Node.js®

Node.js® is a free, open-source, cross-platform JavaScript runtime environment that lets developers create servers, web apps, command line tools and scripts.

nodejs.org

etc etc..

 

[amorosik]

Installation guide:

MySQL :: MySQL Installation Guide :: Preface and Legal Notices

dev.mysql.com

Getting Started with MariaDB

This section helps you get started with MariaDB by providing you with the easy-to-follow steps of installing and connecting to MariaDB server.

www.mariadbtutorial.com

I see you know MariaDb well
Is there a version that can also be used for free in commercial applications?

 

[TILogistic]

About MariaDB Software | MariaDB Documentation

mariadb.com

Licensing FAQ | General Resources | MariaDB Documentation

mariadb.com

 

[josejad]

Is there a version that can also be used for free in commercial applications?

@Peter Simpson knows the answer. He has talked about it but I can't find the post right now

 

[amorosik]

In mysql (oracle) you should read the free licenses community version.
I just know that Oracle is reporting their policy changes and support for the community version.

see;

About MariaDB Software

Overview information about MariaDB Server and related software.

mariadb.com

.

That Oracle gives you something for free, I don't believe it even if I see it written and countersigned by Ellison

 

[TILogistic]

That Oracle gives you something for free, I don't believe it even if I see it written and countersigned by Ellison

read:

MySQL :: MySQL Community Edition

www.mysql.com

It is available under the GPL license and is supported by a huge and active community of open source developers

 

[TILogistic]

read this about your questions about MySQL.

MySQL :: Commercial License for OEMs, ISVs and VARs

www.mysql.com

 

[amorosik]

Q3: As a commercial OEM, ISV or VAR, when should I purchase a commercial license for MySQL software? 

A: OEMs, ISVs and VARs that want the benefits of embedding commercial binaries of MySQL software in their commercial
applications but do not want to be subject to the GPL and do not want to release the source code for their proprietary applications
should purchase a commercial license from Oracle.  Purchasing a commercial license means that the GPL does not apply, and a
commercial license includes the assurances that distributors typically find in commercial distribution agreements.

Then, if your software is not open source, you need a commercial license

 

[EnriqueGonzalez]

read:

MySQL :: MySQL Community Edition

www.mysql.com

it is very important to notice that mysql is not free, if you add mysql to your develpment process by the license you have to disclose all your code.

unless you are doing a GPL based application, then its better if you use mariaDB.

 

[tigrot]

Q3: As a commercial OEM, ISV or VAR, when should I purchase a commercial license for MySQL software?

A: OEMs, ISVs and VARs that want the benefits of embedding commercial binaries of MySQL software in their commercial
applications but do not want to be subject to the GPL and do not want to release the source code for their proprietary applications
should purchase a commercial license from Oracle.  Purchasing a commercial license means that the GPL does not apply, and a
commercial license includes the assurances that distributors typically find in commercial distribution agreements.

Then, if your software is not open source, you need a commercial license

I don't think so. The agreement speaks of embedding code. Nobody embeds proprietary code. If you use a free interface, the engine runs standalone and so it's free of charge as well.

 

[EnriqueGonzalez]

HeidiSQL is good, (XAMPP, WAMP, LARAGON arent sql processors, they are php webservers that you cant use with b4j development, so you have to have both)
but heidiSQL really falls short to the capabilities of SSMS.

Also SQL Server have Azure Data Studio for people like me that uses linux and also SQL CMD Tools for people that only have a headerless os or are in an SSH enviroment.