479552
Erik⚡️

@ryk #479552

Zapper⚡️ /zapper | I write and orchestrate bits | Former CTO of Narcity Media | Proud owner of a brain cell
85 Follower 86 Following
crypto is fascinating
moar.

moar chains.
@base really gained a lot of daily users since the beginning of 2024 compared to other chains.

Data was pulled from Zapper's indexer.

First chart represents the total of daily transactions on Base. Second chart is the total number of unique signers, daily.
At that point Datadog should be my web browser's homepage
Surfacing things to interpret onchain is quite the challenge.

Zapper is traversing an ocean of transactions to pick only the ones for which we're not certain what happened, and sort them by most trending. This allows anyone to make the chain more readable, but also to have a bigger impact.

https://zapper.xyz/curate
Last Friday, we managed to add support for 3 additional chains. This morning, we added another chain in less than 2 hours, including replaying all transactions from genesis.

Focusing on infrastructure is a big investment, but pays off immensely if executed properly.

wen one-click to add network? soon, maybe?
Self-hosted OLAP more than doubled in size in a single month, mostly because of Polygon and BSC. Mind-blowing amount of activity on those two chains yet still able to render beautiful timelines.

Now with the biggest ones out of the way, supporting more chains will be a breeze (or a few clicks.)

Full steam ahead.
Maintaining a database of 100 billion rows can be quite intimidating. Especially when the insert rate is around 30 million rows per minute, or half a million per second.

Storing and querying the data is something, but moving it around is a whole different test of strength.

Half a million rows. Per second. /zapper
Smart routing is a fantastic concept.

For instance, when swapping in a USDC-ARB PancakeSwap V3 pool, to avoid slippage and keep pools balanced, it will swap across multiple different pools like USDC-USDT.

Zapper will show you exactly what pools were routed to when inspecting a transaction.
Most spam filters are inherently opinionated. There is no specific definition nor is there a definitive set of rules to detect it.

The blockchain is no different. Zapper's spam filter is set to a fairly tolerant setting yet will sometimes intercept as many as 18+ million events daily across chains.

Stay safe 💜
Indexing Ethereum transactions including all logs emitted + a couple layer-2 + Degen takes around 228.31 TiB of uncompressed data.

With the right tools, Zapper is able to sort through 15 billion rows in a fraction of a second.