RE: Proposal: Public Hivemind SQL service by contrabourdon

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

Viewing a response to: @emrebeyler/proposal-public-hivemind-sql-service

proposal · @contrabourdon · Oct 20 '19

Is this similar to the @arcange database but for PostgreSQL?

Posted using [Partiko iOS](https://partiko.app/referral/contrabourdon)

properties (22)

`author`	contrabourdon
`permlink`	contrabourdon-re-emrebeyler-proposal-public-hivemind-sql-service-20191020t110341266z
`category`	proposal
`json_metadata`	{"app":"partiko","client":"ios"}
`created`	2019-10-20 11:03:42
`last_update`	2019-10-20 11:03:42
`depth`	1
`children`	16
`last_payout`	2019-10-27 11:03:42
`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`	132
`author_reputation`	226,187,807,219,161
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	91,731,534
`net_rshares`	0

@emrebeyler · Oct 20 '19 (edited)

Yes, it will be the same except Hivemind doesn't store whole blockchain data like SteemSQL. Instead, it focuses on social aspects like votes, comments, posts, resteems, relationships. (ignore, follow, etc.)

In the future, communities data is also planned to store at Hivemind.

👍 ismailkah

`author`	emrebeyler
`permlink`	pzo6wy
`category`	proposal
`json_metadata`	{"app":"steemit/0.1"}
`created`	2019-10-20 11:07:45
`last_update`	2019-10-20 11:09:24
`depth`	2
`children`	15
`last_payout`	2019-10-27 11:07:45
`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`	277
`author_reputation`	448,535,049,068,622
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	91,731,637
`net_rshares`	5,553,630,657
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ismailkah	0 B		5,553,630,657	25%

@contrabourdon · Oct 20 '19

Sounds great! Looking forward to be one of the first to test :) You already have my witness vote and I will support this proposal.

properties (22)

`author`	contrabourdon
`permlink`	re-emrebeyler-pzo76u
`category`	proposal
`json_metadata`	{"tags":["proposal"],"app":"steempeak/1.18.0"}
`created`	2019-10-20 11:13:42
`last_update`	2019-10-20 11:13:42
`depth`	3
`children`	1
`last_payout`	2019-10-27 11:13:42
`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`	130
`author_reputation`	226,187,807,219,161
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	91,731,802
`net_rshares`	0

@emrebeyler · Oct 20 '19

Thanks! 🎉

👍 ismailkah

`author`	emrebeyler
`permlink`	pzo78b
`category`	proposal
`json_metadata`	{"app":"steemit/0.1"}
`created`	2019-10-20 11:14:36
`last_update`	2019-10-20 11:14:36
`depth`	4
`children`	0
`last_payout`	2019-10-27 11:14: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`	9
`author_reputation`	448,535,049,068,622
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	91,731,824
`net_rshares`	5,503,134,454
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ismailkah	0 B		5,503,134,454	25%

@wehmoen · Jun 3 '20 (edited)

properties (22)

`author`	wehmoen
`permlink`	re-emrebeyler-pzqgg2
`category`	proposal
`json_metadata`	{}
`created`	2019-10-21 16:28:51
`last_update`	2020-06-03 06:18:57
`depth`	3
`children`	12
`last_payout`	2019-10-28 16:28: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`	1
`author_reputation`	86,504,380,503,125
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	91,773,367
`net_rshares`	0

@emrebeyler · Oct 21 '19

It is available with a subscription fee.

👍 ismailkah

`author`	emrebeyler
`permlink`	pzqgpe
`category`	proposal
`json_metadata`	{"app":"steemit/0.1"}
`created`	2019-10-21 16:34:27
`last_update`	2019-10-21 16:34:27
`depth`	4
`children`	10
`last_payout`	2019-10-28 16:34:27
`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`	40
`author_reputation`	448,535,049,068,622
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	91,773,545
`net_rshares`	5,581,420,384
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ismailkah	0 B		5,581,420,384	25%

10 replies

@inertia · Nov 4 '19

Both Hivemind and SteemSQL interpret the blockchain differently.  A really good example of how some Hivemind queries are useful over SteemSQL is doing tag queries.  With Hivemind, you can do a query that matches posts that have all tags specified.  With SteemSQL, this is difficult.

When I say "all tags specified" I mean that you want posts that match "tag a" *and* "tag b" as opposed to "tag a" or "tag b".

This is possible in Hivemind because tags are a dedicated table, so doing that kind of query is somewhat trivial.  With SteemSQL, you could probably achieve it with sub-selects and temporary tables, but I haven't needed to look into it.

Some more examples: [Hivemind Queries
](http://steemit.com/@inertia/hivemind-queries)

👎 nanocheeze

`author`	inertia
`permlink`	q0ff0h
`category`	proposal
`json_metadata`	{"links":["http://steemit.com/@inertia/hivemind-queries"],"app":"steemit/0.1"}
`created`	2019-11-04 03:57:54
`last_update`	2019-11-04 03:57:54
`depth`	4
`children`	0
`last_payout`	2019-11-11 03:57:54
`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`	734
`author_reputation`	346,568,901,399,561
`root_title`	"Proposal: Public Hivemind SQL service"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	92,178,932
`net_rshares`	-64,713,014,585
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
nanocheeze	0 B		-64,713,014,585	-100%