https://polkadot.subsquare.io/referenda/1420
Proponent: Subsquid Lab Official - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Beneficiary: Subsquid Lab Official - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Contact Details: Subsquid Labs GmbH 6300 Zug, Switzerland [email protected]
Short description: Ongoing development and maintenance costs for public SQD Archives
Archive raw data: Archive Infrastructure Metrics - April, May, June
Requested DOT: 58 852.91 DOT = $264,838.09
Previous proposals: https://polkadot.polkassembly.io/referenda/1193
Motivation
A) Archives
Archives are an important piece of Polkadot and Kusama data infrastructure provided by SQD (formerly Subsquid). They provide access to on-chain data for public chains in the Polkadot ecosystem. They are being used as a data source for Squids and for efficient data exploration and ad-hoc queries.
The Archives, as performant data sources of historical on-chain data, are critical to the operation of backend APIs run by major projects in the Polkadot ecosystem (the list is not exhaustive):
- Tanssi Network
- Talisman Wallet
- Polimec
- Polkassembly
- Apillon
- Hydration
- Giant Squid API (maintained by LimeChain, see details below)
- SubWallet
- FiDi
- KodaDot
- RMRK
- ChainSafe (in particular the Multix multi-sig, as well as other projects)
- Phala Network
- Stellaswap
- Polkascan
Since the first quarter of 2024, SQD has transitioned to a paid model for supporting parachains. However, public chains continue to be available for free use. Throughout the second quarter of 2024, we provided a free public data indexing service for Substrate blockchains, allowing interested parties to access indexed data on Substrate Events, Extrinsics, Storage Items, and EVM logs. Below is a list of the public chains we currently support at no cost:
- polkadot
- kusama
- asset-hub-kusama
- asset-hub-polkadot
- bridge-hub-polkadot
- collectives-polkadot
- rococo
- westend-collectives
As of Q1 2024, SQD has sunsetted support for Giant Squid, with LimeChain taking over its further development, detailed in the proposal at https://polkadot.polkassembly.io/treasury/758
B) Contribution
During Q2’2024, we made significant contributions to support ink! v5 and address actual use cases that were highly demanded by the community:
- We provided support for manual finality confirmation in the subsquid/substrate-processor for cases where a chain does not expose finalization details.
Achievements
Increase in Archival Data Demand and Infrastructure Scaling.
During Q2, archival data demand increased approximately ~28,1 times, from 110,6 GiB to 3.095,17 GiB. We addressed the increasing demand for archival data by enhancing our infrastructure's throughput and redundancy through deploying archives to OVHCloud in addition to GCE, while also empowering our maintenance and engineering teams to support the expanded infrastructure effectively.
Mainnet Launch and Decentralization of the SQD Network Enhancing the Polkadot Ecosystem:
In Q2’24, we successfully launched the SQD mainnet, a pivotal advancement that significantly strengthens the Polkadot ecosystem's decentralization and resilience. By the end of the quarter, the SQD network comprised 726 Worker Nodes online, securely storing 529 TB of data and serving ~ 9 TB of data a day. This decentralized infrastructure enhances data processing and storage capabilities, ensuring higher security, fault tolerance, and scalability for the Polkadot network.
Advancements in Squid SDK Empowering Polkadot Developers:
Enabled manual configuration of finality confirmation for subsquid/substrate-processor in cases where a parachain does not expose finalization information.
Cloud API Upgrades
We upgraded our Cloud API to offer enhanced capabilities that support the growth of the Polkadot ecosystem:
Multiple API Tokens Support: Allows for more granular access control and better management of development workflows.
Hasura Integration: Enables more efficient and powerful data querying and manipulation, facilitating the creation of responsive and data-driven applications.
Chain ID and SS58 Prefix support: Enhanced network identification and management for seamless interoperability across Polkadot parachains.
Statistics and data
Over the course of Q2 2024:
- Served a total of 3,505,904,767,634 (~3.19 TiB) of data from the substrate based archives in Q2 2024
- Served 301 069 archive requests from substrate based archives in Q2 2024
- The highest daily total data transfer recorded for Substrate was 161.646 GiB within a single 24-hour period.
Costing
This proposal encompasses the combined costs for running Archives for Polkadot, Kusama, and other public chains, along with the development contributions, amounting to a total of 58 852.91 DOT
Raw data for Archives can be seen here.
The proposal is submitted towards the Polkadot treasury. Here is a summary of the running costs for Archives, in a tabular format:
Contribution costs:
