From Rockset to ClickHouse: How Lens made its database faster and more efficient

Lens Protocol is an open social protocol built on the blockchain, providing users with ownership and control over their profile, social graph, and data. The platform relies heavily on machine learning for feed ranking algorithms and bot detection mechanisms. Initially using Postgres and then Rockset to manage its data needs, Lens faced challenges such as data ingestion delays and query concurrency limits. To overcome these issues, the team migrated to ClickHouse Cloud, which has significantly improved their data operations by enabling near-instantaneous data processing and handling a high volume of concurrent queries without performance degradation. The migration to ClickHouse has provided Lens with scalability and confidence in its ability to support future growth and development of social products.