Back to the blog
Retrieval · Field notes

Why my first vector store was a CSV

The cheapest retrieval system that could possibly work, and what it taught me before I reached for anything heavier.

Before the embeddings, before the index, before any of the machinery, there was a spreadsheet. One column of text, one column of vectors written out as strings, and a linear scan that was embarrassingly fast for the size of the problem I actually had.

The point of this first part is not the CSV. It is that the retrieval step deserves to be the last thing you make complicated, not the first. Most of what looks like a retrieval problem is a chunking problem wearing a costume.

We will build up from here — a real index next, then the drift that nobody warns you about — but the shape of the argument is set on day one: measure before you reach for the heavier tool.

One tap, no account

Did it hold?

Answer and you’ll see where other readers landed — and what your own read looked like. Measured while you were reading it.

Attention broke around¶1estimated from your reading pace — nudge it if I guessed wrong
You read for
Your pace
You held to
answers · Nothing is published under your name.

Comments

Sign in to join in

Loading comments…