The Graph Builders Newsletter - 15

🏗️ Subscribe to The Graph Builders Newsletter 🏗️

gm web3 builders,

Welcome to The Graph Builders Newsletter #15  for March 2024! 🏗️Sunray is completed, new features are released, and new building opportunities are here!

New Releases

Sunray Completed - Three New Features Unlocked!

The three-phase Sunrise plan has completed its first major milestone - Sunray! Let’s check out three new features subgraph developers can start using today!

Upgrade Hosted Subgraphs to The Graph Network For Free

Hosted subgraphs now have a quick and easy path to The Graph Network! To learn how to upgrade, read the docs and watch this video, then let's move our subgraphs from the hosted service to The Graph Network 🔥.

Query The Graph Network For Free

With the new Free Tier, subgraph developers have 100k free queries per month to use however we choose! To learn more about querying The Graph Network for free, watch this video and start querying The Graph Network.

Pay for Queries Using A Credit Card

We can now pay for our queries with a credit card or GRT. To learn more about these billing options, read the documents and watch this video.

Timeseries + Aggregations is live in Subgraph Studio and is Rolling Out Soon to The Graph Network

The new timeseries and aggregations features significantly enhances data handling within subgraphs. It is currently available in Subgraph Studio and will soon be available on The Graph Network!

So, why are these features exciting? Feel free to jump into the readme or continue reading for an example use-case!

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 on a recent episode of The Graph Builders Office Hours!

Hackathon Highlights

Scroll VORTEx 01 Hackathon - April 24th-29th

With a prize pool of $85,000 USD, the Scroll VORTEx 01 online hackathon is set to get builders motivated to build!

The Graph is offering bounties for Best New Subgraph and Best Use of Existing Subgraph. If you are a subgraph developer reading this newsletter, you already have a leg-up on the competition—check it out and get building!

EthDenver 2024 Hackathon Winners

EthDenver 2024 had some serious builders! Check out the winners and get inspired!

Best New Subgraph

🥇POA (Perpetual Organization Architect): This AI tool assists in creating Perpetual Organizations by guiding users through defining roles, governance, and voting systems and then deploying a customized organization based on their choices.

🥈VennDAO: This marketplace is a way for vendors to offer products and services entirely on-chain to web3 projects, facilitating secure and encrypted order placements and fulfillment through smart contracts.

Best Use of Existing Subgraphs

🥇ReferFi: This simple, innovative platform enables decentralized exchanges (DEXs) to grow their user base without coding by offering a referral program where users can earn from trades made by their invitees, who in turn receive discounts on service fees.

🥈Mr Dolphin's Attestations Bazaar: An onchain marketplace for permissionless tokenization of real-world assets through a process of adding and valuing attestations, leveraging a real-time social graph for trust assessment, aimed at increasing accessibility and reducing costs.

Best New or Best Use of Substreams

🥇Data Detector: This project removed the need for a Substream to make an RPC call to get data through innovative inclusion of an EVM node inside of the Substream.

Learning Corner

The Graph Builders Office Hours - Thursdays 4pm UTC

Jump into The Graph Builders Office Hours every Thursday at 4pm UTC hosted by Edge & Node Developer Relations Engineer Marcus Rein 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 Updates

Blast, Linea, and Astar Mainnets and Testnets Now Supported

@LineaBuild @Blast_L2, and @Astar_Network devs can now build subgraphs in Subgraph Studio!

Get started building with subgraphs on these new chains today 🔥

Goerli Deprecation and Sepolia Support

Goerli (Ethereum testnet) is approaching 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.

TODO: Upgrade from Hosted Service to Network Endpoints

Now is the time to upgrade your hosted service subgraph to the network. It's easy to do and more and more hosted service subgraphs are doing so on a daily basis.

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 you're using a hosted service subgraph that does not exist on The Graph Network, reach out to the team that owns the hosted service subgraph and refer them to the upgrade documentation.

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!

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 90+ blockchains - including  Ethereum, Solana, 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, Farcaster 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, Messari, GraphOps, Pinax and Geo are seven of the many organizations within The Graph ecosystem.