I had fun querying Steemit database - Is this Steemit first ever post?

in #steemit7 years ago

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?

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"

db.getCollection('Posts').find({})

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:

  • "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.

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.

You can learn more about MongoDB here


Sort:  

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

Coin Marketplace

STEEM 0.19
TRX 0.15
JST 0.029
BTC 63004.58
ETH 2548.62
USDT 1.00
SBD 2.81