Company and Use Case

Bonito Tech is a Philippines-based development company specializing in custom software solutions for clients across industries such as telecom, startups, and mining. They develop everything from web and mobile applications to complex data visualization and warehousing systems. Bonito Tech’s flagship project, Sakai, is a public transportation app that tracks and analyzes real-time vehicle locations in the Philippines. By integrating TimescaleDB, Bonito Tech efficiently handles vast amounts of time-series data, ensuring accurate and actionable insights for its users.

Performance Problems to Solve

Bonito Tech faced challenges managing the rapidly growing data generated by Sakai’s real-time vehicle tracking system. Initially relying on PostgreSQL, the team encountered performance bottlenecks, particularly with data archiving and querying, which caused slowdowns and service interruptions. Deleting or truncating old data would lock the database, limiting their ability to scale and maintain reliable service. They needed a solution that could store, process, and retrieve billions of data points quickly and efficiently.

Performance Gains Unlocked

With TimescaleDB, Bonito Tech optimized their data handling by leveraging time-series capabilities tailored for vehicle trajectory data. TimescaleDB's automatic data retention policies allowed the team to manage massive datasets without manual intervention, significantly improving both query performance and scalability. Additionally, deploying TimescaleDB on the cloud ensured seamless integration with Google Cloud, enhancing performance across their distributed system. As a result, Bonito Tech could focus on refining their analytics instead of wrestling with database performance issues.