willjschmitt / joulia-webserver

Webserver and logging for electric brewing controller connecting distributed users to the equipment.
http://joulia.io
0 stars 0 forks source link

Time series data should be stored in a NoSQL database. #89

Open willjschmitt opened 7 years ago

willjschmitt commented 7 years ago

SQL is not an optimal datastore for live streamed data that is highly related to itself. Series of points stored in an SQL table could be stored in an array accessible by a key.

willjschmitt commented 7 years ago

Deprioritizing, since performance seems reasonably good still, although we may find that performance degrades over time. Not worth it yet for the development time.