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.

Sqllite I like because the path to ponder running in the background of a local first app is more clear

Also generally would default no because sqllite is super mature

Developer 🤓 build, develop and operate Farcaster solutions @ dtech.vision also love tech, decentralization, fitness and oldschool rap 😎

Seems like it yea I just never heard of pglite

Pglite with eletricsql will support react native or has to 

Then it’s the same path no?

Good point. I'm actually not too worried about it though, seems like PGlite is very focused on browser support (WASM-first).

If anything a "con" for PGlite is that it's *too* focused on running in the browser, and they might deprioritize Node.js/Bun (where Ponder is more certain to run).