I want to create a website but very confused.

First:
I would like to have a homepage, which will get data from supabase ONCE every hour and then cache it, so even if 1000 users access it, it won't go to database 1000 times.

Second:
I will be generating 500 html pages per day on my laptop, I need to host them for 7 days, after that they can go to cold storage or archive (not sure how yet)
once generated these pages will not change, so they must be cached as well.

What are my options, I already studied for ISR, SSR etc.. but I am unable to come up with a hosting strategy and so confused, please help