Our great sponsors
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
I know the project epirus (https://github.com/web3labs/epirus-free) is mostly used for private Ethereum blockchains but I don’t know why you couldn’t use it against mainnet.
Block explorers like Etherscan and EthVM maintain additional indexes that use a lot more space than a normal node to make everything efficiently queryable. My team has developed Flume which will index logs, transactions, receipts, and blocks into a relational database, but that database ends up being >1.25 TB without even having the Ethereum state trie. Queries are super efficient, but the tradeoff is a lot more disk space.