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.

I would vote for pglite because it is just strange developing an environment that is fundamentally different than what is in production 

We had some issues with this but tbf we are hacking around ponder a bit to achieve what we want so we are more exposed to these issue probably

Making investing together better https://onit.chat | Variant Founder Fellow | Cambridge Alum | Formerly Ireland's #3 powerlifter (74kg)

Yea agree, the traditional wisdom of avoiding differences between dev and prod is another "pro".