preloader

MySQL

Case Studies

Website Development for a Wine & Spirit Wholesale Platform
E-com & Retail

Website Development for a Wine & Spirit Wholesale Platform

A website for a US-based organization that sells imported wines and spirits to retailers and restaurants around the country and provides expert reviews, cocktail recipes, and pairing tips.

Angelinos Coffee & Tea Online Store
E-com & Retail

Angelinos Coffee & Tea Online Store

An online store that offers visitors to buy fine coffee and tea from around the world. The platform provides a wide range of products and helps users choose the proper items according to product characteristics, cost limitations, producing countries, etc.

DueFocus
Technology

DueFocus

DueFocus is a task-tracking tool for developers. Every single short or long activity can only start after the planning phase. Planning, in turn, should have such attributes as the List of actions, Budget, Time Period and Results. DueFocus allows everyone to define those parameters for every activity seamlessly. The very first and most challenging issue was to solve future performance issues while connecting thousands concurrent request per each second. The ability to deliver new versions using one code base DB is almost always a bottleneck in each high loaded system. With an app on Golang, we allow users to save and store ~50 screenshots of daily activities. Integration with more than 20 project management tools was ensured as well. Usage of microservice architecture was our first and stra

NatRoad
Travel & Hospitality

NatRoad

The National Road Transport Association is Australia’s leading industry association of national scale. The Association represents wide arrays of drivers from owner-drivers to tankers, road trains, tippers, and carriers, etc. We were to create a solid website that matches the expectation of Australia’s leading transport association. Our solution had to encourage confidence in an entire community of transport-related individuals. It had to combine all of them into one force. Considering the stakes, we chose Drupal as the platform for the development of the website. It is easily maintainable and highly reliable. Rich functionality and custom-built modules have allowed us to ensure a stable, reliable and secure website with login and registration functionality, an integrated payment system

SproutBack
Fintech

SproutBack

Sproutback is an Australian based crowdfunding platform that aims to help people show off their creative projects to the world, as well as to help people find amazing projects to support. Sproutback allows people to get funding for their innovative technological projects or art projects and get them off the ground. A community of ‘backers’ who donate funds towards a project receive ‘reward’ from the project’s creator. It also indicates whether the idea of the project is worth development. The website is not only about community financial funding but it also supports the project on every step of the way. Sproutback provides creators with necessary contacts and mentor networks, with guidance and expert advice. To start a project a user only needs to sign up or login to Sproutback a

Destinity
GIS & Navigation

Destinity

QArea performed development of a website that delivers visitors with offers from the world’s leading hotels. The website presents currently active and future proposals, photos of hotels, rooms and the surrounding area, includes descriptions of features and attractions, etc. Orders of customers can be easily specified with additional data that may include such aspects as: Type and number of apartments; The number of people that will be visiting a hotel; Date of arrival; Additional options & special offers. Payment functionality is tailored in a fashion when transactions are possible via numerous systems like PayPal, Click & Buy, Caixa, Banesto. Particular attention is paid to social and marketing component – we have developed a referral system of discounts and a variety of tools

Keeveo
E-com & Retail

Keeveo

This site is a portal created for search, purchase, and deployment as well as marketing purposes of goods from Spain (such as designer clothing, accessories, etc.). These goods are sorted by groups in specialized stores. You pretty much have a shopping mall right inside your browser. The original task was to create a platform that would be allowing users to create their own online shops. In those shops, the user may create and manage and sell new goods. The products’ status and condition, as well as orders from customers, are manageable as well. The website is based on Drupal 6 and Ubercart. The Sphinx is the pages’ search engine that ensures a massive searching speed-up. It is also capable of decreasing the pressure caused on servers. The newly developed interface grants use

YoungCuts
Media & Entertainment

YoungCuts

Site YoungCuts.com represents an informational resource for competitors, critics and spectators of the yearly movie festival of young stage directors, which takes place every October in Canada. The site represents means of communication of this event’s participants and an informational system for the movie critics’ work. Every competitor has the possibility to download a short film (up to 10 Mb), which will be accessible for general viewing further and it can be assessed by the jury members as well. From a technical point of view, the site is developed with the Drupal CMS. Forum and support are switched on; File downloading system is present and integrated; Additional functionality includes, yet is not limited to: Voting system Mailing system E-commerce system Banned ad functio

Skyhook
Travel & Hospitality

Skyhook

Skyhook was founded in 2003 to capitalize on the increasing demand for location-based services. The first location technologies, GPS and cell tower triangulation, were inadequate – leaving frustrated mobile consumers with slow and inaccurate positioning information. In response, Skyhook developed a software-only location system based on Wi-Fi positioning, GPS and cell tower triangulation. Specialists from QArea have been challenged with a series of projects for Boston-based Skyhook Wireless. This series of projects included Skyhook Wireless WPS, Location Logger, LocalFaves, Internal tests, and the big gun – MyLoki. We also needed to implement a website allowing users to register for Skyhook Javascript API key and promoting this technology to web developers/site owners. Skyhook Wire

Kroodle
Banking & Finance

Kroodle

Kroodle is a site that was designed and developed for Agon, a large Netherland insurance company. We were to create an astonishing solution that inspires trust in visitors, embraces rich functionality and delivers fast, complex solutions from the insurance niche to website’s users. The project has 7 insurance types. Every type of insurance has its own parameters for the user to fill in order to know the price of required insurance services, meaning several data entry forms were implemented. All parts of the project are connected to Facebook API. Users require valid Facebook accounts to perform actions on the site, otherwise, one should be created. All users can buy, edit, cancel insurance, invite their Facebook friends and get bonuses thanks to the integration of the Facebook API and va

NowThis News
Education

NowThis News

A web portal for video news materials. Provide a smooth access to the website from any mobile device with a comfortable and convenient interface.

RebelMouse
Social Networks

RebelMouse

The task was to develop a social media aggregator that allows to create user accounts, to connect different social media accounts and conveniently manage the information from them on one single platform. We were also to develop a fitting iOS app that was requited to allow creation of a dynamic feed of messages from social networks with a few touches. RebelMouse is an aggregator for social media that was launched by Huffington Post CTO Paul Berry. On the first look this platform looks like a digital newspaper that represents user’s social media events. Basic registration allows users to connect their accounts on Twitter and Facebook. The updates from the connected accounts are represented in the collage-styled information flow that shows user’s presence within social media. RebelMouse a

Distractify
Media & Entertainment

Distractify

Distractify is a leading entertainment company in the mobile era. This fascinating portal follows the trend (among Buzzfeed and Upworthy) for inspiring, funny and eye-catching post titles, often in list form, with video, image and GIF-heavy content. We are most happy QArea had a chance to assist them and here’s what we did for Distractify: Development Integrating Service-oriented architecture. Android API IOS API Testing Functional testing; Compatibility testing; Regression testing; Ad-hoc testing; UI / UX testing; Validation testing; Smoke testing; Bug reporting; Bug rechecking; Documentation creating. Results were astonishing: Official stats have their unique visitor count at 43 million since its launch in October 2013, and the site has inspired 10 million Facebook shares in that short

HuffPost
Media & Entertainment

HuffPost

HuffPost (formerly The Huffington Post) portal was launched May 9, 2005, and very soon it became extremely popular. While one reason for the apparent success of this portal is that their contributors are popular journalists and well-known personalities from politics, business, and entertainment, the other reason is that the development team has been able to provide a technical solution that was up to the challenge. To build a news portal capable of sustaining the heavy load, including peak load, and convenient for both visitors and authors of the entries. Challenge – making definite entries appear among the results of running search engines queries, SEO optimization, simultaneous maintaining of a large number of users, quick generation of pages that contain dynamic and static data.