Web Application VS Windows Application

scottalanmiller

ok, but i just search on the internet about this mariaDB, i found that it is different than mysql

Yes, it is better. But it is what people CALL MySQL, you see. It's a fork that replaced it. Nearly all Linux distros ship MariaDB as MySQL.

scottalanmiller

@IT-ADMIN said:

Ok, let us just keep simplicity, let's call it mysql, i do not want to confuse myself especially i'm about to start a new project, i have to stick to what is familiar to me so that i can move forward

You need to understand this now, it will be worse later. MySQL is really silly to be discussing. You should be on MariaDB, it's that simple.

scottalanmiller

@IT-ADMIN said:

so ok, now for the DBMS we know that mysql on ubuntu is better than the one in windows and better than MS SQL Server, great

Yes, and MySQL on Ubuntu is MariaDB.

scottalanmiller

@IT-ADMIN said:

also there is a software called lamp (similar to wamp in windows)

LAMP is what there always was. WAMP was copying the Linux ecosystem to Windows for people who just refused to leave Windows. WAMP is a horrible idea Even Microsoft would say that.

scottalanmiller

@IT-ADMIN said:

i guess installing apache and mysql seperatly is more reliable than just install this ready to use application (i guess lamp only for testing and dev, in production envirnemnt we have to install things seperatly, isn't it)

WAMP is not a package, it is installing the components separately.

LAMP on Ubuntu is this command...

apt-get install mariadb httpd php

That's it.

IT-ADMIN

oh great, so what a about connecting to MariaDB, is it the same as mysql, the syntax, is it similar to mysql in every aspect ?? if no what are the differences ??

Dashrender

@scottalanmiller said:

@IT-ADMIN said:

i guess installing apache and mysql seperatly is more reliable than just install this ready to use application (i guess lamp only for testing and dev, in production envirnemnt we have to install things seperatly, isn't it)

WAMP is not a package, it is installing the components separately.

LAMP on Ubuntu is this command...
apt-get install mariadb httpd php
That's it.

Sure you manually have to install the components separately on Windows, but that command installs three things on Linux, you just are fortunate and able to install all of them in one command.
They are still three separate things.

IT-ADMIN

@scottalanmiller but i remember when i installed that linux application i type the following command (in their documentation)
apt-get -y install php5-gd php5-mysql php5 php5-cli apache2 libapache2-mod-php5 tshark mtr mysql-server php5-mcrypt librsvg2-bin gsfonts

so i think this command installed mysql not MariaDB, so i have to upgrade or something ??
i fear if i change mysql to MariaDB, this application will stop

scottalanmiller

@IT-ADMIN said:

oh great, so what a about connecting to MariaDB, is it the same as mysql, the syntax, is it similar to mysql in every aspect ?? if no what are the differences ??

It IS what everyone calls MySQL. All tools are the same. You dont' need to know that it is MariaDB at all. No differences at all.

scottalanmiller

@IT-ADMIN said:

@scottalanmiller but i remember when i installed that linux application i type the following command (in their documentation)
apt-get -y install php5-gd php5-mysql php5 php5-cli apache2 libapache2-mod-php5 tshark mtr mysql-server php5-mcrypt librsvg2-bin gsfonts

so i think this command installed mysql not MariaDB, so i have to upgrade or something ??
i fear if i change mysql to MariaDB, this application will stop

Most systems call MariaDB MySQL so that people don't learn new names.

IT-ADMIN

even if apt-get install mysql not apt-get install MariaDB ??

scottalanmiller

@IT-ADMIN said:

even if apt-get install mysql not apt-get install MariaDB ??

Correct. Unless you are on a really old version of Ubuntu. What's your version?

IT-ADMIN

14.04

scottalanmiller

@IT-ADMIN said:

14.04

Just as a side note, I'd update to current before you start a development project. No reason to be so far behind, and when developing it is that much more important not to rely on old stuff.

scottalanmiller

I'm looking, I've not used that old of Ubuntu is a while (year and a half about) and never run MySQL or MariaDB on Ubuntu. I know that Fedora moved to MariaDB in Fedora 19 and RHEL moved with RHEL 7. From what I can tell, Ubuntu might still be actually installing "old" MySQL by default, at least in the 14.04 era. How sad. Well, if that is what is default, that's fine.

IT-ADMIN

i installed 14.04 because it is a prerequisit in the doc of that software, for this reason i insalled that

scottalanmiller

@IT-ADMIN said:

i installed 14.04 because it is a prerequisit in the doc of that software, for this reason i insalled that

Of which software? I must have missed something.

scottalanmiller

If you are going to develop an application for internal use, you are going to put it on its own server, of course, right? So you would be starting with a VM that isn't used for any other purpose.

IT-ADMIN

@scottalanmiller ah ok, that is a good idea, because i had the intention to use the preexisting server, but now i changed my mind and just grab a new VM and do the dev on it

scottalanmiller

@IT-ADMIN said:

@scottalanmiller ah ok, that is a good idea, because i had the intention to use the preexisting server, but now i changed my mind and just grab a new VM and do the dev on it

Yes, every task should be on a discrete server. You never want to mix things unless absolutely necessary.

I'd start with Ubuntu 15.10 as a minimum. Ubuntu 16.04 is just a month away. And you can consider not using Ubuntu as well, but nothing wrong with Ubuntu.