2 things: E2PG and RLPS (hosted nodes optimized for indexers)E2PG is an open source Ethereum to Postgres indexer. It connects to an Ethereum source, parses blocks, transactions, and logs and maps data onto PG tables. A single E2PG can index events across many L2s into a single Postgres database. E2PG connects to Ethereum by 1 of 3 ways: JSON RPC API, full node file system (fast), or using RLPS (slower than full node but faster than JSON RPC).RLPS is an HTTP API that delivers compressed RLP data for: blocks, transactions, and logs designed specifically for indexers. Index Supply hosted RLPS runs on many chains including the following OP L2s: 10, 420, 8453, and 84531. Index Supply operates a full nodes (op-geth, op-node) for each hosted RLPS API.
E2PG has enabled several projects (popular NFT websites, erc4337 wallet, MUD games) to index data across many OP L2 chains.RLPS was one of the first hosted node providers for the bedrock release. Since then we've made it dead simple to boot up an E2PG indexer and have it be connected to Optimism and Base to start indexing data across those chains. To my knowledge, E2PG + RLPS is the quickest way to get data from multiple L2 chains into a Postgres database. I don't believe any of the hosted API providers are as easy to setup or are as fast as RLPS to index historical data.
.svg){kind=small}
