A Comparison of Time Series Databases for Storing Water Quality Data

Water quality is an ongoing concern and wireless water quality sensing promises societal benefits. Our goal is to contribute to a low-cost water quality sensing system. The particular focus of this work is the selection of a database for storing water quality data. Recently, time series databases have gained popularity. This paper formulates criteria for comparison, measures selected databases and makes a recommendation for a specific database. A low-cost low-power server, such as a Raspberry Pi, can handle as many as 450 sensors’ data at the same time by using the InfluxDB time series database.