Content
@
0 reply
0 recast
0 reaction
Kevin
@typedarray.eth
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)
10 replies
3 recasts
29 reactions
alex
@alexgrover.eth
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!
1 reply
0 recast
2 reactions
Kevin
@typedarray.eth
Oh wow - what was the discrepancy?
1 reply
0 recast
0 reaction
alex
@alexgrover.eth
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
0 reply
0 recast
1 reaction
