SQL stored procedure
Budget: $250 – $750 USD
Description
Products are stored in a mysql DB where each product has a colour stored in HEX
The big picture is that we need to do nearest neighbour search in a table to find the closest matching colour to a specific HEX colour.
There are many ways, but we need an experienced coder to do this little job to implement the Delta E or any other better search function in MySQL.
We can for example use Delta E for CIELAB that can be made in SQL (https://stackoverflow.com/questions/31798883/performance-of-delta-e-cie-lab-calculating-and-sorting-in-sql)
Euclidean distance can not be used since the Delta E is considering the perception of the Eye's way of perceiving colours. CIELAB 2000 Delta E considers this too.
If you have done this kind of work in SQL previously and colour search this is the job for you.
Work to do:
1. adjust the code in the URL so it fits our table in a MSQL DB
2. Make Nearest Neighbour Search, NNS (similar to K-NN)
Time:
The time this will take to copy the code in the URL and then adjust it for our needs and make NN searches will take approx 2 days for you to do.
Not much more.
Your experience:
- colour search
- stored procedure
- SQL
- 5+ years of work as experience
Products are stored in a mysql DB where each product has a colour stored in HEX
The big picture is that we need to do nearest neighbour search in a table to find the closest matching colour to a specific HEX colour.
There are many ways, but we need an experienced coder to do this little job to implement the Delta E or any other better search function in MySQL.
We can for example use Delta E for CIELAB that can be made in SQL (https://stackoverflow.com/questions/31798883/performance-of-delta-e-cie-lab-calculating-and-sorting-in-sql)
Euclidean distance can not be used since the Delta E is considering the perception of the Eye's way of perceiving colours. CIELAB 2000 Delta E considers this too.
If you have done this kind of work in SQL previously and colour search this is the job for you.
Work to do:
1. adjust the code in the URL so it fits our table in a MSQL DB
2. Make Nearest Neighbour Search, NNS (similar to K-NN)
Time:
The time this will take to copy the code in the URL and then adjust it for our needs and make NN searches will take approx 2 days for you to do.
Not much more.
Your experience:
- colour search
- stored procedure
- SQL
- 5+ years of work as experience