Task: Integrate color-based search

[iolyd]

Task Description

For greater appeal to lay people and to put forth the visual dimension of design, a color-based search or filtering functionality here is relevant. As much as possible, we should try to leverage postgres to handle storing the color values and assessing the proximity of various values.

Resources

• Using postgis for colors: https://www.the-art-of-web.com/sql/postgis-compare-colors/

List of actions

• Pre-requisites:
  • Complete image upload implementation
  • Add dominant color(s) extraction during server-side processing on upload
• Identify approach for postgres color proximity evaluation
• Implement color-based search
  • Evaluate if can be chainable with other supabase-js filtering methods

[iolyd]

The adopted approach for storing color values is to use postgres's cube extension, storing colors as point-cubes aka cubes of size 0 (https://www.postgresql.org/docs/current/cube.html). This is simplifies to storing colors as 3d vectors (r, g, b) and enables proximity search using euclidian distance computation, with the <-> operator.

Next step is to determine how color-based search queries can be executed. Are rpc calls unavoidable? If so, how can they chain with other filter params?

[iolyd]

Technical challenges are essentially solved through our migration to drizzle-orm and the publication of drizzle-orm-helpers including the cube custom type driver and cube-related operations.