Topics

Kysely•13mo ago

How to insert JSONB types in postgres?

I've looked at https://kysely-org.github.io/kysely/classes/InsertQueryBuilder.html#values and it's not very clear how I'd apply JSON to that column type when inserting. Do I need to create some sort of special helper like in: https://github.com/kysely-org/kysely/blob/master/site/docs/recipes/extending-kysely.md Also for the interface, do we define the field as a Record type? What if the field is optional?

GitHub

kysely/extending-kysely.md at master · kysely-org/kysely

A type-safe typescript SQL query builder. Contribute to kysely-org/kysely development by creating an account on GitHub.

InsertQueryBuilder | kysely

Documentation for kysely

8 Replies

Unknown User•13mo ago

Message Not Public

Sign In & Join Server To View

Theo Gravity•13mo ago

Oh nice, so just feed in a normal object to the field then

Unknown User•13mo ago

Message Not Public

Sign In & Join Server To View

Theo Gravity•13mo ago

For fetching did you have to implement the extending-kysely.md items?

Unknown User•13mo ago

Message Not Public

Sign In & Join Server To View

Unknown User•13mo ago

Message Not Public

Sign In & Join Server To View

Theo Gravity•13mo ago

Thanks

Unknown User•13mo ago

Message Not Public

Sign In & Join Server To View

1.4KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Querying two different tables with subset of common columnsI have two tables that have an intersection of common columns that I'm looking to query. For each of How to select from a function with parameters?I understand that `kysely` will not natively support stored procedures / functions, and was wonderin In a transaction, how do you ignore generated field requirements?``` export interface TextDocumentTable { id: Generated<number>; created_at: Generated<Date>; } Cross database joins in MySQLHi all, Is it possible to do joins across databases within the same MySQL instance? i.e ```sql SELEC .where('x', 'is not', null) and correspond type's nullabilityNot sure if this even possible in typescript (although all of the work Kysely already makes it seem What is the suggested way of adding/removing methods to expression builders?Context: I am building a custom dialect for YDB https://github.com/Gaspero/kysely-ydb YDB is slightl Running database agnostic queries (MySQL)As part of my test suite, I drop/create databases programmatically. Is it possible to have a Kysely Asserting type of .countAll() (MySQL)I've noticed that the return type from the result of aggregation functions like `countAll()` and `su Coalesce return empty arrayHey is there a way to return an empty array rather than `null` when an array column is empty? I alr kysely-codegen for multiple databasesI have two MySQL 'databases' within the same instance. From the documentation, it doesn't look like