FROM node:18-bookworm-slim

WORKDIR /app

# better-sqlite3 may require native build toolchain on some platforms.
RUN apt-get update \
  && apt-get install -y --no-install-recommends python3 make g++ \
  && rm -rf /var/lib/apt/lists/*

COPY package*.json ./
RUN npm ci --omit=dev

COPY . .

RUN mkdir -p /app/database

ENV NODE_ENV=production
ENV HOST=0.0.0.0
ENV PORT=8088
ENV SQLITE_ENABLED=true
ENV SQLITE_PATH=/app/database/app.db

EXPOSE 8088

CMD ["node", "server.js"]
