create account

streems



advanced mode

Introducing SteemData - A Database Layer for STEEM by furion

View this thread on steemit.com
View on official site
@furion ·
$645.78
Introducing SteemData - A Database Layer for STEEM

Why

The goal of the SteemData project is to make data from the STEEM blockchain more accessible to developers, researchers and 3rd party services.

Today, most apps use steemd as the source of data. In this context, steemd is used for fetching information about the blockchain itself, requesting blocks, and fetching recent content (ie. new blog posts from a user, homepage feed, etc.)

Unfortunately it also comes with a few shortcomings.

Running steemd locally is very hard, due to its growing RAM requirements. (None of my computers are capable of running it). Which means that we have to rely on remote RPC's, and that brings up another issue: time.

It takes a long time for a round trip request to a remote RPC server (sometimes more than 1 second per request).

Because steemd was never intended for running queries, aggregates, map-reduce, text search, it is not very well equipped to deal with historic data. If we are interested in historic data, we have to get it block-by-block form the remote RPC, which takes a really really long time.

For example, fetching the data required to create a monthly STEEM report now takes more than a week. This is simply not feasible.

Hello MongoDB

I have chosen MongoDB for this project for a couple of reasons:

  • Mongo is a document-based database, which is great for storing unstructured (schema-less) data.
  • Mongo has a powerful and expressive query language, ability to run aggregate queries and javascript functions directly in its shell (for example: map-reduce pattern).
  • By utilizing Mongo's Oplog we can 'subscribe' to new data as well as database changes. This is useful for creating real-time applications.
  • Steemit Inc is already developing a MySQL based solution, and Microsoft SQL solution exists on http://steemsql.com/

Server

I have setup a preview version of the database as a service. You can access it on:

Host: mongo0.steemdata.com
Port: 27017

Database: Steem
Username: steemit
Password: steemit

The steemit user account is read-only.

I highly recommend RoboMongo as a GUI utility for experimenting with the database.

After you're connected, you can run queries against any collection like this:

Data Layout

Accounts

Accounts contains Steem Accounts and their:

  • account info / profile
  • balances
  • vesting routes
  • open conversion requests
  • voting history on posts
  • a list of followers and followings
  • witness votes
  • curation stats

Example
Find all Steemit users that have at least 500 followers, less than $50,000 SBD in cash, have set their profile picture, and follow me (@furion) on Steemit.

db.getCollection('Accounts').find({
    'followers_count': {'$gt': 500},
    'balances.SBD': {'$lte': 50000},
    'profile.profile_image': {'$exists': true},
    'following': {'$in': ['furion']},
    })

Posts

Posts provide us with easy to query post objects, and include content, metadata, and a few added helpers. They also come with all the replies, which are also full Post objects.

A few extra niceties:

  • body field supports Full Text Search
  • timestamps are parsed as native ISO dates
  • amounts are parsed as Amount objects

Example
Find all Posts by @steemsports from October, which have raised at least $200.5 in post rewards and have more than 20 comments and mention @theprophet0 in the metadata.

db.getCollection('Posts').find({
    'author': 'steemsports',
    'created': {
        '$gte': ISODate('2016-10-01 00:00:00.000Z'),
        '$lt': ISODate('2016-11-01 00:00:00.000Z'),
     },
     'total_payout_reward.amount': {'$gte': 200.5},
     '$where':'this.replies.length>20',
     'json_metadata.people': {'$in': ['theprophet0']},
    })

Example 2
Find all posts which mention meteor in their body:

db.getCollection('Posts').find({'$text': {'$search': 'meteor'}})

Operations

Operations represent the entire blockchain, as seen trough a time series of individual actions, such as:

operation_types = [
    'vote', 'comment_options', 'delete_comment', 'account_create', 'account_update',
    'limit_order_create', 'limit_order_cancel',
    'transfer', 'transfer_to_vesting', 'withdraw_vesting', 'convert', 'set_withdraw_vesting_route',
    'pow', 'pow2', 'feed_publish', 'witness_update',
    'account_witness_vote', 'account_witness_proxy',
    'recover_account', 'request_account_recovery', 'change_recovery_account',
    'custom', 'custom_json'
]

Operations have the same structure as on the Blockchain, but come with a few extra fields, such as timestamp, type and block_num.

Example
Find all transfers in block 6717326.

db.getCollection('Operations').find({'type':'transfer', 'block_num': 6717326})

We get 1 result:

{
    "_id" : ObjectId("584eac2fd6194c5ab027f671"),
    "from" : "bittrex",
    "to" : "poloniex",
    "type" : "transfer",
    "timestamp" : "2016-11-14T13:21:30",
    "block_num" : 6717326,
    "amount" : "466.319 STEEM",
    "memo" : "83ad5b2c56448d45"
}

VirtualOperations

Virtual Operations represent all actions performed by individual accounts, such as:

    types = {
        'account_create',
        'account_update',
        'account_witness_vote',
        'comment',
        'delete_comment',
        'comment_reward',
        'author_reward',
        'convert',
        'curate_reward',
        'curation_reward',
        'fill_order',
        'fill_vesting_withdraw',
        'fill_convert_request',
        'set_withdraw_vesting_route',
        'interest',
        'limit_order_cancel',
        'limit_order_create',
        'transfer',
        'transfer_to_vesting',
        'vote',
        'witness_update',
        'account_witness_proxy',
        'feed_publish',
        'pow', 'pow2',
        'liquidity_reward',
        'withdraw_vesting',
        'transfer_to_savings',
        'transfer_from_savings',
        'cancel_transfer_from_savings',
        'custom',
    }

Operations have the same structure as in the steemd database, but come with a few extra fields, such as account, timestamp, type, index and trx_id.

Example:
Query all transfers from @steemsports to @furion in the past month.

db.getCollection('VirtualOperations').find({
    'account': 'steemsports',
    'type': 'transfer',
    'to': 'furion',
    'timestamp': {
        '$gte': ISODate('2016-10-01 00:00:00.000Z'),
        '$lt': ISODate('2016-11-01 00:00:00.000Z'),
    }})

TODO

  • [] Historic 3rd party price feeds (partially done)
  • [] add Indexes based on usage patterns (partially done)
  • [] parse more values into native data types
  • [] create relationships using HRefs
  • [] Create Open-Source Server (Python+Docker based)
  • [] Create Open-Source Client Libraries (Python, JS?)

Looking for feedback and testers

I would love to get community feedback on the database structure, as well as feature requests.

If you're a hacker, and have a cool app idea, feel free to use the public mongo endpoint provided by steemdata.com

Expansion Ideas

I would love to expand this service to PostgreSQL as well as build a https://steemdata.com portal with useful utilities, statistics and charts.

Sponsored by SteemSports

A 32GB RAM, Quad-Core baremetal server that is powering SteemData has been kindly provided by SteemSports.



Don't miss out on the next post - follow me

👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
json_metadata{"tags":["steemdata","steem","steemd","steemit"],"users":["steemsports","theprophet0","furion"],"image":["http://i.imgur.com/uAu5ST4.jpg","http://i.imgur.com/lRSpXG1.png","http://i.imgur.com/LjIa5KL.png","http://i.imgur.com/5MaAhy7.png"],"links":["https://steemit.com/stats/@furion/a-collection-of-steem-stats-for-october","http://steemsql.com/","https://robomongo.org/","https://steemdata.com","https://steemsports.com","https://steemit.com/@furion"],"app":"steemit/0.1","format":"markdown"}
created2017-01-10 18:34:24
active2017-01-13 09:19:24
last_payout2017-02-10 21:47:12
depth0
children43
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value628.878 SBD
curator_payout_value16.898 SBD
author_rewards4,192,530
net_votes561
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars0
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (562)

vote your-acct "furion" "introducing-steemdata-a-database-layer-for-steem" 100 true
post_comment your-acct "re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071239972z" "furion" "introducing-steemdata-a-database-layer-for-steem" "" "your reply.." "{}" true

View on official site
@the-future ·

I might not understand everything you are saying, but this is an impressive work @furion.

👍  
json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-10 18:43:39
active2017-01-10 18:43:39
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation42,903,115,342,217
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "the-future" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t184330288z" 100 true
post_comment your-acct "re-the-future-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071239979z" "the-future" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t184330288z" "" "your reply.." "{}" true

View on official site
@thebatchman ·
$1.49

Damn this is some impressive work. Thanks for opening up an query able archive for Steemit.

👍  , , , , , ,
json_metadata{"tags":["steemdata"]}
created2017-01-10 18:48:09
active2017-01-10 18:48:09
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value1.164 SBD
curator_payout_value0.322 SBD
author_rewards7,768
net_votes7
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation10,494,063,569,492
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (7)

vote your-acct "thebatchman" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t184810611z" 100 true
post_comment your-acct "re-thebatchman-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071239987z" "thebatchman" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t184810611z" "" "your reply.." "{}" true

View on official site
@furion · (edited)

A quick Python implementation can be seen in one of the use cases here

👍  , , ,
json_metadata{"tags":["steemdata"],"links":["https://github.com/SteemSports/Research/blob/master/Notebook/FreePlay%20winners%20for%20December%202016.ipynb"]}
last_update2017-01-10 18:48:48
created2017-01-10 18:48:24
active2017-01-10 18:48:48
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes4
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (4)

vote your-acct "furion" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t184823880z" 100 true
post_comment your-acct "re-furion-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071239994z" "furion" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t184823880z" "" "your reply.." "{}" true

View on official site
@twinner ·

Well done, furion. Seems that SteemData will become my favourite SteemTool soon :-)

json_metadata{"tags":["steemdata"]}
created2017-01-10 18:57:03
active2017-01-10 20:12:27
last_payout2017-02-10 21:47:12
depth1
children1
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation25,840,493,618,498
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "twinner" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t185702671z" 100 true
post_comment your-acct "re-twinner-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071239999z" "twinner" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t185702671z" "" "your reply.." "{}" true

View on official site
@furion · (edited)

I'm happy to hear :)

json_metadata{"tags":["steemdata"]}
last_update2017-01-10 20:12:36
created2017-01-10 20:12:27
active2017-01-10 20:12:36
last_payout2017-02-10 21:47:12
depth2
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "furion" "re-twinner-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t201223879z" 100 true
post_comment your-acct "re-furion-re-twinner-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240004z" "furion" "re-twinner-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t201223879z" "" "your reply.." "{}" true

View on official site
@dragosroua ·

Impressive.

What would be the time constraints of porting this into a Firebase backend? Having a Firebase backend mirroring the Steem blockchain would allow for real-time apps without the hassle of RPC calls. Having a little bit of both worlds.

json_metadata{"tags":["steemdata"]}
created2017-01-10 19:02:51
active2017-01-10 19:49:48
last_payout2017-02-10 21:47:12
depth1
children4
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation127,732,899,009,470
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "dragosroua" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t190252767z" 100 true
post_comment your-acct "re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240010z" "dragosroua" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t190252767z" "" "your reply.." "{}" true

View on official site
@furion ·

I'm not familiar with Firebase, but I guess with a little bit of coding its totally feasible.

I build real-time apps with Meteor, which uses MongoDB and its oplog, however Meteor is on decline in popularity these days.

json_metadata{"tags":["steemdata"]}
created2017-01-10 19:42:15
active2017-01-10 19:49:48
last_payout2017-02-10 21:47:12
depth2
children3
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "furion" "re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t194215446z" 100 true
post_comment your-acct "re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240015z" "furion" "re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t194215446z" "" "your reply.." "{}" true

View on official site
@dragosroua ·

I worked a few months with Firebase (check out http://app.zentasktic.com), it's quite similar with Mongo but much faster. It's now integrated into the Google full stack of services (analytics, push notifications, admob, etc).

👍  ,
json_metadata{"tags":"steemdata","app":"esteem/1.3.5","format":"markdown+html"}
created2017-01-10 19:45:06
active2017-01-10 19:49:48
last_payout2017-02-10 21:47:12
depth3
children2
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes2
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation127,732,899,009,470
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (2)

vote your-acct "dragosroua" "re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t194215446z-2017110t21453886z" 100 true
post_comment your-acct "re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t194215446z-2017110t21453886z-20170220t071240021z" "dragosroua" "re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t194215446z-2017110t21453886z" "" "your reply.." "{}" true

View on official site
@furion · (edited)
$1.23

I'm afraid its out of my scope (I don't use any Google services, willingly at least). I would prefer to stick to open-source, self-hostable solutions for data storage.

Perhaps RethinkDB could be a candidate here?

👍  
json_metadata{"tags":["steemdata"]}
last_update2017-01-10 19:49:57
created2017-01-10 19:49:06
active2017-01-10 19:49:57
last_payout2017-02-10 21:47:12
depth4
children1
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.919 SBD
curator_payout_value0.306 SBD
author_rewards6,134
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "furion" "re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t21453886z-20170110t194907671z" 100 true
post_comment your-acct "re-furion-re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t21453886z-20170220t071240027z" "furion" "re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t21453886z-20170110t194907671z" "" "your reply.." "{}" true

View on official site
@dragosroua ·

Got it :)

json_metadata{"tags":"steemdata","app":"esteem/1.3.5","format":"markdown+html"}
created2017-01-10 19:49:48
active2017-01-10 19:49:48
last_payout2017-02-10 21:47:12
depth5
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation127,732,899,009,470
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "dragosroua" "re-furion-re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t21453886z-20170110t194907671z-2017110t214947177z" 100 true
post_comment your-acct "re-dragosroua-re-furion-re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t21453886z-20170110t194907671z-2017110t214947177z-20170220t071240033z" "dragosroua" "re-furion-re-dragosroua-re-furion-re-dragosroua-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t21453886z-20170110t194907671z-2017110t214947177z" "" "your reply.." "{}" true

View on official site
@smysullivan ·

Great work, thank you for your work on the project, I agree MongoDB should be extremely fast and able to handle the project with no issues.

👍  
json_metadata{"tags":["steemdata"]}
created2017-01-10 19:05:06
active2017-01-10 21:13:15
last_payout2017-02-10 21:47:12
depth1
children2
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation15,625,771,027,539
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "smysullivan" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t190501971z" 100 true
post_comment your-acct "re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240038z" "smysullivan" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t190501971z" "" "your reply.." "{}" true

View on official site
@barrydutton · (edited)

how do you know all this stuff lol, so much for my Steemit day off lol

👍  
json_metadata{"tags":["steemdata"]}
last_update2017-01-10 21:10:21
created2017-01-10 21:10:03
active2017-01-10 21:13:15
last_payout2017-02-10 21:47:12
depth2
children1
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation46,999,993,666,941
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "barrydutton" "re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211001375z" 100 true
post_comment your-acct "re-barrydutton-re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240044z" "barrydutton" "re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211001375z" "" "your reply.." "{}" true

View on official site
@smysullivan ·

Working customer service for a large bank they run MangoDB on the back end for accounts so many cool things you can do with MangoDB.

Plus been trying to teach myself programming but not very good anymore have not been able to really work on it as of late.

json_metadata{"tags":"steemdata","app":"esteem/1.3.5","format":"markdown+html"}
created2017-01-10 21:13:15
active2017-01-10 21:13:15
last_payout2017-02-10 21:47:12
depth3
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation15,625,771,027,539
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "smysullivan" "re-barrydutton-re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211001375z-2017110t141310104z" 100 true
post_comment your-acct "re-smysullivan-re-barrydutton-re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211001375z-2017110t141310104z-20170220t071240050z" "smysullivan" "re-barrydutton-re-smysullivan-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211001375z-2017110t141310104z" "" "your reply.." "{}" true

View on official site
@kingscrown ·

damn good job!

json_metadata{"tags":["steemdata"]}
created2017-01-10 19:16:00
active2017-01-10 21:10:48
last_payout2017-02-10 21:47:12
depth1
children1
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation91,494,873,787,986
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "kingscrown" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t191600123z" 100 true
post_comment your-acct "re-kingscrown-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240055z" "kingscrown" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t191600123z" "" "your reply.." "{}" true

View on official site
@barrydutton ·

I have no idea what you guys are talking about lol, but I am happy you are happy (:

json_metadata{"tags":["steemdata"]}
created2017-01-10 21:10:48
active2017-01-10 21:10:48
last_payout2017-02-10 21:47:12
depth2
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation46,999,993,666,941
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "barrydutton" "re-kingscrown-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211046570z" 100 true
post_comment your-acct "re-barrydutton-re-kingscrown-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240061z" "barrydutton" "re-kingscrown-re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211046570z" "" "your reply.." "{}" true

View on official site
@gutzofter ·

@furion I'm on board. Tonight

json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-10 19:39:12
active2017-01-10 19:39:12
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation5,219,988,790,354
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "gutzofter" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t193907903z" 100 true
post_comment your-acct "re-gutzofter-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240066z" "gutzofter" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t193907903z" "" "your reply.." "{}" true

View on official site
@thecryptodrive ·
$0.02

Well done my friend, I am proud of what you have accomplished here.

👍  
json_metadata{"tags":["steemdata"]}
created2017-01-10 20:31:33
active2017-01-10 20:31:33
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.015 SBD
curator_payout_value0.005 SBD
author_rewards105
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation23,752,676,581,332
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "thecryptodrive" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t203135569z" 100 true
post_comment your-acct "re-thecryptodrive-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240072z" "thecryptodrive" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t203135569z" "" "your reply.." "{}" true

View on official site
@barrydutton ·

No idea about all this tech stuff but it sounds nice lol--- Good job.

json_metadata{"tags":["steemdata"]}
created2017-01-10 21:11:36
active2017-01-10 21:11:36
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation46,999,993,666,941
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "barrydutton" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211135575z" 100 true
post_comment your-acct "re-barrydutton-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240077z" "barrydutton" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t211135575z" "" "your reply.." "{}" true

View on official site
@maerco ·

Good job!
I will try to play with it tomorrow!

json_metadata{"tags":"steemdata","app":"esteem/1.3.6","format":"markdown+html"}
created2017-01-10 21:34:54
active2017-01-10 21:34:54
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation755,356,565,984
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "maerco" "re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t223447817z" 100 true
post_comment your-acct "re-maerco-re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t223447817z-20170220t071240083z" "maerco" "re-furion-introducing-steemdata-a-database-layer-for-steem-2017110t223447817z" "" "your reply.." "{}" true

View on official site
@luka.skubonja ·

Good job man :)

json_metadata{"tags":["steemdata"]}
created2017-01-10 22:05:39
active2017-01-10 22:05:39
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation22,161,107,756,409
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "luka.skubonja" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t220537335z" 100 true
post_comment your-acct "re-luka.skubonja-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240088z" "luka.skubonja" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t220537335z" "" "your reply.." "{}" true

View on official site
@teamsteem ·
$1.28

This looks like incredibly useful. This must have been a lot of work. Good job!

👍  , ,
json_metadata{"tags":["steemdata"]}
created2017-01-10 22:08:57
active2017-01-10 22:08:57
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.960 SBD
curator_payout_value0.319 SBD
author_rewards6,408
net_votes3
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation55,675,417,232,994
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (3)

vote your-acct "teamsteem" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t220904117z" 100 true
post_comment your-acct "re-teamsteem-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240094z" "teamsteem" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t220904117z" "" "your reply.." "{}" true

View on official site
@eric-boucher ·

Great accomplishment, thanks for sharing! All for one and one for all!!! Namaste :)

👍  
json_metadata{"tags":["steemdata"]}
created2017-01-10 22:35:15
active2017-01-10 22:35:15
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation39,204,081,717,838
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "eric-boucher" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t223514876z" 100 true
post_comment your-acct "re-eric-boucher-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240100z" "eric-boucher" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170110t223514876z" "" "your reply.." "{}" true

View on official site
@simonjay ·

I see very interesting thanks upped

json_metadata{"tags":["steemdata"]}
created2017-01-11 00:35:48
active2017-01-11 00:35:48
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation11,940,171,817,586
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "simonjay" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t003544797z" 100 true
post_comment your-acct "re-simonjay-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240105z" "simonjay" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t003544797z" "" "your reply.." "{}" true

View on official site
@kurtbeil · (edited)

Oh my God! This is exactly what I needed! Promises almost killed me man! ;-)

Thank you @furion!

json_metadata{"tags":["steemdata"],"users":["furion"]}
last_update2017-01-11 01:48:21
created2017-01-11 01:46:42
active2017-01-11 01:48:21
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation15,168,255,182,141
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "kurtbeil" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t014639802z" 100 true
post_comment your-acct "re-kurtbeil-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240111z" "kurtbeil" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t014639802z" "" "your reply.." "{}" true

View on official site
@saramiller ·

Way to go, @furion!

json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-11 03:41:48
active2017-01-11 03:41:48
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation81,147,995,432,320
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "saramiller" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t034148000z" 100 true
post_comment your-acct "re-saramiller-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240116z" "saramiller" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t034148000z" "" "your reply.." "{}" true

View on official site
@pnc ·
$0.07

Wow! this is great @furion. With SteemData, we could query Steem Blockchain and build Accounting App for community members or even build some tools for financial education, espically in the field of micro-financing to empower the unbanked. Congratulation.

👍  , , , , , , , , , , , , , , , , , , , , , , , ,
json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-11 05:15:09
active2017-01-11 05:15:09
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.052 SBD
curator_payout_value0.015 SBD
author_rewards354
net_votes25
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation6,978,930,302,795
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (25)

vote your-acct "pnc" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t051507794z" 100 true
post_comment your-acct "re-pnc-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240125z" "pnc" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t051507794z" "" "your reply.." "{}" true

View on official site
@good-karma ·

Great work and initiative, brother!

Is it being populated real-time?

👍  , , , , ,
json_metadata{"tags":["steemdata"]}
created2017-01-11 05:27:27
active2017-01-11 21:27:42
last_payout2017-02-10 21:47:12
depth1
children5
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes6
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation158,138,364,138,426
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (6)

vote your-acct "good-karma" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t052727302z" 100 true
post_comment your-acct "re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240132z" "good-karma" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t052727302z" "" "your reply.." "{}" true

View on official site
@andu ·

I'm also interested to know how quickly the blockchain data gets added to the db as I have some apps in the pipeline that need a refresh quicker than SteemDB's 10 minute.

👍  , ,
json_metadata{"tags":["steemdata"]}
created2017-01-11 07:20:30
active2017-01-11 07:20:30
last_payout2017-02-10 21:47:12
depth2
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes3
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation4,233,088,127,846
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (3)

vote your-acct "andu" "re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t072020365z" 100 true
post_comment your-acct "re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240137z" "andu" "re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t072020365z" "" "your reply.." "{}" true

View on official site
@andu ·

refreshing this in the browser: https://steemdata.com/stats seems to add up blocks every 5-10 seconds which is freaking awesome!

👍  
json_metadata{"tags":["steemdata"],"links":["https://steemdata.com/stats"]}
created2017-01-11 07:53:15
active2017-01-11 21:27:42
last_payout2017-02-10 21:47:12
depth2
children3
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation4,233,088,127,846
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "andu" "re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t075305104z" 100 true
post_comment your-acct "re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240143z" "andu" "re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t075305104z" "" "your reply.." "{}" true

View on official site
@good-karma ·

I think, there is queue for block addition it looks (15 blocks behind or so). If @furion can clarify exact numbers or way it is being populated, it would be helpful.

json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-11 07:56:48
active2017-01-11 21:27:42
last_payout2017-02-10 21:47:12
depth3
children2
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation158,138,364,138,426
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "good-karma" "re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t075647828z" 100 true
post_comment your-acct "re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240148z" "good-karma" "re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t075647828z" "" "your reply.." "{}" true

View on official site
@andu ·

Blocks don't always have data/transactions so this is why it isn't a constant x blocks added each x seconds i think, but yea, let's wait for @furion

json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-11 07:58:15
active2017-01-11 07:58:15
last_payout2017-02-10 21:47:12
depth4
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation4,233,088,127,846
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "andu" "re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t075805001z" 100 true
post_comment your-acct "re-andu-re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240153z" "andu" "re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t075805001z" "" "your reply.." "{}" true

View on official site
@furion ·

Operations and new Posts are near real time, new accounts will be too in the future. Everything else is delayed. Once work sharding is in place, it should be pretty fast.

👍  , , , , , ,
json_metadata{"tags":["steemdata"]}
created2017-01-11 21:27:42
active2017-01-11 21:27:42
last_payout2017-02-10 21:47:12
depth4
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes7
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (7)

vote your-acct "furion" "re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t212741252z" 100 true
post_comment your-acct "re-furion-re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240160z" "furion" "re-good-karma-re-andu-re-good-karma-re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t212741252z" "" "your reply.." "{}" true

View on official site
@araki ·

You made my day , when i see dev tool for steemit i feel great @furion even though i don't understand more than ABC at coding , the fact that steemit community actively involved in development make steemit a true decentralized blockchain .
thnx for the hard work , keep it up , steemit on
upvoted , followed and resteemed

👍  
json_metadata{"tags":["steemdata"],"users":["furion"]}
created2017-01-11 09:32:48
active2017-01-11 09:32:48
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes1
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation10,340,426,975,150
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (1)

vote your-acct "araki" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t093248789z" 100 true
post_comment your-acct "re-araki-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240168z" "araki" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t093248789z" "" "your reply.." "{}" true

View on official site
@abudar ·

very interesting

json_metadata{"tags":["steemdata"]}
created2017-01-11 10:34:33
active2017-01-11 10:34:33
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation21,861,862,181,516
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "abudar" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t103431457z" 100 true
post_comment your-acct "re-abudar-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240177z" "abudar" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t103431457z" "" "your reply.." "{}" true

View on official site
@ekaputri ·

very useful your posts@furion

json_metadata{"tags":["steemdata"]}
created2017-01-11 11:09:36
active2017-01-11 11:09:36
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation10,830,858,466,254
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "ekaputri" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t110935490z" 100 true
post_comment your-acct "re-ekaputri-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240183z" "ekaputri" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t110935490z" "" "your reply.." "{}" true

View on official site
@xeroc ·

pretty impressive! good job!

👍  , ,
json_metadata{"tags":["steemdata"]}
created2017-01-11 13:15:30
active2017-01-11 13:15:30
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes3
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation102,722,784,646,604
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (3)

vote your-acct "xeroc" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t131529571z" 100 true
post_comment your-acct "re-xeroc-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240189z" "xeroc" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t131529571z" "" "your reply.." "{}" true

View on official site
@tfhg ·

This is good. Don't understand fully but will reread, maybe couple times :)

json_metadata{"tags":["steemdata"]}
created2017-01-11 15:01:54
active2017-01-11 15:01:54
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation294,066,995,156
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "tfhg" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t150151923z" 100 true
post_comment your-acct "re-tfhg-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240194z" "tfhg" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t150151923z" "" "your reply.." "{}" true

View on official site
@lemouth ·

Impressive! :)

json_metadata{"tags":["steemdata"]}
created2017-01-11 16:02:06
active2017-01-11 16:02:06
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation47,084,568,953,215
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "lemouth" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t160204514z" 100 true
post_comment your-acct "re-lemouth-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240199z" "lemouth" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t160204514z" "" "your reply.." "{}" true

View on official site
@steemalf ·

Great job!

json_metadata{"tags":["steemdata"]}
created2017-01-11 17:19:39
active2017-01-11 17:19:39
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation3,862,826,050,498
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "steemalf" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t171939358z" 100 true
post_comment your-acct "re-steemalf-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240204z" "steemalf" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t171939358z" "" "your reply.." "{}" true

View on official site
@choreboy ·

Very cool! Think I need to give you a follow.

json_metadata{"tags":["steemdata"]}
created2017-01-11 20:58:36
active2017-01-11 20:58:36
last_payout2017-02-10 21:47:12
depth1
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation934,749,233,325
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "choreboy" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t205918238z" 100 true
post_comment your-acct "re-choreboy-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240209z" "choreboy" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170111t205918238z" "" "your reply.." "{}" true

View on official site
@andu ·

@furion: what type is the amount field in the Operations / VirtualOperations table?
How would one search for transactions above a certain amount or transactions that were in SBD etc. Tried with NumberDecimal/Float and currency: STEEM but to no avail..

json_metadata{"tags":["steemdata"],"users":["furion"],"app":"steemit/0.1"}
created2017-01-13 07:52:00
active2017-01-13 09:19:24
last_payout2017-02-10 21:47:12
depth1
children2
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation4,233,088,127,846
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "andu" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170113t075146776z" 100 true
post_comment your-acct "re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240214z" "andu" "re-furion-introducing-steemdata-a-database-layer-for-steem-20170113t075146776z" "" "your reply.." "{}" true

View on official site
@furion · (edited)

The amount fields in Operations/VirtualOperations are still strings unfortunately (todo: have native types everywhere for v2).

So what you have to do is query all transactions for a time period, and then filter out the ones you need in your code.

Python Example:

from steem.amount import Amount

filter(Amount(x['amount']).currency == 'STEEM', lambda x: Amount(x['amount']).amount > 100, db_results)
👍  ,
json_metadata{"tags":["steemdata"],"app":"steemit/0.1"}
last_update2017-01-13 09:27:30
created2017-01-13 09:18:21
active2017-01-13 09:27:30
last_payout2017-02-10 21:47:12
depth2
children1
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes2
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation64,990,248,737,488
promoted0.000 SBD
body_length0
reblogged_by[]
author_curate_reward""
vote details (2)

vote your-acct "furion" "re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170113t091820403z" 100 true
post_comment your-acct "re-furion-re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240220z" "furion" "re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170113t091820403z" "" "your reply.." "{}" true

View on official site
@andu ·

I see, ok, Thanks man!

json_metadata{"tags":["steemdata"],"app":"steemit/0.1"}
created2017-01-13 09:19:24
active2017-01-13 09:19:24
last_payout2017-02-10 21:47:12
depth3
children0
children_rshares20
net_rshares0
vote_rshares0
children_abs_rshares0
cashout_time1969-12-31 23:59:59
max_cashout_time1969-12-31 23:59:59
total_vote_weight0
reward_weight10,000
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
author_rewards0
net_votes0
root_comment1,730,348
modearchived
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
allow_repliestrue
allow_votestrue
allow_curation_rewardstrue
root_title"Introducing SteemData - A Database Layer for STEEM"
total_pending_payout_value0.000 SBD
author_reputation4,233,088,127,846
promoted0.000 SBD
body_length0
reblogged_by[]

vote your-acct "andu" "re-furion-re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170113t091910016z" 100 true
post_comment your-acct "re-andu-re-furion-re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170220t071240225z" "andu" "re-furion-re-andu-re-furion-introducing-steemdata-a-database-layer-for-steem-20170113t091910016z" "" "your reply.." "{}" true