Introducing Philippines Steemit Stats BETA - A Database of Users from the Philippines
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 @vallesleoruther or akosileo in Discord. The data comes from the SteemSQL Database created by @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:
- Heroku has limited hours the web application might not work once the Free Dyno Hours get used up.
- Database Query Deadlock occurs when querying the database, multiple refreshes are needed.
Future Improvements:
- Host it on a decent VPS - Could have done it with PHP but the cheap ass hosting I use does not support mssql
- Solve the Deadlock Problems
- Integrate Angular 3 to make it an SPA(Single Page Application)
- Add some more widgets, different queries like Top 10 Authors/Curators basing on the Authors and Curation rewards of users from the Philippines
- Add some Graphs/Charts to better present the data
- Improve the design of the website
- 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:
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)
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.
![](https://steemitimages.com/DQmSzx8Mb3JjkngeQXWyccZY1PAk3v9UQCZGyzgR1jA3pTV/19114457_1694050927276194_950610598_n.jpg)
![Upvote, Follow, and Resteem.png](https://steemitimages.com/640x0/https://steemitimages.com/DQmWLbF2PD3Y6CeueKo3KcHRWUar9QuvV1LhvY1WF7joLDE/Upvote%2C%20Follow%2C%20and%20Resteem.png)
yay inaantay ko din to
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.
Salamat sa upvote and comment, Yes baka itong Wordpress Plugin ang unahin ko isa sa specialty ko ang WP hehe. Yung Welcome Bot kasi Python baka medyo matagalan di ako marunong nun hehe.
yay!!! my main blog is wordpress kasi.. so galeeeng.
I connect to steemitdb for bisteemit pero inaaral ko pa powerbi haha. which table/s did you select from?
Selected from Accounts table, "SELECT * FROM ACCOUNTS WHERE NAME = 'yournamehere'" yan po ginawa kong basic query muna para makita ko yung laman. Tapos parse ng json_metadata para ma query ko yung Philippines hehe.
What if ijoin sya sa mga ngtatag ng philippines and pilipinas ?
Yan din gawa ko dati pero in (name1, name2).i stopped nung nasa 200 yung list. Nagawa mo na nasa external txt file ang list?
Hindi ko pa nagagawa yung external txt file, yun nga din naisip ko yung gumagamit ng tags, Subukan ko iquery yun hehe.
meep
Streemian has cross-posting but I don't know pano sya gumagana.
meron nang ganyan iirc haha
Where?
You can check steemtools.com! I'm sure its there somewhere : )
Ayos to bro. Sana may exchange upvote section ka na next time. Godbless ;)
Salamat sa upvote and comment bro. hehe tignan natin kung kaya gawin. God bless
Ayos na ayos ito... sana active lahat!
Salamat @iwrite, marami pang improvement na darating dito sa web app. maraming salamat sa upvote at comment.
Awesome @vallesleoruther !
Thank you very much for the comment.
This is a very helpful tool :). Thanks for putting much effort in doing this. Continue to do this thing and you'll surely get some love. Also, you will be a helpful asset in Philippine Community :)
I also want to promote this contest : 50 SBD awaits you! :) please read the guidelines
https://steemit.com/wikang-filipino/@jassennessaj/announcing-philippine-poetry-and-song-writing-challenge-gumawa-ng-sariling-tula-o-kanta-at-manalo-proyektong-naglalayong
Thank you for the comment and upvote and the support. Will definitely check out your contents and might join.
Cool. Isa kang alamat. Gusto ko yung Welcome Bot.
Hahaha, salamat sa upvote at comment. Sana magawa ko, unti unti kong gagawin.
Kaya yan sir. Good luck!
Salamat sa suporta hehe.
Walang anuman! Keep it up! Need natin ng mga katulad mo. :D
We should talk soon. I would like to code something. Hope you don't charge too much. You should join us in the "steemgigs community". Discord server link underneath my post. i am thinking you are already there? If you are, will add you to the dev section
Thank you, Have not joined the discord server yet for steemgigs community. I don't charge too much if it is for a cause I would gladly help in any way I can. Where can I find the link?
https://discord.gg/feucZRj
This is nice. upvoted.
Thank you for the comment and upvote sir.
Hi @vallesleoruther, Ive been searching for this type of statistical tools. I hope you'll do more and go deeper statistics about the Filipino Community, which will be so useful for our project. Followed you and rooting for the next update.
We need statistical growth of the filipino users and their posts per day, and how active they are in a span of 7-days. Thanks!
Thanks @themanualbot, I will take note of you suggestions. It is still on BETA version at the moment so there are many more improvements to be done. Just done something basic for now. Just comment your suggestions and I will be building it on the next version. Thanks for upvoting and commenting.
Ito gusto ko makita sa susunod:
For example this week,
Total Registered Users:
Total number of posts in 7-day period to the day the update post was made:
Total number of comments the same with posts above:
Total payouts received on all posts plus comments:
Take note, all must bare the following tags, #philippines & #pilipinas
Goodluck po! Gawin mo yang weekly update pag.okay na. Then, youll get the rewards you deserve. 😎
Okay noted on this, will add it up on my build notes on the next version. Thanks for your input @themanualbot
Hey bro, nice work. Just by getting the location on their profile instantly makes it up to the database. We are the pioneers at steemit. Let's get it on!
Thanks for the comment, I followed you too. Maybe we can create more apps like this to help other steemit users.