The Indexing CompanyIndexing Mirror.xyz
If you read content online you’ve probably at least heard of publishing services like Medium and Substack. These are centralized, web2 companies that make money with views; subscriptions, ads, etc. Thankfully, as we transition into the web3 space we are already seeing some promising alternatives. The largest of these web3 publishers is Mirror. The beauty of protocols like Mirror is that they don’t own any of the data. They still have a login, a clean text editor, and shareable links just like...
The Indexing CompanyDevcon VI and the State of EVM Data
By all measures, Devcon VI was a huge success. Over 6000 participants from around the world met in Bogota, Colombia to build, network, and celebrate together in the official Ethereum conference. This is coming about a month after The Merge in which Ethereum switched from Proof of Work (PoW) to Proof of Stake (PoS). That transition worked far better than any could have hoped and has lead to ETH even being deflationary at times 🔥https://ultrasound.money/So what’s next for Ethereum and its ecos...
The Indexing CompanyAccessing Data 3.0: Indexing 101
This is an entry in our long running series, “Accessing Data 3.0”, where we talk about the “whats” and the “hows” of working with data in web3. Enjoy! Remember libraries? The walls of books and the fearless librarians somehow always knowing exactly where everything is. Well, two things: 1) libraries still exist, 2) those libraries are each indexed. Librarians around the world categorize all of the books under their purview into what are known as a “library catalogs”. These catalogs serve as a...
Paving the road to Data 3.0 one index at a time
The Indexing CompanyIndexing Mirror.xyz
If you read content online you’ve probably at least heard of publishing services like Medium and Substack. These are centralized, web2 companies that make money with views; subscriptions, ads, etc. Thankfully, as we transition into the web3 space we are already seeing some promising alternatives. The largest of these web3 publishers is Mirror. The beauty of protocols like Mirror is that they don’t own any of the data. They still have a login, a clean text editor, and shareable links just like...
The Indexing CompanyDevcon VI and the State of EVM Data
By all measures, Devcon VI was a huge success. Over 6000 participants from around the world met in Bogota, Colombia to build, network, and celebrate together in the official Ethereum conference. This is coming about a month after The Merge in which Ethereum switched from Proof of Work (PoW) to Proof of Stake (PoS). That transition worked far better than any could have hoped and has lead to ETH even being deflationary at times 🔥https://ultrasound.money/So what’s next for Ethereum and its ecos...
The Indexing CompanyAccessing Data 3.0: Indexing 101
This is an entry in our long running series, “Accessing Data 3.0”, where we talk about the “whats” and the “hows” of working with data in web3. Enjoy! Remember libraries? The walls of books and the fearless librarians somehow always knowing exactly where everything is. Well, two things: 1) libraries still exist, 2) those libraries are each indexed. Librarians around the world categorize all of the books under their purview into what are known as a “library catalogs”. These catalogs serve as a...
Paving the road to Data 3.0 one index at a time
Subscribe to The Indexing Company
Subscribe to The Indexing Company
Share Dialog
Share Dialog
<100 subscribers
<100 subscribers
Farcaster, a Web3 social protocol, has seen a surge in user engagement since launching Frames. From 3,000 daily users in late January to nearly 370k users today, with daily "casts" jumping from 200,000 to 2.9 million. This impressive growth offers valuable insights into where social media is going.
Farcaster's architecture is a blend of on-chain and off-chain systems, which includes registry contracts deployed on the Ethereum network via Optimism. Messages are cast to a network of servers called 'Hubs', ensuring the reliability of user data. This hybrid architecture is spurring some innovative ideas like Frames. Frames allow developers to embed interactive experiences within Farcaster posts, known as Casts. There are fun and different frames being created, including one for Girl Scout cookies. This allows you to shop within the Frame and then checkout via Coinbase without ever leaving Warpcast.
Of course we had to create our own frame : )
We’re committed to the Farcaster ecosystem and are excited about its potential. We integrated Farcaster into our indexing pipelines, positioning it alongside prominent chains like Base, Syndicate, and Solana. We're proud to offer this dataset entirely free as a public good, fueled by our passion for easy and open access to data.
Our approach with this dataset has been to take a semi-opinionated stance on normalizing hub events into views that more easily work for products and analytics (e.g. "user_data" from Hubs maps to "profiles" in BigQuery).
To start, we have 5 tables available: casts, links, reactions, verifications, and profiles.
Currently, BigQuery is updated every hour with the latest snapshot of data. Depending on feedback, we'll likely try to make this truly real-time using some materialized views.
A huge shout out and thanks to @pinatacloud for their public hub support!
Looking where to start? Try seeing who the most active reply guys are.
If you have questions or other data needs, contact us!
Warpcast: Indexing Co - Brock - Stephen
Email: hello@indexing.co
Farcaster, a Web3 social protocol, has seen a surge in user engagement since launching Frames. From 3,000 daily users in late January to nearly 370k users today, with daily "casts" jumping from 200,000 to 2.9 million. This impressive growth offers valuable insights into where social media is going.
Farcaster's architecture is a blend of on-chain and off-chain systems, which includes registry contracts deployed on the Ethereum network via Optimism. Messages are cast to a network of servers called 'Hubs', ensuring the reliability of user data. This hybrid architecture is spurring some innovative ideas like Frames. Frames allow developers to embed interactive experiences within Farcaster posts, known as Casts. There are fun and different frames being created, including one for Girl Scout cookies. This allows you to shop within the Frame and then checkout via Coinbase without ever leaving Warpcast.
Of course we had to create our own frame : )
We’re committed to the Farcaster ecosystem and are excited about its potential. We integrated Farcaster into our indexing pipelines, positioning it alongside prominent chains like Base, Syndicate, and Solana. We're proud to offer this dataset entirely free as a public good, fueled by our passion for easy and open access to data.
Our approach with this dataset has been to take a semi-opinionated stance on normalizing hub events into views that more easily work for products and analytics (e.g. "user_data" from Hubs maps to "profiles" in BigQuery).
To start, we have 5 tables available: casts, links, reactions, verifications, and profiles.
Currently, BigQuery is updated every hour with the latest snapshot of data. Depending on feedback, we'll likely try to make this truly real-time using some materialized views.
A huge shout out and thanks to @pinatacloud for their public hub support!
Looking where to start? Try seeing who the most active reply guys are.
If you have questions or other data needs, contact us!
Warpcast: Indexing Co - Brock - Stephen
Email: hello@indexing.co
No activity yet