The generate_subscripts() function in DuckDB creates a series of index values for accessing elements in an array. It can help us iterate through array indices when we need to work with array elements.
Here’s a quick look at DuckDB’s generate_subscripts() function, along with examples.
DuckDB’s command line interface (CLI) provides a convenient .mode csv command that allows you to output all query results directly in CSV format. This approach differs from the COPY statement as it affects the output format of all subsequent queries until changed.
The article takes a quick look at CSV mode in the DuckDB CLI.
Continue readingIn MySQL, list_add() is a system function that adds a value to a comma-separated list of values and returns the result.
So it’s a handy function that allows us to append a value to a list.
Continue readingIn MySQL, list_drop() is a system function that removes a value from a comma-separated list of values and returns the result.
In Redis, we can use the OBECT IDLETIME command to check how many seconds has passed since the last access to a given key.
In Redis, the LTRIM command allows us to trim a list to a specified number of elements. We specify the starting and ending index, which is used to trim the list to just that range.
In Redis, the LSET command allows us to set a list element to a different value, based on its index.
In Redis, we can use the LREM command to remove one or more elements from a list. The number of elements removed depends on the arguments we pass.
In Redis, the LINSERT command allows us to insert an element into a list.
We have the choice of inserting it either before or after a specified element.
Continue readingIn Redis, the LPOS command returns the index of matching elements inside a list.