In previous articles, we’ve discussed data model that could run card games, board games and even MMO games. Many of these were based off the board games data model; the simple tic-tac-toe game was developed using Spring Boot and AngularJS. In this article we’ll move to a next level and develop a model that... Read more
Every year since 2011, I’ve geared myself up to host SQL in the City in the confines of an event space, conference centre or hotel. The events have always delighted attendees and have proved to be successful but, in the spirit of change and innovation, we’re doing things differently for 2016. In two weeks’... Read more
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 website describes it: “A... 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 demonstrate what you’ve done,... 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 share my impressions and... 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 them. 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? How do you get... 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 with engineering The engineering... Read more
