Viewing a response to: @arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data
How did you populate the database to begin with? If you're using the RPC mechanism, after 30 days some data is no longer returned. For example, `active_votes` is empty for all posts after their second payout. You can even see this on steemit.com where old posts have zero upvotes.
| author | bitcalm |
|---|---|
| permlink | re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t112453737z |
| category | steemit |
| json_metadata | {"tags":["steemit"]} |
| created | 2016-09-14 11:24:45 |
| last_update | 2016-09-14 11:24:45 |
| depth | 1 |
| children | 1 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 280 |
| author_reputation | 24,919,530,803,138 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,242,146 |
| net_rshares | 44,282,381,365 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| bitcalm | 0 | 44,282,381,365 | 100% |
All votes are in transactions and stored in the TxVotes table, even first votes ever : https://s18.postimg.org/mhjtzg7p5/14_09_2016_13_56_49.png
| author | arcange |
|---|---|
| permlink | re-bitcalm-re-arcange-steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data-20160914t120100152z |
| category | steemit |
| json_metadata | {"tags":["steemit"],"image":["https://s18.postimg.org/mhjtzg7p5/14_09_2016_13_56_49.png"]} |
| created | 2016-09-14 12:01:00 |
| last_update | 2016-09-14 12:01:00 |
| depth | 2 |
| children | 0 |
| last_payout | 2016-10-15 13:25:57 |
| 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 | 1,146,608,602,483,196 |
| root_title | "[STEEMSQL.COM] A public SQL server database with all Steemit blockchain data" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 1,242,452 |
| net_rshares | 0 |
hiveblocks