Future Studio Tutorials

Public tutorial on Thursday. Wednesday is only.

MySQL — Group Ranges Into Buckets

We’re working on a running project and want to calculate statistics. For example, how many 10k runs happened during the competition? Or how many half-marathons and marathons did people run? Runners in the event use Strava to track their activities. We’re using Strava webhooks to process and store …

Continue Reading

MySQL — Group by Date or Time

MySQL allows you to group data by certain attributes. Typically you’re grouping data when creating statistics. For example, you want to count the number of users made on a given day or within a selected month. This tutorial shows you how to group data in MySQL by date or …

Continue Reading

MySQL — Get the First Day of the Month

MySQL includes dozens of useful date and time functions. For example, you can retrieve the last day of a month using MySQL’s LAST_DAY function. But there’s no equivalent FIRST_DAY function. Yet, you can calculate the date of the first day of a month and this tutorial …

Continue Reading

Git Prune Remote Branches That No Longer Exist

In git, you’re working with branches. A branch describes a parallel state to the main branch. You can change the code in your branch and test it without affecting the stable main branch. In your development team, you’ll review and work on different features which probably have their …

Continue Reading
Page 1 of 94

Explore the Library

Find interesting tutorials and solutions for your problems.