What is Philippines Steemit Stats BETA? It is a web application built using node.js to show the user stats of Steemit users from the Philippines created by yours truly Hive account@vallesleoruther or akosileo in Discord. The data comes from the SteemSQL Database created by Hive account@arcange. You can visit the site here: https://ph-steemit-stats.herokuapp.com

What data does Philippines Steemit Stats contain? For the BETA version, it contains data of All Users who has the word 'Philippines' in the location information in their Steemit Profile. In the web application as of now it has 4 different data that it presents.

First is the Total Number of Users, and the list of all Users from the Philippines
https://ph-steemit-stats.herokuapp.com/all-users

Next is the Total Number, and List of Active users from the Philippines in the last 30 days based on the parameter last_upvote_time
https://ph-steemit-stats.herokuapp.com/active-users

Next is the Total Number, and List of Inactive users from the Philippines based on the parameter last_upvote time. It compares the date today -30 days if you did not upvote in the date range you will then be classified as inactive.
https://ph-steemit-stats.herokuapp.com/inactive-users

And Lastly the Total Number, and List of New Users from the Philippines based on the Created Date(Steemit Account Creation). It gets all users from the Philippines which has registered in the Last 30 days.
https://ph-steemit-stats.herokuapp.com/new-users

Tecnologies Used:
node.js
express.js
seriate for mssql
bootstrap
handlebars

Deployed on Heroku

Problems:

1. Heroku has limited hours the web application might not work once the Free Dyno Hours get used up.
2. Database Query Deadlock occurs when querying the database, multiple refreshes are needed.

Future Improvements:

1. Host it on a decent VPS - Could have done it with PHP but the cheap ass hosting I use does not support mssql
2. Solve the Deadlock Problems
3. Integrate Angular 3 to make it an SPA(Single Page Application)
4. Add some more widgets, different queries like Top 10 Authors/Curators basing on the Authors and Curation rewards of users from the Philippines
5. Add some Graphs/Charts to better present the data
6. Improve the design of the website
7. Suggestions are open, comment down below it will be appreciated.

I have created this project to see on how many is the Steemit community from the Philippines and help in spreading steemit to fellow users here in the Philippines. The rewards of this post will be used to Continue the development and improvements of this web application.

Other Matters:

Upcoming Project Pipeline:

1. Welcome BOT - Develop a welcome BOT which will post a comment on the first post of a user from the Philippines directing them to the Steemit Philippines Discord Server or link to posts which are useful for newbies in either English/Tagalog/Ilokano(I can make one lol) languages, so that non newbie steemit users can help them if they have questions on steemit and other things about cryptocurrency. (Its quite confusing when you are a newbie and do not know where to go, experienced this myself)

2. Steemit Wordpress Plugin - Automatically post on Steemit. You can create your post from Wordpress and Automatically Post it on Steemit at the same time. Two birds in one stone.

Thank you very much, hope you find this tool helpful.