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 …

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 …

The JavaScript and Node.js ecosystem has a large package ecosystem. You’re typically installing dependencies using a package manager, like npm. Another option is to write the needed code yourself. No matter which direction you’re choosing, your application needs to load the needed files from your own project …

You can create a JSON string from anything in JavaScript using the JSON.stringify(anything) method. However, the resulting JSON string may not contain the expected values. For example, if you’re JSON serializing a JavaScript error, you’ll notice that its JSON string doesn’t contain any properties. JavaScript …

The Fs.realpath method in Node.js resolves the actual file system location of a given path. For example, you’re typically creating a symlink for nginx configuration files from the directory containing all available files to the directory having the enabled files. You can use the Node.js file …