How do you represent information like this in a database?
This event happened in 2015/06, but we don't know in ...
Hierarchical and networked data appears everywhere in modern databases: organisational charts, product category ...
I see a lot of problems with database schemas: missing indexes, wrong types, tables used like an spreadsheet... ...
Years ago, it was extremely common to store user-uploaded images and other multimedia contents in a database. This ...
What are the 3 ways to select rows from a query result in SQL? When you need a subquery or a view? Read more in this article!
SQL is the language of data. You write a query, a single sentence in a language that resembles English, and you ...
MariaDB stored procedures and why they should be improved was the title of my talk at MariaDB Server Fest 2023 in ...
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...