Hacker News new | ask | show | jobs
by thatgaijinguy 1896 days ago
As a new junior developer can you tell me what this is good and what use case it's best for ?
1 comments

Somebody is using a database (sqlite in this case) to store JSON objects. There is nothing strange or unusual here.

When doing this, though, the problem is that it's more difficult to run search queries with the same expressiveness as we would otherwise do had the data been properly "unfolded" into many columns of a relational database.

This tool allows to make such expressive requests. This is very useful.

Interestingly the search query itself is expressed as a JSON object (this is a design choice, it could or could not have ben the case. In any case it's cute.)

Thank you for the explanation. I'll be adding this to my ever growing list of things to study further haha.