Content
@
0 reply
0 recast
0 reaction
Kevin
@typedarray.eth
Introducing Ponder 0.7 PGlite, Drizzle, raw SQL, portable table objects, and more. It’s our biggest release since 0.1 →
2 replies
6 recasts
48 reactions
Kevin
@typedarray.eth
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?).
1 reply
1 recast
17 reactions
Kevin
@typedarray.eth
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.
1 reply
0 recast
0 reaction
Kevin
@typedarray.eth
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
1 reply
0 recast
2 reactions
Kevin
@typedarray.eth
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.
1 reply
0 recast
0 reaction
Kevin
@typedarray.eth
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.
1 reply
0 recast
2 reactions
Kevin
@typedarray.eth
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
1 reply
0 recast
0 reaction
Kevin
@typedarray.eth
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.
0 reply
0 recast
1 reaction
