Adam Harris Comments - Convex Community

Adam Harris

•Created by Adam Harris on 8/24/2024 in #support-community

How to count a large set of results from a query?

Thanks very much for the detailed explanation. Yes it’s option 2 that we’re trying to figure out and from reading around other posts on the discord we were thinking we might need to push the data to somewhere like ClickHouse, but it’s great to have the confirmation here - thanks again

11 replies

CCConvex Community

•Created by Adam Harris on 8/24/2024 in #support-community

How to count a large set of results from a query?

Hi @jamwt, thanks for your suggestions! it doesn’t need to be high performance and ideally we need to be able to do this kind of thing ad-hoc for reporting, so keeping counts insertion won’t really work for us here unfortunately. We’re really missing sql-style ad-hoc aggregations at the moment. Can you please expand a bit on your orm-type table wrapper that you mentioned?

11 replies

CCConvex Community

•Created by RJ on 7/15/2024 in #support-community

Nested optional search field type error

@sshader sorry - I'm actually using zod validators (and copied over here without thinking much) and then using zodToConvex to make the convex validator, so that syntax is correct for a zod validator and it is being transformed to the correct convex validator. But thank you very much for your suggested workarounds! So it this a tracked issue/bug somewhere, so that I can keep an eye on it?

8 replies

CCConvex Community

•Created by RJ on 7/15/2024 in #support-community

Nested optional search field type error

Hi @RJ @sshader I think seeing the same error, but with a standard index. i.e. when I have a schema of the form:

    documents: defineTable({
      fieldOne: v.string(),
      fieldTwo: v.optional(v.object({
        subFieldOne: v.string().optional(),
      })),
    }).index("by_sub_field_one", ["fieldTwo.subFieldOne"]),

    documents: defineTable({
      fieldOne: v.string(),
      fieldTwo: v.optional(v.object({
        subFieldOne: v.string().optional(),
      })),
    }).index("by_sub_field_one", ["fieldTwo.subFieldOne"]),

and I do a query like:

 const data = await ctx.db
      .query("documents")
      .withIndex("by_sub_field_one", (q) =>
        q.eq(
            "fieldTwo.subFieldOne",
            "some string"
          // ^ Argument of type '"some string"' is not assignable to parameter of type 'undefined'.
          )
      )
      .collect();

 const data = await ctx.db
      .query("documents")
      .withIndex("by_sub_field_one", (q) =>
        q.eq(
            "fieldTwo.subFieldOne",
            "some string"
          // ^ Argument of type '"some string"' is not assignable to parameter of type 'undefined'.
          )
      )
      .collect();

I'm seeing the same error Argument of type '"some string"' is not assignable to parameter of type 'undefined'. Note the extra optional in subFieldOne: v.string().optional(). I expect that this error would still be there if I just had subFieldOne: v.string() but I thought I'd see what the status was before looking into a minimal reproducible example etc... What is the current state of the situation here? Has this been fixed anywhere, or do you have a suggested workaround?

8 replies

CCConvex Community

•Created by Adam Harris on 7/24/2024 in #support-community

Issue trying to import csv via Airbyte

Also here are the logs from that failed sync

4 replies

CCConvex Community

•Created by Adam Harris on 6/28/2024 in #support-community

Can't import snapshot to dev

@lee that worked thank you! (I misread the error message as there being documents in the table that conflict, rather than there being a table called documents....!)

9 replies

CCConvex Community

•Created by RJ on 9/19/2023 in #support-community

Codegen typings break when `exactOptionalPropertyTypes` is true

@RJ thanks for the confirmation! Maybe I'll just stick with Zod schemas for now then, since the integration with zod seems good...

23 replies

CCConvex Community

•Created by RJ on 9/19/2023 in #support-community

Codegen typings break when `exactOptionalPropertyTypes` is true

Hi @RJ @ballingt I'm just getting started with convex, looking to use effect-ts schema also and have just come across this issue. Is the recommended workaround still just to keep the exactOptionalPropertyTypes flag set to false?

23 replies

CCConvex Community

•Created by Adam Harris on 6/12/2024 in #support-community

How do I test http actions locally?

ah ok, that explains it - thank you! 👍

4 replies