-
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
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 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.
Upvote
0
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)
Upvote
0
No longer, it is standalone (i have been using it since 2008 R2 and never i had anything related to IIS)
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.
Upvote
0
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).
Upvote
0
? you dont need iis
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)
Upvote
0
Yes, I understood your previous post; in the past it was like that, which is also why I don't like MS Sql server.
Upvote
0
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.
Upvote
0
you should try linux, i mean you are going to create a webapp that is going to be on linux OR windows server 2016 +
Upvote
0
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
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.
For large volumes of data of course there are other alternatives, but I would never use MSSQL.
Upvote
0
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.
Upvote
0
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.
Upvote
0
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
Best Regards
Upvote
0