How to Create a Generated Column in MariaDB

A generated column is a database column whose value is an expression. Therefore, the value of the generated column is usually derived (for example, it could be derived from values in other columns).

Generated columns are also sometimes referred to as computed columns or virtual columns.

Creating a generated column in MariaDB is essentially the same as creating a normal column. The difference is that the definition of the generated column contains an expression that determines the column’s value.

Continue reading

Redis BLMPOP Command Explained

In Redis, the BLMPOP command is the blocking variant of LMPOP.

Just like the LMPOP command, BLMPOP pops one or more elements from the first non-empty list key from the list of provided key names. However, unlike LMPOP, if all lists are empty, BLMPOP blocks the connection until another client pushes to it or until the timeout (a double value specifying the maximum number of seconds to block) elapses.

Continue reading

Redis BRPOP Command Explained

In Redis, the BRPOP command is the blocking variant of the RPOP command. It blocks the connection when there are no elements to pop from any of the given lists.

The way the command works is that an element is popped from the tail of the first list that is non-empty, with the given keys being checked in the order that they are given. When there are no elements to pop from any of the lists, it blocks the connection.

Continue reading

Redis BLPOP Command Explained

In Redis, the BLPOP command is the blocking version of the LPOP command. It blocks the connection when there are no elements to pop from any of the given lists.

The way the command works is that an element is popped from the head of the first list that is non-empty, with the given keys being checked in the order that they are given. When there are no elements to pop from any of the lists, it blocks the connection.

Continue reading