Skyscanner, the Scottish company behind the popular travel search website, has already grown to considerable scale since it was founded by Gareth Williams in 2003. Williams was inspired to create the business by his own frustrations in trying to find the best deal for a skiing holiday. As the Skyscanner…Read more
Software coding is never easy. We all know that. But what if you were given a challenge? In particular, what if you were asked to write a program to generate a maze, using any language you like, from Python to SQL to C#? The only constraint? To be able to…Read more
Mob programming is an emerging agile development approach for creating software. The whole development team gets in a room and works together on the same problem, at the same time, on a single computer. I spent a full week doing mob programming with my current team and I’d like to…Read more
Many freelancers find projects on online job platforms like Upwork and Freelancer. What kind of database model powers these sites? Let’s take a look ... Read more
Across the globe, the job portal site is a well-known feature of the Internet landscape. Big players like Indeed and Monster have turned job hunting and recruiting into a veritable online industry. Let’s dive into the elementary features leveraged by job portals and build a data model that can support…Read more
When you’re using a data warehouse, some actions get repeated over and over. We will take a look at four common algorithms used to deal with these situations. Read more
Software development is a difficult and demanding discipline. It gets even more difficult when you bring teams of developers and database administrators together on a single project. One of the fundamental issues arises around the code itself. Who is responsible for what piece of it? What changes have they made?…Read more
The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in industrial manufacturing and design, where large, complex machines such as aircraft, tanks or motor cars required a great deal of discipline, particularly in the technical drawing of components. It all started…Read more
If you ran a MOOC online learning platform like edX or Coursera, how would you keep it organized? In this article, we’ll look at a database model that would do the job. Read more
Call them taxis or cabs, these convenient rides for rent have been around for centuries. Nowadays, it’s a lot more complicated to run a taxi service. In this article, we’ll look at a database model designed to meet the needs of a cab company. Read more