Middleware Code Level Technology: PHP, ASP, .Net, CFN?!
The code level is the “brains” behind interactive Websites. The business rules and logic is built into the Website with code. This type of code is the “middleware” that is between the User and the database.
The middleware code comes in many flavors and types. With so many acronyms floating around, its easy to be confused and intimidated by this. However, there are two main “camps” or types out there: Microsoft-based technologies (ASP, .NET) and PHP. There is also a has-been third type called Cold Fusion (CFN) that is a proprietary souped-up version of HTML that is becoming obsolete. This middleware player does not enjoy the wide support base of developers like Microsoft-based technologies and the more open-source PHP crowd.
Programming Skill and Experience Types
Is it really cheaper to go with a programmer from India at $20/hr verses a free-lance US programmer at $65/hr? What about the company who charges $120/hr? Below are some example and case-scenarios that compares the different types.
Programmer A) Programmer from India at $20/hr: may take 152 lines of code in 8 hours ($160) to program a function compared to 25 lines of code in 1.5 hours ($97.50) by an efficient, experienced programmer. The end result (function) is and looks exactly the same as the efficient, experienced programmer, but may take more time to process the User’s request and the load time on the Webpage is slow. It is also a lot harder to have another programmer take over the project in the future.
Programmer B) Free-lance programmer at $65/hr: maybe be experienced and efficient, but not always available and responsive due to multiple projects with multiple clients.
Programmer C) A Programmer from an established company: more likely to be experienced and efficient and dedicated to your project. Using an established company also has the benefit of having multiple programmers/specialists working on your project=faster turn-around time.
If a User wants to get some specific information, such as a dealer by zip code address in the neighborhood, the middleware code knows where to find the info/data in the huge database of data and returns it quickly to the User. IF written correctly, the request will only search a specific section of the database instead of the whole
Databases Level Technology: MS SQL, MySQL, Access, Oracle, IBM
Databases contain all of the raw data that is severed up when requested. The same is true about the programming: databases can be designed poorly or efficiently. Here are the main types of databases used for the Web:
Microsoft: Access (personal use, but also Web) and SQL: only runs on a Windows server (can only use .asp and .aspx code)
Oracle and IBM: the largest and fastest databases
MySQL: Open-source: only runs on a Linux/Unix server (can only use PHP code)