© 2026 Hedgehog Software, LLC
ALTER TABLE table_name ADD COLUMN openai_embedding vector(3072);
import OpenAI from "openai"; import { createClient } from "@/utils/supabase/server"; const generateEmbedding = async (input: string, id: number) => { const supabase = await createClient(); const openai = new OpenAI({ apiKey: process.env.OPENAI_API_KEY, }); const response = await openai.embeddings.create({ model: "text-embedding-3-large", input: input, }); // embedding is a number[] const embedding = response.data[0].embedding; const { data, error } = await supabase .from("table_name") // openai_embedding is typed as a string .update({ openai_embedding: embedding }) .eq("id", id); };
embedding
number[]
openai_embedding
string
Type 'number[]' is not assignable to type 'string'.