Fully customizable PostgreSQL deployment with full support for extensions such as open-source TimescaleDB.
Bring Your Own Cloud on AWS makes database hosting and management scalable and cost-effective.
A simple console with an overview of all their metrics and statistics. Analytical tools helps debug queries and speeds up troubleshooting.
Fully automated PostgreSQL, reducing their time spent managing the database and allowing focus to shift to development.
ScaleGrid has provided us with a flexible solution that we needed to optimize our data storage as we scaled our platform capacity to include new types of air quality data onto the OpenAQ Platform. We were able to lower maintenance costs, reduce time managing our database, and develop a sustainable system so that we can focus on delivering our mission to fight air inequality worldwide. We are grateful for the ScaleGrid team for tailoring services specifically to our needs as a small, mission-driven nonprofit organization.
Fighting air inequality through open data and community is the primary focus for OpenAQ, a non-profit organization empowering communities around the world to clean their air by harmonizing, sharing, and using open air quality data. Through their open-source platform, users are able to easily access data that enables them to make a change for the better towards cleaner air.
OpenAQ wants to help the world solve one of the largest public health concerns, air pollution, by opening up access to vital air quality data to communities and organizations across the world. With their recently launched low-cost sensor data, they are now the largest open-source global repository of low-cost sensor and reference-grade data. This new feature allows OpenAQ to reach an even more diverse audience enabling them to fight air inequality on a larger scale than ever before.
As a non-profit organization with limited staff, OpenAQ needed a cost-effective and time-saving solution to their PostgreSQL management that allowed them to effectively scale and customize their deployments to their needs. OpenAQ hosts over 7.8 billion data points and over 35 million API requests each month. After previously hosting their PostgreSQL database via Amazon RDS, they found that they needed a way to scale their database as they added more data. Bringing on low-cost sensor data meant ingesting data an order of magnitude greater than previously ingested, therefore they started looking at updating their database solution. To help optimize their data storage, the solution they found was using the PostgreSQL extension TimescaleDB which is optimized for time-series data. Due to RDS not supporting TimescaleDB, they had to look for other alternatives for database management.
The OpenAQ platform architecture is built on AWS, so finding a DBaaS solution that supported AWS as a cloud provider was of importance. When adding the low-cost sensor data to their offering, they needed a way to minimize their time spent managing the database and shift their focus to development.
After searching for a solution that fit all their requirements, OpenAQ found ScaleGrid’s fully managed PostgreSQL hosting service. With ScaleGrid’s Database as a Service solution, OpenAQ was able to lower their costs and effectively scale as their data size grows. By having an easy to navigate console and a simple way to get an overview of their database statistics with ScaleGrid, OpenAQ is able to dedicate more time to their product and reduce their time spent managing their databases. ScaleGrid’s full support for PostgreSQL extensions such as open-source TimescaleDB was a major deciding factor that made their choice easier.
By utilizing the ScaleGrid Bring Your Own Cloud (BYOC) service, OpenAQ was able to host their databases through their own AWS account and also have the management benefits of ScaleGrid. Coming from AWS RDS and having their platform architecture on AWS, wanting to stay with them as their cloud provider was preferred. With BYOC, they can continue using AWS as their cloud provider and save thousands of dollars long-term on their database hosting costs. They are also able to utilize their own AWS cloud account in combination with the management features of ScaleGrid.
With help from ScaleGrid’s PostgreSQL experts, OpenAQ was able to easily upgrade their PostgreSQL database with minimal downtime. Automatic alerts notify them of any discrepancies or key database stats that can affect their application performance, giving them peace of mind when it comes to any issues that should arise. Features they didn’t have before, such as analytical tools and reports to debug queries, speeds up any troubleshooting they’d need to perform and allows them to get a quick overview of their database.
By using a cost-effective DBaaS, that allowed them the freedom to customize and configure their PostgreSQL deployment, OpenAQ were able to put all their focus on delivering a better service to their customers. Having ScaleGrid’s automatic alerts, patching and upgrades, and 24/7 access to support for their database, meant they didn’t have to worry about managing their database anymore, alleviating the burden from their small development team. With ScaleGrid by their side, OpenAQ could focus more on developing a better service and scale their data without worrying about what will happen with their database in the future. Their database is now fully managed and automated by the ScaleGrid console in the cloud, safely secured by encryption and backups.
Get more database tips, articles and the latest news by subscribing to our monthly newsletters!