 1300 78 20 23 |
Website Application Development and Database
Till 2000, many website application development companies used files to create and store information. This allowed freelancers to provide application development services with knowing much about relational databases. In fact most of the website designers (or website developers) depended on simple file writing codes to develop dynamic websites. This provided a simple and affordable solution at that time. However, as the time passes by, website applications that did not use proper databases started to show the limitations of using files to store information. As the amount of information grew the performance of the website suffered immensely.
There are quite a few databases that are currently used for website design or website application development:
- MS SQL: This is most common for websites developed on platforms like ASP.NET, C# or ASP. This database runs on Microsoft platform. Websites application development using MS SQL could be a little more expensive than other technologies, however in the long run they more than make-up on initial costs through performance, robustness and expandability.
- MYSQL: MYSQL databases are most commonly used in open source projects. Most of the websites developed on UNIX/LINUX platform use MYSQL. PHP is the most preferred website programming language used with MY SQL. .NET and ASP websites can also run with MY SQL but it is not very commonly used with windows based platforms. Most of the open source solutions are developed on MY SQL database and is fairly robust. I would however stay away from MY SQL for major website applications of web portals.
- MS ACCESS: Again a Microsoft technology and runs on windows platform. I have seen quite a few ASP and Cold Fusion websites applications developed in MS ACCESS. Website Application Development is fairly easy with Access. However as your requirement grows, you will notice that MS ACCESS database might inhibit growth of your website.
My suggestion to you ate the time of website application development will be to consider your current status and also the amount of growth your website and web design will have in next 2-3 years. For your short-term benefit, you don’t want to affect your long-term goals.
More useful articles are available on the Sigma Infotech website |
