Skip to content
  • +44 7739 427279
  • info@federico-razzoli.com

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Category: MySQL for devs

Foreign Key bugs in MySQL and MariaDB

Federico Razzoli October 16, 2019May 14, 2020 4 Comments

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

Read more
InnoDB MySQL for devs

Case sensitivity in MySQL and MariaDB queries

Federico Razzoli October 2, 2019November 30, 2019 4 Comments

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 more
MySQL for devs

READ ONLY transactions in MySQL (→Vettabase)

Federico Razzoli August 27, 2019November 21, 2020 9 Comments

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

Read more
InnoDB MySQL for devs

MySQL/MariaDB: use SQL properly to run less queries (→Vettabase)

Federico Razzoli July 29, 2019November 21, 2020 Leave a comment

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

Read more
MySQL for devs

MariaDB Stored Aggregate Functions by examples

Federico Razzoli May 9, 2019June 28, 2020 2 Comments

Let’s use MariaDB 10.3 stored aggregate functions to implement a geometric mean.

Read more
MySQL for devs

3 good reasons to use Stored Procedures

Federico Razzoli May 7, 2019June 10, 2019 12 Comments

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.

Read more
MySQL for devs

Working with JSON objects in MySQL/MariaDB

Federico Razzoli May 1, 2019December 1, 2019 4 Comments

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

Read more
MySQL for devs

Circular tables in MariaDB

Federico Razzoli April 5, 2019April 5, 2019 5 Comments

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

Read more
MySQL for devs

NULL comparisons in MySQL, PostgreSQL, and SQLite

Federico Razzoli March 5, 2019July 14, 2020 1 Comment

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

Read more
MySQL for devs SQL

How to concatenate strings in MySQL and MariaDB

Federico Razzoli February 28, 2019September 30, 2019 2 Comments

MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs.

Read more
MySQL for devs
  • ← Previous

Recent Articles

  • Do languages need NULL? – Rust example
  • Webinar: Database Design most common pitfalls
  • Consistency Level patterns for high accuracy in Cassandra
  • MySQL backup methods comparison
  • Sizing Aria Pagecache (→Vettabase)
  • Webinar: MySQL Backups
  • Can we shrink InnoDB Buffer Pool? (→Vettabase)
  • Is InnoDB Buffer Pool big enough? (→Vettabase)
  • About Planet MySQL
  • MySQL danger: comments and ALTER TABLE

Categories

  • Amazon Redshift
  • Cassandra
  • Community and news
  • InnoDB
  • Monitoring
  • MySQL and MariaDB
  • MySQL for devs
  • Operations
  • PostgreSQL
  • Query optimisation
  • SQL
  • Stored procedures

Recent Comments

  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB
  • Daniel R. on Working with JSON arrays in MySQL/MariaDB
  • Federico Razzoli on Working with JSON arrays in MySQL/MariaDB

Archives

  • June 2020 (4)
  • May 2020 (3)
  • April 2020 (4)
  • March 2020 (3)
  • February 2020 (2)
  • January 2020 (3)
  • December 2019 (2)
  • November 2019 (1)
  • October 2019 (2)
  • September 2019 (3)
  • August 2019 (3)
  • July 2019 (1)
  • June 2019 (5)
  • May 2019 (6)
  • April 2019 (7)
  • March 2019 (4)
  • February 2019 (6)
Copyright © 2021 Federico Razzoli.
Powered by WordPress. | Theme: colorskin by Dimitrakopoulos.