abdullahislam_ Comments - Convex Community

abdullahislam_

Posts Comments

CCConvex Community

•Created by erquhart on 7/11/2024 in #support-community

Record counts for large numbers of records is non-trivial

This is exactly what I'm looking for - and I love the "convex approach" to this.

23 replies

CCConvex Community

•Created by abdullahislam_ on 7/10/2024 in #support-community

Filter scanning entire table - any alternative to withIndex?

Update: This seems to be working wonders for me: Run a query for just email on using a withIndex("by_email") Run another query for anonId using a withIndex("by_anonId")

3 replies

CCConvex Community

•Created by abdullahislam_ on 6/29/2024 in #support-community

De-duplicate table with existing values

So instead of returning, I would just put it in a const and do a promise all on await ctx.db.delete(DOC_ID_FROM_MAP); ?

6 replies

CCConvex Community

•Created by abdullahislam_ on 6/29/2024 in #support-community

De-duplicate table with existing values

Ah got it. So something like this should work:

interface CityObject {
  city: string;
  [key: string]: any;
}

function deduplicateCities<T extends CityObject>(arr: T[]): T[] {
  return Array.from(
    new Map(arr.map(item => [item.city, item])).values()
  );
}

interface CityObject {
  city: string;
  [key: string]: any;
}

function deduplicateCities<T extends CityObject>(arr: T[]): T[] {
  return Array.from(
    new Map(arr.map(item => [item.city, item])).values()
  );
}

6 replies

CCConvex Community

•Created by Joseph_Ebuka on 12/14/2023 in #support-community

How do i get a type of date

This is brilliant. Really appreciate this 👌

18 replies

CCConvex Community

•Created by abdullahislam_ on 2/18/2024 in #support-community

Upsert feature in convex?

Thanks. The support here is amazing!

5 replies

CCConvex Community

•Created by Joseph_Ebuka on 12/14/2023 in #support-community

How do i get a type of date

Thank you. I'll try this. I've already uploaded all my data that have dates stored with slashes e.g. "01/01/2024" - is there a function or something I can write to loop through and edit those dates or should I just re-upload?

18 replies

CCConvex Community

•Created by Joseph_Ebuka on 12/14/2023 in #support-community

How do i get a type of date

Following up on this - I have dates stored in the DB as strings e.g. "01/15/2024". I'm trying to use the q.gte("date_start", startdate) for example but seem to be missing the parsing. I can parse the date type of startdate passed in, but does it work with gte?

18 replies