I was wondering regarding Web3 data, if anyone was succesful to self-host the transactions in some local database.
When I was trying to do that, my local system could keep up only with doing writes, but not much more. What specs you need to have for that? I guess now its like 10tb of transactions in Ethereum, 1m transactions per day.