3 ms·
Curious as to why you aren’t tracking that with a time series database?
by brodouevencode 5y ago
Curious as to why you aren’t tracking that with a time series database?
- earleybird 5y agoIt's hobby diversion so minimal effort is a factor. That and that SQL query comes back in seconds. The initial experimentation was with ESP8266's and the MQTT/NodeRed/SQLite played a supporting roll. My experience with SQLite is that it can take you a long ways before needing to look elsewhere.
- ClumsyPilot 5y agoThe IoT hubs are an embedded system, built with a minimal memory footprint and overhead, 512 mb of ram is typical, sometimes less. Here is an example: https://www.gl-inet.com/products/gl-s1300/ https://www.gl-inet.com/products/gl-s1300/ That means you can't have docker and different versions of Java, node and .Net all running in parallel. You run a single process and Sqlite is a library that allows SQL operations and database to be inbuilt. You 'budget' is like 100 mb of Ram, becauae other stuff has to run too. All the time-series databases I know are a large, memory hungry hippo, built for distributed compute/kubernetes. Just very different usecase. If one was built with minimalism in mind, then it could be used.