Menu

1 / 2

Build Buddy, Day 5: my vector search's best match was a wrong answer

DEV Community: postgres·Gabby Gill·about 14 hours ago
#IwGQfhf7
#devtopostgresql#devto#dev#wrong#null
Reading 0:00
15s threshold

Day 5 of MLH Global Hack Week: Builders Week. All week, Build Buddy has been collecting explanations from AI models about C# compiler errors. Some of them are right. Some are confidently wrong. Today I put them in a vector database to see what happens when you search them like a RAG system would.

The setup

12 real explanations of compiler errors from Gemma 3 4B and Grok 4.7, collected during the week

Each one reviewed by hand : correct, wrong, or inconsistent

Embedded locally with nomic-embed-text through Ollama, so no text left my laptop

Stored in a Tiger Data hypertable with a VECTOR(768) column and an HNSW index

CREATE TABLE fix_notes ( noted_at TIMESTAMPTZ NOT NULL , model TEXT NOT NULL , error_code TEXT NOT NULL , explanation TEXT NOT NULL , review TEXT NOT NULL , embedding VECTOR ( 768 ) NOT NULL ) ; SELECT create_hypertable ( 'fix_notes' , by_range ( 'noted_at' , INTERVAL '1 day' ) ) ; CREATE INDEX ON fix_notes USING hnsw ( embedding vector_cosine_ops ) ;

Enter fullscreen mode

Exit fullscreen…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.