B4J Question MS Sql or MySql/Maria DB?

[LucaMs]

Which of the two do you prefer to use?

 

[ilan]

Difference between MySQL and MS SQL Server - GeeksforGeeks

A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.

www.geeksforgeeks.org

 

[TILogistic]

very good 2020

Difference between MariaDB and MS SQL Server - GeeksforGeeks

A Computer Science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.

www.geeksforgeeks.org

Note: New version MariaDB

It enables for stopping query execution.

Doesn’t block the database while backing up the data.

It is a highly secured and doesn’t allow any kind of database file manipulation while running.

 

[LucaMs]

Note that the question is not which one is better but which one do you prefer to use.

 

[TILogistic]

I understand

sorry

 

[ilan]

Note: New version MariaDB

It enables for stopping query execution.

Doesn’t block the database while backing up the data.

It is a highly secured and doesn’t allow any kind of database file manipulation while running.

very interesting. currently, i am using mariadb. from which version can I benefit from those features?

 

[TILogistic]

sorry @LucaMs

very interesting. currently, i am using mariadb. from which version can I benefit from those features?

MariaDB Administration

mariadb.com

we did a migration from Mysql to MariaDB of millions of records, and we have seen that its performance is excellent.
We did this because Mysql (Oracle) will stop maintaining and supporting the free version in the near future.

 

[Hanz]

Some people choose among the three sql servers by having their criteria first. What are the criteria or specifications they need for their applications? And from there, they identify which of the three is more relevant to them. They say, when you hunt for food in the forest, why will you shoot a rabbit or deer with a tank? Even one has heavenly and overwhelming features, if your need is just the basic ones, then, by all means, why not choose it?

 

[tigrot]

Hi everybody
I could be outdated but i go for ODBC, so customer has the chance to decide DB engine on the fly.

 

[LucaMs]

Hi everybody
I could be outdated but i go for ODBC, so customer has the chance to decide DB engine on the fly.

I think it would be "a little" difficult if I create a MySql db for the customer(s) and then he connects via ODBC... to an MS SQL Server ?

 

[tigrot]

I mean app side . I have an external table to define sql for creation under different engine. So the DB is created at first startup for the Select ed environment.

 

[tigrot]

What I do is to create SQL's on a runtime table so different dialects can coexist. It's a hard work but my main customer asks engine independence. He sells my work for Industry 4.0 to many users.

 

[Swissmade]

Using both in a Security Application.
Some Clients using there MSSQL Server what is a must.
This application is using both MSSQL and MariaDB by selection.

Because of the difference from this DB's I prefer MariaDB what is more easy to work with.

 

[tigrot]

Some one uses PARADOX as well???

 

[LucaMs]

Some one uses PARADOX as well???

 

[tigrot]

My old first PC app used DBIII. Previously I wrote for DBMS, a database engine for Unisys/Burroughs. I was one of a small bunch of IT men in Italy to use it. In 1985 or so.

 

[LucaMs]

My old first PC app used DBIII. Previously I wrote for DBMS, a database engine for Unisys/Burroughs. I was one of a small bunch of IT men in Italy to use it. In 1985 or so.

I was lucky enough to use even... DBIV !!! ?

 

[tigrot]

IBM S/1 was the most challenging system. I had to write every low level disk file handler and a ISAM support as well. As native EDL language support was only direct access to single 256 bytes blocks.

 

[tigrot]

Keep the manual for you descendant, they won't believe you have done???

 

[LucaMs]

?

(it is an indication of my old age)

 

[tigrot]

View attachment 117336

?

(it is an indication of my old age)

My first system was IBM 360/125 tape and 80 col's cards. No disk at all.