A place for developers to talk about building on Farcaster.

/dev

wtf did i just executed a postgres query with a psql cli against postgres running in webassembly via js

Based House. Engineering @neynar. Amusement, wonder, and uncertainty ✴︎ libred.org

Florence, Metropolitan City of Florence, Italy

I also saw electric-sql pivot, away from sqlite and towards PGlite. I don't get it. PG is connections-based, while Sqlite spins up/down in JIT fashion. 

What do you gain with PGlite that offsets the mental dissonance? Is it basically, tons of dev tooling and dev familiarity?

https://SassyHash.artlu.xyz/download

See pinned cast frame for more.

PFP is my Native.fun Print, genart unique hash of wallet txns -> Faces of Farcaster

I experiment with it right now for local development as my production end uses Postgres. I considered using SQLite but because frame.town gets much complex each week with external data ingestion, in-house stats I went with Postgres because of it’s connection-based nature (it’s easier to interface it from multiple machines), tooling for analytical workflow (timescaledb), and foreign data wrappers.
With SQLite I’d have to implement all this myself.

I don’t use it for local db sync. I’m more interested in simulating production environment. I can imagine that having full blown single-threaded postgres may prove too slow

pretty cool use case, if I may summarize? it allows lightweight local development (no need for a Docker or a heavy db) plus sync is mostly handled for you.

My local-first toys have started small rather than attempted to integrate with existing servers. Happy to learn from efforts going the other way!

(s/o Evolu my favorite of multiple projects picking up the local-first sqlite ball)