Bus and train travel hubs are full of activity: the crowd, the rush, the lines, the race to the platform r a terminal. Clearly, such places require a lot of organization! In this article, we’ll describe a database model that could keep a transport hub organized. Read more
What kind of database model does it take to run a gallery or museum? How can it be optimized to manage events, partnerships, and other activities? Read more
At Redgate, we think DevOps is now sufficiently mainstream and that it’s worth businesses thinking of moving to a database DevOps type of world. One of the reasons is the 2016 State of DevOps Report from Puppet Labs. They interviewed 4,500 people about their experiences of DevOps and the report provides some strong evidence... Read more
Here at Redgate, there’s a strong sense of working as a team, even across functions, and that really came through during the preparations for this year’s virtual SQL in the City Streamed. Doing a live stream isn’t something I’ve put my hand to before, but I knew a guy – two guys in fact. They... Read more
In this article, I’ll walk you through some fundamental considerations for working with date- and time-related data in MySQL. We’ll also look at how to handle multiple time zones and daylight saving time changes. Read more
Lots of people talk about DevOps lots of the time. No surprise there. It’s seen as the route to speed up the software delivery cycle, while at the same time improving the efficiency and quality of the development process. But how many companies out there are actually doing DevOps? What are the obstacles to... Read more
Project management is a booming field. In this article, we’ll examine a data model to support a project management app. Read more
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
