If you want to use React, use something like Nextjs or Gatsby to compile it into a static HTML website.
Gatsby doesn't compile to a static HTML website. It compiles to a static site. There's a subtle difference. The pages are rendered on the server and served as static assets, but the entire React routing and content loading is still there. When a visitor loads a page it renders and then gets turned from plain HTML back in to a React again. When you navigate from one page to the next all the content for further pages is preloaded. You are not loading a full HTML page for each link you click on (which is exactly what makes it feel so lovely and fast - everything is being preloaded behind the scenes).
I've built API powered React sites with almost no consideration for SEO that Google has indexed without issue. My experience has been that as long as the API requests for content are quick Google is happy to wait and index correctly as expected. YMMV obviously.
Single-page apps (SPAs) using client-side rendering (CSR) like React do get indexed by Google, it's just not instant. Depending on how long it takes for the content to load, the Googlebot might not be able to figure out the correct on-page SEO.
If SEO is a critical requirement, I'd recommend either server-side rendering (SSR) through a framework like Next.js or completely static sites through whatever framework you prefer (Next.js, Gatsby, 11ty, Hugo, Jekyll, etc, etc).
I have been "struggling" with this myself for a long time. It doesn't affect my day to day life but I'm still searching what to do with my life. So much I want to do and so little time.
I saw some mentionings of philosophers. I would love to read what philosophers said about "regret". Does somebody have a list of books or sources to read about this subject?
+1 - I have a couple Chromecast Audios that I use as a poor-man's Sonos and it works pretty well, but the Spotify iOS app's Chromecast streaming is pretty half-assed. It can only adjust volume when the app is in the forground, and sometimes not even then, sometimes forgets it's streaming and loses sync.
That gives you understanding of data modeling, dimensions vs facts and how to structure database tables (or other data stores). Next read up on ETL system (how to get data into databases) and Hadoop (aggregating data among dimensions). At least for Hadoop there should be many online presentations and youtube videos. Lastly data visualization.
This is exactly what is was trying to build for myself. I saw that no tracker was simple and still full of functions. Except for the tax part. I'm still building my own but you gave me allot of great ideas