kysely
kysely copied to clipboard
kysely-org
A type-safe typescript SQL query builder
Hey 👋 Looking at this [answer](https://discord.com/channels/890118421587578920/1176608816238972988/1177351318600417280), we could offer a `db.sql.ref('users.id')` that would know the type of `'users.id'` from `Database` - and also provide better dx with autocompletion for all...
Hi folks. As always, thanks for making such a wonderful library! Kysely is my favorite tool for interacting with a db, and I've used a lot over the years :)...
Hi, once again thanks for this great library. I've run into a bad surprise when performing migrations concurrently, as the SQLite adapter does not actually perform any locking during migrations:...
I'm not sure if all DBs allow this, but at least in postgres you can alias the table. The specific part of [the spec](https://www.postgresql.org/docs/current/sql-insert.html) that I'm referencing is this: >...
Add `cast` function that produces a `cast(expr as datatype)` expression. `cast` is not strictly a function so I think it should live under `ExpressionBuilder`. The signature would be something like:...
I hope this feature will be introduced in Kysely. With proper referencing (and maintainer approval) I can file a PR.
Hi! I am currently working on an application that stores geodata in a MySQL database using the [spatial data types](https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html). I can use the sql literal to perform all the...
# Are you using Kysely in production? We're want to add a **Kysely in production** section to our website. If your company is using Kysely or you know of a...
Kysely with SQLite on Bun already (kinda) works using the `better-sqlite3` driver (installation is still wonky but should be fixed soon). AFAICT `bun:sqlite` is more performant than `better-sqlite3` when using...
Has anyone done this before? Just wondering if there is anything I should be aware of that might cause issues? I thought about keeping my knex schema migrations until all...
