Better Cardano Blockchain Insights

[GENERAL] Name and surname of main applicant

André de Amorim Fonseca

[GENERAL] Email address of main applicant

fanscardano@gmail.com

Additional applicants

Matheuz Czeladka

[GENERAL] Please specify how many months you expect your project to last (from 2-12 months)

6

[GENERAL] Please indicate if your proposal has been auto-translated into English from another language.

No

[GENERAL] Does your project have any dependencies on other organizations, technical or otherwise?

Yes

[GENERAL] If YES, please describe what the dependency is and why you believe it is essential for your project’s delivery. If NO, please write “No dependencies.” .

IOG analytics dataset is one of the alternatives we will explore as an alternative analytical solution that could scale with the growth of the Cardano blockchain.

[GENERAL] Will your project’s output/s be fully open source?

No

[GENERAL] If NO, please describe which outputs are not going to be open source. If YES, please write “Project will be fully open source.”

I'll open source all queries used on the Cardano Blockchain Insights which are being directed to the IOG analytics dataset.

[METADATA] Category of Proposal

Data, Explorers, Trackers

[IMPACT] Please describe your proposed solution.

The data produced on the Cardano Blockchain is not easily translatable into consumable information which could be used by the public for, for example, blockchain health monitoring and financial analysis. Better exposing information extracted from the blockchain raw data, in a user-friendly format, is vital for the engagement of different user profiles, such as developers and/or investors, ultimately increasing the growth of the Cardano ecosystem.

In this context, we created Cardano Blockchain Insights as a tool to help different profiles of users to better visualize different dimensions of events inside this blockchain. This tool is materialised as a dashboard exposing data collected from multiple public data sources (Mesari, adapools, adatstats.net, Twitter, etc.) and private APIs exposing views made on top of Cardano DB sync and also other off-chain data. This tool is already created and being used by the Cardano community since February 2021. The CRFA team and other external contributors extended it multiple times within the course of the last year. 

However, with the increasing complexity of the queries aiming to simplify its content and the growth of the blockchain itself, enabling a better way to scale will be crucial to continuing exposing the full history of the metrics collected so far. Thus, exploring different analytical data storage for our views over Cardano DB Sync (such as ClickHouse), and investigating the usage of other data sources such as Carp (https://github.com/dcSpark/carp) or IOHK's Cardano Bigquery solution (IOG analytics dataset), will be an important step of the work done on this proposal.

We also plan to devise a better solution to get a faster feedback loop from the community towards the data we are now exposing by open-sourcing all queries used on the Cardano Blockchain Insights. The goal is to provide a way for different contributors to challenge our data and propose fixes and improvements.

At last, besides current content, we plan future short / medium term developments that will help improve the user experience which focuses on improving the quality of current content and adding new metrics of interest.

[IMPACT] How does your proposed solution address the challenge and what benefits will this bring to the Cardano ecosystem?

Based on the feedback received so far, it is clear that Cardano Blockchain Insights brings value to the community with its organised, easy to understand content and at the same time helps the ecosystem by attracting new users and reducing their learning curve. Although this proposal does not fit in the other specific Catalyst Challenges, we choose this broad section because it is a project that has the support of the community and could enrich the Cardano ecosystem even more.

There are 3 main values brought to the Cardano ecosystem by Cardano Blockchain Insights are: to provide decision-making tools for research/investor analysis, the opportunity to monitor the state of the blockchain, and create educational content for the community.

Data for research/investor analysis

Cardano Blockchain Insights content can be used as inputs for monitoring and performing multiple blockchain analysis, such as adoption or decentralisation analyses, amongst many others. It offers a way to visualize network effects in Cardano which can feed research/investor studies and also, creates the possibility to perform valuation projections. Many of the statistics already present on the site like: the number of wallets created, the total Ada staked by users or the social media statistics, are important KPI’s that show Cardano has a vibrant ecosystem and are metrics that an investor looks at when assessing a possible investment. As an example, Grayscale, an important investment fund, mentioned data from Cardano Insights about the rise of active addresses in their report “An introduction to Cardano”.

The content provided by Cardano Blockchain Insights can also be seen frequently on sites about cryptocurrency, in various articles about Cardano. For example, Ada’s increase in total number of transactions was presented by Cointelegraph.com using data from Cardano Blockchain Insights. Additionally, Kraken report about Cardano’s development of smart contracts also mentions Cardano Blockchain Insights data when presenting the network growth. The same can be said about the actual growth of the blockchain mentioned in an article on U.Today, or the fact that Cardano is 47,000x more energy-efficient than Bitcoin cited by Finbold.com. In conclusion, content from Cardano Blockchain Insights was overwhelmingly popular to present Cardano’s growth and increase in adoption.

Monitor the state of the blockchain

An important use case of the data is to check decentralisation metrics and use this as a compass for decision- making regarding governance policies. We can provide 2 examples of the way these stats can be used. The first example is the "Stake Pools" section on the dashboard, used to monitor the blockchain level of decentralisation. This healthy metric was useful, especially after the launch of ISPOs that started after smart contracts were deployed on Cardano. A second example is the tracking of the Nakamoto coefficient, which is an indicator striving to measure the extent of decentralisation. The goal of the community is to mitigate the risk of an attack on the blockchain and monitoring this coefficient and then taking action is critical in keeping the network decentralised.

The platform also provides a way to monitor the usage of smart contracts in the blockchain, by showing the number of Plutus scripts, indicating the growth of the number of Dapps or NFT marketplaces deploying on Cardano. It also tracks which Dapps are running smart contracts and counts how many times their scripts are being executed - this data can be used, together with the TVL (Total Value Locked) evolution, to check their user engagement and adoption.

Creating educational content for the community

As the language in the blockchain industry is quite technical, it is important to provide information that explains how the network is functioning in a way that the whole community understands the capabilities of Cardano.

A good example in this direction is the "Transactions" section, where it is presented what kind of transactions are being performed in the blockchain and their impact on the blockchain load. For example, a smart contract transaction requires much more resources than a simple transaction and by providing this information, the Cardano Blockchain Insight helps the community to understand the current status and the connection with the network scaling plan that is implemented this year.

Another interesting example can be found in the number of transactions per day chart. Cardano is using the eUTXO model (same as Bitcoin) and the way transactions are performed is different from the account model (used by Ethereum). For eg., one transaction can be a payment from either one-to-many addresses or even from many-to-many addresses. In this direction, Cardano Blockchain Insights is providing a way to normalize the transactions to account style blockchains also revealing the particularities of Cardano when compared with other blockchains. 

[IMPACT] How do you intend to measure the success of your project?

We consider the increase in adoption and awareness of Cardano to be the most important indicator of success of this project.

Becoming the first source of information about Cardano for regular Ada holders, Dapp developers and people from outside the ecosystem who are considering Cardano a potential entry opportunity.

In order to measure the success of the project, we will monitor the daily site visits by setting a target of 450 visits/day.

Use of Cardano Blockchain Insights as a reference-able resource, for example, the data provided to be used by other parties in marketing Cardano’s current level of development and high potential.

A monthly evaluation of the number of times Cardano Insights data is referenced in the media will be put in place.

[IMPACT] Please describe your plans to share the outputs and results of your project?

Increases of media references to the Cardano Blockchain Insights and unique visits are internal data, but we can share it in case any project audition need.

Ultimately, we plan to provide all queries used on Cardano Blockchain Insights in a Github page so then we will be able to validated by the community, creating a feedback loop so we could increase the precision of our data.

[CAPABILITY/ FEASIBILITY] What is your capability to deliver your project with high levels of trust and accountability?

With the current estimated blockchain size growth, the scalability of the analytical capabilities of Cardano DB Sync can be a problem in the medium/long term. We will explore other storage/retrieval solutions in order to make our queries scale and be more reliable over time.

Among these solutions, we will investigate how the current IOG Bigquery analytics dataset could be a replacement for our current infrastructure, measuring it against our actual costs and precision. We believe that due to the current state of maturity of the IOHK solution and the already existing conversations between our team members and the IOHK Bigquery's responsible team, this choice will fit our needs with high degree of confidence.

[CAPABILITY/ FEASIBILITY] What are the main goals for the project and how will you validate if your approach is feasible?

The main goal of this project is to provide scalability for Cardano Blockchain Insights in terms of costs and reliability against the Cardano blockchain growth.

By testing alternatives such as IOG's analytics dataset on Bigquery, we will be able to estimate usage cost and compare it with the current DB-Sync based solution. We will also be able to check if we can express all our queries in the data exposed in this dataset, and how its performance compares with our current solution. We are confident we can yield good results with this approach but we might prepare for the case of failure by testing the same properties on a on-premise alternative private database where we will be the only responsible for the indexation of the Cardano Blockchain data.

[CAPABILITY/ FEASIBILITY] Please provide a detailed breakdown of your project’s milestones and each of the main tasks or activities to reach the milestone plus the expected timeline for the delivery.

Future developments (1-6 months), we’ll be planned as follows:

Month 1 to 3

- Improving accuracy and validity of data by checking data against multiple sources of data, e.g. APIs but, also DB sync SQL queries

-Fixing stability of ingestion of data and performance issues by reviewing the code and fixing places where ingestion often fails, analyse root causes

-Analyse other data storage/retrieval solutions which could provide better scalability for our heaviest queries on Cardano DB Sync. Ideally, propose an analytical environment for Cardano Blockchain Insights that could scale for the next few years to come, without drastic changes on its data ingestion architecture. Iterate with IOHK for adding missing data pieces for potential alternative solution using BigQuery. Check the feasibility of a change to Bigquery against current DB-Sync solution (centralization might be a blocker).

Month 4 to 5

-Add metrics and charts related to Catalyst Fund 10 (as we already did for Fund 6).

-Adding new metrics (e.g. effective-k, tokens metrics, pool groups with skin in the game, google trends, building on Cardano metrics, and many more) as part of the improved monitoring of the blockchain goal.

Month 6

- Providing queries and documentation of how we calculate metrics as our commitment to provide educational content to the community.

[CAPABILITY/ FEASIBILITY] Please describe the deliverables, outputs and intended outcomes of each milestone.

Month 1 to 3

-Evaluate, choose, and iterate over an alternative solution for information retrieval for the Cardano Blockchain Insights. This choice must allow this platform scale for the next years in terms of storage and costs.

Month 4 to 5

-Catalyst Fund 10 charts and metrics (as already presented for Fund 6)

-Other new charts around metrics of interest being indicated by users (ex: token metrics and improvement of MAV).

Month 6

-Open source all queries used against IOG's analytics dataset exposed on a Github repository, with explanations.

[RESOURCES & VALUE FOR MONEY] Please provide a detailed budget breakdown of the proposed work and resources.

Asking for $9’000 = ca. 27.000 ADA at the time this is being written.

$9.000 funds for development and content creation: 600 hours of work with $ 15 / hour just to maintain server costs and minimum compensation for both participants (sharing ~4h of work/day).

We believe that this fund will cover most of expenses already incurred on this project and pay for the proposed additional development. This proposal is also not a simple step of a bigger project.

[RESOURCES & VALUE FOR MONEY] How does the cost of the project represent value for money for the Cardano ecosystem?

Cardano Blockchain Insights is already attracting and will continue to attract new users interested in getting involved in the ecosystem. Charts from this project are constantly being refereed in the crypto specialized media (both written articles and Youtube channels). In that sense, we believe we are already providing great value to the Cardano ecosystem and we would like to make this project scale in order to survive the growth of this blockchain and continue being a easy-to-understand and precise reference about the Cardano ecosystem for both newcomers and veterans. Ultimately, we believe that by maintain this project will be an adoption increase factor for Cardano.

[IMPORTANT NOTE] The Applicant agreed to Fund10 rules and also that data in the Submission Form and other data provided by the project team during the course of the project will be publicly available.

I Accept