Database Development

Do you need your website to gather, display, or manipulate information? If so then you may need a database powered dynamic website. Autus specialises in bespoke database design and development for the web. Database powered websites can handle large amounts of data that a standard static website simply cannot cope with. If you have information which needs regular updates or where updates are time critical, for example your catalogue of products or prices, then a database powered website would be the solution.

mySQL & Other Database Technologies

Database technologies used include mySQL, PHP, ASP, MSSQL & MS Access.

Content Management Systems

With each bespoke database we also build a Content Management System (CMS) tailored to meet your specific requirements. Every CMS is built to exacting web standards with particular attention being paid to the overall User Experience (UX) making each CMS intuitive and easy to use. This way live updates and changes to your website can be implemented quickly and in-house by non-technical staff.

Processes Requiring Databases

Some examples of why you might need a database powered dynamic website are:

  • Showing price lists

  • Displaying menus

  • Listing your product catalogue

  • Managing event registration

  • Collecting email addresses for mailing lists

  • Displaying photo galleries of work

  • Managing members lists

  • Showing current job vacancies

Database Development Skills Base

Our lead database developer has 20 years of commercial application experience and an honours degree in Computer Science. So we have the knowledge and technical experience in-house to tackle your bespoke database requirements. Call us now on 07971 484 695 to discuss your web based database requirements.

Database Projects – Examples

Database Project 1 – Steel-Quick Ltd – Salford, Manchester

Steel-Quick are a Manchester based, independent steel stock holder. The brief set out to Autus was that Steel Quick wanted to display, and sell online, all of the steel sections and profiles that they offer. It was important that this could be done in a simple, quick and convenient way.

Fast Two Table Relational Database

The complication involved in this project relates specifically to the 8 different steel profiles on offer, each having different specifications such as diameter, width, weight etc. In order to produce a fast and responsive database the challenge was to analyse the existing steel section specifications and devise a generic database structure to fit all of the requirements. To meet this specification, we developed a fast, two table, mySQL relational database to store the steel profiles and sections.

Fast Loading & Seamless

The brief stated that the way customers find and buy steel needed to be simple and quick. Upon choosing from one of the 8 steel profiles, the site lists all of the sections on offer, pulled from the database. The user can then filter these results to narrow down their search. This is achieved using web-technologies such as AJAX and Asynchronous Javascript to minimise page loading time and to provide a seamless user experience.

Simple, Fast Price Changes

An additional requirement for this project relates to the pricing of each steel section. Steel prices change regularly and the website needs to adapt quickly to price changes. We therefore developed a secure password protected responsive bespoke content management system which the client can log into in order to update the steel pricing. Price changes are reflected immediately on the website.

At the time of writing there are 579 steel sections in the mySQL database.
Other bespoke development technologies used included HTML, CSS, jQuery, Bootstrap and PHP.

Database Project 2 – Trade Window Services, Leigh on Sea, Essex

Trade Window Services is a major player in double glazing in Essex and Kent. TWS install for retail customers and for house builders, as well as supplying to the trade.

TWS instructed Autus to develop an online Window Quote tool. Customers can use the tool to produce a price for their new UPVC windows, from a single window unit to a whole house. The customer uses the online tool to work their way through a 6 step process selecting their desired frame colour, options such as handle type, locks, energy rating, frame style, dimensions and glass type. The customer is able to build up their quote and save it for later reference. A copy is also sent to Trade Window Services , for reference when a customer makes contact to discuss placing an order.

Plethora of Configurations & Prices

The challenges involved in developing this online tool related to the sheer number of configuration options and respective prices. It was decided that a bespoke database using mySQL was the best solution for storing and retrieving this information. In order to provide a seamless user experience the following technologies, development techniques and programming languages were also used: HTML, CSS, jQuery, JSON, AJAX (Asynchronous JavaScript) and PHP.

If you would like to view the Window Quote tool please visit the Trade Window Services website here: https://www.twsos.com/window-quote/

Database Project 3 – CODAS, Salford, Manchester

CODAS is a market leading software solution for fuel distributors developed in Manchester by software house CDS. CDS came to Autus with a very specific requirement. Whilst their existing software facilitated their customers being able to sell their fuel and take orders over the telephone, they wanted to offer their customers the option to sell fuel online.

E-Commerce Enabled System to Integrate With Codas

CDS have a team of software developers in house however they lacked the knowledge and experiencing of developing software for the web, this is where Autus came in. We designed and developed a ‘white label’ bespoke online e-commerce enabled web system which integrated seamlessly with the existing CODAS database.

Information was passed between our online solution and the CODAS database at numerous points in the ordering process using XML (eXtensible Markup Language). XML was designed specifically to store and transport data and as such was deemed a good fit for this project.

Payments are taken using either SagePay or GlobalPayments as these were two providers CODAS customers were already using. Upon successful payment the software saves the transaction to the CODAS database with order notifications being sent by email. Other technologies used included HTML, CSS, jQuery, Bootstrap, PHP and AJAX.

Call Autus Now

Databases

Call Autus Now

We have the knowledge and technical experience in-house to tackle your bespoke database requirements. Call us now on 07971 484 695 to discuss your web based database requirements.

Database Technologies

mySQL
PHP
ASP
MSSQL
MS Access

A Comprehensive Package of Database Development Services for Your Dynamic Website

Autus Web Design & Marketing, Salford, Manchester – Website Database Development – mySQL, PHP, jQuery, Bootstrap, AJAX, JSON, ASP, MSSQL, MS Access for Display of Menus, Job Vacancies & Product Catalogues. Also Collecting E mail Addresses for Mailing Lists & Managing Members Lists.

Autus – Your Digital Marketing Partner. Call us now on 07971 484 695

Responsive Design Websites for – Wigan, Salford, Bolton, Manchester, Yorkshire, North East, Newcastle, London, Essex Brentwood, Billericay, Chelmsford, Basildon, Southend