what is – Page 71

PostgreSQL DATE_BIN() Function Explained

November 24, 2022 by Ian

In PostgreSQL, the DATE_BIN() function enables us to “bin” a timestamp into a given interval aligned with a specific origin. In other words, we can use this function to map (or force) a timestamp to the nearest specified interval.

This can be handy when we want to truncate a timestamp to a given interval, for example a 10 minute interval. We can specify the interval (e.g. 10 minutes, 15 minutes, 30 minutes, etc), and we can specify the starting point for the interval. Therefore, we can have the interval starting at any odd time we want (it doesn’t need to start on the hour or anything like that).

Redis HINCRBYFLOAT Command

November 16, 2022 by Ian

The Redis HINCRBYFLOAT command increments the field in the hash at the specified key by a floating point number. We specify how much we want the field to increment by when we call the command.

Redis HINCRBY Command

November 16, 2022 by Ian

The Redis HINCRBY command increments the number that’s stored at the specified field in the hash at the specified key. We specify how much we want the field to increment by when we call the command.

Redis HVALS Command

November 15, 2022 by Ian

The Redis HVALS command returns all values in the hash stored at the specified key.

Redis HLEN Command

November 14, 2022 by Ian

The Redis HLEN command returns the number of fields in the hash stored at the specified key.

Redis HGETALL Command

November 12, 2022 by Ian

The Redis HGETALL command returns all fields and values from the hash at the specified key.

Redis HMGET Command

November 11, 2022 by Ian

The Redis HMGET command allows us to get multiple values from a hash. It returns the value/s associated with the specified field/s in the hash at the specified key.

Redis HGET Command

November 10, 2022 by Ian

The Redis HGET command allows us to get a value from a hash. It returns the value associated with the specified field in the hash at the specified key.

Redis HRANDFIELD Command

November 9, 2022November 8, 2022 by Ian

The Redis HRANDFIELD command allows us to get a random field from a given key.

The command accepts several arguments that allows us to specify the number of random fields returned, whether to include the same field multiple times, and whether or not to include the values with each field returned.

The HRANDFIELD command was introduced in Redis 6.2.0.

Redis HEXISTS Command

November 7, 2022 by Ian

In Redis, the HEXISTS command allows us to check whether a field exists in a given hash. We pass the name of the key and the field to the command, and it returns 1 if the field exists, and 0 if it doesn’t.