McPizza Posts - Answer Overflow

McPizza

Explore posts from servers

•Created by McPizza on 4/16/2024 in #✋｜help

Railway <> Hetzner servers cant communicate

We had a deployment running succesfully for the last week today, the railway instances cant communicate with the servers in Hetzner datacenter, and the otherway around is true too is there some way we can diagnose this? feels like railway has blocked the whole ip range

88 replies

DTDrizzle Team

•Created by McPizza on 9/8/2023 in #help

Subqueries with INSERT - errors

I'm trying to create an insert that uses a subquery

      const sq = db.select({id: orgs.id}).from(orgs).where(eq(orgs.publicId, input.orgPublicId)).as('sq');
      const insertOrgResponse = await db.insert(orgInvitations).values({
        orgId: sq.id,
        invitedByUserId: userId,
        publicId: newPublicId,
        role: input.role,
        inviteToken: nanoid(),
      })

      const sq = db.select({id: orgs.id}).from(orgs).where(eq(orgs.publicId, input.orgPublicId)).as('sq');
      const insertOrgResponse = await db.insert(orgInvitations).values({
        orgId: sq.id,
        invitedByUserId: userId,
        publicId: newPublicId,
        role: input.role,
        inviteToken: nanoid(),
      })

Getting type errors on orgId, seems its not detecting correct type of sq.id If I explicitly set sq.id to a number, no more errors Still need to queries though....

4 replies

DTDrizzle Team

•Created by McPizza on 9/7/2023 in #help

Relationships: Self one-one & one-many

9 replies

TtRPC

•Created by McPizza on 9/4/2023 in #❓-help

Calling a tRPC service from another tRPC service

I have 2 services (App1 and Service2) App1 is client facing and uses trpc well But occasionally App1 backend needs to call a procedure on Service2 Should I just use the vanilla client on App1 backend and import types/context from Service2? p.s. this is not Next ecosystem

5 replies

Gaming

Programming