DAppBoard BI-Weekly Recap 1

The past 2 weeks were a fresh start for our organization. We have been working hard to set up the foundation of the new upcoming version of DAppBoard. We are currently focusing on building the backbone of it: principally how data are collected, organized and accessed. Our goal, in the next few months, is to get the new version of DAppBoard out.

This recap is what we did from 12 to 24 November 2018.

🛠 DAppBoard ETL

In 2 weeks we architectured, developped and released our Ethereum ETL that is written in Javascript. The ETL’s goal (Extract, Load & Transform)and writes to SQL compatible database.

The elements that we currently focus on are:

• Basics of the Ethereum blockchain (blocks, transactions, event logs).
• Tokens (ERC20/ERC721): we aggregate there transfers but also their metadata like name, symbol, number of decimals.
• Contracts: the source code and element of their ABIs are stored in an easy to use way. Thanks Etherscan for the openness of their API.

We deployed our pipeline and database live for testing and could easily extract more than 60M transactions from 700K blocks, 22K tokens.

All the software we run in the background is and will stay open source. As we can’t rely on decentralized technologies to do what we want yet. We open our work so community can thrust us and grow with us.

📊Firsts analysis

We set up the awesome Metabase to access and play with our data. Metabase is an open source piece of software that let anyone build queries and visualize and organize the results. The goal was to see if our data were correct and how easy the way they were stored let us play with it.

Our first piece of analysis was about tokens (ERC20/ERC721):

And our second piece about mining ⛏:

Those two studies helped us validate our architecture and the correctness of our data set. If you want to be one of the first to see our upcoming tweet storms, do follow DAppBoardTeam on twitter.

Those 2 weeks went so fast and we could achieve a lot. The next steps of our adventure are:

Step back and explain, as the code written for the ETL has been done fast, a lot of things need to be consolidated and also documented so anyone can use it, or we can read it in few months too!

Produce more analysis, we just scratched the surface of what was possible to do with our pipeline. We’ll try to produce DApps specific dashboards. This will also let us improve even more how we structure and test our data set.

Enrich the data, some of the data we store need to be edited manually for more consistency. We need to build an interface for us to easily check and edit some of the data.

Grow the team, we want to grow the team, but for this we need to decide and secure how we’ll get funded for the next months.

DAppBoard is focusing on building tools to store, explore and explain data that are generated by the Ethereum makers and users. Follow us or get in touch on Twitter!