Configuration

This document provides information on how to configure the Environment variables.

Overview

You should follow the instruments in this .env.template

PgVector

CREATE OR REPLACE FUNCTION finalyzer_id_as_text(json) RETURNS text AS $$
BEGIN
  RETURN ($1->>'finalyzer_id')::text;
END;
$$ LANGUAGE plpgsql IMMUTABLE;

CREATE OR REPLACE FUNCTION finalyzer_path_as_text(json) RETURNS text AS $$
BEGIN
  RETURN ($1->>'finalyzer_path')::text;
END;
$$ LANGUAGE plpgsql IMMUTABLE;

CREATE INDEX idx_finalyzer_id ON data_vector_store (finalyzer_id_as_text(metadata_));
CREATE INDEX idx_finalyzer_path ON data_vector_store (finalyzer_path_as_text(metadata_));