Jacob Kim
CCConvex Community
•Created by abldxtr001 on 1/3/2025 in #support-community
implement optimistic updates for a paginated query
oh very cool thanks for letting me know
15 replies
CCConvex Community
•Created by abldxtr001 on 1/3/2025 in #support-community
implement optimistic updates for a paginated query
did you guys find a nice solution for this?
15 replies
CCConvex Community
•Created by Jacob Kim on 5/9/2025 in #support-community
how do I do optimistic update with a paginated query?
ok it seems like this has already been discussed, but it is not resolved.
https://discord.com/channels/1019350475847499849/1324674398258593833
Has there been any updates to this?
3 replies
CCConvex Community
•Created by Jacob Kim on 1/19/2025 in #support-community
Convex on my lambda
Oh of course! forgot that most of the convex usecase is calling from user's client. thanks for the detailed answer @Lee !
8 replies
CCConvex Community
•Created by Jacob Kim on 1/19/2025 in #support-community
Convex on my lambda
just my home grown auth key between the lambda and convex functions?
8 replies
CCConvex Community
•Created by Jacob Kim on 1/19/2025 in #support-community
Convex on my lambda
hi thanks for the response. so I don’t need any “CONVEX PRODUCTION KEY” or anything?
8 replies
CCConvex Community
•Created by Jacob Kim on 9/12/2024 in #general
For language other than English, Korean
Ah of course, I always forget that SQL isn't magic.
1. If I do the filtering logic in JS, I assume it will cause higher "action compute" charge?
2. I didn't know about this extension, so thanks for letting me know. Seems like
pg_trgm only supports alphabetical languages (no Korean, Japanese, Chinese, etc). But pg_bigm seems to support Korean as well.
I guess my current best bet is to implement an efficient text search function with JS.9 replies
CCConvex Community
•Created by Jacob Kim on 9/12/2024 in #general
For language other than English, Korean
sorry for the late response @sujayakar .
my query string won't always be a single character. I tested and seems like query string starts working when the query string length is greater than 5.
For instance:
actual string: 가나다라마바
The following works because of prefix matching:
-
가
- 가나
- 가나다...
The following does not work: (this is substring from index 1)
- 나
- 나다
- 나다라
- 나다라마
This starts working:
- 나다라마바
Since convex does not have LIKE %STR% like regular SQL, is the only option for text search the search index? Should I use other DB if I am using non-english language?9 replies
CCConvex Community
•Created by Jacob Kim on 9/12/2024 in #general
For language other than English, Korean
so here is an example Korean string
"가나다라"
- I search for "가" (first index) it correctly performs a prefix search.
- I search for "나" or "다" (2nd and 3rd index) returns nothing.
Not sure how typo tolerance work with Korean either. I would really love to be able to just run
String.prototype.includes() with serachIndex. Don't even need fancy fuzzy search and typo tolerancy.9 replies
CCConvex Community
•Created by Jacob Kim on 9/9/2024 in #support-community
neq condition for `withIndex`
I see thanks for the detailed response
19 replies
CCConvex Community
•Created by Jacob Kim on 9/9/2024 in #support-community
neq condition for `withIndex`
I doubt there is any meaningful difference here but I’m curious.
if I change the schema from strings to 0, 1, 2(numbers), I could run the query in a single gt(). Would this change be better for storage & query performance?
19 replies
CCConvex Community
•Created by Jacob Kim on 9/9/2024 in #support-community
neq condition for `withIndex`
Is there any performance hit when I run two indexed queries instead of just one indexed query?
19 replies
CCConvex Community
•Created by ballingt on 9/6/2024 in #general
Today you should just use
I guess that's the only solution so far. Will usePaginatedQuery support tanstack in the future?
7 replies