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.

FWIW we ran into a discrepancy between local (sqlite) and production almost immediately when we started using ponder, so ended up setting up postgres for local dev. Assuming pglite is reasonably stable it would be preferable IMO!

likes building things • https://alexgrover.me/links

this was months ago, but I believe it was that updating the same DB row twice in the same indexing function worked in sqlite but not postgres