Kevin

@typedarray.eth

395 Following

262831 Followers

Kevin pfp

@typedarray.eth

New release! Ponder 0.6.0 improves observability, simplifies self hosting, and updates to the latest version of Viem. - New /ready endpoint - Terminal UI improvements (req/s, latest block) - Better ETA formula

2 replies

3 recasts

29 reactions

Kevin pfp

@typedarray.eth

Should Ponder replace SQLite with PGlite (pglite.dev) as the dev database? Pros: 1) Less magic/astonishment ("wait, what database am I using rn?") 2) Simpler schema definition API (currently stuck with the subset of stuff that both PG and SQLite support)

12 replies

4 recasts

42 reactions

Kevin pfp

@typedarray.eth

This is my favorite weird edge case in our codebase. If you manage to crash a Ponder app with this error, I'll give you $100. github.com/ponder-sh/ponder/blob/c19358158d3be13e0c8bab8450ba16ab3f71011d/packages/core/src/sync-store/postgres/store.ts#L222-L230

4 replies

6 recasts

34 reactions

Kevin pfp

@typedarray.eth

Savory cocktails were a mistake https://x.com/0xveer/status/1820918317705535670?s=46

4 replies

2 recasts

33 reactions

Kevin pfp

@typedarray.eth

You won't see it on GitHub, but it's a huge day here at Ponder HQ.

17 replies

8 recasts

85 reactions

Kevin pfp

@typedarray.eth

10 replies

11 recasts

76 reactions

Kevin pfp

@typedarray.eth

Do any EVM RPC providers support programmatic creation of API keys?

3 replies

3 recasts

41 reactions

Kevin pfp

@typedarray.eth

If you noticed "missing events" in your Ponder app recently, you may have been affected by this (rare) bug. Upgrade to 0.5.3 for the fix. It's more common on low-throughput chains where bloom filters are mostly empty. S/o @kjs and Mateus - was a team effort! https://x.com/devjoshstevens/status/1816567954521383339

2 replies

5 recasts

54 reactions

Kevin pfp

@typedarray.eth

TIL about `overscroll-behavior`, a CSS property that controls the behavior of the overscroll/rubberband effect. Setting it to "none" on the <body> element can prevent the user from scrolling "behind" the web page. https://developer.mozilla.org/en-US/docs/Web/CSS/overscroll-behavior-x

1 reply

9 recasts

112 reactions

Kevin pfp

@typedarray.eth

Love this set https://youtu.be/iPH2O2nID2w?feature=shared&t=410

2 replies

3 recasts

26 reactions

Kevin pfp

@typedarray.eth

Introducing API functions With today's 0.5.0 release, you can build custom API endpoints directly in your Ponder app. Use cases - Replace GraphQL with tRPC or REST - Build SQL queries with Drizzle - Merge onchain & offchain data

13 replies

24 recasts

138 reactions

Kevin pfp

@typedarray.eth

We're hiring backend, infrastructure, and web framework engineers at Ponder (ponder.sh). We have hundreds of production users, growing 40% per month. NYC required. Team is 3 people, all engineers. DM with interest or referrals.

3 replies

16 recasts

116 reactions

Kevin pfp

@typedarray.eth

tRPC is absurdly productive

9 replies

10 recasts

117 reactions

Kevin pfp

@typedarray.eth

ok I need RANK TO GO UP. I cant take this anymore. every day I am checking rank and its dipping. every hour, check wait time, bad wait time. I cant take this anymore, I have over invested, by a lot. it is what it is. but I need cohort to START ALREADY. can devs DO SOMETHING

2 replies

1 recast

8 reactions

Kevin pfp

@typedarray.eth

Claiming my /scoop profile with address: 0x973CFC9D37C21Eb42b366A464C9925639C45BCD0 let the scoop wars begin 🍦

5 replies

2 recasts

75 reactions

Kevin pfp

@typedarray.eth

Just shipped a *very exciting* experimental feature in the Ponder telegram

9 replies

21 recasts

187 reactions

Kevin pfp

@typedarray.eth

Just got the best DM ever.

27 replies

28 recasts

314 reactions

Kevin pfp

@typedarray.eth

48 replies

58 recasts

321 reactions

Kevin pfp

@typedarray.eth

Ponder is now 10-50x faster during historical indexing 0.4.37 introduces batched database writes & an in-memory cache for frequently accessed records Apps that use a remote database will be much faster

24 replies

33 recasts

306 reactions

Kevin pfp

@typedarray.eth

TIL postgres has multirange types and operators We currently store ranges in a table with `start` and `end` columns, and have implemented these set operations in app code Might be able to delete a bunch of code and tests 😈 Docs: https://www.postgresql.org/docs/current/rangetypes.html

6 replies

14 recasts

127 reactions