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

Federico Razzoli

  • About Me
  • Newsletter
  • Webinars
  • Vettabase
  • Contacts

Category: SQL

MariaDB RETURNING Statements (→Vettabase)

Federico Razzoli July 7, 2020November 13, 2020 Leave a comment

MariaDB supports INSERT RETURNING and DELETE RETURNING, which help avoid an additional SELECT.

Read more
MySQL and MariaDB SQL

Do languages need NULL? – Rust example

Federico Razzoli June 28, 2020June 29, 2020 Leave a comment

Rust shows the correct way to implement NULL in a programming language.

Read more
SQL

MySQL danger: comments and ALTER TABLE

Federico Razzoli April 21, 2020April 21, 2020 2 Comments

In MySQL/MariaDB one has to use ALTER TABLE to set a table comment. This is a problem in many situations.

Read more
Operations SQL

When to use NULLable columns in relational databases (→Vettabase)

Federico Razzoli March 29, 2020November 17, 2020 Leave a comment

There are cases when using NULL in an SQL database is desirable. However, there are always alternatives.

Read more
SQL

Optimising or fixing SQL queries: how to ask for help

Federico Razzoli September 22, 2019December 8, 2019 Leave a comment

If you need free help or paid support, you should phrase your questions correctly and provide the necessary information.

Read more
SQL

What does NULL mean in SQL? (→Vettabase)

Federico Razzoli April 2, 2019November 17, 2020 Leave a comment

Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent.

Read more
SQL

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

Recent Articles

  • DROP TABLE improvements in MariaDB (→Vettabase)
  • MariaDB RETURNING Statements (→Vettabase)
  • 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)

Categories

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

Recent Comments

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

Archives

  • July 2020 (2)
  • June 2020 (4)
  • May 2020 (3)
  • April 2020 (5)
  • 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.