For TypeScript->Postgres, is Drizzle the best lib to use if I just want to have: * Type safety * No full ORM (I want to basically write SQL, but type safe) Or is there something even nicer now? I also saw Kysely (kysely.dev). - ThreadSky

About ThreadSky

juliusv.com • 43 days ago

For TypeScript->Postgres, is Drizzle the best lib to use if I just want to have:

* Type safety
* No full ORM (I want to basically write SQL, but type safe)

Or is there something even nicer now? I also saw Kysely (https://kysely.dev/).

Comments

lroal.bsky.social•28 days ago

Try https://github.com/alfateam/orange-orm
I am the author. Feel free to ask me anything.

juliusv.com•28 days ago

Thank you, Orange ORM looks great! However, I went all-in on Kysely for now, as I really just wanted great query building type safety, but without all the ORM-y abstractions. I might try Orange ORM in the future though!

lroal.bsky.social•28 days ago

Sure. I understand completely. 😊

igal.dev•42 days ago

"type-safety". 🫠

juliusv.com•42 days ago

Ah are you referring to Drizzle's lack of query builder type safety? That's why I'm currently leaning towards using Kysely.

schickling.dev•43 days ago

I've built my own type-safe SQL query builder for @livestore.dev mostly to support bidirectional schemas (to encode/decode data e.g. date objects, binary data <> ImageBitmap, ...).

juliusv.com•43 days ago

Hah, of course you did! 😅 However, I'm like 10 layers of yak-shaving deep and just need a well-maintained and documented library that I can quickly pick up and use :)

rawkode.dev•43 days ago

Drizzle is fantastic, but if you just need a query builder; Kysley is probably a quicker lift.

juliusv.com•43 days ago

Thanks! :)

juliusv.com•43 days ago

Interesting, I also read https://github.com/thetutlage/meta/discussions/8 and the part of the interview with the Drizzle devs at https://www.youtube.com/watch?v=Hh9xqRWYEJs&t=338s where they talk about why they didn't make Drizzle's query builder fully type safe. So torn!

Posting Rules

Be respectful to others
No spam or self-promotion
Stay on topic
Follow Bluesky's terms of service

Comments

Posting Rules

Reply