Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Advantages ASP.NET/SQL Server vs. PHP/MySql

Advantages ASP.NET/SQL Server vs. PHP/MySql

Scheduled Pinned Locked Moved The Lounge
csharpphpasp-netdatabasemysql
50 Posts 24 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Stephan Hoppe

    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

    R Offline
    R Offline
    rziak
    wrote on last edited by
    #41

    As someone already told you it may be good idea to learn the other side so you can at least identify pros and cons on both sides. For starters PHP is C ripoff very easy to learn and understand and that's probably why it became so popular. It has functions for almost anything. But it has a mess libraries with no consistency, there may be 3 functions doing same or similar things. Someone criticized that PHP needs some 2000 functions for what Perl can do the same with well designed library of 300. Google on how many problems people have with "magic quotes". Secondly PHP is fairly slow. There is a comparison available between c# and PHP here: http://shootout.alioth.debian.org/gp4/csharp.php That's actually comparison for Mono C#, which last time I checked did not stand-up to MS C# benchmark-wise. The ASP.NET server will be way more responsive than PHP one. In my opinion Visual Studio is superior editor and debugger to any PHP editor/debugger (if you'll be learning PHP and like your VS, try out the VS.PHP) IMO PHP is more suitable for quick hacking and prototyping, but .NET is more suitable for writing robust long-term easily maintainable web apps. Cannot give you comparison of MySQL and MSSQL because never had to do anything with the latter. Cheers Roman

    1 Reply Last reply
    0
    • S Stephan Hoppe

      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

      C Offline
      C Offline
      csinge
      wrote on last edited by
      #42

      Hey mate, Have you considered Joombla its an awsome of CMS and its free and Although I am a .Net person, I still recommend using it. Also any one who isn't computing-challenged can set them up, there isn't much programming invloved unless you decided to build your own modules. And most likey some else has built a module to your likings. Also like some other guys have mention, PHP and MYSQL have their benfits, they are completely free however the CASE tools might be lacking in some areas, PHP is still a really useful language and would widen your skills as a developer. Furthermore Considering most langauges are similar, PHP isn't that much of a leap, if you have experinence with a any oop, javascript or bash scripting. Perferably a bit of everything :)

      1 Reply Last reply
      0
      • M Mike Dimmick

        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

        C Offline
        C Offline
        csinge
        wrote on last edited by
        #43

        I agree A server is as secure as you make it, people running both windows or linux can still experience of security problems, it comes down the practices of the system admin. Also on another note, i think people miss the point with MYSQL, its just another RDMS there is no majour difference, just sutle ones. Minus the IDE support you get with VS and the MS SQL Server Interface (For common uses anways :) )

        1 Reply Last reply
        0
        • J Jeremy Falcon

          We're not talking about development costs. ;)

          Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]

          P Offline
          P Offline
          Paul Conrad
          wrote on last edited by
          #44

          Jeremy Falcon wrote:

          We're not talking about development costs.

          Totally. Cost is something to think about, but client requirement is more important. Figure out what they need/want, and go from there.

          1 Reply Last reply
          0
          • J Jeremy Falcon

            Yeah, I think most people don't for religious reasons. But, if you're in the business, I don't see the harm in learning both.

            Jeremy Falcon A multithreaded, OpenGL-enabled application.[^]

            P Offline
            P Offline
            Paul Conrad
            wrote on last edited by
            #45

            Jeremy Falcon wrote:

            if you're in the business, I don't see the harm in learning both.

            Yup, doesn't hurt at all. Just adds to one's skill sets.

            1 Reply Last reply
            0
            • J jasperp

              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:

              T Offline
              T Offline
              TecnoPilgrim
              wrote on last edited by
              #46

              I had a bit of a similar problem where my provider was Linux. I am able to use ASP (1.0 - yuck) - and used MySQL for the database. It worked fantastic. MySQL is easy to use and there are free front-end tools to work with it. So on my Windows box at home, I can view my MySQL database. I would say, at least consider MySQL. As someone who had never used it before, I was really, really impressed with it.

              1 Reply Last reply
              0
              • S Stephan Hoppe

                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

                E Offline
                E Offline
                eraseunavez
                wrote on last edited by
                #47

                I'm an ASP.NET/SQL Server programmer and I'm also helping a non-profit organization. Guess what. I'm programing for them with php/mysql a cms, I'm using Joomla and it's quite ok. It's php AND it's object oriented so it's quite easy even thought you dont know the language. Even more, you dont have to mind filling/storing the objects, it's all done for you. Just to be a bit aware of the API, but for every programmer that's assumed and it's the easy part. I would recommend php and mysql for those projects, just to keep them simple and cheap to host, but it's up to you which offer... but please dont offer them asp.net/sql just because you know them MORE than php/mysql...that's not a good reason!!! elf

                1 Reply Last reply
                0
                • A Anand Vivek Srivastava

                  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.

                  E Offline
                  E Offline
                  Ecologic
                  wrote on last edited by
                  #48

                  friends, try to concentrate on ASP.NET in MONO on Linux with SQLite.NET as back end. I have tried it and feel satisfied.

                  1 Reply Last reply
                  0
                  • S Stephan Hoppe

                    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

                    P Offline
                    P Offline
                    PhilLenoir
                    wrote on last edited by
                    #49

                    My answer would be productivity. I honestly don't believe that there is a more productive tool out there that ASP.NET 2. There are plenty of inexpensive ASP.NET + SQL Server hosting options out there. I use one for my own domain and the same one for a non-profit that I do programming for. Frequently development cost is considered not to be an issue, because it's donated. But maintenance, and the possibility of having to pay for the maintenance, should always be a factor. On the other hand, there may be other good reasons than hosting costs that drive a customer's requirement for a specific technology. I would certainly ask the question!

                    Life is like a s**t sandwich; the more bread you have, the less s**t you eat.

                    1 Reply Last reply
                    0
                    • J Jeremy Falcon

                      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.[^]

                      J Offline
                      J Offline
                      jasperp
                      wrote on last edited by
                      #50

                      you've got me on that one, all is revealed!

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups