Ditching PostgreSQL, 10M+ Users Web3 Analytics (www.velodb.io)

Ave.ai, an Australian Web3 and DeFi trading platform boasting over 10 million users, recently transitioned from PostgreSQL to VeloDB as its analytical data infrastructure. The switch was driven by the increasing complexity and volume of on-chain data management—processing hundreds of terabytes of data across more than 190 blockchains and 500 decentralized exchanges (DEXs). With VeloDB, which integrates Apache Doris, Ave.ai aims to enhance real-time data analytics, enabling near-instant insights for users while maintaining scalability and performance during high demand. The significance of this transition lies in the rapid evolution of Web3 technology that requires agile data solutions capable of handling high-concurrency queries and low-latency interactions. VeloDB’s architecture supports flexible scaling, real-time analytics, and high-performance data processing, allowing Ave.ai to achieve write speeds of 5,000 records per second while querying up to 1,000 queries per second with sub-second latency. This upgrade not only improves operational efficiency, with cost reductions exceeding 50%, but also fortifies the platform's ability to provide timely insights, such as transaction metrics and whale movements, crucial for traders navigating the fast-paced DeFi landscape.