Schema Design for RAG: Chunks, Versions, Sources in SQLite
Asked one question, a one-table design I built without tenant, version or access columns returned 3 chunks in its top 4 that the user should not get: an old version, another tenant's text, and a note she may not read.
Python 3.12.15