Unfolding the Blockchain Narrative

In the rapidly evolving world of blockchain, Once Upon is quietly making a name for themselves as a true pioneer. With a belief that every transaction tells a story, they have set out to challenge established players like Etherscan. Their goal is ambitious: create a block explorer that not only tracks every transaction ever recorded but also makes these digital stories human-readable. The result is an elegant, and engaging platform that transformed blockchain exploration into an intuitive and even enjoyable experience.

The Infrastructure Challenge

Building an ETL (Extract, Transform, Load) process for such a sophisticated block explorer is no trivial undertaking. The task involved handling billions of transactions - a feat requiring an advanced infrastructure layer. The talented team at Once Upon didn't underestimate this challenge. They built a capable infrastructure layer, but the costs were astronomical, both in terms of resources and maintenance.

In the realm of early web3 innovation, many teams find themselves burdened with infrastructure development, detracting from their core product focus. That's where Indexing Co. steps in, specializing in lifting the heavy load of infrastructure, allowing clients like Once Upon to concentrate on what they do best and delivering value to their users.

Your data. Your way.

Once Upon had already invested significantly in their infrastructure, but scalability and efficiency issues were evident. Traditional backfilling of a new network was taking over a week, severely limiting their ability to innovate with data. Infra was becoming a bottleneck to their product visions.

The choice was clear: invest in the team to build out enterprise-grade indexing systems or seek an external solution. Indexing Co. offered just that - a flexible, non-opinionated infrastructure solution that fit seamlessly with Once Upon's existing framework.

Here's how we adapted to their needs:

• Database Flexibility: For Once Upon, we integrated with their chosen database, ensuring seamless data flow. In this case we plugged directly into the mongoDB and optimized backfill pipelines to best fit their database. We helped Once Upon to set up partitions + indexes and hopped on with their MongoDB support to resolve issues as needed
• Chain Expansion: In the first week alone, we helped backfill 8 new chains, eventually expanding to 18. This rapid scalability was a game-changer.

Adding additional networks is seamless due to the flexible nature of Indexing Co’s platform. In one particular instance we helped Once Upon onboard the entire mode network in just under 3 minutes.