There are plenty of ways that apps can unintentionally misuse databases. When the abuses are pervasive, you can catch them by means of a few deft queries on various DMOs.
Orange is an extremely easy-to-use, lightweight, drag-and-drop tool for building machine learning models and analyzing data. More importantly, it is open source!
Window functions and CTEs have been a mainstay of many popular DB products for some time now. With the release of MySQL v8 and MariaDB 10.2.0, both vendors have caught up with competing DBMSes.
The SOLID design principles can be a little tricky to get your head around. In this post, we dive into the S in SOLID - the Single Responsibility Principle.