- Referenda/
- Medium Spender/
- #1668/
SQD (fka Subsquid) - Public Data Indexing Infrastructure for Polkadot and Kusama (Q4 2024)
Rejected
Content
AI Summary
Translations
Summary
Proponent: Subsquid Lab Official - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Beneficiary: Subsquid Lab Official - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Contact Details:
Subsquid Labs GmbH
6300 Zug, Switzerland
Short description: Ongoing development and maintenance costs for public SQD Archives, providing critical data infrastructure for Polkadot and Kusuma and other public Substrate-based chains in Q4 2024.
Archive raw data: Archive Infrastructure metrics - October, November, December
Requested amount: $308,704 USDC
Previous proposals: https://polkadot.polkassembly.io/referenda/1526
Motivation
A) Archives
SQD Archives are a vital component of the Polkadot and Kusama ecosystem’s data infrastructure, offering scalable access to historical on-chain data for public Substrate-based chains. These archives serve as performant data pipelines for major dApps, APIs, and developer tools, supporting critical ecosystem projects such as:
- 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
By providing free indexing services for the following public chains, SQD lowers barriers for developers and projects building on Substrate, fostering innovation and adoption:
- polkadot
- kusama
- asset-hub-kusama
- asset-hub-polkadot
- bridge-hub-polkadot
- collectives-polkadot
- Westend
Despite transitioning to a fee-based model for private data services to ensure sustainability, SQD remains committed to covering infrastructure costs for public archives, ensuring open access to indexed Substrate Events, Extrinsics, Storage Items, and EVM logs. This commitment aligns with Polkadot’s vision of a decentralized, accessible ecosystem.
B) Contribution
During Q4’2024, we made significant contributions to the Polkadot ecosystem:
- Infrastructure Scaling: Expanding archive capacity to meet growing data demand.
- Squid SDK Enhancements: Introducing advanced indexing features, including support for new Substrate pallets and improved error-handling mechanisms.
- Decentralized Network Growth: Increasing SQD Worker Node participation to enhance network resilience.
Achievements
Growth in Archival Data Demand, Network Expansion and Further Decentralization
In Q4 2024, demand for archival data grew steadily, rising from 11.35 TiB to 11.68 TiB. At the same time, the number of active Worker Nodes in the SQD network increased from 1,139 in October to 1,600 by the end of December—a 40.47% increase. This expansion strengthens the SQD network’s infrastructure, contributing to greater decentralization and resilience across the Polkadot ecosystem.
By the end of 2024, the SQD network had scaled to approximately 1,600 active Worker Nodes, securely storing around 900 TB of data and serving roughly 11 TB daily. This robust, decentralized infrastructure significantly enhances data processing and storage capabilities, delivering improved security, fault tolerance, and scalability for the Polkadot network.
Squid SDK improvements empowering Polkadot Developers:
- Additional unique support for Revive pallet: Enabling the tracking of contracts deployed to the PolkaVM.
- Indexing efficiency upgrades: Implementation of a novel mechanism to skip and log problematic blocks-those containing invalid or non-decodable data on Substrate based chains, ensuring uninterrupted indexing and improved resilience of the data pipeline.
Statistics and data
Over the course of Q4 2024:
- Served a total of 11,668,177,888,249 (~10.06 TiB) of data from substrate based chains.
- Served 2,336,249 archive requests from substrate based archives.
- The highest daily total data transfer recorded for Substrate was 382.57 GiB within a single 24-hour period (2024-10-05).
Cost Breakdown
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 $308,704 USDC Raw data 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:
| Service | Cost | VAT 8.1% | Subtotal |
|---|---|---|---|
| Compute Engine (GCE) | $92,630.90 | $100,134.00 | $100,134.00 |
| OVHCloud | $28,419.03 | $30,720.97 | $30,720.97 |
| Networking | $2,963.02 | $3,203.02 | $3,203.02 |
| Kubernetes Engine (GKE) | $436.23 | $471.56 | $471.56 |
| Cloud Storage (GCS) | $63.21 | $68.33 | $68.33 |
| Cloud SQL | $396.38 | $428.49 | $428.49 |
| Cloud DNS | $18.01 | $19.47 | $19.47 |
| Cloud Logging | $13,506.84 | $14,600.89 | $14,600.89 |
| Cloud Key Management Service (KMS) | $2.99 | $3.23 | $3.23 |
| Artifact Registry | $336.01 | $363.23 | $363.23 |
| Engineers & Maintenance* | $144,000.00 | $155,664.00 | $155,664.00 |
| Total | $305,677.20 |
Contribution costs:
| Service | Cost / h | Quantity | VAT 8.1% | Subtotal |
|---|---|---|---|---|
| Revive pallet support | $100.00 | 16.00 | $1,729.60 | $1,729.60 |
| Indexing efficiency upgrades | $100.00 | 6.00 | $648.60 | $648.60 |
| Product management | $100.00 | 3.00 | $324.30 | $324.30 |
| Project management | $100.00 | 3.00 | $324.30 | $324.30 |
| Total | $3,026.80 |
- Who: Subsquid Lab
- What: Helps Polkadot and Kusama with data storage
- Why: Supports important apps and tools
- Growth: More data and workers in Q4 2024
- Improvements: Better indexing and new features
- Cost: $308,704 USDC for services and work
- Data Served: Over 11 TB for Polkadot chains
- Workers: 1,600 nodes storing 900 TB
Source
Summary
Proponent: Subsquid Lab Official - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Beneficiary: Subsquid Lab Official - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Contact Details:
Subsquid Labs GmbH
6300 Zug, Switzerland
Short description: Ongoing development and maintenance costs for public SQD Archives, providing critical data infrastructure for Polkadot and Kusuma and other public Substrate-based chains in Q4 2024.
Archive raw data: Archive Infrastructure metrics - October, November, December
Requested amount: $308,704 USDC
Previous proposals: https://polkadot.polkassembly.io/referenda/1526
Motivation
A) Archives
SQD Archives are a vital component of the Polkadot and Kusama ecosystem’s data infrastructure, offering scalable access to historical on-chain data for public Substrate-based chains. These archives serve as performant data pipelines for major dApps, APIs, and developer tools, supporting critical ecosystem projects such as:
- 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
By providing free indexing services for the following public chains, SQD lowers barriers for developers and projects building on Substrate, fostering innovation and adoption:
- polkadot
- kusama
- asset-hub-kusama
- asset-hub-polkadot
- bridge-hub-polkadot
- collectives-polkadot
- Westend
Despite transitioning to a fee-based model for private data services to ensure sustainability, SQD remains committed to covering infrastructure costs for public archives, ensuring open access to indexed Substrate Events, Extrinsics, Storage Items, and EVM logs. This commitment aligns with Polkadot’s vision of a decentralized, accessible ecosystem.
B) Contribution
During Q4’2024, we made significant contributions to the Polkadot ecosystem:
- Infrastructure Scaling: Expanding archive capacity to meet growing data demand.
- Squid SDK Enhancements: Introducing advanced indexing features, including support for new Substrate pallets and improved error-handling mechanisms.
- Decentralized Network Growth: Increasing SQD Worker Node participation to enhance network resilience.
Achievements
Growth in Archival Data Demand, Network Expansion and Further Decentralization
In Q4 2024, demand for archival data grew steadily, rising from 11.35 TiB to 11.68 TiB. At the same time, the number of active Worker Nodes in the SQD network increased from 1,139 in October to 1,600 by the end of December—a 40.47% increase. This expansion strengthens the SQD network’s infrastructure, contributing to greater decentralization and resilience across the Polkadot ecosystem.
By the end of 2024, the SQD network had scaled to approximately 1,600 active Worker Nodes, securely storing around 900 TB of data and serving roughly 11 TB daily. This robust, decentralized infrastructure significantly enhances data processing and storage capabilities, delivering improved security, fault tolerance, and scalability for the Polkadot network.
Squid SDK improvements empowering Polkadot Developers:
- Additional unique support for Revive pallet: Enabling the tracking of contracts deployed to the PolkaVM.
- Indexing efficiency upgrades: Implementation of a novel mechanism to skip and log problematic blocks-those containing invalid or non-decodable data on Substrate based chains, ensuring uninterrupted indexing and improved resilience of the data pipeline.
Statistics and data
Over the course of Q4 2024:
- Served a total of 11,668,177,888,249 (~10.06 TiB) of data from substrate based chains.
- Served 2,336,249 archive requests from substrate based archives.
- The highest daily total data transfer recorded for Substrate was 382.57 GiB within a single 24-hour period (2024-10-05).
Cost Breakdown
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 $308,704 USDC Raw data 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:
| Service | Cost | VAT 8.1% | Subtotal |
|---|---|---|---|
| Compute Engine (GCE) | $92,630.90 | $100,134.00 | $100,134.00 |
| OVHCloud | $28,419.03 | $30,720.97 | $30,720.97 |
| Networking | $2,963.02 | $3,203.02 | $3,203.02 |
| Kubernetes Engine (GKE) | $436.23 | $471.56 | $471.56 |
| Cloud Storage (GCS) | $63.21 | $68.33 | $68.33 |
| Cloud SQL | $396.38 | $428.49 | $428.49 |
| Cloud DNS | $18.01 | $19.47 | $19.47 |
| Cloud Logging | $13,506.84 | $14,600.89 | $14,600.89 |
| Cloud Key Management Service (KMS) | $2.99 | $3.23 | $3.23 |
| Artifact Registry | $336.01 | $363.23 | $363.23 |
| Engineers & Maintenance* | $144,000.00 | $155,664.00 | $155,664.00 |
| Total | $305,677.20 |
Contribution costs:
| Service | Cost / h | Quantity | VAT 8.1% | Subtotal |
|---|---|---|---|---|
| Revive pallet support | $100.00 | 16.00 | $1,729.60 | $1,729.60 |
| Indexing efficiency upgrades | $100.00 | 6.00 | $648.60 | $648.60 |
| Product management | $100.00 | 3.00 | $324.30 | $324.30 |
| Project management | $100.00 | 3.00 | $324.30 | $324.30 |
| Total | $3,026.80 |
Request
≈308.7KUSDC
Status
Decision28d
Confirmation
4dAttempts
0
Tally
16%Aye
50.0%Threshold
84%Nay
Aye
≈7.46MDOT
Nay
≈39.15MDOT
- 0.00%
- 0.0%
Threshold
- 0.0%
Support
0.09%≈1.4MDOT
Issuance
≈1.59BDOT
Votes
Nested
Flattened
Actions
Check how referenda works here.
Call
Metadata
Timeline4
Votes Bubble
Curves
Statistics
Timeline
Comments
Request
≈308.7KUSDC
Status
Decision28d
Confirmation
4dAttempts
0
Tally
16%Aye
50.0%Threshold
84%Nay
Aye
≈7.46MDOT
Nay
≈39.15MDOT
- 0.00%
- 0.0%
Threshold
- 0.0%
Support
0.09%≈1.4MDOT
Issuance
≈1.59BDOT
Votes
Nested
Flattened
Actions
Check how referenda works here.