[Enhancement] Ensure project list view query is cached

[johnclary]

When navigating back and forth between the project list and project details, it becomes apparent that the data that powers the project list is not cached.

The desired behavior is that previously queried data is always cached so that the project list is not blocked from rendering. The app should also refetch for updated data in the background.

[mddilley]

Started looking into this some yesterday (9/11/23), but I'm going to put it on hold until syncing with John and Chia on other work related to the project list view

Some links:

• What may or may not be cached by Apollo https://stackoverflow.com/a/73344084
• fetch policy https://www.apollographql.com/docs/react/data/queries/#setting-a-fetch-policy
• dev tools (i had to set connectToDevTools = true in the client instance passed to ApolloProvider in App.js to get the tools to work) https://www.apollographql.com/docs/react/development-testing/developer-tooling/#configuration
• https://www.apollographql.com/blog/apollo-client/caching/when-to-use-refetch-queries/
• https://www.youtube.com/watch?v=ZhdGLMeXnvI

[mddilley]

Going to keep this one's status as-is for now. Met with John and Chia yesterday, and we identified short term fixes like lowering the default number of rows and longer term fixes like exploring alternatives to gql abstract. Caching could help us after looking at those solutions.

[johnclary]

Thanks, Mike—I have marked it as blocked by https://github.com/cityofaustin/atd-data-tech/issues/13844. Moving to backlog.

[johnclary]

@mddilley those resources were super helpful! thanks for your research on this!