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

🐵 ← 🙈🙉🙊 → /phil →  phil.cockfield.net, db.team →  
ƒ(🌳) →  🧫 /sys  ←  @cell <T>

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

@pjc @git can you pinch me. Am I dreaming?

Tech entrepreneur. Founder @electricsql. Founder @gatsbyjs (acquired by Netlify). @kylemathews on Twitter

Farcaster Development Boutique @ https://dTech.vision 💜 in love with tech 🤓decentralization, fitness and oldschool rap 😎

You know Farcaster will succeed when open source library authors are tagged on casts that mention their work

https://SassyHash.artlu.xyz/download

See pinned cast frame for more.

PFP is my Native.fun Print, genart unique hash of wallet txns

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 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?

some of these local first db's (at least I think that's what they are?) are pretty sweet tbh. I don't know how I'd really use them, I feel like it'd have ot be a pretty specific reasoning/usecase. But still cool that you can do stuff like this now.