Showing entries 1 to 10 of 11
1 Older Entries »
Displaying posts with tag: MySQL for devs (reset)
Foreign Key bugs in MySQL and MariaDB

Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here.

Case sensitivity in MySQL and MariaDB queries

Maybe you’re wondering why in MySQL/MariaDB 'string' seems to be the same as 'STRING'. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case ...

READ ONLY transactions in MySQL

MySQL transactions can be read only. Here's how to use them, and why they are useful.

MySQL/MariaDB: use SQL properly to run less queries

Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose.

Paginating the results of an SQL query

One of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down. You want the DBMS to only return ...

The post Paginating the results of an SQL query appeared first on Federico Razzoli.

MariaDB Stored Aggregate Functions by examples

MariaDB 10.3 supports stored aggregate functions. Let's see how to create them with examples.

The post MariaDB Stored Aggregate Functions by examples appeared first on Federico Razzoli.

3 good reasons to use Stored Procedures

Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.

The post 3 good reasons to use Stored Procedures appeared first on Federico Razzoli.

Working with JSON objects in MySQL/MariaDB

MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.

The post Working with JSON objects in MySQL/MariaDB appeared first on Federico Razzoli.

Circular tables in MariaDB

Let's create a table that always contains a fixed amount of rows, using MariaDB 10.3.

The post Circular tables in MariaDB appeared first on Federico Razzoli.

NULL comparisons in MySQL, PostgreSQL, and SQLite

Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.

The post NULL comparisons in MySQL, PostgreSQL, and SQLite appeared first on Federico Razzoli.

Showing entries 1 to 10 of 11
1 Older Entries »