All posts about relational database like MySQL and NoSQL with Elasticsearch (page 2/2)

What is an application without data. I'm not talking of BigData, but current data of a project that we need to store and use. From relational database mostly with MySQL or MariaDB to persist transactional data in longterm to NoSQL use with Elasticsearch to speed up application but also to use advanced features to facilitate search or dashboard creation. This is the main purpose of posts in this category.

Handling dates and times in SQL queries with MySQL & MariaDB

Manipulating dates in a programming language (PHP, Java ....) is simple and known to all. But what about in the MySQL database? In this article I present what it is possible to do in SQL queries: operation, date interval ... Read the post