-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
B4J Question MS Sql or MySql/Maria DB?
- Thread starter LucaMs
- Start date
- Similar Threads Similar Threads
Trusting a 12 yo hd - now that is optimism!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)
Upvote
0
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?
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?
Upvote
0
Sure, use HeidiSQL
You have another XAMPP or WAMPP alternative I tested thanks to aeric and I like it¡¡ Laragon¡¡¡
Upvote
0
Yes, it is a cheat using Laragon and single adminer PHP file as a web based management tool. It’s lightning fast!
Upvote
0
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:
codingsight.com
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
Last edited:
Upvote
0
Installation guide:
www.mariadbtutorial.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
Upvote
0
web server:
www.sitepoint.com
www.howtogeek.com
examples.javacodegeeks.com
nodejs.org
etc etc..
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
Node.js — Download Node.js®
Node.js® is a JavaScript runtime built on Chrome's V8 JavaScript engine.
nodejs.org
etc etc..
Last edited:
Upvote
0
Installation guide:
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.
I see you know MariaDb well
Is there a version that can also be used for free in commercial applications?
Upvote
0
MariaDB Licenses
Copy of the GNU General Public License, Version 2 for MariaDB Software.
mariadb.com
Last edited:
Upvote
0
@Peter Simpson knows the answer. He has talked about it but I can't find the post right now
Last edited:
Upvote
0
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;
.
That Oracle gives you something for free, I don't believe it even if I see it written and countersigned by Ellison
Upvote
0
read this about your questions about MySQL.
www.mysql.com
MySQL :: Commercial License for OEMs, ISVs and VARs
Upvote
0
B4X:
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
Upvote
0
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.read:
MySQL :: MySQL Community Edition
unless you are doing a GPL based application, then its better if you use mariaDB.
Upvote
0
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.
Upvote
0
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.
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.
Upvote
0
Similar Threads
- Article
- Article
- Article
