@monteluna
I wouldn't necessarily say this. I've used multiple indexing solutions ( @dune.eth, @envio, and touched some others).
The fundamental issue is trying to sync data between two different computers is a hard problem. There's blockchain state, then the indexer solutions usually roll with their own database that syncs events. Usually teams also want a third (or more) product database.
Maintaining messages between each layer is hard. Also, since the indexers only capture specific events that you listen for, every time you want a new event, you have to re-index and orchestrate how you want to update the product database, while also maintaining uptime.
It doesn't matter if you're using Base or any other chain, the problems are across whatever L2's data you're interested in. Data engineering is hard in general.
https://x.com/LefterisJP/status/2028048813491995122