K
Kysely•5mo ago
mike

How to work with json columns?

There are so many different sources in the documentation as those made me confused completely. I used documented way but still get errors: https://kyse.link/H3MKN
4 Replies
Igal
Igal•5mo ago
Hey 👋 This is dialect/underlying driver specific. What dialect are you using?
mike
mike•5mo ago
postgres
Unknown User
Unknown User•5mo ago
Message Not Public
Sign In & Join Server To View
mike
mike•4mo ago
thanks for the link however to my understanding I doesn't have typings on the json at all. I used the plugin plugins: [new ParseJSONResultsPlugin()], and I am saving the typed objects as string which works without any problem on the db level. However there is a mystery for me how to use the typing in the create and update json columns (as the attached link)
Want results from more Discord servers?
Add your server
More Posts
Does the TypeScript performance scale with larger projects?I just started migrating to kysely, love it so far! I was wondering how well the TypeScript performaSQLite__namespace is not a constructorHi Im building a Electron-Vite App and running into the following error: ``` TypeError: SQLite__nameRaw SQL in where clauseI have the following code and I'm getting a type error. This is strange as the raw sql statement worsmallint support (Postgres)Type dataType does not contain smallint? ```TS addColumn<CN extends string>(columnName: CN, dataTypeExamples inner join using OR?Hello, we are having trouble trying to have a inner join using OR, as in `ON a.id = b.id OR a.sub_idfull join "using" list of columnsHey, How can I create a full join which uses "using" I want to use "using" in the join but I only sIs kysely sanitizing sql injection when using raw sql ?Suppose I have a piece of code that does sql`${myString}` where myString contains sql injection, wilSupport for D1 batchingHi. I'm wondering about support for batching statements with Cloudflare's D1 batching, similar to liOmit/filter out columns from queryHey, is there an easy or convenient way with Kysely to filter out data from a query? Lets say I havHow to create a typed array of columns for select?Hello, I am trying to create some helpers that contain the list of columns used by multiple queries,