How i use pglite on docker by alpine image ?

[seepine]

I use bun + elysia + drizzle-orm + pglite, and i run direct bun run src/index.ts, it can auto create pglite.data dir.

import { PGlite } from '@electric-sql/pglite'
import { drizzle } from 'drizzle-orm/pglite'

      const client = new PGlite('pglite.data')
      const db = drizzle({ client, schema, casing: 'snake_case' })

I use it on docker

FROM bun:alpine AS build
WORKDIR /work
COPY package.json bun.lock bunfig.toml tsconfig.json ./
RUN bun install
COPY ./src ./src
RUN bun run build

## js runtime, bun run build -js
FROM bun:alpine
WORKDIR /work
COPY --from=build /work/dist ./
COPY ./drizzle ./drizzle
ENTRYPOINT ["bun", "run", "index.js"]

I got error

elysia-template-1  | EISDIR: illegal operation on a directory, read
elysia-template-1  |       fd: 15,
elysia-template-1  |  syscall: "read",
elysia-template-1  |    errno: -21,
elysia-template-1  |     code: "EISDIR"
elysia-template-1  | 
elysia-template-1  | 36 |   async queryWithCache(queryString, params, query) {
elysia-template-1  | 37 |     if (this.cache === void 0 || is(this.cache, NoopCache) || this.queryMetadata === void 0) {
elysia-template-1  | 38 |       try {
elysia-template-1  | 39 |         return await query();
elysia-template-1  | 40 |       } catch (e) {
elysia-template-1  | 41 |         throw new DrizzleQueryError(queryString, params, e);
elysia-template-1  |                    ^
elysia-template-1  | error: Failed query: CREATE SCHEMA IF NOT EXISTS "drizzle"
elysia-template-1  | params: 
elysia-template-1  |   query: "CREATE SCHEMA IF NOT EXISTS \"drizzle\"",
elysia-template-1  |  params: [],
elysia-template-1  | 
elysia-template-1  |       at queryWithCache (/node_modules/drizzle-orm/pg-core/session.js:41:15)
elysia-template-1  | 
elysia-template-1  | EISDIR: illegal operation on a directory, read
elysia-template-1  |       fd: 15,
elysia-template-1  |  syscall: "read",
elysia-template-1  |    errno: -21,
elysia-template-1  |     code: "EISDIR"
elysia-template-1  | 
elysia-template-1  | 
elysia-template-1  | Bun v1.3.9 (Linux arm64)
elysia-template-1 exited with code 1

my package.json

  "dependencies": {
    "@electric-sql/pglite": "^0.3.15",
    "drizzle-orm": "^0.45.1"
  }

[tdrz]

i run direct bun run src/index.ts, it can auto create pglite.data dir.

What does this mean? pglite.data cannot be "autocreated", it's an artifact created during the build process.

[seepine]

The problem is that the same code runs fine in the dev environment, but fails when packaged in Docker.

[seepine]

The minimum reproducing case.

bun init
bun add @electric-sql/pglite

Touch index.ts

import { PGlite } from '@electric-sql/pglite'

const client = new PGlite(process.env.DATABASE_URL)
client.exec('SELECT 1').then((res) => console.log(res))

Create Dockerfile

FROM oven/bun:alpine AS build
WORKDIR /work
COPY package.json tsconfig.json ./
RUN bun install
COPY index.ts index.ts
RUN bun build index.ts --outdir dist
ENTRYPOINT ["bun", "run", "dist/index.js"]

Dev

$ bun run index.ts                
[
  {
    rows: [
      [Object ...]
    ],
    fields: [
      [Object ...]
    ],
    affectedRows: 0,
  }
]

In docker

elysia-pglite-1  | ENOENT: no such file or directory, open '/work/dist/pglite.data'
elysia-pglite-1  |     path: "/work/dist/pglite.data",
elysia-pglite-1  |  syscall: "open",
elysia-pglite-1  |    errno: -2,
elysia-pglite-1  |     code: "ENOENT"
elysia-pglite-1  | 
elysia-pglite-1  | ENOENT: no such file or directory, open '/work/dist/pglite.data'
elysia-pglite-1  |     path: "/work/dist/pglite.data",
elysia-pglite-1  |  syscall: "open",
elysia-pglite-1  |    errno: -2,
elysia-pglite-1  |     code: "ENOENT"
elysia-pglite-1  | 
elysia-pglite-1  | 
elysia-pglite-1  | Bun v1.3.9 (Linux arm64)
elysia-pglite-1 exited with code 1

[seepine]

Maybe pglite not support bun build?
Change dockerfile direct run can work.

FROM oven/bun AS build
WORKDIR /work
COPY package.json bun.lock bunfig.toml tsconfig.json ./
RUN bun install
COPY index.ts index.ts
#RUN bun build index.ts --outdir dist
#ENTRYPOINT ["bun", "run", "dist/index.js"]
ENTRYPOINT ["bun", "run", "index.ts"]

elysia-pglite-1  | [
elysia-pglite-1  |   {
elysia-pglite-1  |     rows: [
elysia-pglite-1  |       [Object ...]
elysia-pglite-1  |     ],
elysia-pglite-1  |     fields: [
elysia-pglite-1  |       [Object ...]
elysia-pglite-1  |     ],
elysia-pglite-1  |     affectedRows: 0,
elysia-pglite-1  |   }
elysia-pglite-1  | ]