THE CHALLENGE
Finding the right database for a scalable, mobile-first environment
Picap is a big believer in innovation and does a lot of development in-house. In an industry where manual processes are common, it designed software to digitalize 90% of the processes behind transport and logistics. But backend processes are only part of the story. Picap wanted the app it built for drivers and customers to be easy to use and designed around the needs of real people.
“People are at the heart of everything we do. Our platforms need to be scalable, highly available, and easy to use so we can help more drivers to earn on the road,” explains Andrés Murcia, Chief Technology Officer at Picap. “Working for us is the only source of income for some drivers, but others fit it in around their studies or other jobs. Our app was designed with the flexibility to cater to both groups.”
Picap’s multi-cloud environment spans AWS and Google Cloud, and it needs any technology it works with to be optimized for mobile.
In 2016, when evaluating available databases, Picap struggled to find a SQL database with the flexibility and scalability it needed. The solution Picap was looking for also needed fast response times and to be able to support the Ruby programming language and Google’s Flutter apps.
“The impact of choosing the wrong database solution would have been huge. Without high levels of performance and scalability, we wouldn’t be able to give customers and drivers the high-performing app they rely on,” says Murcia. “That would have led to a dip in service quality and bad reviews from customers that could potentially slow down company growth. In a competitive industry, it’s not a risk we could take.”
OUR SOLUTION
Taking a platform approach to support growth and agility
Picap implemented MongoDB Atlas as the transactional data store for its main platform, which supports business services and operations. Critical services rely on the biggest cluster, which stores transactional data for Pibox, while location data, metadata, driver working logs, and geolocation data is spread across other clusters.
“This setup enables us to achieve optimal efficiency around handling and processing data,” says Murcia. “The transactionality, speed, and reliability of MongoDB Atlas improves business processes and operations.”
Additionally, the introduction of MongoDB Time Series Collections has revolutionized the way the company has managed its extensive logistics data, such as drivers’ working hours. “The specialized columnar storage format and efficient data-handling capabilities allow us to process high volumes of time-stamped data with unprecedented speed and accuracy. This has not only streamlined our operations but also enabled us to extract valuable insights in real-time, helping us to continually optimize our services and customer experience," adds Murcia.
The company’s mobile app is optimized for multiple cloud environments, including AWS and Google Cloud. MongoDB Atlas is compatible with multi-cloud and handles data synchronization and real-time updates, which are vital for drivers. Features such as geolocation tracking and transaction processing are also made more efficient thanks to the platform’s robust data-handling capabilities. Overall, this makes life much easier for drivers and enhances the app’s user experience.
As the business matured and diversified, Picap implemented more of the MongoDB platform, including local persistence on-device with Atlas Device SDKs. The solutions are used alongside Ruby and Flutter to improve the developer experience and give them the agility, scalability, and responsiveness they require to build new features quickly.
“MongoDB is a pillar of our business. All transactions run on MongoDB, and it’s essential to managing both lines of business efficiently,” notes Hernández.
Picap also receives support from the team at MongoDB, including technical assistance, education around best practices, and guidance on how to optimize services. “The support from MongoDB helps us resolve issues quickly and maintain high levels of operational efficiency. That’s crucial to keeping our platform reliable and high performing,” adds Murcia.