Advantages ASP.NET/SQL Server vs. PHP/MySql
-
Stephan Hoppe wrote:
why it is better to use the MS technology
I agree with a lot of what Jeremy is saying. The bottom line is what is the skill set that is going to support it? You will make yourself far more respected if you help them find the right solution. Be that what you know or not. If it is PHP then go help do a PHP solution if you want to do it. Is cost really the driver to that extent. My hosting provider is $10 a month and does include ASP.net and SQL server as well as PHP (4 and 5) and mysql. If $120 is a show stopper then the answer probably is a PHP 4 with mysql on one of the $16/year sites.
Michael A. Barnhart wrote:
Is cost really the driver to that extent. My hosting provider is $10 a month and does include ASP.net and SQL server as well as PHP (4 and 5) and mysql. If $120 is a show stopper then the answer probably is a PHP 4 with mysql on one of the $16/year sites.
I'm actually curious about this. If you're using a web host with SQL Server support, are you still not responsible for buying the CALs for your company to use it?
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
-
I knew I will ask the right people :-D Thanks a lot for your answers!!!
Jeremy Falcon wrote:
Stephan Hoppe wrote: 2. In PHP I had php skript within the html code (not only in html of course). At the end it was difficult to handle the whole source. I like the fact that ASP.NET has the code behind feature. This is a design issue. Even in PHP 3.0 they had facilities to achieve this. Although, I think ASP.NET allows the integrating to go a bit more smoothy, but it's not impossible provided you understand the design principles behind it rather than syntax.
I would say you are right. I had to finish a PHP project within three weeks without knowing anything about PHP. So I am sure it was my fault.
Jeremy Falcon wrote:
Stephan Hoppe wrote: 4. I wasn't able to develop assemblies or dlls which handle the business logic code, etc. This is still a design issue. There's nothing stopping you from acheiveing similar functionality by separating your logic tiers into different files, etc.
Of course I had classes and differnt files, but PHP didn't give me the ability to create a dlls.
Jeremy Falcon wrote:
Stephan Hoppe wrote: 5. The IDE support for ASP.NET and SQL Server is much better. I worked with an Text Editor and PhpMyAdmin to write a PHP webapplication what wasn't nice. I'd suggest you do some shopping around. You can't compare VS to a plain text editor, that's just being totally unfair.
You are right it is unfair comparing VS with a text editor. At the end I guess I have to question myself if I am able to give them the same kind of quality in PHP/MySql then in ASP.NET/SqlServer. With Typo3 or PhpNuke the main work is already done and I guess I should be able to give them pretty much the same quality. Thanks again! Stephan
Come to think of it. If SQL Server ends up being the major catch (price wise) you could always use ASP.NET with a MySQL backend. Just another option.
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
-
Okay my PHP knowledge is PHP 3.0 so whenever I am wrong please feel free to correct me. 1. When I worked with PHP I didn't like the fact that I wasn't able to debug my project. Writing debug code to find a bug was a pain in the ... 2. In PHP I had php skript within the html code (not only in html of course). At the end it was difficult to handle the whole source. I like the fact that ASP.NET has the code behind feature. 3. Object oriented programming was possible in PHP 3.0 but limited. 4. I wasn't able to develop assemblies or dlls which handle the business logic code, etc. 5. The IDE support for ASP.NET and SQL Server is much better. I worked with an Text Editor and PhpMyAdmin to write a PHP webapplication what wasn't nice. Don't understand me wrong, I am sure PHP has its pros but for me ASP.NET works better. The only thing I don't like about ASP.NET + SQL Server are the hosting cost. Stephan
Stephan Hoppe wrote:
The only thing I don't like about ASP.NET + SQL Server are the hosting cost.
Do they need a dedicated server? If not, there are a lot of good, cheap hosts out there. Ex: http://www.webhost4life.com/[^]
Jon Sagara When I grow up, I'm changing my name to Joe Kickass! My Site | My Blog | My Articles
-
Michael A. Barnhart wrote:
Is cost really the driver to that extent. My hosting provider is $10 a month and does include ASP.net and SQL server as well as PHP (4 and 5) and mysql. If $120 is a show stopper then the answer probably is a PHP 4 with mysql on one of the $16/year sites.
I'm actually curious about this. If you're using a web host with SQL Server support, are you still not responsible for buying the CALs for your company to use it?
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
I think there is another type of license. Per CPU, or something. These companies must have enough volume to cover their asses expenses.
Jon Sagara When I grow up, I'm changing my name to Joe Kickass! My Site | My Blog | My Articles
-
Come to think of it. If SQL Server ends up being the major catch (price wise) you could always use ASP.NET with a MySQL backend. Just another option.
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
I just wrote an email to the project manager to get the answer why they want Linux. Thanks. Stephan
-
Michael A. Barnhart wrote:
Is cost really the driver to that extent. My hosting provider is $10 a month and does include ASP.net and SQL server as well as PHP (4 and 5) and mysql. If $120 is a show stopper then the answer probably is a PHP 4 with mysql on one of the $16/year sites.
I'm actually curious about this. If you're using a web host with SQL Server support, are you still not responsible for buying the CALs for your company to use it?
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
Jeremy Falcon wrote:
you still not responsible for buying the CALs for your company to use it?
Jon's answer covers 99% of web usage. Now if my company was using clients that directly hit the SQL server I would be most likely violating the hosting contract that I have. For that class of hosting, we would not be talking the fees I have quoted. As it stands, I can set up database access via ASP.net, PHP web pages or web service calls and that is covered in the fees.
-
I am currently working on a proposal for a CMS. One requirement from the customer is that they want the CMS running on a LINUX webserver. They don't have their own webserver what would explain why they want it on LINUX. My guess is they don't want to spend a lot of money for hosting (it is just a small non-profit organization). My idea is to offer them an open source CMS like DotNetNuke with the customizing they need. I know I could use Typo3 or PhpNuke, but my skills in PHP and MySql are not as strength as my ASP.NET and SQL Server skills (and I need to create some modules). However, I would like to explain them why it is better to use the MS technology but I don't know exactly what I should tell them because they are no IT people. From your point of view, what would you tell them? Thanks for your thoughts. Stephan
There are many differences and I believe it takes far less work in development and maintaining an ASP.NET site than you would spend to have the same benefits with PHP. I used PHP for a few years and will never use it again! I have flashback every time I open a can of spaghetti :) Anyway, putting personal preferences aside, there have been several wars on the difference here in the Lounge and a quick search might find a few of them. As for cost, that is a joke anymore. ASP.NET hosting is trivial in cost for many different places. If there host is only Linux, that is easy to change. Some mention the cost of SQL Server, but that is usually included in most hosting packages. If not, they usually have SQL Server Express which will work for most basic types of sites (such as DotNetNuke). There is even supposed to be a module out now to use MySql with DNN, so cost should not be a factor. Clean, clear, reusable code with great scalability and modular design all come for free in ASP.NET!
Rocky <>< Latest Code Blog Post: ASP.NET HttpException - Cannot use leading "..".. Latest Tech Blog Post: Microsoft Zune to be built by Toshiba
-
Stephan Hoppe wrote:
That's why I would like to offer them an ASP.NET solution and explain them why it would be better for them.
I hear you. But think about this... if you, being the expert and IT guru can't think of a reason maybe there isn't one outside of the fact that ASP.NET/SQL Server is what you know. With that being said, why not learn both? If you plan on being successful, I don't see how knowing both of them will hurt your business. Trust me when I say, you'll see that ASP.NET/SQL Server doesn't do everything the best way and the same goes for PHP/MySQL. The more you use both, the more you'll realize the strengths and weaknesses of both. It'll give you an interesting perspective few people have too. And then of course, there's the benefit of you being able to cater to your customer's needs no matter which camp they want to roll with.
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
Jeremy Falcon wrote:
If you plan on being successful, I don't see how knowing both of them will hurt your business.
I agree with you, Jeremy. Does not hurt to know both PHP/MySQL and ASP.NET/MSSQL.
I'd like to help but I don't feel like Googling it for you.
-
There are many differences and I believe it takes far less work in development and maintaining an ASP.NET site than you would spend to have the same benefits with PHP. I used PHP for a few years and will never use it again! I have flashback every time I open a can of spaghetti :) Anyway, putting personal preferences aside, there have been several wars on the difference here in the Lounge and a quick search might find a few of them. As for cost, that is a joke anymore. ASP.NET hosting is trivial in cost for many different places. If there host is only Linux, that is easy to change. Some mention the cost of SQL Server, but that is usually included in most hosting packages. If not, they usually have SQL Server Express which will work for most basic types of sites (such as DotNetNuke). There is even supposed to be a module out now to use MySql with DNN, so cost should not be a factor. Clean, clear, reusable code with great scalability and modular design all come for free in ASP.NET!
Rocky <>< Latest Code Blog Post: ASP.NET HttpException - Cannot use leading "..".. Latest Tech Blog Post: Microsoft Zune to be built by Toshiba
Ok i can see wxactly where you are coming from, your native language is what you are going to produce the best products in (unless you're not actually coding but i'm going to assume you are). HOWEVER it is well known that windows was NEVER designed to be on the web. It is the most vulnerable of the OS's (Mac, Linux (Based on SUSE), UNIX) for many different reasons. All my user end interfaces and basic functions on the web are ALL PHP and MySQL. This is just because to use anything but Linux and Apache as a web server would be occupational suicide. I'm guessing your client does not have a strong IT background and therefore could never hope to find the security holes in their server. Trust me on this, Linux iswhat you want. PHP is the 3rd easiest language i ever learned and MySql really cuts the overhead. Please if you listen to one thing i say make sure you tell your clients about the security risk in a way they can understand. It is bad practice to customize the job for a solution, rather then the other way around.
From Brad
-
I am currently working on a proposal for a CMS. One requirement from the customer is that they want the CMS running on a LINUX webserver. They don't have their own webserver what would explain why they want it on LINUX. My guess is they don't want to spend a lot of money for hosting (it is just a small non-profit organization). My idea is to offer them an open source CMS like DotNetNuke with the customizing they need. I know I could use Typo3 or PhpNuke, but my skills in PHP and MySql are not as strength as my ASP.NET and SQL Server skills (and I need to create some modules). However, I would like to explain them why it is better to use the MS technology but I don't know exactly what I should tell them because they are no IT people. From your point of view, what would you tell them? Thanks for your thoughts. Stephan
Did they choose you specifically for this project? If so then I imagine they had an idea why they wanted you. As much as I want to say what the others are saying, that actually maybe PHP/MySQL or some other LAMP like stack is better, if you aren't proficient in those areas and are good at ASP.NET then that is your reasoning to them. Technology is not chosen just for technologies sake, businesses often choose on HR issues before technology issues. One thing you dont want to do is sell PHP/MySQL and then not be able to deliver. Don't concede on some points just to get your foot in the door and then find you can't actually do the project to your normal standards. So you need to look at your position with them. Do they want you or do they just want the project done? they may want you because they see a good future with you that they don't see with other developers in which case your technology choice, and happiness, is more important than initial costs. Saying all that most of your points against PHP above can be countered by using Ruby on Rails and still be on the cheap LAMP stack ;) (I really, really, really like Rails.)
regards, Paul Watson Ireland FeedHenry needs you
eh, stop bugging me about it, give it a couple of days, see what happens.
-
I am currently working on a proposal for a CMS. One requirement from the customer is that they want the CMS running on a LINUX webserver. They don't have their own webserver what would explain why they want it on LINUX. My guess is they don't want to spend a lot of money for hosting (it is just a small non-profit organization). My idea is to offer them an open source CMS like DotNetNuke with the customizing they need. I know I could use Typo3 or PhpNuke, but my skills in PHP and MySql are not as strength as my ASP.NET and SQL Server skills (and I need to create some modules). However, I would like to explain them why it is better to use the MS technology but I don't know exactly what I should tell them because they are no IT people. From your point of view, what would you tell them? Thanks for your thoughts. Stephan
Stephan Hoppe wrote:
they don't want to spend a lot of money for hosting (it is just a small non-profit organization).
Godaddy offers Linux & Windows for the same price, or at least that's what thier site states.
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
-
I haven't spoken to them yet because of this point (just downloaded the requirements from their website) and I think you are right. However, I just moved to this town and just started my own business and I would really like to do this job. Not because of the money, but to become more known. That's why I would like to offer them an ASP.NET solution and explain them why it would be better for them.
How about going down the Linux/Mono.net/MySQL road? That would be a cost effective alternative to Windows Server/Microsoft.Net/Sql Server. And it's actually pretty easy to find hosting providers for that setup..? /Aquaboy
-
Stephan Hoppe wrote:
From your point of view, what would you tell them?
No offense, but if cost is important (like it is for a non-profit), I'd tell them to go use the Linux server and find someone who knows PHP/MySQL, etc. You should choose a technology based on your needs IMO. They need to be cheap, and I'm sure they don't want to worry about SQL Server licensing issues, etc.
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]
we are hosting .Net- SQL on a server for $8 per month (www.webhost4life.com), we understand everything on there and can manage our databases using Enterprise Manager, We are also hosting a php/mysql joomla website for about $6 per month - but the addtional effort and time spent on the joomla website has probalbly cost us about $400 per month in wasted time. Go with what you know, even if it costs more- you will save money in the long run. PS: Microsoft had a product like PHP/ MSQL a while ago - it was called ASP v1.0 and MS Access.:rolleyes:
-
I am currently working on a proposal for a CMS. One requirement from the customer is that they want the CMS running on a LINUX webserver. They don't have their own webserver what would explain why they want it on LINUX. My guess is they don't want to spend a lot of money for hosting (it is just a small non-profit organization). My idea is to offer them an open source CMS like DotNetNuke with the customizing they need. I know I could use Typo3 or PhpNuke, but my skills in PHP and MySql are not as strength as my ASP.NET and SQL Server skills (and I need to create some modules). However, I would like to explain them why it is better to use the MS technology but I don't know exactly what I should tell them because they are no IT people. From your point of view, what would you tell them? Thanks for your thoughts. Stephan
-
we are hosting .Net- SQL on a server for $8 per month (www.webhost4life.com), we understand everything on there and can manage our databases using Enterprise Manager, We are also hosting a php/mysql joomla website for about $6 per month - but the addtional effort and time spent on the joomla website has probalbly cost us about $400 per month in wasted time. Go with what you know, even if it costs more- you will save money in the long run. PS: Microsoft had a product like PHP/ MSQL a while ago - it was called ASP v1.0 and MS Access.:rolleyes:
hey don't compare MS Access with MySQL, MS Access is a joke in the name of databases. If you are unhappy with MySQL try PostgreSQL.
-
I am currently working on a proposal for a CMS. One requirement from the customer is that they want the CMS running on a LINUX webserver. They don't have their own webserver what would explain why they want it on LINUX. My guess is they don't want to spend a lot of money for hosting (it is just a small non-profit organization). My idea is to offer them an open source CMS like DotNetNuke with the customizing they need. I know I could use Typo3 or PhpNuke, but my skills in PHP and MySql are not as strength as my ASP.NET and SQL Server skills (and I need to create some modules). However, I would like to explain them why it is better to use the MS technology but I don't know exactly what I should tell them because they are no IT people. From your point of view, what would you tell them? Thanks for your thoughts. Stephan
If it's running on Linux, use free tools (stay away from .net). They're obviously on a budget, and you don't want them tied to a technology they can't afford to exploit.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 -
There are many differences and I believe it takes far less work in development and maintaining an ASP.NET site than you would spend to have the same benefits with PHP. I used PHP for a few years and will never use it again! I have flashback every time I open a can of spaghetti :) Anyway, putting personal preferences aside, there have been several wars on the difference here in the Lounge and a quick search might find a few of them. As for cost, that is a joke anymore. ASP.NET hosting is trivial in cost for many different places. If there host is only Linux, that is easy to change. Some mention the cost of SQL Server, but that is usually included in most hosting packages. If not, they usually have SQL Server Express which will work for most basic types of sites (such as DotNetNuke). There is even supposed to be a module out now to use MySql with DNN, so cost should not be a factor. Clean, clear, reusable code with great scalability and modular design all come for free in ASP.NET!
Rocky <>< Latest Code Blog Post: ASP.NET HttpException - Cannot use leading "..".. Latest Tech Blog Post: Microsoft Zune to be built by Toshiba
You must have missed the part where he said it has to run on Linux.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 -
Why is it better to use MS technology ? Tell me I am an IT person, then we can re-word for the masses
One argument in favor of a Microsoft-centric solution is that decent Microsoft resources that can support and enhance the application are more abundant and easier to find. For a smaller client lacking in-house resources this flexibility can be a huge difference maker alone. Given that, its probably still in your best interest to learn to develop on PHP/MySQL platform. Especially since then you can build more cost-effective solutions for your clients AND be the one they know to turn to in the future.
-
Ok i can see wxactly where you are coming from, your native language is what you are going to produce the best products in (unless you're not actually coding but i'm going to assume you are). HOWEVER it is well known that windows was NEVER designed to be on the web. It is the most vulnerable of the OS's (Mac, Linux (Based on SUSE), UNIX) for many different reasons. All my user end interfaces and basic functions on the web are ALL PHP and MySQL. This is just because to use anything but Linux and Apache as a web server would be occupational suicide. I'm guessing your client does not have a strong IT background and therefore could never hope to find the security holes in their server. Trust me on this, Linux iswhat you want. PHP is the 3rd easiest language i ever learned and MySql really cuts the overhead. Please if you listen to one thing i say make sure you tell your clients about the security risk in a way they can understand. It is bad practice to customize the job for a solution, rather then the other way around.
From Brad
Bradml wrote:
HOWEVER it is well known that windows was NEVER designed to be on the web. It is the most vulnerable of the OS's (Mac, Linux (Based on SUSE), UNIX) for many different reasons.
Complete rubbish. Go look at the vulnerability statistics for Windows Server 2003 versus any recent Linux distro. Windows wins. Compare IIS 6.0 to Apache. IIS 6.0 wins. There have been three vulnerabilities, total, listed on Secunia[^] since its release in 2003. The most recent one only applies to the ASP runtime which is disabled by default, and if you're only coding ASP.NET pages, isn't required. Anyone who thinks that a Windows web server will be vulnerable in 2006 needs to get up to date.
Stability. What an interesting concept. -- Chris Maunder
-
we are hosting .Net- SQL on a server for $8 per month (www.webhost4life.com), we understand everything on there and can manage our databases using Enterprise Manager, We are also hosting a php/mysql joomla website for about $6 per month - but the addtional effort and time spent on the joomla website has probalbly cost us about $400 per month in wasted time. Go with what you know, even if it costs more- you will save money in the long run. PS: Microsoft had a product like PHP/ MSQL a while ago - it was called ASP v1.0 and MS Access.:rolleyes:
jasperp wrote:
PS: Microsoft had a product like PHP/ MSQL a while ago - it was called ASP v1.0 and MS Access
Spoken like a true zealot that doesn't know what they are talking about.
Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]