Ponder

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)

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

what features under #2 are unlocked if the switch was made?

/max • /bracket • @quickcast • /coys • maxp.co

we are heavy users of drizzle, so that would literally be a dream!

as it stands i'm defining our db tables in three different schema apis (drizzle, powersync, and now ponder)

The big one is for Ponder to simply use Drizzle (drizzle-orm/pg-core) instead of the custom ponder.schema.ts table definitions and Store API.

Big maintenance burden win for us, and there's a decent chance that new users already know Drizzle (vs a 0% chance they know our custom API 😉 )

Curious for your take!