Erik⚡️ pfp

Erik⚡️

@ryk

86 Following
180 Followers


Erik⚡️ pfp
Erik⚡️
@ryk
crypto is fascinating
0 reply
0 recast
1 reaction

Erik⚡️ pfp
Erik⚡️
@ryk
moar. moar chains.
0 reply
0 recast
0 reaction

Erik⚡️ pfp
Erik⚡️
@ryk
@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.
1 reply
0 recast
8 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
At that point Datadog should be my web browser's homepage
0 reply
0 recast
0 reaction

Erik⚡️ pfp
Erik⚡️
@ryk
more.
0 reply
1 recast
4 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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
0 reply
1 recast
3 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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?
1 reply
0 recast
5 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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.
2 replies
1 recast
6 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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
1 reply
1 recast
19 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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.
0 reply
2 recasts
6 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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 💜
0 reply
0 recast
6 reactions

Erik⚡️ pfp
Erik⚡️
@ryk
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.
2 replies
1 recast
7 reactions