A place for developers to talk about building on Farcaster.

/dev

OrchidORM is one of those tools I can't praise enough. It deserves way more exposure, as the author works tirelessly to build likely the best ORM for Node.js there is.

This is not just some query builder, this is the real shit!

OrchidORM is one of those tools I can't praise enough. It deserves way more exposure, as the author works tirelessly to build likely the best ORM for Node.js there is.

This is not just some query builder, this is the real shit! 
https://github.com/romeerez/orchid-orm

✳︎ design engineer/ui wizard → @ponder 
✳︎ humanist • petrolhead/gearhead
✳︎ React+SwiftUI
✳︎ bento.me/matthew

The author is quick to reply to questions and has a wealth of knowledge in RDBMS, and has build something so powerful and simple to use, it's a joy.

Currently, I'm pushing it to its limit building faceted nav and nested queries, and I'm yet to eject once to raw SQL.

Works great with Next.js and Supabase.

likes building things • https://alexgrover.me/links

I used probably most ORMs made for Node.js by now, none of which can match this little project.

Drizzle isn't really a proper ORM, more like ORM-lite, or advanced query builder. Can't even do faceted navigation, a la Amazon filtering system without ejecting to raw SQL, which defeats the purpose of having ORM.

If you're curious how they compare, it may be biased coming from the creator of Orchid, but sound objective enough to me:

If you're curious how they compare, it may be biased coming from the creator of Orchid, but sound objective enough to me: https://orchid-orm.netlify.app/guide/benchmarks.html

Have you used drizzle? Haven’t tried orchid, curious how they compare

Wow thanks for sharing! Gonna try this out