Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Somewhere on the 3rd Rock

    Database Security and CMS

    Hello, Our web content is running on a Windows based server and we are looking to implement a reporting database that will be used by over 200 individuals in 5 states, we are thinking of writing the database from scratch, but we are also considing using a pre-designed CMS, to save some time. I am familar with MySQL and PHP, and I am currently learning ASP, and windows based server applications. The database will become quite large and we need it to be able to handle around 4500 entires a day, so we are looking at size as well as security.

    We need a database that we can secure and on that can handle this load. The database will be edited and data will be input via the internet, via a unlisted domain name.

    Does anyone have any suggestions for an ASP beginner on this project or should I stick to PHP.

    Will Dove
    working hard is better then hardly working ...

  2. #2
    Join Date
    Jan 2005
    I will try not to be too biased as I am a huge PHP supporter, especially over ASP. There are many sites and discussions on "the best" web scripting language... do a Google search on "PHP vs ASP" and you'll see

    A few things I can think of is PHP is more portable, it can run on various systems and operating systems, as opposed to ASP which is the work of Microsoft. You won't see ASP running (happily) on linux, confining your ASP solution to a Windows-only platform which may raise issues with your concern for security. PHP is also completely free whereas I think ASP requires licensing? On the other hand, many will show disfavor for PHP as it is sometimes deemed "insecure"

    My overall point is you can reach your goal with PHP or ASP, and make it fast, efficient, and secure - so I would recommend you stick with the language you know best - security issues are usually introduced by developer ignorance, so whichever you choose - read up on some best practices to writing secure applications... for instance with PHP, check out php|architect, its a great magazine

    As for the database server, I don't see why MySQL wouldn't be a great solution for you - it can handle your proposed workload. My only experience is with MySQL and Oracle (which would be overkill), so I can't comment on other RDBMS like MS SQL, etc.

    Just my 0.05 euro

  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    Also, take a look at PostgreSQL. It is a full-featured, open source (truly free) database with excellent performance and is scaleable.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts