melodyclue Comments - Answer Overflow

Topics

melodyclue

Explore posts from servers

TtRPC DTDrizzle Team

CDCloudflare Developers

•Created by mw10013 on 3/24/2024 in #d1-database

GitHub - mw10013/remix-auth-totp-cloudfl...

@mw10013 Understood. For now, it seems like local development is possible. Thank you.

5 replies

CDCloudflare Developers

•Created by mw10013 on 3/24/2024 in #d1-database

GitHub - mw10013/remix-auth-totp-cloudfl...

@mw10013 I see. I couldn't find in the documentation that to reference the local DB, we need to include a dummy database_id. Is there such a thing?

5 replies

CDCloudflare Developers

•Created by mw10013 on 3/24/2024 in #d1-database

GitHub - mw10013/remix-auth-totp-cloudfl...

@mw10013 Thank you! It worked after I followed your code. local bindings" can be a hypothetical name like "intentionally-dummy-id-leave-as-is"?

5 replies

•Created by melodyclue on 2/28/2024 in #help

Followers count

i want users I followed

7 replies

•Created by melodyclue on 2/28/2024 in #help

Followers count

I don't have full table but like this...

export const followers = mysqlTable("followers", {
    userId: varchar("user_id", { length: 255 }).notNull(),
    followerId: varchar("follower_id", { length: 255 }).notNull(),
})

export const followers = mysqlTable("followers", {
    userId: varchar("user_id", { length: 255 }).notNull(),
    followerId: varchar("follower_id", { length: 255 }).notNull(),
})

7 replies

•Created by melodyclue on 2/28/2024 in #help

Followers count

@solo I also want information about people I follow and like, so I store it in the JUNCTION TABLE. So by counting the number of records in the condition, that is the number of followers and likes

7 replies

•Created by melodyclue on 2/23/2024 in #help

json_arrayagg(json_array ...

I think json_object is right one, not json_array

2 replies

•Created by davebanana on 11/22/2023 in #help

How to inspect generated query?

Can the log be coloured according to query or mutation?

6 replies

•Created by mrnicericee on 9/18/2023 in #help

Dropping mysql unique errors

I have the same problem!

2 replies

•Created by melodyclue on 7/20/2023 in #❓-help

Sometimes invalidate not work...

@David ok figured out! you're right David. And this issue (invalidate not works) is fully resolved !!! https://trpc.io/docs/client/react/getQueryKey trpcold

trpcold

22 replies

•Created by melodyclue on 7/20/2023 in #❓-help

Sometimes invalidate not work...

@David I think await queryClient.invalidateQueries(getQueryKey(trpc.path.to.query)) is the way how it works on v9 🤔

22 replies

•Created by melodyclue on 7/20/2023 in #❓-help

Sometimes invalidate not work...

@David oh you are talking about v9. mine is v10 actually...

22 replies

•Created by melodyclue on 7/20/2023 in #❓-help

Sometimes invalidate not work...

@David so useQueryClient is the key to solve this problrem? I will try !

22 replies

•Created by melodyclue on 7/20/2023 in #❓-help

Sometimes invalidate not work...

@David 🧐 no, I dont use QueryClientProviders. instead I use export default trpc.withTRPC(App)

22 replies