The Graph Builders Newsletter #14

gm web3 builders,

Welcome to The Graph Builders Newsletter #14 for February 2024! February was a great one for builders around the world! Let’s dive into all the news and feature-updates 🏗️

New Releases

Subgraph Timeseries + Aggregations Feature (Beta)

These are beta features that are currently deployed on the hosted service.

The exciting new timeseries and aggregations beta features in schema.graphql significantly enhances data handling within subgraphs and is currently available in beta on hosted service.

Why are these features exciting?

By allowing builders to define timeseries and aggregation entities in a subgraph’s schema, builders can programmatically perform computations over specified intervals, such as computing daily averages of transaction values. This automation streamlines data processing, and reduces query load, resulting in a better building experience.

For instance, consider a simplified schema for tracking daily average transaction values:

type Transaction @entity(timeseries: true) {
 id: ID!
 timestamp: BigInt!
 value: BigDecimal!
}

type DailyTransactionStats @aggregation(intervals: ["day"], source: "Transaction") {
 id: ID!
 timestamp: BigInt!
 averageValue: BigDecimal! @aggregate(fn: "avg", arg: "value")
}

This setup automatically calculates daily averages, enabling efficient and simplified data queries for analytics, thus enhancing the user experience by providing quick access to aggregated data insights.

The following aggregation functions are supported:

sum - Sum of all values

count - Number of values

min - Minimum value

max - Maximum value

first - First value

last - Last value

Want to see Timeseries + Aggregations in action? Check out this workshop with Simon Emanuel Schmid building with Timeseries + Aggregations on a recent episode of The Graph Builders Office Hours!

Read more about these beta features and contact [email protected] with any feedback.

Hackathon Highlights

The Graph’s Farcaster Frames Hackathon

Farcaster's Frames feature has sparked significant interest among web3 builders by enabling builders to create interactive posts, such as voting polls and direct NFT minting.

The Graph put out a bounty on building some projects and we are lucky enough to be inspired by their builds!

Read more about the Farcaster Frames + The Graph hackathon in this blog by Senior Developer Relations Manager Simon Emanuel Schmid.

Farcaster Frames Bounty Winners

🥇First Place: 3070 implemented an NFT browser inside a Frame. It queries the NFT subgraphs on Ethereum and Base.

3070’s project programmatically routes queries depending on the NFT type (Eth ERC 721/Eth1155 or Base721/Eth1155) to four existing subgraphs on The Graph Network.

Check out 3070’s project on Farcaster!

🥈Second Place: Hashir and Shiyas created a Frame that can look up the activity of an Ethereum address on POAP, ENS, Uniswap, NFTs and Lens.

This project queries these various subgraphs programmatically using these queries.

Try it out andread the source code.

🥉Third Place: limone.eth built a Frame that can vote on onchain proposals.

A Safe would then execute if the quorum is met. limone.eth created a custom subgraph for their project that indexed the onchain votes.

Check it out on Warpcast and view the source code and subgraph code.

Learning Corner

The Graph Brunch and Learn @ ETHGlobal London - March 15th

Want to learn how to build subgraphs with one-on-one instruction and workshops?

🏛️ EthGlobal London

📅 Friday, March 15th

⏲️9:00 AM - 1:00 PM GMT

At this event you will learn about the following topics...

Data Indexing and Subgraph Development
GraphQL Querying in your Frontend
Full Stack dapp Development with Scaffold-ETH and The Graph

About the speakers:

Simon Emanuel Schmid is the Senior Developer Relations Manager at Edge & Node, working on The Graph protocol
Kevin Jones is a Developer Relations Engineer at Edge & Node and also core contributor in the Buidl Guidl, supporting Scaffold-ETH

The Graph Builders Office Hours - Thursdays 5pm UTC

Jump into The Graph Builders Office Hours every Thursday at 5pm UTC hosted by Edge & Node Developer Relations Engineer Kevin Jones in The Graph Discord.

Each session includes live workshops and Q&A discussions with developers who are building in The Graph Ecosystem.

Start building fast with all 24(!) The Graph Builders Office Hours workshops!

Here are a few recent episodes:

Better understand Substream Composability
Dive into building with Token Name Service
Discover and build no-code dashboards with Dapplooker
Build better with Brian AI
Jump into building with Phala Network
Hackathon winner ‘Nazar’ built their project on Substreams
Explore Graph Client’s subgraph composition features
See how Clickhouse can be used as a Substreams sink

Ecosystem Announcements

TODO: Upgrade from Hosted Service to Network Endpoints

More and more subgraphs are upgraded to The Graph Network and their hosted service equivalents stop receiving maintenance by their developers. We can already update our endpoints to use The Graph Network subgraphs:

If any builders are using the Hosted Service version of Uniswap v3, the endpoint will eventually deprecate in favor of The Graph Network version of Uniswap V3.

This means builders will soon have to change the endpoints used in their dapp from hosted service subgraph endpoints to The Graph Network subgraph endpoints.

If no The Graph Network version of a hosted subgraph is in existence, please reach out to the team that owns the hosted service version of the subgraph and point them to these docs to upgrade their subgraph to The Graph Network.

This announcement will go out in every Builders Newsletter to ensure clarity during the sunsetting of the Hosted Service. If any builders see X’s (Tweets) of these reminders, please retweet, as it helps all builders in The Graph ecosystem!

Blast and Linea Mainnets and Testnets Now Supported

@Blast-L2 and @LineaBuild devs can now build subgraphs in Subgraph Studio!

Get started building on these new chains 🔥

Goerli Deprecation and Sepolia Support

Goerli (Ethereum testnet) isapproaching the end of the road. Accordingly, The Graph will be ending support for Goerli subgraphs across the Subgraph Studio and Hosted Service.

It’s recommended that developers migrate to the Sepolia testnet which is supported by The Graph.

The Graph will prevent new Goerli subgraph deployments on April 1, 2024, existing Goerli subgraphs will cease indexing on April 7, 2024 and we will remove all Goerli subgraphs on April 21, 2024.

Developer Survey

Building The Graph Network is a collaborative effort, and the core devs would love to hear your feedback!

Thanks for reading and happy hacking! 💌

Marcus Rein

Developer Relations and Success

Edge & Node, working on The Graph

About The Graph

The Graph is the source of data and information for the decentralized internet. As the original decentralized data marketplace that introduced and standardized subgraphs, The Graph has become web3’s method of indexing and accessing blockchain data. Since its launch in 2018, tens of thousands of developers have built subgraphs for dapps across 45+ blockchains - including Ethereum, Arbitrum, Optimism, Base, Polygon, Celo, Fantom, Gnosis, and Avalanche.

As demand for data in web3 continues to grow, The Graph enters a New Era with a more expansive vision including new data services and query languages, ensuring the decentralized protocol can serve any use case - now and into the future.

Discover more about how The Graph is shaping the future of decentralized physical infrastructure networks (DePIN) and stay connected with the community. Follow The Graph on X, LinkedIn, Instagram, Facebook, Reddit, and Medium. Join the community on The Graph’s Telegram, join technical discussions on The Graph’s Discord.

The Graph Foundation oversees The Graph Network. The Graph Foundation is overseen by the Technical Council. Edge & Node, StreamingFast, Semiotic Labs, The Guild, Messari, GraphOps, Pinax and Geo are eight of the many organizations within The Graph ecosystem.

Category: Graph Builders
Author: Marcus Rein
Published: March 8, 2024