I’ve been working on a general IoT solution:
It has an embedded database for managing basic config, users, device state, rules, etc. For timeseries data, simple iot supports storing data in influxdb. I’ve used grafana in the past for graphing, but hope to eventually have graphs in the simple iot web UI. Grafana is great if you don’t have a lot of sites and can afford to set up graphs/dashboards for each site manually. Once you get to 10’s of devices, maintaining lots of dashboards can be time consuming.
Simple IoT is not a drag-n-drop experience, but rather requires some programming and may be a good solution if you want to own your IoT platform.
I really like Go applications, as they are typically statically linked and easy to deploy and run – often just a single binary.
You can easily run siot, influxdb, grafana on a $5/mo digital ocean server. Here are ansible roles to deploy the pieces:
Caddy is nice as it gives you automatic https with lets-encrypt.
I’ve deployed the above stack for several projects and it has proven to be very efficient and reliable solution.
I’ve not done any LPWAN integration, but would like to in the future.