Company or project name
ClickHouse
Use case
ClickHouse is used to analyze scientific and raster data visually. See https://adsb.exposed/ as an example.
Describe the solution you'd like
Add two functions:
colorSRGBToOkLCH
colorOkLCHToSRGB
These functions take a three-element tuple of floating-point values (or values of other numeric types, which are converted to floating-point internally), and an optional value of gamma (by default it is set to 2.2), and return a three-element tuple.
It can return out-of-range values, such as values less than zero or more than 256 for RGB. Saturation and rounding are the responsibility of the caller. It can also accept out-of-range values.
See https://oklch.com/
Describe alternatives you've considered
It is doable with SQL UDF.
Additional context
No response
Company or project name
ClickHouse
Use case
ClickHouse is used to analyze scientific and raster data visually. See https://adsb.exposed/ as an example.
Describe the solution you'd like
Add two functions:
These functions take a three-element tuple of floating-point values (or values of other numeric types, which are converted to floating-point internally), and an optional value of gamma (by default it is set to 2.2), and return a three-element tuple.
It can return out-of-range values, such as values less than zero or more than 256 for RGB. Saturation and rounding are the responsibility of the caller. It can also accept out-of-range values.
See https://oklch.com/
Describe alternatives you've considered
It is doable with SQL UDF.
Additional context
No response