Hi everyone, long time forum lurker, just joined today.

I am actually using a Mac (macOS High Sierra 10.13.6), however I am sure that any help here will still be usable since it always has been in the past

Anyway, I have a hierarchical database I created using a .json file, which all looks wonderful and all, however I need to be able to read, write and modify the content inside that .json file. I don't know that much about databases and the like, but doesn't SQL allow that pretty seamlessly?

I did try writing the content in my .json file in a SQL database, however this was pretty much impossible for me, since the database I have contains a lot of children and siblings and it just didn't turn out that great.

I'm wondering if there are any CLI tools that make this possible. I'm using bash 3.2.57(1)-release for the record and I've already got brew installed.

Thanks!

Take a look at jq.