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.

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

Pglite with eletricsql will support react native or has to 

Then it’s the same path no?

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

No one has unless your familiar with eletricsql most likely

Not yet

Once back from Veecon will evaluate

TinyBase https://tinybase.org
ElectricSQL + PGLite
LiveStore https://github.com/livestorejs

And may even need to check effect SQLite that has a RN port https://www.npmjs.com/package/@effect/sql-sqlite-react-native

Though most likely the above 3 and use effect to connect to the DB

To me biggest hurdle is not having a somewhat proven default

So need to experiment with the lack of knowledge I have about frontend dev

Are you using electric sql for anything today? I'm considering using it to build a local first app but know nobody who has ever used it before to give me feedback about it