Please don't, it was just to have an idea of the impact that this has and compare it to HiveSQL.
Would it be possible to add a call for users by location?
Please don't, it was just to have an idea of the impact that this has and compare it to HiveSQL.
Would it be possible to add a call for users by location?
Yes that is possible. The data is there. I could make it an API call. You could run the following query to find users with Germany location:
SELECT name FROM hafsql.accounts WHERE json_metadata->'profile' @> '{"location": "Germany"}'::jsonb
You could even run your own website and provide this data. Just like how Hive Analytics takes data from the database and shows it on the website. This public database makes it easy for anyone to access and serve the data that otherwise would be hard to get.
That would help us with a small project with have in mind. We are already working on others that take await most of our time, but will definitely use this.
If you can make it a call, even better.