3 ms·
What is the advantage of using a database vs. rolling your own data structures on such a small device?
by nitrogen 11y ago
What is the advantage of using a database vs. rolling your own data structures on such a small device?
- pfalcon 11y agoThe same as on any other device I guess - you either need to sit and roll out your own data structures, or just take and use a database.
- nitrogen 11y agoI guess it depends on what you find more familiar. But at this device scale, one should really be comfortable with C data structures.
- emcq 11y agoDynamic queries and data serialization. Imagine sending just a text query (in SQL) around to a sensor network. It would be a fair amount of work to reproduce that on your own but seems like it can open up some nice features for distributed IoT
- nitrogen 11y agoIt still seems pretty inefficient. With 4KB of RAM I'd just store my data in an array of structs and send it in raw binary to the central server. The SQL also leaves potential for running unwanted SQL. I'm reminded of a commercial home automation platform that had agonizingly slow response times because the LCD controllers were sending raw, unauthenticated Python code to the 70MHz central controller.