Jacob Kim Comments - Convex Community

Jacob Kim

•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 Connor on 1/25/2024 in #support-community

server region

47 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

CCConvex Community

•Created by ballingt on 9/6/2024 in #general

Today you should just use

But for some reason, usePaginatedQuery does not cache to query result. By using it with Tanstack query, I thought it could help the cache issue. Seems like usePaginatedQuery deletes the cache once the component is unmounted.

7 replies

CCConvex Community

•Created by Jacob Kim on 8/7/2024 in #support-community

how to refresh JWTs before they expire

thanks for the response. I couldn't figure it out and now I moved away from nextjs to vite and everything is working fine 🤷‍♂️

10 replies

CCConvex Community

•Created by imightbejesus on 8/11/2024 in #support-community

await ctx.auth.getUserIdentity() returns null in http action

https://discord.com/channels/1019350475847499849/1270746067582980129 same issue reported here. this happened to me about a day ago.

38 replies

CCConvex Community

•Created by noob saibot on 8/7/2024 in #support-community

Convex auth: auth.getSessionId returns null

I have the same issue. Even though I can get my auth token with useAuthToken() in React, convex websocket requests do not have auth token in their messages. ctx.auth.getUserIdentity() in the server just returns null.

39 replies

CCConvex Community

•Created by Jacob Kim on 8/7/2024 in #support-community

how to refresh JWTs before they expire

I get this error on Convex dashboard.

Aug 09, 00:43:22

M auth:store error
'Invalid refresh token'

Aug 09, 00:43:22

M auth:store error
'Invalid refresh token'

This error occurs when refreshToken is null here. My question is, why would refreshToken be null in the first place?

10 replies

CCConvex Community

•Created by Jacob Kim on 8/7/2024 in #support-community

how to refresh JWTs before they expire

Do I need to have /app/api/auth/route.tsx ? It seems like convex already setup POST /api/auth endpoint. very puzzled. I guess I will have to dive in more to find a root cause. will report back if I find any.

10 replies