Ponder

Introducing Ponder 0.7

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

Building ponder.sh. EVM, TypeScript, open-source enjoyer.

Users shouldn’t need to run Postgres just to get through the quickstart. To make this possible, Ponder offers an embedded database option.

With this release, we moved from SQLite to PGlite. This eliminates dialect-specific behavior and minimizes astonishment (where’s the data?).

We started experimenting with PGlite last month, and have been impressed by the performance, usability, and growing ecosystem around it.

Huge thanks to Sam Willis for creating PGlite (https://pglite.dev) and ElectricSQL + Supabase for sponsoring its development.

With our dual-dialect problem eliminated, we were unblocked to replace our home-grown ORM with a mature query builder library.

We chose Drizzle. It covers all the bases - fast, typesafe, extensible, and has a growing cohort of frameworks building on it, including Astro.

With our dual-dialect problem eliminated, we were unblocked to replace our home-grown ORM with a mature query builder library.

We chose Drizzle. It covers all the bases - fast, typesafe, extensible, and has a growing cohort of frameworks building on it, including Astro.

https://orm.drizzle.team/docs/overview

Most writes in a Ponder app use a subset of SQL that runs in-memory and flushes to the database in large batches. It’s really fast.

For more complex logic, you can now drop down to raw SQL without losing automatic reorg resistance. @kjs absolutely cooked with this one.

The new Drizzle-based schema API also makes Ponder much more portable.

You can import the table objects and query them from any TS code, e.g. a React Server Component elsewhere in your monorepo.

Other goodies in this release
1) Composite primary keys and default column values
2) Crash recovery now works during the backfill
3) Fixed issues introduced in 0.6 with `ponder serve`

Migration guide: https://ponder.sh/docs/migration-guide#07
Telegram chat (come say hi):

Other goodies in this release
1) Composite primary keys and default column values
2) Crash recovery now works during the backfill
3) Fixed issues introduced in 0.6 with `ponder serve`

Migration guide: https://ponder.sh/docs/migration-guide#07
Telegram chat (come say hi): https://t.me/ponder_sh

And, for anyone who made it this far - if you’re a Ponder user currently hosting on Railway and are excited to try a *different* production experience, we have something to show you. Get in touch.