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 ...
All posts about relational database like MySQL/MariaDB and PostgreSQL (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/MariaDB and PostgreSQL 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.
Background: One site offers its members to vote to elect the member of the month. Each month the counters are reset to zero. On a dedicated page, the site displays the history of the top 5 members of each month over a period of one year.