Hi, Can I ask your advice on how to store data in my JSON based database efficiently (PostgreSQL). I have a number of Arduino modules that send various data at various intervals, these need to be stored. Each Arduino module is different in it’s IP number, example IP01 .. IP02 .. IP03 etc. The wa…

zenofmud 27 February 2024 08:50 11

Another time series database you could try out is TickTock DB. I posted and example of running it on a RPI 2 model B a couple weeks ago:

I haven't linked it to Grafana (yet), but it is suppose to work fine with it.

Topic		Replies	Views
Node-red + postgres General	8	2464	8 May 2020
JSON persistence with NodeRed- Redis or PostGreSQL or? General	16	3690	19 August 2019
Wanted to create database General	16	2740	8 November 2019
Store data on a database General	17	10653	13 March 2020
Advice on Database Design for Home Automation General	7	451	27 August 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Slightly off topic, insert data into a database, one table or many tables?

Related topics