Kysely

K

Kysely

Join the community to ask questions about Kysely and get answers from other members.

Join

help

query-showcase

announcements

Coffee11
Coffee11
View on Discord
9/26/2023

Select count?

Can't find any docs regarding this can someone send me the docs for this? Thank you in advance.
bun
bun
View on Discord
8/30/2023

how to sort `db.updateTable` returning values?

``` await db .updateTable("users") .where("id", "in", ({ selectFrom }) => selectFrom("users")...
decho
decho
View on Discord
7/2/2023

Prediction league leaderboard

Hey, hope I'm not becoming annoying, but I thought I'd share another query I made, perhaps someone can find it useful. This is a leaderboard for a prediction league. It's using 2 CTEs. In the first one we count occurences where the user predicted the correct result, outcome or first scorer of the match. In the second one we sum and multiply these occurrences by score factor, to distribute points with the following score system: - 1 point for guessing the correct outcome...
decho
decho
View on Discord
6/30/2023

CTE with exists() and case()

Hey guys, just wrote this one and I thought I'd share. ```sql WITH "ongoing" AS (...
Igal
Igal
View on Discord
4/9/2023

sale representative performance for Q3 2015

please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....
No description
Igal
Igal
View on Discord
4/8/2023

olympic gold medals

query https://user-images.githubusercontent.com/103982094/211247985-7d15da7b-820f-4615-810b-bd317f3acc13.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....
Igal
Igal
View on Discord
4/6/2023

duplicate job listings

query https://user-images.githubusercontent.com/103982094/211246010-ea3cf036-1973-4a69-b2da-57ecc51737a3.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....
Igal
Igal
View on Discord
4/5/2023

stock trade

query https://user-images.githubusercontent.com/103982094/228803165-415ff305-d8d7-49e2-ba93-1359bf69c74f.png please share your solutions or discuss the solutions in the comments. Kysely feedback and suggestions for enhancement are also welcome....