I had fun querying Steemit database - Is this Steemit first ever post?
The past few days I have been exploring Steemit libraries and database. It all started when I wanted to know the top 10 people who votes for my posts in a week/month then populate it on a bar graph/chart. I was then inspired by a post "Steemit's Community Engagement is up over 1,000%" posted by @furion. While busy exploring the database I come across this:
Is this Steemit first ever post?
Is this Steemit first ever post?
Link to the post: https://steemit.com/meta/@steemit/firstpost
Link to the post: https://steemit.com/meta/@steemit/firstpost
One may ask how did I get to this conclusion? Well I used Robomongo to login into Steemit database like what is described on a post by @furion "Introducing SteemData - A Database Layer for STEEM"
Well after gaining access to the database I didn't even have to know MongoDB query format I simply clicked "Posts"
Well after gaining access to the database I didn't even have to know MongoDB query format I simply clicked "Posts"
db.getCollection('Posts').find({})
The results is in JSON but there are other options:
The results is in JSON but there are other options:
"_id" : ObjectId("591c30930f44d6e209df74b6"),
"children_abs_rshares" : "319683813723",
"author_rewards" : 3548,
"created" : ISODate("2016-03-30T18:30:18.000Z"),
"curator_payout_value" : {
"asset" : "SBD",
"amount" : 0.756
},
"permlink" : "firstpost",
"total_pending_payout_value" : {
"asset" : "STEEM",
"amount" : 0.0
},
"parent_author" : "",
"active" : ISODate("2017-07-11T20:50:15.000Z"),
"community" : "",
"title" : "Welcome to Steem!",
"allow_votes" : true,
"patched" : false,
"identifier" : "@steemit/firstpost",
"body" : "Steemit is a social media platform where anyone can earn STEEM points by posting. The more people who like a post, the more STEEM the poster earns. Anyone can sell their STEEM for cash or vest it to boost their voting power.",
"allow_curation_rewards" : true,
"active_votes" : [
{
"percent" : 100,
"reputation" : "243819801586934",
"voter" : "dantheman",
"rshares" : 375241,
"time" : "2016-04-07T19:15:36",
"weight" : "32866333630"
},
Lets zoom in:
Lets zoom in:
- "created" : ISODate("2016-03-30T18:30:18.000Z")
- "identifier" : "@steemit/firstpost",
- "body" : "Steemit is a social media platform where anyone can earn STEEM points by posting. The more people who like a post, the more STEEM the poster earns. Anyone can sell their STEEM for cash or vest it to boost their voting power.",
Based on Wikipedia Steemit was released in March 2016 and that first post by @Steemit seems to be was created 30 March 2016.
Based on Wikipedia Steemit was released in March 2016 and that first post by @Steemit seems to be was created 30 March 2016.
Well if it is not the FIRST POST...I will accept to be corrected with supporting evidence 😎😎.
Well if it is not the FIRST POST...I will accept to be corrected with supporting evidence 😎😎.
There are many other useful info you can QUERY on the database like the examples @furion has given...well I still need to get my top 10 voters...so the fun has just began.
There are many other useful info you can QUERY on the database like the examples @furion has given...well I still need to get my top 10 voters...so the fun has just began.
You can learn more about MongoDB here
Good
Followed , upvoted
Thanks followed back
You're welcome
Can you check out my blog ?
that's great the first post will be gold in several years now steemit is new so it don't last that much time but that's pretty good to see it ;)
Thanks for reading
Nice work there
Thanks for reading