Hacker News new | ask | show | jobs
by 0x264 1889 days ago
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.)

1 comments

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