bombillazo Posts - Answer Overflow

bombillazo

Explore posts from servers

DDeno RRefine KKysely HHono DTDrizzle Team

•Created by bombillazo on 9/26/2024 in #help

Kysely client usage and pooling question

Hello, We have a long running server that at the moment creates a single Kysely instance. It is setup to use pg pooling. We have a util function called getKysely which returns this instance and is used throught our backend , like on every request handler that calls the DB. So in theory multiple concurrent requests call this function to get the Kysely client and make queries. We are noticing that even within the same API endpoint handler, executing queries with a fetched client seems to be running on different connections. We think this because we sometimes execute raw sql queries which change the role of the connection, but later on using the same client we execute a query to check the current role and it is not the one set up previously. I am curious about how Kysely internally uses pooling, does it fetch a connection from the pool on every query? I know we are using a singleton, but how can I make sure that Kysely uses a single connection throughout the scope of a single request?

7 replies

HHono

•Created by bombillazo on 8/22/2024 in #help

Cannot load `hono` from JSR

Hello, we're using Deno and are getting the following error when importing hono using the jsr:@hono/hono import which has worked for us for the past months:

import 'https://registry-staging.deno.com/@hono/hono/meta.json' failed: error sending request for url (https://registry-staging.deno.com/@hono/hono/meta.json): error trying to connect: dns error: failed to lookup address information: nodename nor servname provided

import 'https://registry-staging.deno.com/@hono/hono/meta.json' failed: error sending request for url (https://registry-staging.deno.com/@hono/hono/meta.json): error trying to connect: dns error: failed to lookup address information: nodename nor servname provided

Any way to fix this issue?

2 replies

DDeno

•Created by bombillazo on 8/13/2024 in #help

Reset position of terminal cursor when calling io.writeAllSync()

Currently using io.writeAllSync, the next data is written where the last data left off, even with a new line the cursor is kept horizontally in the position that was left. I tried the ansi library cursorBack function but it did not work, how can I control or reset the cursor?

2 replies

DDeno

•Created by bombillazo on 8/13/2024 in #help

How to log Deno.Command output in real time (not after command completes)

Hello, is there a guide on how to log stdout with a Deno.Command is running, not just after it completes?

6 replies

HHono

•Created by bombillazo on 8/11/2024 in #help

Return early from middleware

Hello, I want to return a 200 response from a middleware if certain conditions are not met, else run await and cleanup after the await. How can I return early from the middleare function?

3 replies

HHono

•Created by bombillazo on 8/8/2024 in #help

Match both `/` and `/:id` routes the the same router

Hello, is there any way to handle 2 routes in the same router? We want to handle requests coming to both / and /:id to handle when id is undefined or has a value.

6 replies

DDeno

•Created by bombillazo on 7/3/2024 in #help

Is there any way to force a Deno dependency to use a specific version of std?

We're having an issue were a dependency we are importing from npm with the npm: identifier is trying to use a node lib that only exisits up to std v0.177.0, specifically the tty lib. Our main std version is in 0.244.0 specified in our import_map.json file. Is there any way to specify this 3rd party dep to use the std version it requires to work?

2 replies

KKysely

•Created by bombillazo on 6/20/2024 in #help

How to do `LIKE ANY` query in Kysely?

Hello, I am trying to build this query in Kysely but have no idea how to properly insert the ANY into the query.

SELECT *
FROM your_table
WHERE your_column LIKE ANY (ARRAY[
    '%suffix1',
    '%suffix2',
    '%suffix3'
]);

SELECT *
FROM your_table
WHERE your_column LIKE ANY (ARRAY[
    '%suffix1',
    '%suffix2',
    '%suffix3'
]);

Any constructs with kysely that I should use in particular?

3 replies

KKysely

•Created by bombillazo on 5/17/2024 in #help

Dynamic conditional raw query question

Hello there, Im trying to create a dynamic query like this:

 await sql`SELECT
  column AS "data"
FROM my_table 
${type ? ` WHERE type = ${type}` : ''};`.execute(client);

 await sql`SELECT
  column AS "data"
FROM my_table 
${type ? ` WHERE type = ${type}` : ''};`.execute(client);

But kysely is trying to do substitution where I have my TS logic to either add the WHERE clause or not. How can I fix this ?

6 replies

DDeno

•Created by bombillazo on 4/11/2024 in #help

How to upgrade `import_map.json` package versions?

Hello, in node I used ncu to check for new package versions and automatically update the versions. Is there any utility for deno to scna my packages and check if there are new versions?

4 replies

KKysely

•Created by bombillazo on 4/11/2024 in #help

jsonArrayFrom with `as` not being typed

I have the following query

await db
    .selectFrom('user')
    .selectAll()
    .select((eb) => [
      jsonArrayFrom(
        eb
          .selectFrom('book')
          .selectAll()
          .where('book.is_enabled', '=', true)
      ).as('books'),
    ])
    .execute();

await db
    .selectFrom('user')
    .selectAll()
    .select((eb) => [
      jsonArrayFrom(
        eb
          .selectFrom('book')
          .selectAll()
          .where('book.is_enabled', '=', true)
      ).as('books'),
    ])
    .execute();

but the resulting query is not seeing the jsonArrayFrom field with the name books , rather it types it like this:

{
  [x: string]: {
      created_at: TimestampTZ;
      description: string | null;
      id: string;
      label: string | null;
      name: string;
      is_enabled: boolean;
  }[];
  ... 5 more ...;
  name: string;
}[]

{
  [x: string]: {
      created_at: TimestampTZ;
      description: string | null;
      id: string;
      label: string | null;
      name: string;
      is_enabled: boolean;
  }[];
  ... 5 more ...;
  name: string;
}[]

How can i fix this?

25 replies

KKysely

•Created by bombillazo on 4/2/2024 in #help

Kysely setup in monolith API

Hello, we have a basic http server with a basic router and a PostgreSQL database. We're wondering what is the proper setup to use the Kysely client in our routes to make calls to the database. Should there be a singleton client that is used across routes, or do we need to instantiate a kysely client on every request ?

10 replies

KKysely

•Created by bombillazo on 2/9/2024 in #help

How do I use `WHERE NOT EXISTS`?

I am trying to write the followng where condition:

INSERT INTO Filing (location_id, filing_date, other_columns)
SELECT L.location_id, '2023-01-01'::date, default_values_for_other_columns
FROM Location L
WHERE NOT EXISTS (
  SELECT 1
  FROM Filing F
  WHERE F.location_id = L.location_id
    AND F.filing_date = '2023-01-01'::date
);

INSERT INTO Filing (location_id, filing_date, other_columns)
SELECT L.location_id, '2023-01-01'::date, default_values_for_other_columns
FROM Location L
WHERE NOT EXISTS (
  SELECT 1
  FROM Filing F
  WHERE F.location_id = L.location_id
    AND F.filing_date = '2023-01-01'::date
);

But Im not sure how to approach it.

5 replies

DDeno

•Created by bombillazo on 1/31/2024 in #help

Run `nvm` using Deno.Command

Hello, I am trying to run nvm from a Deno script using Deno.Command.

  new Deno.Command('nvm', {
    args: ['use'],
    stderr: 'inherit',
    stdin: 'inherit',
    stdout: 'piped',
  }).outputSync;

  new Deno.Command('nvm', {
    args: ['use'],
    stderr: 'inherit',
    stdin: 'inherit',
    stdout: 'piped',
  }).outputSync;

but I am getting the following error:

Failed to spawn 'nvm': No such file or directory (os error 2)

Failed to spawn 'nvm': No such file or directory (os error 2)

nvm was install with brew and I tried passing env: {PATH: Deno.env.get('PATH') but nothing works...

2 replies

KKysely

•Created by bombillazo on 1/25/2024 in #help

Examples 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_id = b.sub_id

5 replies

KKysely

•Created by bombillazo on 1/18/2024 in #help

Omit/filter out columns from query

Hey, is there an easy or convenient way with Kysely to filter out data from a query? Lets say I have columns 1,2,3,4,..., 10 and I want to omit column 9, do I have to really list all my columns like this:

select(['1','2','3','4','5','6','7','8','10']

select(['1','2','3','4','5','6','7','8','10']

11 replies

KKysely

•Created by bombillazo on 1/17/2024 in #help

How 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, and I want to have them typed to the table they belong to to have it suggest errors if a table changes or someone uses a non-valid column. How is this achievable with the kysely helper types? The array may also include expression builder or the jsonObjectFrom helpers since they are valid Select options

3 replies

KKysely

•Created by bombillazo on 1/12/2024 in #help

Return `null` by default if no record found

Hey, I am looking to have my queries return null instead of undefined if no records match my query when using executeTakeFirst. Is there a way to set this in the Kysely client?

7 replies

DDeno

•Created by bombillazo on 12/25/2023 in #help

Deno.Command output as it runs

Hello, I am trying to run a command and have its output be logged as it runs , but for some reason the command runs but no output is displayed. I tried using both ouput with await and outputSync, setting stdout to piped and inherit but nothing.

6 replies

RRefine

•Created by absent-sapphire on 12/14/2023 in #ask-any-question

What are the differences between the `useNotification` and `useHandleNotification` hooks?

Id like to know more about each hook and what are their different uses and purposes.

4 replies

Gaming

Programming