Hacker News new | past | comments | ask | show | jobs | submit login

Not only 3/3 but also includes full text search built in. Tables look like:

    MyThingEmbedding
    ______
    id primary key
    mything_id integer -- fkey to mything table
    embedding vector(1536)
    fulltext tsvector

    GIN index on tsvector
    HSNW index on embedding
Then you can pull results that match either the tsvector AND/OR the similarity with a single query, and it's pretty performant. You can also choose at the query level whether you want exact matching or fuzzy.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: