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
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
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
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
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.