Best practice for collection union
Hi! I'm working on an app that combines data from two different datasources (currently using tanstack/db + tanstack/query). There are a few options on how to handle this, but I haven't found a good, built-in way for tanstack/db:
Given two collections, that produce the same datatype, I want to combine the result set into a single result, e.g.:
Preferably this could be done with tanstack/db, so there is support for db operations such as orderBy, where, etc., something like this:
Alternatively, right now I have to do:
Or I can combine the result of the api calls in
Given two collections, that produce the same datatype, I want to combine the result set into a single result, e.g.:
[ItemA1, ItemA2] + [ItemB1] => [ItemA1, ItemA2, ItemB1]Preferably this could be done with tanstack/db, so there is support for db operations such as orderBy, where, etc., something like this:
Alternatively, right now I have to do:
Or I can combine the result of the api calls in
queryFn
