RE: Tower: A REST API implementation on the top of Hivemind by emrebeyler

utopian-io · @emrebeyler · Jan 17 '19 (edited)

$0.03

```
postgres=# SELECT pg_size_pretty( pg_database_size('hive') );
 pg_size_pretty
----------------
 181 GB
(1 row)
```

181 GB for hivemind. But beware, Hive doesn't store all the data of the blockchain.

👍 shaunmza

`author`	emrebeyler
`permlink`	re-shaunmza-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190117t092344491z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-17 09:23:45
`last_update`	2019-01-17 09:39:48
`depth`	2
`children`	1
`last_payout`	2019-01-24 09:23:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.022 HBD
`curator_payout_value`	0.005 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	203
`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,492,172
`net_rshares`	49,628,464,881
`author_curate_reward`	""

properties (23)vote details (1)

Thanks for this, I see it's a Postgres db in the back then. I am interested in only a subset of the data. Is it possible to filter posts where the parent id is empty (i.e. only get back posts, not comments)? Going to read up a bit more.

voter	weight	wgt%	rshares	pct	time
shaunmza	0 B		49,628,464,881	100%