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

/Ponder

651

Kevin

@typedarray.eth·

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

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

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

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

Introducing Ponder 0.7

PGlite, Drizzle, raw SQL, portable table objects, and more. It’s our biggest release since 0.1 →

✅ shipping next week

"Why is Ponder so slow"

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

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

@typedarray.eth in what order do the events / call handlers execute in ponder?

Name a better indexer than /ponder-sh.

I'll wait.

Working on indexing huts built in /stokefire.

/Ponder

4199

Michael Gingras (lilfrog)

@frog·

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 😩

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)

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

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

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

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

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.

Anyone writing tests for your ponder indexer?

How are you doing it?

/Ponder