Kevin

@typedarray.eth

386 Following

262918 Followers

Kevin pfp

@typedarray.eth

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

0 reply

0 recast

0 reaction

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

1 reply

5 recasts

47 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

11 recasts

119 reactions

Kevin pfp

@typedarray.eth

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

2 replies

5 recasts

28 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

8 replies

34 recasts

158 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

21 recasts

129 reactions

Kevin pfp

@typedarray.eth

tRPC is absurdly productive

11 replies

13 recasts

125 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

6 reactions

Kevin pfp

@typedarray.eth

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

4 replies

7 recasts

79 reactions

Kevin pfp

@typedarray.eth

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

11 replies

27 recasts

226 reactions

Kevin pfp

@typedarray.eth

Just got the best DM ever.

28 replies

33 recasts

352 reactions

Kevin pfp

@typedarray.eth

55 replies

68 recasts

379 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

34 replies

55 recasts

373 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

18 recasts

139 reactions

Kevin pfp

@typedarray.eth

Ponder 0.4.35 improves support for Foundry/Anvil With a few lines of code, you can integrate Ponder with any Foundry development workflow using `forge script` Build your indexer alongside your smart contracts, all on your local machine

10 replies

47 recasts

280 reactions

Kevin pfp

@typedarray.eth

Is the term "devnet" still commonly used to refer to Anvil, Hardhat Network, Ganache? Want to get the naming right for docs + public API decisions.

19 replies

29 recasts

193 reactions

Kevin pfp

@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.

3 replies

0 recast

16 reactions

Kevin pfp

@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?

2 replies

4 recasts

23 reactions

Kevin pfp

@typedarray.eth

POV: you work on tooling that's compatible with *any* EVM chain

1 reply

3 recasts

20 reactions

Kevin pfp

@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

3 replies

3 recasts

20 reactions