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 …

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 …

You already have all your data in MySQL and for some decisions, you want to use statistics based on your data. For example, you may want to query the number of users that signed up during a given month. Or how many actions were triggered in a month. This tutorial …

MySQL comes with dozens of date and time functions. It’s great to have these functions at hand in your SQL queries. The database can already do the calculations you would do afterward in your code. One of these date functions is to get the last day of a 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 …

MySQL comes with dozens of date and time functions. It can already handle calculations at the database level and you may filter the result based on the number of days between two dates. MySQL’s integrated DATEDIFF date function handles that calculation for you. This tutorial shows you how to …

We’re working on the next iteration of the Future Studio website. The new website uses MySQL as the database. The database schema uses foreign key relationships between columns in different tables. At some point, we ran into the following issue when truncating the data in a MySQL table: [MySQL] …

In the previous two tutorials, you've learned how to set up custom fonts on Android the modern way. Either as fixed font style (such as Noto Serif bold) or as font family (such as Noto serif in several weights). However, so far you've only used XML designs to configure app …