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> </center> #### <center><p>Link to the post: [https://steemit.com/meta/@steemit/firstpost ](https://steemit.com/meta/@steemit/firstpost)</p> </center> <center>  </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> </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> </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> </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 😎😎.</p> </center> <center>  </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>  </center> <center>  </center>
author | mokluc |
---|---|
permlink | i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post |
category | steemit |
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"} |
created | 2017-07-12 16:52:51 |
last_update | 2017-07-12 16:52:51 |
depth | 0 |
children | 7 |
last_payout | 2017-07-19 16:52:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 9.347 HBD |
curator_payout_value | 2.084 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 4,109 |
author_reputation | 42,525,517,127,291 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,245,334 |
net_rshares | 3,091,725,946,472 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
pharesim | 0 | 103,527,248,498 | 0.03% | ||
boy | 0 | 595,800,643 | 100% | ||
bue-witness | 0 | 726,478,268 | 100% | ||
bunny | 0 | 97,780,981 | 100% | ||
bue | 0 | 13,408,527,807 | 100% | ||
mini | 0 | 318,445,555 | 100% | ||
moon | 0 | 80,976,394 | 100% | ||
healthcare | 0 | 118,674,965 | 100% | ||
daniel.pan | 0 | 187,746,577 | 100% | ||
helen.tan | 0 | 81,544,485 | 100% | ||
nomoreheroes7 | 0 | 4,348,508,277 | 5% | ||
gavvet | 0 | 668,459,265,848 | 5% | ||
steve-walschot | 0 | 2,097,816,685 | 5% | ||
dragonslayer109 | 0 | 79,632,232,953 | 5% | ||
coinbitgold | 0 | 58,828,054,245 | 30% | ||
ratel | 0 | 2,001,074,233 | 20% | ||
thecryptodrive | 0 | 297,902,091,501 | 25% | ||
infovore | 0 | 44,925,165,035 | 5% | ||
spiz0r | 0 | 105,035,926,780 | 100% | ||
jacor | 0 | 39,564,982,829 | 5% | ||
livingfree | 0 | 36,272,177,724 | 1% | ||
annieb | 0 | 6,315,619,302 | 100% | ||
speda | 0 | 93,508,720,096 | 25% | ||
ubg | 0 | 1,492,850,539 | 100% | ||
crazymumzysa | 0 | 1,541,592,540 | 5% | ||
craigslist | 0 | 80,301,128 | 100% | ||
timsaid | 0 | 252,108,129,387 | 2.5% | ||
jrcornel | 0 | 292,212,003,559 | 10% | ||
annaarthur | 0 | 10,347,352,638 | 100% | ||
funnyman | 0 | 2,721,717,972 | 1% | ||
rynow | 0 | 17,346,917,476 | 10% | ||
ocrdu | 0 | 2,067,656,306 | 5% | ||
keuudeip | 0 | 439,359,930 | 5% | ||
mokluc | 0 | 41,310,979,923 | 100% | ||
selwi | 0 | 3,102,936,129 | 100% | ||
chessmasters | 0 | 272,288,331 | 100% | ||
detol | 0 | 293,603,973 | 5% | ||
prudy | 0 | 1,462,732,137 | 100% | ||
mandela | 0 | 123,808,278,793 | 100% | ||
oluwoleolaide | 0 | 180,205,368 | 0.5% | ||
velimir | 0 | 231,966,883 | 0.5% | ||
sv67216721 | 0 | 5,527,349,386 | 5% | ||
altcointrends | 0 | 2,067,344,470 | 3% | ||
indiantraveller | 0 | 58,024,344 | 0.3% | ||
done | 0 | 768,219,971,232 | 15% | ||
guiltyparties | 0 | 1,252,239,939 | 100% | ||
nape | 0 | 2,061,421,710 | 100% | ||
ahmedezzat | 0 | 1,588,527,100 | 100% | ||
neiraurdaneta | 0 | 1,320,031,685 | 100% | ||
kendall2 | 0 | 575,303,913 | 100% |
Good Followed , upvoted
author | ahmedezzat |
---|---|
permlink | re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t165451365z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-12 16:54:54 |
last_update | 2017-07-12 16:54:54 |
depth | 1 |
children | 2 |
last_payout | 2017-07-19 16:54:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 24 |
author_reputation | 275,970,797,855 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,245,553 |
net_rshares | 0 |
Thanks followed back
author | mokluc |
---|---|
permlink | re-ahmedezzat-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t175650507z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-12 17:56:54 |
last_update | 2017-07-12 17:56:54 |
depth | 2 |
children | 1 |
last_payout | 2017-07-19 17:56:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 20 |
author_reputation | 42,525,517,127,291 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,251,593 |
net_rshares | 0 |
You're welcome Can you check out my blog ?
author | ahmedezzat |
---|---|
permlink | re-mokluc-re-ahmedezzat-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170713t192511360z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-13 19:25:18 |
last_update | 2017-07-13 19:25:18 |
depth | 3 |
children | 0 |
last_payout | 2017-07-20 19:25:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 43 |
author_reputation | 275,970,797,855 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,374,284 |
net_rshares | 0 |
Nice work there
author | guiltyparties |
---|---|
permlink | re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t173654317z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-12 17:35:48 |
last_update | 2017-07-12 17:35:48 |
depth | 1 |
children | 1 |
last_payout | 2017-07-19 17:35:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 15 |
author_reputation | 261,203,126,670,124 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,249,419 |
net_rshares | 0 |
Thanks for reading
author | mokluc |
---|---|
permlink | re-guiltyparties-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t175713481z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-12 17:57:18 |
last_update | 2017-07-12 17:57:18 |
depth | 2 |
children | 0 |
last_payout | 2017-07-19 17:57:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 18 |
author_reputation | 42,525,517,127,291 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,251,641 |
net_rshares | 0 |
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 ;)
author | othmanesl |
---|---|
permlink | re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t172548551z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-12 17:25:48 |
last_update | 2017-07-12 17:25:48 |
depth | 1 |
children | 1 |
last_payout | 2017-07-19 17:25:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 144 |
author_reputation | 422,822,256,945 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,248,494 |
net_rshares | 0 |
Thanks for reading
author | mokluc |
---|---|
permlink | re-othmanesl-re-mokluc-i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post-20170712t180311142z |
category | steemit |
json_metadata | {"tags":["steemit"],"app":"steemit/0.1"} |
created | 2017-07-12 18:03:15 |
last_update | 2017-07-12 18:03:15 |
depth | 2 |
children | 0 |
last_payout | 2017-07-19 18:03:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 18 |
author_reputation | 42,525,517,127,291 |
root_title | "I had fun querying Steemit database - Is this Steemit first ever post?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 8,252,232 |
net_rshares | 0 |