color strip deduplication
Apps Script

Color Vector embeddings vs Video Intelligence API labelling

In Making a film color DNA I described how I was using both color strips and labelled content to find videos that were duplicates or similar. I’m already using ElasticSearch to disambiguate films using labels and object tracking artefacts identified by the Google Video Intelligence API. The next step is to enhance that similarity matching using the color strips of a film as finger prints. […]

CockroachDB

Dynamically updating elastic indices after graphQL mutation

I was talking to some cockroachDB developers at an event lately and discovered that many of them were, like me, using ElasticSearch for full text and complex querying in the cases where SQL was not […]

Elastic

Elastic Search

This section is all about using Elastic Search with Cockroach DB and GraphQL. Sometimes SQL just doesn’t cut it for the kind of searching that’s required nowadays, and you need to use something that’s designed […]

Elastic

Flattening arrays for Elastic Search

The data that comes back from GraphQL is not ideal for input to Elastic Search which is designed for full-text searching, which means it loses context when searching arrays. Consider this response from some fictional […]