kysely's Avatar

kysely

@kysely.dev

The type-safe SQL query builder for TypeScript. Not an ORM, product or company. Inspired by Knex.js. From Objection.js' creator. "what you see is what you get". http://kysely.dev

473
Followers
156
Following
60
Posts
31.10.2024
Joined
Posts Following

Latest posts by kysely @kysely.dev

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

17.08.2025 23:57 πŸ‘ 4 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
a screenshot from GitHub showing that `kysely-org/kysely` has reached 12k GitHub stars.

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

f yeah! 🀩

21.05.2025 10:43 πŸ‘ 13 πŸ” 1 πŸ’¬ 1 πŸ“Œ 1
Preview
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...

19.05.2025 11:20 πŸ‘ 4 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Preview
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...

24.04.2025 12:27 πŸ‘ 4 πŸ” 2 πŸ’¬ 0 πŸ“Œ 1

🍻

23.04.2025 17:40 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
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...

13.04.2025 15:18 πŸ‘ 11 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

sky's the limit. πŸ₯³

11.03.2025 20:19 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
03.03.2025 20:35 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 1
03.03.2025 20:20 πŸ‘ 6 πŸ” 0 πŸ’¬ 0 πŸ“Œ 1
03.03.2025 19:17 πŸ‘ 5 πŸ” 1 πŸ’¬ 0 πŸ“Œ 1

new patch out.

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

03.03.2025 19:06 πŸ‘ 6 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Preview
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...

09.02.2025 20:45 πŸ‘ 2 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0

been right all along. πŸ˜‡

07.02.2025 06:21 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

not a big deal. it'll probably be exposed in v0.28.

02.02.2025 14:51 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

the ast has a root node with a `kind` property. you can also import and use `is` functions of `DeleteQueryNode`, `SelectQueryNode`, etc.

02.02.2025 13:57 πŸ‘ 1 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

you can use `.toOperationNode()` to just get the ast, then instantiate a query builder on the other side based on its root kind. e.g. `new DeleteQueryBuilder({
executor: db.getExecutor(),
queryId: createQueryId(),
queryNode: queryThatYouSentOverWire,
})`

02.02.2025 13:50 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

πŸ€πŸ‘

02.02.2025 12:54 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

don't forget to index your columns. πŸ˜‰πŸ‘

01.02.2025 22:52 πŸ‘ 9 πŸ” 0 πŸ’¬ 0 πŸ“Œ 2
Splitting query building and execution | Kysely Kysely is primarily a type-safe sql query builder.

this is better explained on kysely.dev/docs/recipes...

01.02.2025 22:43 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

welcome to type-safety. πŸ€—

01.02.2025 22:40 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
dm from a bot pretending to be kylie jenner.

dm from a bot pretending to be kylie jenner.

guess she didn't read the docs. no relationships. πŸ«ΈπŸ‘«

01.02.2025 17:58 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

what are you working on? πŸ‘€

01.02.2025 17:12 πŸ‘ 2 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

stay safe out there! πŸ˜‰πŸ‘

26.01.2025 15:28 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Preview
Roadmap to v1.0? Β· Issue #1328 Β· kysely-org/kysely Thanks for this excellent library. We are evaluating whether to use this library for our next project, but are a bit hesitant because it hasn't reached v1.0 yet. What are the reasons for kysely not...

v1 doesn't matter. πŸ§β€β™‚οΈπŸ™…β€β™‚οΈ

21.01.2025 13:12 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

new FUNDING doc out.
github.com/kysely-org/k...

πŸ‘ŽπŸ€ž

12.01.2025 11:57 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

oh there's worse.

people can be assholes and entitled.

06.01.2025 11:09 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

new CoC out.
github.com/kysely-org/k...

don't be an asshole. you are not entitled to other people's time, energy, or attention. 🀝

05.01.2025 11:40 πŸ‘ 6 πŸ” 0 πŸ’¬ 1 πŸ“Œ 1

i'm smart? πŸ₯Ή

01.01.2025 13:00 πŸ‘ 5 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

πŸ‘¨β€πŸŽ“

01.01.2025 12:54 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

πŸ€œπŸ€›

01.01.2025 12:53 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0