create account

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

View this thread on: hive.blogpeakd.comecency.com
· @mokluc ·
$11.43
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%](https://steemit.com/steemit/@furion/steemit-s-community-engagement-is-up-over-1-000)" posted by @furion. While busy exploring the database I come across this:

### <center><p>Is this Steemit first ever post?</p> </center>
<center> ![](https://picload.org/image/rpcpoaci/first.jpg)</center>
#### <center><p>Link to the post: [https://steemit.com/meta/@steemit/firstpost ](https://steemit.com/meta/@steemit/firstpost)</p> </center>

<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>

One may ask how did I get to this conclusion? Well I used [Robomongo](https://robomongo.org/) to login into Steemit database like what is described on a post by @furion "[Introducing SteemData - A Database Layer for STEEM](https://steemit.com/steemdata/@furion/introducing-steemdata-a-database-layer-for-steem)"

<center> ![](https://picload.org/image/rpcwoggr/robo.jpg)</center>

### <center><p>Well after gaining access to the database I didn't even have to know MongoDB query format I simply clicked *"Posts"* </p> </center>

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

### <center><p>The results is in JSON but there are other options: </p> </center>

<center> ![](https://picload.org/image/rpcwawrw/result.jpg)</center>

```
"_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"
        }, 
```
### <center><p>Lets zoom in:</p> </center>

<center> ![](https://picload.org/image/rpcwawla/results2.jpg)</center>

* "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.",

### <center><p>Based on [Wikipedia](https://en.wikipedia.org/wiki/Steemit) Steemit was released in March 2016 and that first post by @Steemit  seems to be was created 30 March 2016.</p> </center>

### <center><p>Well if it is not the FIRST POST...I will accept to be corrected with supporting evidence &#128526;&#128526;.</p> </center>
<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>
### <center><p>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.</p> </center>

You can learn more about [MongoDB here](https://docs.mongodb.com/manual/reference/operator/query/)

<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>
<center> ![](https://media.giphy.com/media/F0M5HYrDY5Fkc/giphy.gif) </center>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authormokluc
permlinki-had-fun-querying-steemit-database-is-this-steemit-first-ever-post
categorysteemit
json_metadata{"tags":["steemit","steemdata","steem","steemstats"],"users":["furion","steemit"],"image":["https://picload.org/image/rpcpoaci/first.jpg","https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png","https://picload.org/image/rpcwoggr/robo.jpg","https://picload.org/image/rpcwawrw/result.jpg","https://picload.org/image/rpcwawla/results2.jpg","https://media.giphy.com/media/F0M5HYrDY5Fkc/giphy.gif"],"links":["https://steemit.com/steemit/@furion/steemit-s-community-engagement-is-up-over-1-000","https://steemit.com/meta/@steemit/firstpost","https://robomongo.org/","https://steemit.com/steemdata/@furion/introducing-steemdata-a-database-layer-for-steem","https://en.wikipedia.org/wiki/Steemit","https://docs.mongodb.com/manual/reference/operator/query/"],"app":"steemit/0.1","format":"markdown"}
created2017-07-12 16:52:51
last_update2017-07-12 16:52:51
depth0
children7
last_payout2017-07-19 16:52:51
cashout_time1969-12-31 23:59:59
total_payout_value9.347 HBD
curator_payout_value2.084 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length4,109
author_reputation42,525,517,127,291
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,245,334
net_rshares3,091,725,946,472
author_curate_reward""
vote details (50)
@ahmedezzat ·
Good 
Followed , upvoted
properties (22)
authorahmedezzat
permlinkre-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t165451365z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-12 16:54:54
last_update2017-07-12 16:54:54
depth1
children2
last_payout2017-07-19 16:54:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length24
author_reputation275,970,797,855
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,245,553
net_rshares0
@mokluc ·
Thanks followed back
properties (22)
authormokluc
permlinkre-ahmedezzat-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t175650507z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-12 17:56:54
last_update2017-07-12 17:56:54
depth2
children1
last_payout2017-07-19 17:56:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length20
author_reputation42,525,517,127,291
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,251,593
net_rshares0
@ahmedezzat ·
You're welcome 
Can you check out my blog ?
properties (22)
authorahmedezzat
permlinkre-mokluc-re-ahmedezzat-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170713t192511360z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-13 19:25:18
last_update2017-07-13 19:25:18
depth3
children0
last_payout2017-07-20 19:25:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length43
author_reputation275,970,797,855
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,374,284
net_rshares0
@guiltyparties ·
Nice work there
properties (22)
authorguiltyparties
permlinkre-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t173654317z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-12 17:35:48
last_update2017-07-12 17:35:48
depth1
children1
last_payout2017-07-19 17:35:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length15
author_reputation261,203,126,670,124
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,249,419
net_rshares0
@mokluc ·
Thanks for reading
properties (22)
authormokluc
permlinkre-guiltyparties-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t175713481z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-12 17:57:18
last_update2017-07-12 17:57:18
depth2
children0
last_payout2017-07-19 17:57:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length18
author_reputation42,525,517,127,291
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,251,641
net_rshares0
@othmanesl ·
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 ;)
properties (22)
authorothmanesl
permlinkre-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t172548551z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-12 17:25:48
last_update2017-07-12 17:25:48
depth1
children1
last_payout2017-07-19 17:25:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length144
author_reputation422,822,256,945
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,248,494
net_rshares0
@mokluc ·
Thanks for reading
properties (22)
authormokluc
permlinkre-othmanesl-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t180311142z
categorysteemit
json_metadata{"tags":["steemit"],"app":"steemit/0.1"}
created2017-07-12 18:03:15
last_update2017-07-12 18:03:15
depth2
children0
last_payout2017-07-19 18:03:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length18
author_reputation42,525,517,127,291
root_title"I had fun querying Steemit database - Is this Steemit first ever post?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id8,252,232
net_rshares0