Questions about Purpose
I respectfully would like to make sure I understand the value add of this library because I find it super interesting and I may actually use it to speed up some deeply nested stuff I'm doing in a menu builder app, here are some questions I have...
1. If I'm building something with TanstackDB is the assumption that I fetch all my data for a user up front in flat arrays rather than nested data structures, that way I'm doing my joins on the frontend and can keep things more performant?
For example, in my current app, I fetch nested data for a Restaurant that looks like this (it's way more complicated in practice)
It seems like maybe at least part of the goal here is that with the query language I can take some of that load off my backend having to do joins and instead just:
- get all restaurants for user
- get all menus for user
- get all items for user
Then I can do stuff like: caching each endpoint separately, faster querying, easier to write frontend mutations because it's all onto a flat array.
Is this correct?
2. Is the query language a performance thing or a convenience thing? For example to do what I described above I could do something like:
But other than optimistic stuff, is this functionally any more performant than just doing something like this?
This is all I've got for right now, I imagine this could actually be something that speeds up my app considerably.
Also I've attached a picture of the app I'm thinking about doing this on. It's kind of perfectly built for local-first architecture, and if I don't use something like Tanstack DB in the future at some point I'll likely use something else similar.
1. If I'm building something with TanstackDB is the assumption that I fetch all my data for a user up front in flat arrays rather than nested data structures, that way I'm doing my joins on the frontend and can keep things more performant?
For example, in my current app, I fetch nested data for a Restaurant that looks like this (it's way more complicated in practice)
It seems like maybe at least part of the goal here is that with the query language I can take some of that load off my backend having to do joins and instead just:
- get all restaurants for user
- get all menus for user
- get all items for user
Then I can do stuff like: caching each endpoint separately, faster querying, easier to write frontend mutations because it's all onto a flat array.
Is this correct?
2. Is the query language a performance thing or a convenience thing? For example to do what I described above I could do something like:
But other than optimistic stuff, is this functionally any more performant than just doing something like this?
This is all I've got for right now, I imagine this could actually be something that speeds up my app considerably.
Also I've attached a picture of the app I'm thinking about doing this on. It's kind of perfectly built for local-first architecture, and if I don't use something like Tanstack DB in the future at some point I'll likely use something else similar.
