elitan Comments - Answer Overflow

Topics

elitan

•Created by elitan on 11/28/2023 in #help

Help with CTE query

thank you

7 replies

•Created by elitan on 11/28/2023 in #help

Help with CTE query

impressive, my kysely GPT didn't solve this one

7 replies

•Created by elitan on 11/28/2023 in #help

Help with CTE query

Guess I need to use this: https://kysely.dev/docs/examples/SELECT/complex-selections

7 replies

•Created by elitan on 11/24/2023 in #help

Object literal may only specify known properties, and 'clientId' does not exist in type 'InsertObjec

Second option does not sound too bad. Good error messages for debugging is such a painkiller.

16 replies

•Created by elitan on 11/24/2023 in #help

Object literal may only specify known properties, and 'clientId' does not exist in type 'InsertObjec

ah, seems like LID/RID was a string but should be a number. Hard to debug these error messages.

16 replies

•Created by elitan on 11/24/2023 in #help

Object literal may only specify known properties, and 'clientId' does not exist in type 'InsertObjec

ok, so, uhm, what do I do? In the last link I do provide a value for all non-nullable fields but I still get the error.

16 replies

•Created by elitan on 11/24/2023 in #help

Object literal may only specify known properties, and 'clientId' does not exist in type 'InsertObjec

Updated: https://kyse.link/?p=s&i=OYPNRzrAU4HrhaXoRwUR

16 replies

•Created by elitan on 11/24/2023 in #help

Object literal may only specify known properties, and 'clientId' does not exist in type 'InsertObjec

Is the problem that I need to add all non-nullable and non-undefined fields in my insert?

16 replies

•Created by elitan on 11/24/2023 in #help

Object literal may only specify known properties, and 'clientId' does not exist in type 'InsertObjec

https://kyse.link/?p=s&i=xuoahFZZv6ja3sMgwtTo

16 replies

•Created by elitan on 11/3/2023 in #help

How to order by with embeddings using pgvector?

Thanks again @koskimas ❤️

10 replies

•Created by elitan on 11/3/2023 in #help

How to order by with embeddings using pgvector?

lol had to come back to this one 😄

10 replies

•Created by elitan on 11/3/2023 in #help

How to order by with embeddings using pgvector?

Now I can continue the work for https://1177.ai 😄

10 replies

•Created by elitan on 11/3/2023 in #help

How to order by with embeddings using pgvector?

Thanks that worked 🙏

10 replies

•Created by elitan on 11/3/2023 in #help

How to order by with embeddings using pgvector?

Inspired by: https://github.com/neondatabase/yc-idea-matcher/blob/main/src/app/api/idea/route.ts#L57

10 replies

•Created by elitan on 11/3/2023 in #help

How to order by with embeddings using pgvector?

Here's the generated sql:

select "id", "domain_path_id" from "embedding_chunks" order by embedding::VECTOR <=> '[$1]' limit $2

select "id", "domain_path_id" from "embedding_chunks" order by embedding::VECTOR <=> '[$1]' limit $2

10 replies

•Created by elitan on 9/20/2023 in #help

Kysely doesn't work in jest/test environment

Moved to vitest fixed it

4 replies

•Created by elitan on 7/18/2023 in #help

Build a basic Kysely Plugin

@Igal How do you imagine this "hint" approach to work? I'm not following exactly what you mean here.

12 replies

•Created by elitan on 7/18/2023 in #help

Build a basic Kysely Plugin

Been playing around with this now for some time and I don't think it's worth pursuing. To many cases to consider. Aliases are one. Not having the table name in the result is another. I'm starting to think that a "application level" encrypt/decrypt plugin is not the right match for Kysely

12 replies

•Created by elitan on 7/20/2023 in #help

camelCase plugin with a strangely named column

that's it

21 replies

•Created by elitan on 7/20/2023 in #help

camelCase plugin with a strangely named column

// convert wierd column names
const snakeLookup = {
  clCompanyID: 'cl_companyID',
} as Record<string, string>;

class CustomCamelCasePlugin extends CamelCasePlugin {
  protected override snakeCase(str: string): string {
    if (snakeLookup[str]) {
      return snakeLookup[str];
    }

    return super.snakeCase(str);
  }
}

// convert wierd column names
const snakeLookup = {
  clCompanyID: 'cl_companyID',
} as Record<string, string>;

class CustomCamelCasePlugin extends CamelCasePlugin {
  protected override snakeCase(str: string): string {
    if (snakeLookup[str]) {
      return snakeLookup[str];
    }

    return super.snakeCase(str);
  }
}

21 replies