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

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

Viewing a response to: @quochuy/re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190117t072043851z

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

$0.04

Yes. It's possible. But I limited the options on `posts` and `post_cache` tables because these tables are huge. To make the queries efficient I need to add indexes targeted for them. For example, Tower will support json_metadata.app filters soon.

👍 quochuy

`author`	emrebeyler
`permlink`	re-quochuy-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190117t072304668z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-17 07:23:03
`last_update`	2019-01-17 07:23:21
`depth`	2
`children`	3
`last_payout`	2019-01-24 07:23:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.038 HBD
`curator_payout_value`	0.001 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	246
`author_reputation`	448,528,959,341,273
`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,488,666
`net_rshares`	83,291,759,130
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
quochuy	0 B		83,291,759,130	100%

@quochuy · Jan 17 '19

Do you have an idea when such search API will be available? With AskSteem being shutdown, I’m looking for a replacement for my @steemtelly project

Posted using [Partiko iOS](https://steemit.com/@partiko-ios)

properties (22)

`author`	quochuy
`permlink`	quochuy-re-emrebeyler-re-quochuy-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190117t072520800z
`category`	utopian-io
`json_metadata`	{"app":"partiko","client":"ios"}
`created`	2019-01-17 07:25:21
`last_update`	2019-01-17 07:25:21
`depth`	3
`children`	2
`last_payout`	2019-01-24 07:25:21
`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`	208
`author_reputation`	758,372,221,814,367
`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,488,728
`net_rshares`	0

@emrebeyler · Jan 17 '19

Probably in the next couple of weeks. What kind of queries do you use? I am gathering this data to create additional indexes on the database side.

properties (22)

`author`	emrebeyler
`permlink`	re-quochuy-quochuy-re-emrebeyler-re-quochuy-re-emrebeyler-tower-a-rest-api-implementation-on-the-top-of-hivemind-20190117t072829233z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-17 07:28:30
`last_update`	2019-01-17 07:28:30
`depth`	4
`children`	1
`last_payout`	2019-01-24 07:28:30
`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`	146
`author_reputation`	448,528,959,341,273
`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,488,818
`net_rshares`	0

@quochuy · Jan 17 '19 (edited)

Great!
I use the same asksteem queries as on dtube website. They are still there despite the asksteem API returning an error, so you can see what they are exactly. But to summarise:

- recent dtube posts for an author
- related content, probably dtube posts that are using the same tag as the current post. The way you make sure it’s a dtube content that has a video is by checking that json_metadata contains the ‘video’ property
- searching posts by keywords inside title and body
- searching posts by tag
- searching posts by author
- combine the three above with a filter that look for the ‘video’ property in the json_metadata

I believe asksteem is using Solr or Elastic search and you can enter the lucene query in the URL query string

Posted using [Partiko iOS](https://steemit.com/@partiko-ios)

properties (22)