enable SSR on SIGs/Projects page by reducing number of airtable requests #59
Description
The Projects page is currently using SSG + ISR since it takes too long to build at request time. The most likely reason for this is the number of requests to Airtable that the page has to make to get all the project information, which currently is 128 requests. Given Airtable's rate limit of 5 requests per second, the high request amount and relatively slow API means a longer time for the page to build.
We should be able to reduce the total number of requests down to just 3-5 by pulling all the tables in at once (they aren't big, so fine to store in memory), and then combining the data into the format we need for the views on the server. Once we do this, we should be able to enable SSR on the page so that changes in Airtable data are reflected as soon as the page is reloaded instead of after a 60 second delay.