Viewing a response to: @emrebeyler/re-wehmoen-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190116t135746078z
| author | wehmoen |
|---|---|
| permlink | re-emrebeyler-re-wehmoen-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190116t143502334z |
| category | utopian-io |
| json_metadata | {} |
| created | 2019-01-16 14:35:03 |
| last_update | 2020-06-03 06:51:30 |
| depth | 3 |
| children | 6 |
| last_payout | 2019-01-23 14:35:03 |
| 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 | 1 |
| author_reputation | 86,504,380,503,125 |
| root_title | "Tower: A REST API implementation on the top of Hivemind" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,457,285 |
| net_rshares | 0 |
Not with the api, yet :) I will add it if it returns in a feasible time to serve in the api.
| author | emrebeyler |
|---|---|
| permlink | re-wehmoen-re-emrebeyler-re-wehmoen-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190116t143725578z |
| category | utopian-io |
| json_metadata | {"tags":["utopian-io"],"app":"steemit/0.1"} |
| created | 2019-01-16 14:37:27 |
| last_update | 2019-01-16 14:37:27 |
| depth | 4 |
| children | 5 |
| last_payout | 2019-01-23 14:37:27 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.022 HBD |
| curator_payout_value | 0.007 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 92 |
| author_reputation | 448,535,049,068,622 |
| root_title | "Tower: A REST API implementation on the top of Hivemind" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,457,366 |
| net_rshares | 51,000,103,576 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| jrawsthorne | 0 | 5,350,062,442 | 100% | ||
| dustsweeper | 0 | 45,650,041,134 | 4.34% |
@emrebeyler I added an index for it (took about 15 minutes) with ``` CREATE INDEX ON hive_posts_cache((json::json->>'app')); ``` and then I could query like this ``` SELECT json::json->>'app' as app, author, permlink, body, created_at from hive_posts_cache where json::json->>'app' like 'busy%' order by post_id desc limit 100 ``` 
| author | jrawsthorne |
|---|---|
| permlink | re-emrebeyler-re-wehmoen-re-emrebeyler-re-wehmoen-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190116t205801472z |
| category | utopian-io |
| json_metadata | {"community":"busy","app":"busy/2.5.6","format":"markdown","tags":["utopian-io"],"users":["emrebeyler"],"links":["/@emrebeyler"],"image":["https://ipfs.busy.org/ipfs/Qmf5SsuCH4UVAC2UKbykp55Jz9svgMAgJPrDuqg5q3LmET"]} |
| created | 2019-01-16 20:58:03 |
| last_update | 2019-01-16 20:58:03 |
| depth | 5 |
| children | 3 |
| last_payout | 2019-01-23 20:58:03 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 1.092 HBD |
| curator_payout_value | 0.261 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 419 |
| author_reputation | 6,883,202,705,575 |
| root_title | "Tower: A REST API implementation on the top of Hivemind" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,470,399 |
| net_rshares | 2,377,834,158,734 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| ausbitbank | 0 | 1,616,927,103,760 | 100% | ||
| emrebeyler | 0 | 760,907,054,974 | 100% |
This is great @jrawsthorne! How long does this example query take to complete after the index?
| author | emrebeyler |
|---|---|
| permlink | re-jrawsthorne-re-emrebeyler-re-wehmoen-re-emrebeyler-re-wehmoen-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190116t205937442z |
| category | utopian-io |
| json_metadata | {"tags":["utopian-io"],"users":["jrawsthorne"],"app":"steemit/0.1"} |
| created | 2019-01-16 20:59:39 |
| last_update | 2019-01-16 21:00:00 |
| depth | 6 |
| children | 2 |
| last_payout | 2019-01-23 20:59:39 |
| 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 | 96 |
| author_reputation | 448,535,049,068,622 |
| root_title | "Tower: A REST API implementation on the top of Hivemind" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,470,443 |
| net_rshares | 0 |
| author | wehmoen |
|---|---|
| permlink | re-emrebeyler-re-wehmoen-re-emrebeyler-re-wehmoen-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190116t182635545z |
| category | utopian-io |
| json_metadata | {} |
| created | 2019-01-16 18:26:36 |
| last_update | 2020-06-03 06:38:36 |
| depth | 5 |
| children | 0 |
| last_payout | 2019-01-23 18:26:36 |
| 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 | 1 |
| author_reputation | 86,504,380,503,125 |
| root_title | "Tower: A REST API implementation on the top of Hivemind" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 78,465,701 |
| net_rshares | 0 |
hiveblocks