Kevin

@typedarray.eth

462 Following

158179 Followers

Kevin pfp

@typedarray.eth

Introducing Marble. Marble is a platform for offchain software, built by the team behind Ponder. We're making it radically easier to build fast & reliable backend systems for crypto apps.

26 replies

87 recasts

493 reactions

Kevin pfp

@typedarray.eth

Created a new Ponder chat including full history from the old one - come say hi! https://t.me/pondersh

8 replies

15 recasts

85 reactions

Kevin pfp

@typedarray.eth

Anyone have experience getting a (legitimate) Telegram group unbanned? The Ponder chat (support, feature requests, etc for an open-source tool) got banned last night. No idea why. We have 600+ members, it's a key support tool for us - appreciate any leads immensely.

5 replies

12 recasts

40 reactions

Kevin pfp

@typedarray.eth

Just finished the first page of Ponder's new docs website

7 replies

1 recast

38 reactions

Kevin pfp

@typedarray.eth

Ponder 0.10 This release speeds up large factories and contract reads, adds a new `event.id` property, and fixes several reliability issues →

1 reply

4 recasts

24 reactions

Kevin pfp

@typedarray.eth

I find the Prometheus data model intuitive (counter gauge histogram + labels), but the PromQL side of things (instant vs range vectors, series, etc) has never clicked. Even on this cheat sheet, the return type / shape of each statement is not obvious to me. Feels strictly worse than SQL - what am I missing? Skill issue? https://promlabs.com/promql-cheat-sheet/

1 reply

0 recast

16 reactions

Kevin pfp

@typedarray.eth

Is anyone using Tailwind v4.0 ? Required browser versions seem rather recent. https://tailwindcss.com/docs/compatibility

4 replies

5 recasts

29 reactions

Kevin pfp

@typedarray.eth

The TypeScript team is rewriting the compiler in Go. Incredible news. https://x.com/typescript/status/1899469817863888958

5 replies

5 recasts

33 reactions

Kevin pfp

@typedarray.eth

If you choose a chain ID greater than Number.MAX_SAFE_INTEGER for your chain, call me. There's something I'd like to say. Best not in writing

4 replies

7 recasts

42 reactions

Kevin pfp

@typedarray.eth

https://x.com/typedarray/status/1893028129221784058

2 replies

2 recasts

14 reactions

Kevin pfp

@typedarray.eth

Use this one WEIRD trick to differentiate ANY shadcn/ui slop website Designers hate it!

3 replies

3 recasts

28 reactions

Kevin pfp

@typedarray.eth

Going all-in on Postgres was the single best decision we made in 2024. Much simpler, with no regression to the quickstart / local dev experience (thanks to PGlite). Obvious in retrospect.

6 replies

2 recasts

49 reactions

Kevin pfp

@typedarray.eth

Goal: By the end of 2025, even the largest Ponder app backfills will be fast enough to run in CI. Seconds or minutes, not hours or days. It should feel like a build or reload, not a "backfill".

4 replies

3 recasts

34 reactions

Kevin pfp

@typedarray.eth

Ponder 0.9.3 adds a new event ordering strategy designed for low-latency apps that index 10+ chains. The current ordering strategy is “omnichain” - events across all chains share a single queue, with blocks ordered by (block timestamp, chain ID, block number).

2 replies

2 recasts

23 reactions

Kevin pfp

@typedarray.eth

NY halal cart-style chicken over rice

2 replies

7 recasts

47 reactions

Kevin pfp

@typedarray.eth

Introducing Ponder 0.9 We built a SQL-based alternative to GraphQL, with live query support and a TanStack Query integration. Apps & websites that use Ponder for indexing are about to feel much faster →

21 replies

54 recasts

228 reactions

Kevin pfp

@typedarray.eth

2 replies

0 recast

39 reactions

Kevin pfp

@typedarray.eth

Did Etherscan remove their public/unauthenticated tier for API requests? Until recently, you could make unauthenticated requests for verified contract ABIs, contract deployment transactions, etc with a restrictive rate limit (1 req / 5 second). Now seeing consistent "Missing/Invalid API Key" errors.

4 replies

1 recast

16 reactions

Kevin pfp

@typedarray.eth

Quick PG debugging story. And a great blog post about the Postgres null byte situation. Seems to be a common rough edge. https://www.commandprompt.com/blog/null-characters-workarounds-arent-good-enough/ https://warpcast.com/typedarray.eth/0x761b14a8

0 reply

0 recast

15 reactions

Kevin pfp

@typedarray.eth

Fun debugging rabbit hole from this week. Last week, a few Ponder users opened issues for an "invalid byte sequence for encoding "UTF8": 0x00" error. Most software ignores or removes null characters (\0, \x00, or \u0000), but the Postgres TEXT data type rejects them with that error. We reproduced the issue with an ENS NameRegistered event log from 2022 (s/o @greg). Turns out, some EVM event logs contain null characters within decoded `string` parameter values. Now, the framework removes null characters from all decoded ABI parameters before passing them to userland. We could have instead fixed this on the PG driver/Drizzle side, but it seemed more fragile (are we wrong?). We're not certain why this only appeared recently - we haven't changed any relevant codepaths in recent releases. My best guess is that Viem used to remove them but stopped. Viem is a peer dep, so the version can change independently from Ponder's version. PR: https://github.com/ponder-sh/ponder/pull/1414

1 reply

5 recasts

26 reactions