Skip to content

Instantly share code, notes, and snippets.

@ps2
Created March 11, 2015 19:25
Show Gist options
  • Save ps2/9174963c583ee285feb5 to your computer and use it in GitHub Desktop.
Save ps2/9174963c583ee285feb5 to your computer and use it in GitHub Desktop.
Google product search
image, keywords, category hierarchy
https://support.google.com/merchants/topic/2473799?hl=en
https://support.google.com/merchants/answer/188494
Categories: https://support.google.com/merchants/answer/160081?hl=en
Google’s or your own: separate attributes
Current Comparison
Color
Text
Shape
Title similarity:
Full Text Search: http://www.postgresql.org/docs/9.4/static/textsearch-intro.html#TEXTSEARCH-MATCHING
pg_trgm: http://www.postgresql.org/docs/current/interactive/pgtrgm.html
Vector(color, image, shape?) similarity:
smlar: http://railsware.com/blog/2012/05/10/effective-similarity-search-in-postgresql/
Implementation
Docker?
Figure out windows dev setup?
Product Extract:
Google product format
Golang (postgres driver?)
Postgres
Any extensions? pg_tgrm?, smlar?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment