Continuing the discussion from Emoncms.org billing:
Using a Round Robin Database is one way to solve that issue.
Here’s a link that explains what an RRD is and how it works: https://oss.oetiker.ch/rrdtool/
@TrystanLea, perhaps that type of database could help with OEM and self-hosted storage issues.
I’m not recommending the RRD Tool itself, rather that type of storage method.