

Welcome to Paragraph!
Learn how to make the most of it.
The Landscape of Web3 Scores and Algorithms
We’ve seen algorithms become the lifeblood of the internet - driving infinite recommendations on top of infinite feeds. In web2, these algorithms are complete black boxes (end-to-end), used for one specific application, and manipulated by some interested party. No one knows exactly what inputs are used, what scores are given to people and content, or what models are used for curation. And you can be sure there’s no API to run their models and get their outputs yourself. Web3 algorithms are st...
The Landscape of Web3 Scores and Algorithms
We’ve seen algorithms become the lifeblood of the internet - driving infinite recommendations on top of infinite feeds. In web2, these algorithms are complete black boxes (end-to-end), used for one specific application, and manipulated by some interested party. No one knows exactly what inputs are used, what scores are given to people and content, or what models are used for curation. And you can be sure there’s no API to run their models and get their outputs yourself. Web3 algorithms are st...
Web3 Data Guide: Sudoswap
This is the first of many Web3 data guides I plan on doing. The goal here is to explain the protocol from a data analyst/engineer’s perspective. These guides aim to bring transparency to the data you see on dashboards, as well as awareness of how well (or not well) protocols are built for data analysis. In these guides, I’ll cover protocols in three sections:Protocol overview and high-level statisticsMain protocol interactions and how to derive the important data points from themSome of the m...
Web3 Data Guide: Sudoswap
This is the first of many Web3 data guides I plan on doing. The goal here is to explain the protocol from a data analyst/engineer’s perspective. These guides aim to bring transparency to the data you see on dashboards, as well as awareness of how well (or not well) protocols are built for data analysis. In these guides, I’ll cover protocols in three sections:Protocol overview and high-level statisticsMain protocol interactions and how to derive the important data points from themSome of the m...
On Web3 Membership and Composable Monetization
We’ve seen various combinations of NFT (ERC721) auctions, ERC20 airdrops, open sales of both, tiered access to the open sales, etc. - all under the guise of making you a “member of the community”. Some have worked well, while others have been flaming piles of garbage. I believe each monetization method has its place, but we need to be more intentional about:who in the community they’re targetinghow they’re composed togetherIn this piece, I want to propose some frameworks and implementation to...
On Web3 Membership and Composable Monetization
We’ve seen various combinations of NFT (ERC721) auctions, ERC20 airdrops, open sales of both, tiered access to the open sales, etc. - all under the guise of making you a “member of the community”. Some have worked well, while others have been flaming piles of garbage. I believe each monetization method has its place, but we need to be more intentional about:who in the community they’re targetinghow they’re composed togetherIn this piece, I want to propose some frameworks and implementation to...

Learning to Work With Ethereum Storage and State Data
If you’re completely new to SQL and Ethereum I recommend starting with my full beginners’ overview or breaking down an Ethereum transaction first. Feel free to support my work by buying a Data Landscape edition at the end of the article, or sending a tip to ilemi.eth! Most explanations of storage and state on Ethereum are diagram heavy and don’t get into the meat and bones of how to access or work with that data. I’m going to avoid the diagrams and theoretical explanations, but you should sti...

Learning to Work With Ethereum Storage and State Data
If you’re completely new to SQL and Ethereum I recommend starting with my full beginners’ overview or breaking down an Ethereum transaction first. Feel free to support my work by buying a Data Landscape edition at the end of the article, or sending a tip to ilemi.eth! Most explanations of storage and state on Ethereum are diagram heavy and don’t get into the meat and bones of how to access or work with that data. I’m going to avoid the diagrams and theoretical explanations, but you should sti...
![Cover image for [2022] Guide to Web3 Data: Thinking, Tools, and Teams](https://img.paragraph.com/cdn-cgi/image/format=auto,width=3840,quality=85/https://storage.googleapis.com/papyrus_images/91aa0a3c103ae7ed1c719174973b8520c984fde583eb960915f4a6d9a04eb604.png)
[2022] Guide to Web3 Data: Thinking, Tools, and Teams
Welcome! I’m assuming you’re a data analyst who is new to web3, starting to build your web3 analytics team, or have just taken an interest in web3 data in general. Either way, you should already be loosely familiar with how APIs, databases, transformations, and models work in web2. For this inaugural guide, I’m going to try to keep things very concise and highlight my thoughts across these three pillars:Thinking: why an open data pipeline re-shapes how data work gets doneTools: an overview of...
![Cover image for [2022] Guide to Web3 Data: Thinking, Tools, and Teams](https://img.paragraph.com/cdn-cgi/image/format=auto,width=3840,quality=85/https://storage.googleapis.com/papyrus_images/91aa0a3c103ae7ed1c719174973b8520c984fde583eb960915f4a6d9a04eb604.png)
[2022] Guide to Web3 Data: Thinking, Tools, and Teams
Welcome! I’m assuming you’re a data analyst who is new to web3, starting to build your web3 analytics team, or have just taken an interest in web3 data in general. Either way, you should already be loosely familiar with how APIs, databases, transformations, and models work in web2. For this inaugural guide, I’m going to try to keep things very concise and highlight my thoughts across these three pillars:Thinking: why an open data pipeline re-shapes how data work gets doneTools: an overview of...