Kevin pfp

Kevin

@typedarray.eth

358 Following
161894 Followers


Kevin pfp
Kevin
@typedarray.eth
New in Ponder: JSON columns Use p.json() for 1) Solidity structs 2) Storing raw log/trace/receipt objects alongside application data 3) Any schema-less KV data Include a custom TypeScript type to enjoy autocomplete + type checking across your app.
6 replies
8 recasts
40 reactions

Kevin pfp
Kevin
@typedarray.eth
Shipped: Call trace indexing This was a top requested feature from teams looking to migrate their subgraphs to Ponder. Why use call traces?
6 replies
5 recasts
52 reactions

Kevin pfp
Kevin
@typedarray.eth
POV: you work on tooling that's compatible with *any* EVM chain
7 replies
3 recasts
49 reactions

Kevin pfp
Kevin
@typedarray.eth
Ponder 0.4.16 introduces block indexing Block indexing is great for cron / scheduled tasks: - Read the latest price from an oracle contract every minute to build a price chart - Aggregate data every hour to update protocol-wide statistics
4 replies
5 recasts
40 reactions

Kevin pfp
Kevin
@typedarray.eth
Ponder 0.4.15 improves crash recovery behavior Before, if a fully indexed app crashed (often due to a short-lived RPC reliability issue) it would need to reindex from scratch Now, Ponder apps periodically checkpoint their indexing progress. After a crash, you can restart the app and it will pick up where it left off
5 replies
3 recasts
49 reactions

Kevin pfp
Kevin
@typedarray.eth
You wouldn’t last one hour in the asylum where they raised me
6 replies
2 recasts
44 reactions

Kevin pfp
Kevin
@typedarray.eth
In the next version of Ponder, error logs for SQL constraint violations are more human-friendly
1 reply
2 recasts
32 reactions

Kevin pfp
Kevin
@typedarray.eth
0.4.9 adds support for transaction receipts and speeds up historical indexing by ~50%, thanks to @kjs https://x.com/kyscott18/status/1782826942908997653
3 replies
2 recasts
32 reactions

Kevin pfp
Kevin
@typedarray.eth
TIL degen chain has a very short block time (currently 0.1s, average 0.4s). For what applications does such a fast block time offer tangible benefits over a 2s chain like Base?
5 replies
3 recasts
49 reactions

Kevin pfp
Kevin
@typedarray.eth
With today's release, Ponder runs on Windows via PowerShell and command prompt (cmd.exe). Huge thanks to Mateus (not on FC yet) who found the key bug! We’re also running the entire test suite on Windows runners in CI. PR: github.com/ponder-sh/ponder/pull/806
6 replies
3 recasts
33 reactions

Kevin pfp
Kevin
@typedarray.eth
Enums were a mistake
15 replies
0 recast
36 reactions

Kevin pfp
Kevin
@typedarray.eth
Pondows soon
6 replies
0 recast
9 reactions

Kevin pfp
Kevin
@typedarray.eth
It's never been easier to build and self-host a custom EVM indexer Docker, DigitalOcean, Railway, local - Ponder runs nearly anywhere, using web technologies you already know
7 replies
1 recast
35 reactions

Kevin pfp
Kevin
@typedarray.eth
Ponder 0.4.0 - Better direct SQL experience - Faster indexing for apps with >10 contracts - New terminal UI - Express -> Hono - Fixed annoying "there is a newer version of the record" bug Migration guide: ponder.sh/docs/migration-guide#040
5 replies
3 recasts
39 reactions

Kevin pfp
Kevin
@typedarray.eth
>100 open-source Ponder apps on GitHub as of today Underrated advantage of Ponder over closed-source providers or rolling your own indexer: You get dozens of high-quality example apps that you can fork, run locally, browse for best practices, etc github.com/ponder-sh/ponder/network/dependents
6 replies
3 recasts
51 reactions

Kevin pfp
Kevin
@typedarray.eth
This remains unsolved. I think it's impossible - if anyone wants to learn more about traces and double check my work, would gladly chat
4 replies
4 recasts
43 reactions

Kevin pfp
Kevin
@typedarray.eth
Fun `trace_` API problem: Write a function that accepts a single trace object and returns a uint256 representing its execution index within the transaction. The index doesn't need to be absolutely accurate, but when used as a sort key, it must accurately order _any_ subset of traces within one transaction.
3 replies
7 recasts
36 reactions

Kevin pfp
Kevin
@typedarray.eth
5 replies
0 recast
8 reactions

Kevin pfp
Kevin
@typedarray.eth
Ponder Ship Week, Day 3: Cached indexing Thanks to @kjs, Ponder now caches indexing progress across hot reloads and redeploys. If you restart a fully cached app with no code changes, it goes live in ~2 seconds. (1/6)
2 replies
0 recast
9 reactions

Kevin pfp
Kevin
@typedarray.eth
Ponder Ship Week, Day 2 New Viem Transports: `loadBalance` and `rateLimit`
3 replies
0 recast
16 reactions