Ponder
/ponder-sh226
An open-source backend framework for crypto apps
Created a new Ponder chat including full history from the old one - come say hi!
https://t.me/pondersh
https://t.me/pondersh
651
Kevin
@typedarray.eth·15:54 28/03/2025
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.
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.
Ponder (new)
Feedback, ideas, bug reports, and content relevant to Ponder
t.me
wake up, check ponder, eat, ponder some more
rinse and repeat
rinse and repeat
420493
Melanin 💭💜
@0xmelanin·18:57 12/04/2025
wake up, check ponder, eat, ponder some more
rinse and repeat
rinse and repeat
💭 Check out this prediction. What do you think? I really like this ponder
💭 Check out this prediction
Honestly I think everyone knew harry potter would win this one
Honestly I think everyone knew harry potter would win this one
Just finished the first page of Ponder's new docs website
Are there any examples of developers building an SDK* with ponder for a specific project (eg set of contracts) that other developers can easily drop into their own ponder indexer?
* I don’t know the right terminology here… module? plugin?
* I don’t know the right terminology here… module? plugin?
Ponder 0.10
This release speeds up large factories and contract reads, adds a new `event.id` property, and fixes several reliability issues →
This release speeds up large factories and contract reads, adds a new `event.id` property, and fixes several reliability issues →
Is Ponder a good starting point to build a Frame?
I've recently deployed a few Ponder installations on Railway, and thought that I could make a template so that it's easier for others:
https://railway.com/template/ma-2Wo
I'm keen to know about any requests. Some ideas I've had:
- Another template with a monorepo that includes a vite frontend
- Integrating contract indexing into this existing template, as a quickstart
https://railway.com/template/ma-2Wo
I'm keen to know about any requests. Some ideas I've had:
- Another template with a monorepo that includes a vite frontend
- Integrating contract indexing into this existing template, as a quickstart
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".
It should feel like a build or reload, not a "backfill".
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).
The current ordering strategy is “omnichain” - events across all chains share a single queue, with blocks ordered by (block timestamp, chain ID, block number).
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 →
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 →
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
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
Two of the top 20 built with ponder, possibly more
602
Jason Goldberg
@betashop.eth·20:55 30/12/2024
these apps had the highest daily average # of transactions the past 7 days on Base
we're bringing the world onchain in 2025
we're bringing the world onchain in 2025
Introducing Ponder 0.8
Native transfer indexing, `ponder` NPM package, support for 16 new Viem actions, and a simpler pattern for Direct SQL →
Native transfer indexing, `ponder` NPM package, support for 16 new Viem actions, and a simpler pattern for Direct SQL →
Built with ponder - great execution of a data-intensive, realtime EVM app
874938
Goose Run 🪿🪿🪿
@goosedotrun·22:40 09/12/2024
The Wait is Over: @GooseDotRun is live on @base🪿
Not just another launchpad—it’s a #MemeFi revolution with:
🔹Fair launch liquidity options for creators
🔹Native borrowing against memecoins
🔹Leaderboards & more
🔹ve(3,3) voting
🥚Hatch & trade memecoins on: goose.run
Not just another launchpad—it’s a #MemeFi revolution with:
🔹Fair launch liquidity options for creators
🔹Native borrowing against memecoins
🔹Leaderboards & more
🔹ve(3,3) voting
🥚Hatch & trade memecoins on: goose.run
Good first issue re: ABI encoding, factory indexing. Will unblock real use cases. Happy to help you get started / jam on it - get in touch :)
https://github.com/ponder-sh/ponder/issues/1323
https://github.com/ponder-sh/ponder/issues/1323
it's not often that you think "wow this is amazing" every step of the way when using a software dev framework
that's how i feel whenever i use /ponder-sh though
@typedarray.eth & co are legends
that's how i feel whenever i use /ponder-sh though
@typedarray.eth & co are legends
The ponder client library will be very, very good
Write queries in your frontend codebase, type-safe with no codegen, realtime/reactive by default
Coming soon to a browser near you
Write queries in your frontend codebase, type-safe with no codegen, realtime/reactive by default
Coming soon to a browser near you
We're hosting a Ponder holiday meetup in NYC next Thursday!
This is a developer-focused event for users, contributors and friends interested in crypto app development, TypeScript tooling, web frameworks, open-source, the holiday spirit, etc
Reply here or send me a DC if you'd like to join
This is a developer-focused event for users, contributors and friends interested in crypto app development, TypeScript tooling, web frameworks, open-source, the holiday spirit, etc
Reply here or send me a DC if you'd like to join
Enjoyed working with @0age on this!
Most actors using The Compact need an indexer. It’s a great use case for Ponder - multichain, non-trivial indexing logic, 100% open-source
Use our endpoint (link in readme) or host an instance yourself
Most actors using The Compact need an indexer. It’s a great use case for Ponder - multichain, non-trivial indexing logic, 100% open-source
Use our endpoint (link in readme) or host an instance yourself
4262
0age
@0age·17:03 02/12/2024
open-sourced an indexer for The Compact built alongside the gigabrains at
ponder.sh: https://github.com/Uniswap/the-compact-indexer
very clutch for anyone building a frontend, tracking analytics, or running a filler or an allocator (link to hosted version in the README)
h/t @typedarray.eth @kjs
ponder.sh: https://github.com/Uniswap/the-compact-indexer
very clutch for anyone building a frontend, tracking analytics, or running a filler or an allocator (link to hosted version in the README)
h/t @typedarray.eth @kjs
Just shipped 0.7.7 which adds a `totalCount` field to the GraphQL page type. This is actually pretty handy for some paginated UI patterns, and is also probably the fastest way to check how big the database is
https://github.com/ponder-sh/ponder/releases/tag/%40ponder%2Fcore%400.7.7
https://github.com/ponder-sh/ponder/releases/tag/%40ponder%2Fcore%400.7.7
522554
yukigesho
@yukigesho.eth·21:21 15/11/2024
Hey all, just wrote my first blog post. I would be really grateful for any feedback:
https://paragraph.xyz/@yukigesho.eth/how-i-made-a-crypto-app-10x-faster
https://paragraph.xyz/@yukigesho.eth/how-i-made-a-crypto-app-10x-faster
Introducing Ponder 0.7
PGlite, Drizzle, raw SQL, portable table objects, and more. It’s our biggest release since 0.1 →
PGlite, Drizzle, raw SQL, portable table objects, and more. It’s our biggest release since 0.1 →
✅ shipping next week
651
Kevin
@typedarray.eth·16:01 13/08/2024
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)
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)
https://ponder.sh/docs/indexing/call-traces#register-an-indexing-function how does this work if you're trying to index eth xfrs to an EOA (or CREATE2 address that hasn't been deployed)?
@typedarray.eth in what order do the events / call handlers execute in ponder?
biggest critique of ponder right now is the logging immediately jumps to the table and I can't scroll up to see any logs that I might have emitted from the indexing function bodies.
As a serial console.log debugger this is terrible 😩
As a serial console.log debugger this is terrible 😩
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)
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)
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
github.com/ponder-sh/ponder/blob/c19358158d3be13e0c8bab8450ba16ab3f71011d/packages/core/src/sync-store/postgres/store.ts#L222-L230
Life can be a puzzle sometimes, but every piece fits together eventually. Keep believing!
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
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
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
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
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.
We have hundreds of production users, growing 40% per month.
NYC required. Team is 3 people, all engineers. DM with interest or referrals.
