Question: Pagination

[VelinGeorgiev]

Is it possible to do a pagination?

I tried the following

 SELECT
           *
        FROM %s
        WHERE embedding MATCH vec_quantize_binary(%s)
        AND k = %d
        LIMIT %d OFFSET %d

but got an error

Only LIMIT or 'k =?' can be provided, not both

I am planning to implement something like this:

SELECT
           *
        FROM %s
        WHERE embedding MATCH vec_quantize_binary(%s)
        ORDER BY distance
        LIMIT %d OFFSET %d

but wonder. Is there a better way to do it?

Thank you very much!

[VelinGeorgiev]

I could not make the second query using the LIMIT work . It throws the same error Only LIMIT or 'k =?' can be provided, not both . Please let me know if there is a better solution, I could perform inline code pagination otherwise anyway.

[asg017]

Pagination isn't supported yet, but I have a WIP PR for it here: #166

LIMIT/OFFSET pagination won't be supported with that PR, but you'll be able to add a AND distance > :previous_distance constraint, for cursor-based pagination

[VelinGeorgiev]

Thank you very much! sqlite-vec is a great little life changer anyway.