Searching similar vectors in SQLModel about pgvector-python

[pamelafox]

Is that a run-time error a typing error? I can replicate the typing error with mypy, but not a runtime error.

[ankane]

Thanks @pamelafox, it looks like it's a typing error from Pyright (can reproduce with pyright tests/test_sqlmodel.py).

error: Cannot access member "l2_distance" for type "List[float]"
  Member "l2_distance" is unknown (reportAttributeAccessIssue)

I'm not sure I'd like to commit to supporting types right now, but if someone decides to fork and add, please share.

[ankane]

Hi @AniLeo-01, I'm not sure how to reproduce. If you can create a minimal reproducible example, happy to look into it more (see the tests for some examples).

[AniLeo-01]

So I have this Vectors table model:

embedding_dim = int(get_settings().EMBEDDING_DIM)
class Vectors(SQLModel, table=True):
    id: Optional[UUID] = Field(default=None, primary_key=True)
    embedding: List[float] = Field(sa_column=Column(Vector(embedding_dim)))

When I'm using the query on this table, it is showing the following issues:

Can you reproduce the issue?

[AniLeo-01]

I'm not sure of it, let me try it once.