I’m Pavlo Tkachenko, co-founder and developer of SaveEcoBot – a Ukrainian non-profit tech start-up that aims to protect people from air pollution and raise the environmental awareness of the citizens by providing them with free and easy access to air quality indexes and other public environmental data.
We are the biggest air quality data provider in Ukraine with the largest amount of data sources:
- Eight civic systems and business projects;
- Eight local governmental systems;
- Two universities.
In total, we have online data from more than 1400 air quality stations in Ukraine, from which near 700 is always up and running.
We’ve started on 2019 and right now, our MySQL database has more than 3 billion records about Ukrainian air, and near 500 million average records by stations, cities, and regions in Ukraine. All that data is available for free on our map, in our chatbots, and through our free API.
Because we were just a small startup, we were not thinking about large amount of data storing, and now we have to refactor our database to make it faster and do additional calculations like moving average, daily/monthly/yearly averages by pollutants.
I’ve found on Twitter a great thread by Jack Ellis (co-founder of Fathom Analytics) about their experience moving to SingleStore from MySQL Building the world’s fastest website analytics - Fathom Analytics, and would like to try SingleStore in our project.