Using sql.lit
Hey
I have a question about using sql.lit and using dates
````
const query = kyselyBase...
Any thoughts on how to move data migrations from knex to kysely?
I've been working on shifting my code over to kysely, and it's been fantastic so far. However, I'm not entirely sure how to restructure my migrations directory into Kysely while maintaining up/down state without some manual overhead. The documentation has great advice for setting up migrations from scratch, but not as much for moving an existing project to its structure. I plan to collect all existing table data into a new initial migration, so that makes this somewhat easier. But there are still challenges. The way I see it I have 2 options:
1. Put a hacky check in the initial migration to apply its change only if one of my tables is not present.
2. Manually create the kysely migration record in existing databases to note that the initial migration has been run....
Using a custom HTTP driver for Kysely
Hi. I want to use neondb as my database. The issue is that I can't create a PostgresDialect class instance from the default provided pool, as that uses websockets - which is not what I want. Is there a way to tell Kysely to use HTTP connections (such as with
kysely-planetscale), or do I need to make the driver myself?Solution:
Hey 👋
Have you tried the kysely-neon community dialect?...
How to order by with embeddings using pgvector?
I'm trying to get this to work:
```js
const raw = db
.selectFrom("embeddingChunks")...
Solution:
You can't have parameters inside strings. https://kyse.link/?p=s&i=mSBxXrsodd1aLwlEKulE
Recipe for generated types + JSON?
Hey all! I'm currently migrating my application from objection to Kanon + Kysely, and I'm having trouble figuring out a good solution for the JSON Data Types. I have zod objects built for all of my JSON, but I'm unsure of how to integrate these types in a clean way.
As I see it, my best option is to import each Table's interface into a separate Database file. In that file, for each type that has a json object, omit the existing column type and union in the new column type. Of course, that results in unfortunately ugly type annotations.
The other option loses basically all of the benefits of Kanon outside of the first generation. In this method, I stop using the type auto-generation, and simply edit the json values into the schema and manually update the kysely schema whenever I need to update....
Consensus on immutable vs. mutable result for .executeTakeFirst
Hi folks, love Kysely, thanks for your work.
Is there a consensus on whether or not the query result for
executeTakeFirst should be immutable? Or is this up to the dialect/not a concern of Kysely?
I'm asking because I seem to have found an inconsistency with kysely-libsql where the result of executeTakeFirst is immutable, but this isn't the case for built-in dialects (checked Sqlite and Pg). ...Solution:
The result is not meant to be immutable. It's up to the dialect and the underlying driver. Unless you use something like
CamelCasePlugin, Kysely doesn't touch the result in any way. It just returns what the driver returns.Relational table join question
Hey, just out of curiosity, does Kysely have any helpers for joining tables across a relational table? For example, if I have tables
user and account joined via the user_account relational tables, if I use jsonArrayFrom from a query on the user table to get accounts, do I always need to do a join with the intermediary table or does Kysely provide any type of shortcut for this?Raw SQL in select type to number
Hellow, I have the following sql expression in a select statement array:
but the return type of the column in the row is a string. How can I get the type to be a number?...
sql<number>`(${sql.raw(precisionScore)} * 100)::NUMERIC(10,2)`
sql<number>`(${sql.raw(precisionScore)} * 100)::NUMERIC(10,2)`
Solution:
The
pg driver returns numeric type as a string. Use the pg-types package to configure the type.Select by id?
With this code:
```
export const getProductById: RequestHandler = async (req, res, next) => {
const { id } = req.params
try {...
Solution:
That is because Kanel create a "special" type for the id
Why has the json_agg and to_json call functions not been released?
Hi
Recently I have favored Kysely.
I would like to implement a query that calls to_json using kysely....
Solution:
Hey 👋
We don't have a roadmap. It'll be released when we're ready to cut a version....
Why jsonArrayFrom converts a Generated<number> field into string | number?
Look at this pic
Solution:
Since you're not using table specifiers, are you sure some "parent" table doesn't also have those columns and you are actually selecting them?
kysely uses prepared statements like knex?
im planning use rds proxy and prepared statements pin connection
Solution:
Hey 👋🏻
nope. you can use kysely as a standalone query builder and execute the sql using a 3rd party driver's prepared statement execution api....
How to improve performance in large SELECT?
I have a large query with >100 selections, this makes VS Code hangs for type checking every 30s.
I tried
$assertType() with a hard-coded object type at the end of the select query, but it doesn't help much.
Is there a recommended way for large inferred types?...Type inference of queries with expressions in Webstorm
Webstorm reports that the type of
const result = await selectable.select(({ eb }) => eb(eb.fn.count('id'), '>', 0).as('email_exists')).executeTakeFirst()
is {email_exists: SqlBool} | undefined
...How to compose functions?
I have been unable to calculate
select count(id) > 0 from foo. I tried this:
.select(({ eb }) => {
eb(eb.fn.count('id'), '>', 0)
})...Solution:
I needed to alias the return:
.select(({ eb }) => eb(eb.fn.count('id'), '>', 0).as('email_exists'))
I learned this by accidentally stumbling across this note in the documentation:
You can select arbitrary expression including subqueries and raw sql snippets. When you do that, you need to give a name for the selections using the as method....
How do I create a helper to be used on a select array of fields?
I want to create a toBool helper to convert from tinyint, however I'm lost on the type I need to pass to get autocomplete of the possible fields in the select
```ts
import { sql } from 'kysely'
...
Solution:
I think checking equality to 0 would make this safer (and swapping true/false order), as tinyint can be negative.
How do I cast the type of a eb.fn('...') ?
I tried with eb.fn<string>("CONCAT", [....]) but it didn't worked
Solution:
If it doesn't work for some reason, you can use
...
eb.fn('now', []).$castTo<Date>()
eb.fn('now', []).$castTo<Date>()
cant use kysely-codegen
I followed this part https://kysely.dev/docs/getting-started of documentation till CODEGEN part when you can generate types based on actual database. https://kysely.dev/docs/generating-types this one. I installed needed packages:
npm install --save-dev kysely-codegen, and I set database string in .env file. Next step is: kysely-codegen, but I get this error when I type it in the console:
```
kysely-codegen
kysely-codegen : The term 'kysely-codegen' is not recognized as the name of a cmdlet, function, script file, o ...Solution:
oh I feel stupid...
npx kysely-codegen workswithSchema is marked as deprecated in ExpressionBuilder?
why and how to be replaced? How can be the schema defined dynamically (env)?
Insert values from subquery
What am I doing wrong here? https://kyse.link/?p=s&i=cvuB1ICSw0A1wiPUHxgK
Solution:
comments on ...
eb.lit :
To prevent SQL injections, only boolean, number and null values are accepted. If you need string or other literals, use sql.lit instead.
To prevent SQL injections, only boolean, number and null values are accepted. If you need string or other literals, use sql.lit instead.