In our applications we perform quite a bit of sensor data collection. In some cases sensors are impractical, so we collect certain sparse measurements with purely manual techniques and handheld instruments. Given that all our sensor readings are in Influx, naturally we want to store manual measurements there as well.
To make data entry easily available and simple we rely on web application frameworks to build those CRUD-style interfaces with a variety of user friendly extras in the UI. Generally, web app frameworks assume relational databases and provide ORMs and abstraction layers to make it easy to map data storage to the user actions. To our knowledge, InfluxDB is not supported by any of these technologies. Because of the assumptions baked into web app frameworks we’ve had to “wire in” InfluxDB library calls in somewhat ugly ways. I’d like to do this in a smarter way.
I’m curious if anyone has already come up with an elegant solution to this problem? Is there a framework out there that already natively supports InfluxDB? Is there some middleware that is able to translate InfluxDB reads and writes to a traditional SQL style for these integrations? Any thoughts on how to best incorporate a ‘raw’ InfluxDB connection into an otherwise basic CRUD-style web app?