Kysely (the type-safe SQL query builder for TypeScript) v0.29 is out btw

https://github.com/kysely-org/kysely/releases/tag/v0.29.0

by igalklebanov • 2 months ago

3 5 2 months ago

github.com

igalklebanov3• 2 months ago

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.

overflowy• 2 months ago

How does it compare to Drizzle?

igalklebanov3• 2 months ago

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.

igalklebanov3• 2 months ago

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

carlual• 2 months ago

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.

Kysely (the type-safe SQL query builder for TypeScript) v0.29 is out btw

Related Stories