Introducing Philippines Daily Express
What is the project about?
Philippines Daily Express, is a newspaper styled web application built with node.js and express. Basically the web application looks like a newspaper but the content of it is Steemit posts for the #philippines tag on Steemit.
The Data comes from STEEMSQL, The application gets the top commented post, top upvoted post, top post with pending payout value within the past time of loading the page to 24 hours before. Mimicking a newspaper that adds news from the previous 24 hours the least.
The posts are displayed on each column with the title, author of the post, the featured image of the post, a small excerpt of the post, stats of the post(Created date of the post, number of comments, Total number of upvotes, and post pending rewards).
You can visit the live link of the web appication here:
https://philippines-daily-express.herokuapp.com
SQL queries done to retrieve the data
Top Commented - /queries/topCommented.sql
select top 1
*,
JSON_QUERY(json_metadata, '$.tags')
from
Comments (NOLOCK)
where
title <> '' and
parent_author = '' and
category = 'philippines' and
datediff(hour, created, GETDATE()) between 0 and 24
order by
children desc
This SQL query gets the top 1 commented post with the #philippines tag(first tag of the post) and gets the created time of the post then used to retrieve the posts of the time the app was loaded and 24 hours before.
Top Upvoted - /queries/topUpvoted.sql
select top 1
*,
JSON_QUERY(json_metadata, '$.tags')
from
Comments (NOLOCK)
where
title <> '' and
parent_author = '' and
category = 'philippines' and
datediff(hour, created, GETDATE()) between 0 and 24
order by
net_votes desc
This query returns the top 1 most upvoted post with the #philippines tag(first tag of the post) and gets the posts from 24 hours before.
Top Rewards - /queries/topRewards.sql
select top 1
*,
JSON_QUERY(json_metadata, '$.tags')
from
Comments (NOLOCK)
where
title <> '' and
parent_author = '' and
category = 'philippines' and
datediff(hour, created, GETDATE()) between 0 and 24
order by
pending_payout_value desc
This query returns the top 1 post with the most pending_payout_value post with the #philippines tag(first tag of the post) and gets the posts from 24 hours before.
The purpose of creating this web application
- Data gathering - it will be a great way for newbie steemians to see what makes a top upvoted, commented, and a post with the highest pending payout value.
- Increase engagement to the top posts.
- Post visibility, the top posts will get more visibility to people who are visiting the web application.
- Featured posts may get more followers
- Another unique front-end for Steemit Posts
- Might help in curation efforts by using the data on the Web Application
Technology Stack
- node.js
- express.js
- bootstrap
- handlebars
- seriate for queries on STEEMSQL
- STEEMSQL - A monthly subscription is now needed to access the database.
Roadmap
For the future plans of this project, here are the features I am thinking of:
- Design a logo and the frontend, as of now it looks plain
- Convert the Web Design to HTML and integrate it to the web application
- Add a lightbox to the post, when clicked opens up a lightbox that can display the whole post where they can read it on the web application and not go directly to steemit.
- Add more data and featured items on the newspaper eg. number of words on the post etc.
How to contribute?
On the road map you can contribute to the items that I have listed, so I am also encouraging all people to contribute:
- Design a Logo for the web application.
- Design a newspaper look for the front-end of the web application.
- Suggest ideas for new features of the web application
You can find me on Steemit and Discord with the username: @vallesleoruther
Links
Web App: https://philippines-daily-express.herokuapp.com/
Github Repository: https://github.com/renegade47/philippines-daily-express
Github Proof
Posted on Utopian.io - Rewarding Open Source Contributors
This is very helpful. I might have to visit your github and check out the code as that's the fastest way I can learn anything.
So can you give me quick rundown on heroku? Is it hosting the app you just made? How about apprenticing for you? :)
Wow! Thank you for sharing this @vallesleoruther . I admire you on that app. I'm planning to develop an application similar to that soon.
Nice, more applications on STEEM, if you can open source the app contribute it to utopian so it will be rewarded. You can also check the previous app I created for Philippine Steemit Users:
http://ph-steemapp.herokuapp.com
Excited to see the application you are building.
Hi @vallesleoruther, what technologies did you use for this application? http://ph-steemapp.herokuapp.com
Also, it would be a great help for me if you can give me advice how to start. I really love to develop an app.
Thanks
I used node.js and STEEMSQL for the application, well it depends what kind of app will you build? A steem app too?
Thank you for the contribution. It has been approved. From next time try to follow the Utopian.io rule
You can contact us on Discord.
[utopian-moderator]
I will keep it in mind, I just finished the web app within the day so it was one large commit. Thank you very much for reviewing my contribution :)
Wow this is a great initiative idol! If it is automated then the savings on time.
Thank you lodi, I will think of ways to improve it more, and make it like a newspaper in terms of design haha.
@vallesleoruther Thank you for sharing this! :D
When you want to Flag them but see their Steem power
LOL haha
hi, could i need you help, about post words minum its refle what earn here at steemit , its so messy do1$
I cannot understand, what are you trying to say?
ok, for post its minum words to make steems dollars, and for coment other historys its minum word for make steems dollars
Really good. I think, I need to work on it.
Thank you, are you gonna contribute on the project? :)
Yap bro. I have interest on it. But i need to know more details & clear guideline about it otherwise i can't be helpful in this project.
Great work.. lets grow all together hand in hand in this community :) Cheers!
Thank you yes, just keep on steeming!
Most welcome @vallesleoruther looking forward to see more of your pos on my wall
Kudos for you guys!!! A brilliant work that can help minnows like us to have a chance to be visible and be upvoted here in STEEMIT! Keep up the good work.. Proud to be PINOY BISDAK.....