In the industrial control system world we call time series DBs &#x27;Enterprise Historians&#x27; they are well optimised. Good ones support storing data at native frequency of control system including sub-second intervals. Basically whatever frequency the instrument can sample at these things can record.<p>They also have good compression and buffering support, including catchup functionality.<p>They are by no means lightweight - usually they rely on PLC&#x27;s or SCADA system for inputs. They may not offer a complete solution for IOT but I&#x27;m sure there are lessons which can be adapted.