db folder is too big

[JaLe29]

I have simple prisma schema with 4 tables.

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator db {
  provider = "go run github.com/steebchen/prisma-client-go"
}

model Proxy {
  // ----------------------------------------------
  id        String   @id @default(auto()) @map("_id") @db.ObjectId
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  // ----------------------------------------------
  source    String
  target    String
  disable   Boolean
  cache     Boolean
  // guardActive     Boolean
 
  // Relation to Block
  blocks     Block[]

  // Relation to Allow
  allows Allow[]
  Guard  Guard[]
} 

model Block {
  // ----------------------------------------------
  id        String   @id @default(auto()) @map("_id") @db.ObjectId
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  // ----------------------------------------------
  ip        String   @db.String
  // ----------------------------------------------
  // Relation to Proxy
  proxy     Proxy?   @relation(fields: [proxyId], references: [id])
  proxyId   String?  @db.ObjectId
}

model Allow {
  // ----------------------------------------------
  id        String   @id @default(auto()) @map("_id") @db.ObjectId
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  // ----------------------------------------------
  ip        String   @db.String
  // ----------------------------------------------
  // Relation to Proxy
  proxy     Proxy?   @relation(fields: [proxyId], references: [id])
  proxyId   String?  @db.ObjectId
}

model Guard {
  // ----------------------------------------------
  id        String   @id @default(auto()) @map("_id") @db.ObjectId
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  // ----------------------------------------------
  email     String   @db.String
  password  String   @db.String
  // ----------------------------------------------
  // Relation to Proxy
  proxy     Proxy?   @relation(fields: [proxyId], references: [id])
  proxyId   String?  @db.ObjectId
}

After generate phase go run github.com/steebchen/prisma-client-go generate db folder is too big - 50mb.

I would like to pack my app into docker image, but I need to pack this 50mb of some mess into my docker image.

It's really necessary, or is there any better way?

I also checked https://goprisma.org/docs/reference/deploy/docker , but looks like my code is correct.

Docker file:

# Build
FROM golang:1.21.5-alpine as builder

WORKDIR /app

COPY go.mod                                 ./go.mod
COPY go.sum                                 ./go.sum
COPY main.go                                ./main.go
COPY pkg                                    ./pkg
COPY schema.prisma                          ./schema.prisma

RUN go mod download
RUN go run github.com/steebchen/prisma-client-go prefetch

RUN go run github.com/steebchen/prisma-client-go generate

RUN GOOS=linux GOARCH=amd64 CGO_ENABLED=0 go build -o build/main /app/main.go

# Production image
FROM gcr.io/distroless/static

COPY --from=builder /app/build/main     /main

CMD ["/main"]

Thank you!

[steebchen]

The reason it's so big is that the underlying query engine is packed into that folder as well which is then bundled into the Go repo at build time.

It is not needed to put this into the docker image at runtime, in fact it should not be done this way; you can and should ignore these files with .dockerignore (e.g. using *_gen.go or the db folder).

Let me know if this helps or if you still have concerns.

[JaLe29]

Thank you for your reply.

I am not sure if dockerignore will help there.

Command RUN go run github.com/steebchen/prisma-client-go generate will generate new one.

And looks like this *_gen.g is compiled into binary file.

RUN go run github.com/steebchen/prisma-client-go generate # <----------------------------- will create *_gen.go
# or, if you use go generate to run the generator, use the following line instead
# RUN go generate ./...
 
# build a fully standalone binary with zero dependencies
RUN CGO_ENABLED=0 GOOS=linux go build -a -installsuffix cgo -ldflags '-extldflags "-static"' -o app .

I also tryed to remove *_gen.go before build phase but build will fail without this *_gen.go

RUN go run github.com/steebchen/prisma-client-go generate
RUN rm ./db/*_gen.go

RUN GOOS=linux GOARCH=amd64 CGO_ENABLED=0 go build -a -installsuffix cgo -ldflags '-extldflags "-static"' -o build/main /app/main.go

| ERROR: failed to solve: process "/bin/sh -c GOOS=linux GOARCH=amd64 CGO_ENABLED=0 go build -a -installsuffix cgo -ldflags '-extldflags "-static"' -o build/main /app/main.go" did not complete successfully: exit code: 1

[steebchen]

Yes, maybe that was not clear, it needs to be generated inside the docker file, as the Go client needs the Prisma engine as that is what it's built on. If you do not want a bigger binary, you can always use a different ORM which only uses native code and doesn't rely on any engine.