Web Application VS Windows Application

IT-ADMIN

so he planned to use SQL SERVER ? i told him that we may install separably apach and MySQL and phpmyadmin in a linux server, at least it will be better that easyphp or wamp (designed for personnel use) but i cannot persuade him

scottalanmiller

@IT-ADMIN said:

i'm very sorry guys, i was in a meeting regarding this project,

actually i was informed that this project will not be only a payroll application but it should be kind of a small ERP that include all modules that our enterprise is working on, it is the best news i heard today, because we will migrate from VB.net to a whole PHP application, because we faced a limitation with .net because the boss want to access the portal from his mobile, so the decision was made to start a web application from scratch, i think it was the best decision ever made in my company,

While I am 100% in support of PHP over .NET here, I do have to point out that .NET has no limitation on mobile, that's a mistake that someone made in that meeting. .NET can do anything PHP can do there and more.

dafyre

I find that MySQL is far, far more reliable than Microsoft's SQL Server. To me, it seems easier to manage and comes without all of the extra overhead in licensing costs.

scottalanmiller

@IT-ADMIN said:

so what do you think guys of SQL Server VS MySQL?? because my collegue told me that we gonna use SQL server because MySQL is not reliable and supposed to manage small size databases

MySQL is totally reliable and that guy is nuts and shouldn't be consulted. There are many good options. SQL Server is probably nearly the least viable. Oracle would be worse. DB2 worse. But that's about it.

Do you need relational data (I think so)
If so, my first pick would normally be PostgreSQL, then MariaDB, Firebird, Sybase (if you wanted to pay)

scottalanmiller

@IT-ADMIN said:

so he planned to use SQL SERVER ? i told him that we may install separably apach and MySQL and phpmyadmin in a linux server, at least it will be better that easyphp or wamp (designed for personnel use) but i cannot persuade him

he's clearly not even slightly technical, why is he involved?

IT-ADMIN

@scottalanmiller said:

@IT-ADMIN said:

so he planned to use SQL SERVER ? i told him that we may install separably apach and MySQL and phpmyadmin in a linux server, at least it will be better that easyphp or wamp (designed for personnel use) but i cannot persuade him

he's clearly not even slightly technical, why is he involved?

he is the boss hhhh, the developer, i will only help him in his development

IT-ADMIN

@scottalanmiller said:

@IT-ADMIN said:

i'm very sorry guys, i was in a meeting regarding this project,

actually i was informed that this project will not be only a payroll application but it should be kind of a small ERP that include all modules that our enterprise is working on, it is the best news i heard today, because we will migrate from VB.net to a whole PHP application, because we faced a limitation with .net because the boss want to access the portal from his mobile, so the decision was made to start a web application from scratch, i think it was the best decision ever made in my company,

While I am 100% in support of PHP over .NET here, I do have to point out that .NET has no limitation on mobile, that's a mistake that someone made in that meeting. .NET can do anything PHP can do there and more.

does VB.net application .exe can be hosted and accessed in android devices ??? (i'm not talking about ASP.NET)

JaredBusch

@IT-ADMIN said:

@scottalanmiller said:

@IT-ADMIN said:

i'm very sorry guys, i was in a meeting regarding this project,

actually i was informed that this project will not be only a payroll application but it should be kind of a small ERP that include all modules that our enterprise is working on, it is the best news i heard today, because we will migrate from VB.net to a whole PHP application, because we faced a limitation with .net because the boss want to access the portal from his mobile, so the decision was made to start a web application from scratch, i think it was the best decision ever made in my company,

While I am 100% in support of PHP over .NET here, I do have to point out that .NET has no limitation on mobile, that's a mistake that someone made in that meeting. .NET can do anything PHP can do there and more.

does VB.net application .exe can be hosted and accessed in android devices ??? (i'm not talking about ASP.NET)

You only said .Net not VB.Net Thus the confusion.

IT-ADMIN

because the current application we are using is .exe (VB.NET) for this reason we decided to rebuilt the project using PHP (web application)

IT-ADMIN

@JaredBusch said:

@IT-ADMIN said:

@scottalanmiller said:

@IT-ADMIN said:

i'm very sorry guys, i was in a meeting regarding this project,

actually i was informed that this project will not be only a payroll application but it should be kind of a small ERP that include all modules that our enterprise is working on, it is the best news i heard today, because we will migrate from VB.net to a whole PHP application, because we faced a limitation with .net because the boss want to access the portal from his mobile, so the decision was made to start a web application from scratch, i think it was the best decision ever made in my company,

While I am 100% in support of PHP over .NET here, I do have to point out that .NET has no limitation on mobile, that's a mistake that someone made in that meeting. .NET can do anything PHP can do there and more.

does VB.net application .exe can be hosted and accessed in android devices ??? (i'm not talking about ASP.NET)

You only said .Net not VB.Net Thus the confusion.

ah sorry for that, i just said .NET because in the same sentence i mention which .NET i'm referring to, sorry for confusion

JaredBusch

@IT-ADMIN said:

because the current application we are using is .exe (VB.NET) for this reason we decided to rebuilt the project using PHP (web application)

Basically, since you are abandoning vb.net, you should abandon Windows completely.

Use a LAMP stack then since those are very simple and familiar to many people.

Spin up a CentOS 7 box, install MariaDB (replacement for MySQL), PHP, and Apache.

IT-ADMIN

no. we cannot made such transition right now, we are still relying on microsoft,

JaredBusch

@JaredBusch said:

Spin up a CentOS 7 box, install MariaDB (replacement for MySQL), PHP, and Apache.

Start with CentOS 7 Minimal

yum -y installl epel-release php mariadb httpd

This will get the basics.

IT-ADMIN

is there any diffirence btw mysql on linux and mysql on windows in term of performance and reliability ?? the same question for apach ??

IT-ADMIN

@JaredBusch said:

@JaredBusch said:

Spin up a CentOS 7 box, install MariaDB (replacement for MySQL), PHP, and Apache.

Start with CentOS 7 Minimal
yum -y installl epel-release php mariadb httpd
This will get the basics.

sorry but i'm not familliar with this, it is new for me and there is not time for learning from scratch, the only option i have is mysql or sql server

JaredBusch

@IT-ADMIN said:

@JaredBusch said:
@JaredBusch said:

Spin up a CentOS 7 box, install MariaDB (replacement for MySQL), PHP, and Apache.

Start with CentOS 7 Minimal
yum -y installl epel-release php mariadb httpd
This will get the basics.
sorry but i'm not familliar with this, it is new for me and there is not time for learning from scratch, the only option i have is mysql or sql server

Are you installing mysql on windows? Because netiher of those choices are an OS.

IT-ADMIN

on both

scottalanmiller

@IT-ADMIN said:

@JaredBusch said:
@JaredBusch said:

Spin up a CentOS 7 box, install MariaDB (replacement for MySQL), PHP, and Apache.

Start with CentOS 7 Minimal
yum -y installl epel-release php mariadb httpd
This will get the basics.
sorry but i'm not familliar with this, it is new for me and there is not time for learning from scratch, the only option i have is mysql or sql server

Why are those your options? Neither is really a valid option today (for most things.) MariaDB replaced MySQL in nearly all cases a few years ago. MariaDB is the actually database 90% of people mean when they say MySQL.

IT-ADMIN

but i do not know in which one i should host my future database

i have one in windows in easyPHP, and i have apache and mysql and phpmyadmin on ubuntu

scottalanmiller

@IT-ADMIN said:

is there any diffirence btw mysql on linux and mysql on windows in term of performance and reliability ?? the same question for apach ??

Yes, MariaDB (what you call MySQL) is faster and more stable on Linux. It's also much easier.

yum -y install mariadb

That's all you need.