SQL with NEAREST NEIGHBOUR MATCHING: Delta E CIELAB for DB indexing, MYSQL
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)
If you have done this kind of work in SQL previously and colour search this is the job for you.
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)
If you have done this kind of work in SQL previously and colour search this is the job for you.
Your experience:
- colour search
- stored procedure
- SQL
- 5+ years of work as experience