
Agora uses 3.is to power best-in-class governance platform
How 3.is enables database access for governance data
The Challenge
Agora powers best-in-class governance platforms for top crypto protocols
Agora offers the best-in-class governance platform for crypto protocols, including Optimism, Nouns, ENS and Uniswap. To power this platform, Agora requires a significant amount of on-chain governance data.
Agora considered building data infrastructure in-house, but knew it would be difficult
Agora considered building the necessary indexing and database infrastructure in-house, but knew this would be complex, time-consuming and expensive. They looked at third-party solutions, but had stringent requirements around speed and flexibility.
Solution
Agora found 3.is — which was able to provide direct database access to the data it needs. That means the Agora team can write direct SQL queries on the data, which provide unmatched speed and flexibility. Agora benefits from:
- Self-serve portal: Agora simply specifies the governance contracts that it cares about via a self-serve portal, and sees new tables populate in Postgres in seconds. New events are pulled into the database milliseconds after they land on chain.
- Optimized database performance: 3.is optimizes database performance and speed, so that Agora doesn't have to think about it. For tricky queries or unfamiliar data structures, the 3.is team provides support.
- Direct database access: Agora has direct database access to tables that operate, effectively, as if they were indexing the data themselves without any of the operational overhead.
Results
- ENS governance platform at https://agora.ensdao.org/
- Optimism governance platform at https://vote.optimism.io/
- 100K+ governance events indexed
- More governance platforms on the way!