RE: Hivemind Queries by emrebeyler

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @inertia/hivemind-queries

hivemind · @emrebeyler · Aug 11 '18

$2.31

Looking sharp. 

One thing I am skeptical about is syncing. 

It should be rock-solid and catch-up with the chain no matter what the block volume or database size is.

I will certainly play with the project since it's written on my beloved Python.

👍 inertia, surpassinggoogle

`author`	emrebeyler
`permlink`	re-inertia-hivemind-queries-20180811t081727084z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2018-08-11 08:17:27
`last_update`	2018-08-11 08:17:27
`depth`	1
`children`	7
`last_payout`	2018-08-18 08:17:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	1.736 HBD
`curator_payout_value`	0.576 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	247
`author_reputation`	448,535,049,068,622
`root_title`	"Hivemind Queries"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	67,834,768
`net_rshares`	1,747,815,839,678
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
inertia	0 B		1,525,783,292,486	100%
surpassinggoogle	0 B		222,032,547,192	1%

@emrebeyler · Aug 11 '18

$0.29

btw,

> It took a while to sync.

How many hours/days?

👍 surpassinggoogle

`author`	emrebeyler
`permlink`	re-emrebeyler-re-inertia-hivemind-queries-20180811t081834444z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2018-08-11 08:18:33
`last_update`	2018-08-11 08:18:33
`depth`	2
`children`	6
`last_payout`	2018-08-18 08:18:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.220 HBD
`curator_payout_value`	0.072 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	54
`author_reputation`	448,535,049,068,622
`root_title`	"Hivemind Queries"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	67,834,830
`net_rshares`	222,032,547,192
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
surpassinggoogle	0 B		222,032,547,192	1%

@inertia · Aug 11 '18 (edited)

Yup, the sync routine is *rock solid*. @roadscape really nails it.  Initial sync took me about a week.  But that’s because I used api.steemit.com.  I wanted to see what the typical hobbyist might experience trying this out, so I didn’t try anything heroic on the initial sync.

I also didn’t set *any* of the recommended Postgres configurations.  Same reason.  Hobbiests might skip that too.

properties (22)

`author`	inertia
`permlink`	re-emrebeyler-re-emrebeyler-re-inertia-hivemind-queries-20180811t153952178z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"users":["roadscape"],"app":"steemit/0.1"}
`created`	2018-08-11 15:39:51
`last_update`	2018-08-11 21:19:36
`depth`	3
`children`	5
`last_payout`	2018-08-18 15:39:51
`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`	391
`author_reputation`	346,568,901,399,561
`root_title`	"Hivemind Queries"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	67,868,067
`net_rshares`	0

@good-karma · Aug 13 '18

It took 3 days for me couple weeks back, likely depends on stability of rpc and server specs

👍 longberry

`author`	good-karma
`permlink`	re-inertia-re-emrebeyler-re-emrebeyler-re-inertia-hivemind-queries-20180813t063701747z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2018-08-13 06:37:03
`last_update`	2018-08-13 06:37:03
`depth`	4
`children`	1
`last_payout`	2018-08-20 06:37: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`	92
`author_reputation`	656,223,454,697,932
`root_title`	"Hivemind Queries"
`beneficiaries`	`[]`
`max_accepted_payout`	0.000 HBD
`percent_hbd`	10,000
`post_id`	68,027,015
`net_rshares`	486,025,719
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
longberry	0 B		486,025,719	100%

1 reply

@irelandscape · Aug 12 '18

Very exciting.
Is it possible to import your database into another instance of hivemind so that a fully sync wouldn't be necessary?

Thanks for sharing!

properties (22)

`author`	irelandscape
`permlink`	re-inertia-re-emrebeyler-re-emrebeyler-re-inertia-hivemind-queries-20180812t181002441z
`category`	hivemind
`json_metadata`	{"tags":["hivemind"],"app":"steemit/0.1"}
`created`	2018-08-12 18:10:03
`last_update`	2018-08-12 18:10:03
`depth`	4
`children`	2
`last_payout`	2018-08-19 18:10: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`	152
`author_reputation`	15,380,678,988,494
`root_title`	"Hivemind Queries"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	67,977,229
`net_rshares`	0

2 replies