👋 If project is paused, does it mean it does not receive any requests from the application? - Which would mean nothing would be stored in a DB

I would like to think so, yes.

Then it would seem that supabase isn't good for small projects (on free tier) that don't have weekly traffic

I think the free tier is mainly for dev work, so while you are creating the project use it.

Yeah, seems so. But, would rather self host 😄

Nothing stopping you from doing that, that doesn't have a project pause feature from what I can tell