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.
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 readingIn Redis, the RPOP command removes and returns the last elements of the list stored at the specified key.
By default, the command pops a single element from the end of the list. However, we have the option of passing a second argument that specifies how many elements to pop.
Continue readingIn 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 readingIn Redis, the LPOP command removes and returns the first elements of the list stored at the specified key.
By default, the command pops a single element from the beginning of the list. However, we have the option of passing a second argument that specifies how many elements to pop.
Continue readingIn Redis, the RPUSHX command inserts one or more values into the tail of the list at the specified key, but only if the key exists and it contains a list.
If the key doesn’t exist, no operation is performed. If the key exists but it doesn’t contain a list, an error is returned.
Continue readingIn Redis, the RPUSH command inserts one or more values into the tail of the list at the specified key.
If the key doesn’t exist, it is created as an empty list before performing the push operation. If the key already holds a value that is not a list, an error is returned.
Continue readingIn Redis, the LPUSHX command inserts one or more values into the head of the list at the specified key, but only if the key exists and it contains a list.
If the key doesn’t exist, no operation is performed. If the key exists but it doesn’t contain a list, an error is returned.
Continue readingIn Redis, the LPUSH command inserts one or more values into the head of the list at the specified key.
If the key doesn’t exist, it is created as an empty list before performing the push operation. If the key already holds a value that is not a list, an error is returned.
Continue readingIn PostgreSQL, the CASE expression compares a list of conditions and returns one of multiple possible result expressions.
The CASE expression is included in the SQL standard (ISO/IEC 9075), and most major RDBMSs support it.