Igal Klebanov 💥 kysely

kysely is amazing. the best SQL interface i've ever worked with hands down

store it in an environment variable.

what genocide?

try `kysely-ctl` and mine latest versions. lemme know what you think. 😊

there's pronounciation help in the readme.. 🫠

separate the art from the artist.

The Copilot Delusion Disclaimer: This post was written May 2025, and the arguments apply to AI code capabilities at this time. The arguments around lack of competence are certainly likely to become less prevalent-while th...

💯
deplet.ing/the-copilot-...

100% the neon dude.

we have @pkg.pr.new for that. pushing preview builds for PRs, the long-living `next` branch, etc. people can play around with these or the playground.

there were a few times where we rolled back and redesigned an API idea before release. if that would have hit `latest` on `npm` prematurely - ouch.

trying to come up with terminology for common typescript hacks in dynamic kysely examples be like:

"now take this floating table and ground it with a static alias that's known at compile-time" 🥴

and the equally fun "when are you going to release this?" 🤡

prepare for support hours? 😬

a screenshot from GitHub showing that `kysely-org/kysely` has reached 12k GitHub stars.

f yeah! 🤩

Release v0.13.0 - migrator/seeder factory, lazy resources, sql module. · kysely-org/kysely-ctl Hey 👋 NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW MINOR. NEW ...

new `kysely-ctl` out.

github.com/kysely-org/k...

from a perspective of someone who doesn't read the docs. 🫠

it's out!

Release 0.28.2 · kysely-org/kysely Hey 👋 v0.28 broke an undocumented TypeScript behavior our API had that allowed you to pass table name unions to query builders and enable some DRYing of queries. Seeing that this pattern was quite ...

dynamic table values were an undocumented, accidental thing before v0.28.
now they're officially supported in v0.28.2.

please drink lots of water. it's hot outside, and DRY in your codebases now. 🥤

github.com/kysely-org/k...

Release 0.28.0 · kysely-org/kysely Hey 👋 Transactions are getting a lot of love in this one! As part an effort to replace Knex with Kysely, B4nan, the author of mikro-orm drove the new setAccessMode('read only'|'read write') method ...

new me, who this?

github.com/kysely-org/k...

Type-safety with TypeScript ORMs and query builders · thetutlage meta · Discussion #8 Alright, so I maintain a JavaScript ORM called Lucid. Lucid is built on top of knex, which isn't type-safe, and hence, Lucid isn't type-safe either. My gut feeling is that utilizing SQL to its full...

that's more of a comparison between an orm and a query builder. you needed an orm. it's fine.

you were not "holding it right" in some parts, and complaining about sql more than about kysely.

unmatched type-safety.
github.com/thetutlage/m...

dynasty.

omg, so many times.

new patch out.

github.com/kysely-org/k...

in other words, what are the queries you're gonna execute on this table? what `where`s are you using?

e.g. if all you do is `where a = ?` and `where a = ? and b = ?`, all you need is a composite index `(a,b)`, probably*. 🤞

* - run some `explain`s to see actual query plans to test assumptions.

what are the access patterns?

query builders to the rescue.

Type-safety with TypeScript ORMs and query builders · thetutlage meta · Discussion #8 Alright, so I maintain a JavaScript ORM called Lucid. Lucid is built on top of knex, which isn't type-safe, and hence, Lucid isn't type-safe either. My gut feeling is that utilizing SQL to its full...

github.com/thetutlage/m...

לגמרי. החדר-משרד שלי קפוא. זה מחרפן.

Release v0.11.0 - automatic `tsconfig.paths` resolution. · kysely-org/kysely-ctl Hey 👋 This release adds automatic tsconfig.paths resolution behind a --experimental-resolve-tsconfig-paths flag, as jiti doesn't do it by design - which caused crashes in setups that have aliases (...

some of ya'll love them `@` prefixes in imports. hope this helps. 🤞🤞

github.com/kysely-org/k...

🙌