Use MySQL Window Functions to Get More out of Your Data
MySQL introduced Window functions in their release of MySQL version 8.0. to target groups of rows without collapsing them. In this article, we will explore example implementations of the most versatile window functions MySQL has to offer.
MySQL Schema Design: Back to The Future?
Once developers find themselves in the MySQL world, they will almost certainly hear some advice on how they should go about designing database schemas in MySQL. This blog post will provide insight into what you should consider when dealing with database schemas in MySQL.
Performance differences between Postgres and MySQL
What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency.
A very short guide to choosing between MySQL and PostgreSQL.
While MySQL and PostgreSQL have many things in common, you should make sure you understand the differences between them in order to make sure you select the right one for your specific application.