Database Development

Many modern web applications are powered or driven by databases such as Microsoft Access or Microsoft SQL Server.

It is common to develop a web application that consists of one or more templates that are then populated with data drawn from the database (content management systems). In such cases the templates contain the styling and layout information for the web page while the page content or data is drawn from the database. The benefits of such systems is that it allows the data to be easily updated through use of content managment systems or delivered dymanically according to the requests of the end user. This would be the case where there is a requirement for the user to search data to find specific information.

Microsoft Access

For many of our smaller clients we have traditionally specified the Microsoft Access database. Please view the Gatwick Guest House Association website which uses a database to display information. This database software is well suited to the smaller web applications as it keeps costs down and is supported by many professional web site hosting companies.

Microsoft Access scales to about 1 or 2 Gbytes of data and can manage approximately 6 to 10 concurrent connections. This is often sufficient to power a small company website.

Microsoft SQL Server

Microsoft SQL server is the database of choice for most Microsoft based development projects. Although there may be additional costs associated with its use it is more scalable and more powerful than Microsoft Access. A Microsoft SQL Server Database can be scaled to virtually any size handling even the largest of corporate databases and can simultaneously handle thousands of requests. With the release of SQL Server 2005 has been the introduction of SQL server 2005 Express Edition, which although limited to database sizes of up to 4 Gbytes, has all the benefits of the full versions. The main benefit being that once the database size nears this limit the database can easily be transferred to the full edition without any technical changes.

What does database development cost?

Database devleopment normally forms part of a larger project and will vary in cost according to complexity. To give you an indication of our standard costs click here.