Hacker News new | ask | show | jobs
Kysely (the type-safe SQL query builder for TypeScript) v0.29 is out btw (github.com)
3 points by igalklebanov 34 days ago
3 comments

Hey

DISCLAIMER: I'm co-leading the org/project.

We recently broke 6M downloads per week on NPM, and became 3rd after `drizzle-orm` and `@prisma/client`.

If you haven't tried it yet, it's a query builder, not an ORM. You don't outsource your SQL to someone else. It's type-safe, like.. it's super important to us. You can use it with ORMs - e.g. Prisma, mikro-orm, zenstack, etc. Allows you to compose some complex stuff but keep it maintainable af.

If you have. Great seeing ya'll here.

0.29 was a real nice release, with lots of goodies. Can't wait for 0.30, gonna be super fun.

As the creator of ZenStack, rewriting our ORM engine for v3 with Kysely was honestly one of the best technical decisions we’ve made. The composability, type safety, and overall architecture fit our use case surprisingly well.
How does it compare to Drizzle?
As far as query building goes, `kysely` is more in-depth, type-safe, expressive, 1:1 and doesn't require importing as many things.

`kysely-ctl` doesn't generate migrations for you, and `kysely` not being an ORM, doesn't provide declarative schema design.

here's a good write up on the type-safety advantages https://github.com/thetutlage/meta/discussions/8