Docker support

[eandersson]

I use Docker to run this locally, but the workflow with postgres makes it a bit awkward to work with. Would it be possible add Docker support for building and deploying easier locally?

Right now I do something like this, but it is not ideal that the build process requires a db connection string.

FROM node:22-bookworm AS build

WORKDIR /build
COPY . .

ENV DATABASE_URL="postgresql://ckstats:<password>@192.168.0.100:5432/ckstats"
RUN npm install && npm run build

FROM node:22-bookworm

ENV DATABASE_URL="postgresql://ckstats:<password>@192.168.0.100:5432/ckstats"
ENV API_URL="http://192.168.0.100:8000/api/v1"
WORKDIR /ckstats

COPY --from=build /build .

[mrv777]

I can take a look into this. Right now trying to optimize it as there is a memory issue, but can look at this after.
Would you want it to use a different db like sqlite so postgres isn't needed too? (Not sure how the performance will be with sqlite)

[eandersson]

I use postgres for my setup. No rush as it's already working, but just a bit messy.

[peacechen]

Docker compose could be used to spin up a pg container. Share a network between them and connect directly.

[pdath]

I use Docker Compose, and deploy a seperate PostgreSQL instance.