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.
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.
Java 8 and streams: A match made in heaven, but it can be a little overwhelming. In this post, we take an in-depth look at this combination with some examples.
Where do you begin in choosing a database? We've looked at both NoSQL and relational database management systems to come up with a bird's eye view of both ecosystems to get you started.