You can't get an exact answer to this question because it is impossible to track with the current setup. But from interactions I had with people, I can tell peakd is one of the apps that is using this mainly for polls and snaps. Recently themarkymark launched Hive Analytics which is also using this database.
I could gather the statistics of the server like how many queries are run per day and share that.
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.
You can't get an exact answer to this question because it is impossible to track with the current setup. But from interactions I had with people, I can tell peakd is one of the apps that is using this mainly for polls and snaps. Recently themarkymark launched Hive Analytics which is also using this database.
I could gather the statistics of the server like how many queries are run per day and share that.
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"}'::jsonbYou 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.