Kevin

@typedarray.eth

460 Following

185430 Followers

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

12 recasts

109 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

42 reactions

Kevin pfp

@typedarray.eth

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

7 replies

3 recasts

45 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

3 recasts

34 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

1 recast

14 reactions

Kevin pfp

@typedarray.eth

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

4 replies

10 recasts

30 reactions

Kevin pfp

@typedarray.eth

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

5 replies

10 recasts

46 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

58 reactions

Kevin pfp

@typedarray.eth

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

2 replies

6 recasts

32 reactions

Kevin pfp

@typedarray.eth

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

3 replies

5 recasts

37 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

3 recasts

61 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

39 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

3 recasts

25 reactions

Kevin pfp

@typedarray.eth

NY halal cart-style chicken over rice

2 replies

8 recasts

65 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

53 recasts

290 reactions

Kevin pfp

@typedarray.eth

2 replies

1 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

Kevin pfp

@typedarray.eth

Two of the top 20 built with ponder, possibly more

2 replies

3 recasts

39 reactions