Hacker News new | past | comments | ask | show | jobs | submit | thatgaijinguy's comments login

Google trends ?


Yup: https://trends.google.com/trends/explore

But, the info you get is very broad and sampled, so you can't drill down to any city/ZIP; you have to choose from regions they've provided.


As a new junior developer can you tell me what this is good and what use case it's best for ?


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.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: