marcdeb1
marcdeb1
If we want to fetch statistics on content on Chainquery, such as Top claims, we need to have an index on the *effective_amount* column. https://chainquery.lbry.io/api/sql?query=SELECT%20*%20from%20claim%20order%20by%20effective_amount%20desc%20LIMIT%2010 Otherwise, the query is too...
As started by @AlessandroSpallina (https://github.com/lbryio/block-explorer/issues/67), a new explorer is proposed, developed in Laravel (original repo : https://github.com/marcdeb1/LBRYEXPLORER) This new explorer shows improvements in design, user experience, performance, and maintainability. It...