MissS

PostsComments

XXata

•Created by MissS on 6/24/2024 in #help

Filtering searches, row size limitations

I'm currently using filters to create an exact text search but I noticed that there are row size limitations and large rows (>10KB) are being silently excluded. I'm attempting to filter documents, which can be pretty big (hundreds of KB), and I'm wondering if Xata is a good use case for this or not. I think we only care about exact keyword search sorted by date and not BM25 scoring.

2 replies

XXata

•Created by MissS on 6/23/2024 in #help

Search duplication latency

I recently truncated a table, and noticed that the search usage metrics hasn't been updated. How long is the delay between updating the DB and the elasticsearch update?

3 replies

XXata

•Created by MissS on 6/11/2024 in #help

Return types of search

I'm calling xata.search.all on my backend, and I'm trying to figure out what types that I should use to represent the record result. I'm currently searching two tables. Doing RouterOutput['search']['records'][0] gives me one of the two possible types I think? RouterOutput is the return type of the function using TRPC.

2 replies

XXata

•Created by MissS on 6/7/2024 in #help

Increase check limit on text

It seems like Xata is limiting "text" columns to 204800 when it's created through the ui. I'm judging this based on the schema that's generated through the CLI Is there a specific reason for this, will search break if I increase the column size limit?

10 replies

XXata

•Created by MissS on 6/7/2024 in #help

Am I forced to use Xata_id?

I'd want to use a numeric primary key if possible, secondly, I'd probably want to remove xata_id all together

3 replies