A place for developers to talk about building on Farcaster.

/dev

there’s beauty in a properly normalized schema mapped to strong types

constrain your data (and thank me later)

hints: use postgres constraints on your string fields, don’t put JSON in your db, use materialized views and/or prudent caching if joins get too expensive

working on /microsub + @degentipbot.eth; producer/dj; host of /campfire 🎧 + /downshift ⚙️

Counterpoint, JSON fields can sometimes be handy for some data

That said, definitely a +1 on strongly typed schemas

Purple 🟣 #134
Building ScoutGame & CharmVerse.io

Love to talk about new ideas, build and use AI daily

agree, sometimes it does make sense

usually, it’s done lazily and makes the system worse in a lot of ways