B4J Question MS Sql or MySql/Maria DB?

LucaMs · Jul 29, 2021

Which of the two do you prefer to use?

EnriqueGonzalez · Jul 29, 2021

i love MS SQL, the dialect is very easy to understand and the license is also fairly easy to get.

You want non limited free non commercial? use developer edition
you want limited free commercial? use express edition
you want unlimited non free commercial? anything else.

you will be okey with ms sql express for hundreds (thousands maybe?) of customers.

with tools like SSMS or Azure Data Studio you will have an integrated IDE that will help you do backups and specifics of SQL SERVER at hand,

And! SQL Server is now Linux native, that means that you can install it everywhere.

LucaMs · Jul 29, 2021

Enrique Gonzalez R said:
i love MS SQL, the dialect is very easy to understand and the license is also fairly easy to get.

You want non limited free non commercial? use developer edition
you want limited free commercial? use express edition
you want unlimited non free commercial? anything else.

you will be okey with ms sql express for hundreds (thousands maybe?) of customers.

with tools like SSMS or Azure Data Studio you will have an integrated IDE that will help you do backups and specifics of SQL SERVER at hand,

And! SQL Server is now Linux native, that means that you can install it everywhere.

You have forgotten the cons.
1 - it's heavy
2 - tied to heavy IIS (at least when I was using it -many years ago - it was like that)

EnriqueGonzalez · Jul 29, 2021

LucaMs said:
tied to heavy IIS (

No longer, it is standalone (i have been using it since 2008 R2 and never i had anything related to IIS)

LucaMs said:
1 - it's heavy

What do you mean by heavy? yes it is heavier than the other 2, but i dont think 6gb will dent a scratch wherever you are installing it.

LucaMs · Jul 29, 2021

Enrique Gonzalez R said:
What do you mean by heavy?

Mainly on startup.
And also thinking about the slow start of IIS...!

It is more or less the same with MS VS: great, powerful, lots of features but heavy and slow (not only in startup).

EnriqueGonzalez · Jul 29, 2021

LucaMs said:
And also thinking about the slow start of IIS...!

? you dont need iis

LucaMs said:
Mainly on startup.

i think you are talking about ms sql 1999 with windows me or something like that. i use it with docker and starts with 15 seconds (i guess it is even faster in linux)

LucaMs · Jul 29, 2021

Enrique Gonzalez R said:
? you dont need iis

Yes, I understood your previous post; in the past it was like that, which is also why I don't like MS Sql server.

LucaMs · Jul 29, 2021

Enrique Gonzalez R said:
i think you are talking about ms sql 1999 with windows me or something like that. i use it with docker and starts with 15 seconds (i guess it is even faster in linux)

Actually I have IIS and MS Sql installed on this (elderly) laptop as well.
It's been so long since I didn't start them that... I don't remember their versions.

EnriqueGonzalez · Jul 29, 2021

LucaMs said:
. I don't remember their versions.

SELECT @@VERSION

LucaMs · Jul 29, 2021

LucaMs said:
Actually I have IIS and MS Sql installed on this (elderly) laptop as well.
It's been so long since I didn't start them that... I don't remember their versions.

LucaMs · Jul 29, 2021

LucaMs said:
View attachment 117185

View attachment 117186

Note: laptop 12 yo - Win7 !

EnriqueGonzalez · Jul 29, 2021

LucaMs said:
Note: laptop 12 yo - Win7 !

you should try linux, i mean you are going to create a webapp that is going to be on linux OR windows server 2016 +

LucaMs · Jul 29, 2021

Enrique Gonzalez R said:
you should try linux, i mean you are going to create a webapp that is going to be on linux OR windows server 2016 +

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 )

TILogistic · Jul 30, 2021

if you only choose between these 2 databases I prefer MariaDB or PostgreSQL.

For large volumes of data of course there are other alternatives, but I would never use MSSQL.

EnriqueGonzalez · Jul 30, 2021

oparra said:
but I would never use MSSQL.

There is no real reason to not use MSSQL, except of course, emotionally, you hate microsoft, that i admit it is kinda a good reason.

TILogistic · Jul 30, 2021

I don't hate Microsoft, but I do hate their policies.

aeric · Jul 30, 2021

If I develop with .NET, I will go for MS SQL. If I develop with PHP or B4X, I go for MySQL. Currently, I am focusing on the latter.

Sandman · Jul 30, 2021

LucaMs said:
I'm afraid to install new stuff on a HD that is 12 years old

Do what I tend to do in those situations: Just buy a new HD and put into the machine. No baggage to be careful with, if the installation goes bad you can wipe the drive clean and give it another go. If you're happy and need stuff from the old HD, just put it in an enclosure and plug it in as an external USB drive.

Plus, if you decide you didn't like Linux at all, just put back your old rusty HD and chug along with Win7.

aeric · Jul 30, 2021

When there is a need to switch to another DBMS, I will dump the SQL script and modify it a bit. Boom, my application is now supporting both.

virpalacios · Aug 1, 2021

In a Full Windows Environment I use MS SQLServer Express, however If there is mixed one (web and CS) I preffers MariaDB (you get tons of samples in php code). In Addition to it our programmers are very conforable with both.

Best Regards

B4J Question MS Sql or MySql/Maria DB?

Expert

Well-Known Member

Expert

Well-Known Member

Expert

Well-Known Member

Expert

Expert

Well-Known Member

Expert

Expert

Well-Known Member

Expert

Expert

Well-Known Member

Expert

Expert

Expert

Expert

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency