Hi, this is quite a "beginner's" question but hopefully someone can help? I want to build up a "definitions" file that describes the properties for various custom DIY home automation devices. I'm thinking the best way might be some form of JSON file on disk. Should I use context, and store to dis…

[image] Colin: possibly an sqlite database I would actually disagree here. As long as you need the whole thing available to Node-RED, a JSON file loaded to memory is much easier to work with and avoids the additional complexity of a database. Only if you need to query or aggregate data would…

[image] TotallyInformation: I would actually disagree here. It is possibly arguable either way in this case. Requirements such as "count the number of light circuits in a room" suggest a database approach to me. Also for the Scenes, looking up the available scenes for a particular room, ad…

[image] Colin: possibly arguable either way in this case As always :wink: [image] Colin: count the number of light circuits in a room Yes, given the data shown, this might be correct. Of course, the advantage of using JSON is that you can simply adjust to need. So that you could easil…

[image] TotallyInformation: "Light 1": { "device":"Light 1", "zone":"bedroom1", "name":"Wall Light" <=========== "fitting":"wall", "colour":"warmwhite" Missing a comma??? :grin:

Thanks for your help so far. In @TotallyInformation ’s suggestion for a json file, does anyone know how it would be possible to count the number of items (eg with a specific property like fittingtype=wall) in a JSON file? With a simple loop that reads all values and compares and counts?

if the data was stored as an array of objects like: { "payload": [{ "device": "Light 1", "zone": "bedroom1", "name": "Wall Light", "fitting": "wall", "colour": "warmwhite" }, { "device": "Light 2",…

[image] zenofmud: you could use a JSONata expression Or in JavaScript: msg.payload.filter(function(item){return item.fitting === 'wall'}).length; or msg.payload.filter(function(item){return item.zone === 'bedroom1'}).length; Not as neat as @zenofmud 's expression but usable in a function …

Thanks @zenofmud and @drmibell for the practical tips. Most useful. Out of interest @drmibell , re your earlier post where you suggested a JSON file. That's what I originally envisaged. Sorry if this is a basic question, but would you literally create the file with a text editor to start with? If yo…

[image] hazymat: would you literally create the file with a text editor to start with? Yes. Because scenes typically involve more than one device, I generally use a different format and a separate JSON file for them. [image] hazymat: update it programmatically Easy, I think, although…

How to store data in JSON file in Node-RED

General

moebius 9 January 2019 20:40 11

in sql one could do a "group by" without knowing any zone/fitting names - is this also possible in jsonata?

Topic		Replies	Views
The best way to implement device database General	38	2909	12 February 2019
Ideas for a "database-like" structure in global context General	14	1922	8 October 2019
Saving in global context parses key, breaking on "." shown in JSON General context	36	334	23 April 2026
Store msg alone without needing to have excel ,SQLite table just by topic to payload it again to node red when needed General	39	1467	7 August 2021
Helpful criticism requested General	44	2718	17 July 2018

How to store data in JSON file in Node-RED

Related topics