Create page to show top content and channel claims

tzarebczan commented

2018-04-12 20:56:35 +02:00

(Migrated from github.com)

Similar to the rich list, have a page which shows claims/channels that have top LBC bid amounts.

Internal Use

Acceptance Criteria

Definition of Done

Tested against acceptance criteria
Tested against the assumptions of the user story
The project builds without errors
Unit tests are written and passing
Tests on devices/browsers listed in the issue have passed
QA performed & issues resolved
Refactoring completed
Any configuration or build changes documented
Documentation updated
Peer Code Review performed

Similar to the rich list, have a page which shows claims/channels that have top LBC bid amounts. ## Internal Use ### Acceptance Criteria 1. 2. 3. ### Definition of Done - [ ] Tested against acceptance criteria - [ ] Tested against the assumptions of the user story - [ ] The project builds without errors - [ ] Unit tests are written and passing - [ ] Tests on devices/browsers listed in the issue have passed - [ ] QA performed & issues resolved - [ ] Refactoring completed - [ ] Any configuration or build changes documented - [ ] Documentation updated - [ ] Peer Code Review performed

tiger5226 commented

2018-05-11 07:54:37 +02:00

(Migrated from github.com)

We can just #ChainqueryIt

This will give us the data we want in the format we want to present how we want :)

SELECT 
  name,
  (effective_amount/100000000) as amount 
FROM chainquery.claim 
WHERE claim_type = 2 
ORDER BY effective_amount 
DESC LIMIT 100

For claim streams just do claim_type = 1

So what you enter would be
https://chainquery.lbry.io/api/sql?query=SELECT name,(effective_amount/100000000) as amount FROM chainquery.claim WHERE claim_type = 1 ORDER BY effective_amount DESC LIMIT 100

We can just [#ChainqueryIt](https://chainquery.lbry.io/api/sql?query=SELECT%20name,(effective_amount/100000000)%20as%20amount%20FROM%20chainquery.claim%20WHERE%20claim_type%20=%202%20ORDER%20BY%20effective_amount%20DESC%20LIMIT%20100) This will give us the data we want in the format we want to present how we want :) ```SQL SELECT name, (effective_amount/100000000) as amount FROM chainquery.claim WHERE claim_type = 2 ORDER BY effective_amount DESC LIMIT 100 ``` For claim streams just do `claim_type = 1` So what you enter would be `https://chainquery.lbry.io/api/sql?query=SELECT name,(effective_amount/100000000) as amount FROM chainquery.claim WHERE claim_type = 1 ORDER BY effective_amount DESC LIMIT 100`

marcdeb1 commented

2018-10-28 15:25:21 +01:00

(Migrated from github.com)

To expand on your suggestion, here are some good stats that could be added :

List of channels and claims by highest bid
Claims and channels that got the most from paid content (not sure if this can be found, doesn't seem so according to https://lbry.io/faq/transaction-types)
Top channels regarding tips

Also it would be good to have one or several charts with the following data points :

Number of claims and channels published per day and total
Number of LBC locked in claims/channels per day and total
Tips sent per day

This could be added to a separate page concerning content stats, as opposed to blocks/addresses stats. Since LBRY is a marketplace, it seems important to make such data points available, to help publishers and users. It would be also good to have a search feature to find out, for example, which are the top claims or channels in a certain category.

To expand on your suggestion, here are some good stats that could be added : - List of channels and claims by highest bid - Claims and channels that got the most from paid content (not sure if this can be found, doesn't seem so according to https://lbry.io/faq/transaction-types) - Top channels regarding tips Also it would be good to have one or several charts with the following data points : - Number of claims and channels published per day and total - Number of LBC locked in claims/channels per day and total - Tips sent per day This could be added to a separate page concerning content stats, as opposed to blocks/addresses stats. Since LBRY is a marketplace, it seems important to make such data points available, to help publishers and users. It would be also good to have a search feature to find out, for example, which are the top claims or channels in a certain category.

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: LBRYCommunity/block-explorer#24

Create page to show top content and channel claims #24

Internal Use

Acceptance Criteria

Definition of Done