Luccas Posts - Answer Overflow

Luccas

Explore posts from servers

KKysely Ttamagui TTCTheo's Typesafe Cult

Posts Comments

KKysely

•Created by Luccas on 10/21/2023 in #help

kysely uses prepared statements like knex?

im planning use rds proxy and prepared statements pin connection

4 replies

KKysely

•Created by Luccas on 10/1/2023 in #help

jsonb_build_object and raw sql possibilities

is possible to do this query without use sql.raw?

sql<string>`jsonb_build_object(${sql.join([
  sql.raw(`'hair_type',coalesce (dog.hair_type, dog_breed.hair_type)`),
  sql.raw(`'ear_type',coalesce (dog.ear_type, dog_breed.ear_type)`),
  sql.raw(`'size',coalesce (dog.size, dog_breed.size)`),
  ])})`

sql<string>`jsonb_build_object(${sql.join([
  sql.raw(`'hair_type',coalesce (dog.hair_type, dog_breed.hair_type)`),
  sql.raw(`'ear_type',coalesce (dog.ear_type, dog_breed.ear_type)`),
  sql.raw(`'size',coalesce (dog.size, dog_breed.size)`),
  ])})`

5 replies

KKysely

•Created by Luccas on 6/8/2023 in #help

insertId return by transaction

the insertId returned by a transaction is of the last executed query, right?

2 replies

KKysely

•Created by Luccas on 4/28/2023 in #help

converting result.insertedId to number

when using INT as PK i can safe convert result.insertedId from bigInt to Int using Number(result.insertedID)?

3 replies

KKysely

•Created by Luccas on 3/23/2023 in #help

mysql InsertResult always empty

my app is heavy id/transaction user and i need the id of created register to insert another register but InsertResult always is empty

17 replies

Gaming

Programming