"live" time series query
I'm not currently using TanStack Query, but I would like to! and want to know if it could fit my current use case. I'll try to be as concise as possible.
I have a database table called
which is unique on timestamp+case_id
And another table called
which is unique on case_id only
A user on the frontend (vite react) selects a specific case, and updates its
Another server sees the
I would like the frontend to show the case's data as soon as it's available, instead of pinwheeling for ~10 mins; so meanwhile the frontend incrementally queries the
{
case_id: number,
starting_data_index: number,
num_results: number
}
And the backend's response is like:
{
results: [ data, data, ...],
actual_num_results: number
}
The response may not include the total
Can something similar be achieved in TanStack query? I can change the backend functionality, but I can't make the "other server" insert records faster, and I'd like to keep the incremental data loading if possible.
Sorry for being long winded, and thanks!
I have a database table called
case_datawhich is unique on timestamp+case_id
And another table called
caseswhich is unique on case_id only
A user on the frontend (vite react) selects a specific case, and updates its
statusAnother server sees the
statuscase_dataexpected_num_data_recordscase_dataI would like the frontend to show the case's data as soon as it's available, instead of pinwheeling for ~10 mins; so meanwhile the frontend incrementally queries the
case_data{
case_id: number,
starting_data_index: number,
num_results: number
}
And the backend's response is like:
{
results: [ data, data, ...],
actual_num_results: number
}
The response may not include the total
num_resultsresultsstarting_data_indexactual_num_resultsresultsstarting_data_indexactual_num_resultsexpected_num_data_recordsCan something similar be achieved in TanStack query? I can change the backend functionality, but I can't make the "other server" insert records faster, and I'd like to keep the incremental data loading if possible.
Sorry for being long winded, and thanks!
