FROM debian:bullseye

RUN useradd -m -u 1000 user
USER user
ENV HOME=/home/user \
	PATH=/home/user/.local/bin:$PATH

RUN apt-get update && apt-get install -y \
    wget unzip \
    && rm -rf /var/lib/apt/lists/*

RUN wget https://github.com/duckdb/duckdb/releases/download/v1.2.1/duckdb_cli-linux-amd64.zip \
    && unzip duckdb_cli-linux-amd64.zip -d /home/user/.local/bin \
    && rm duckdb_cli-linux-amd64.zip

RUN duckdb -c "INSTALL httpfs;"

CMD [ "duckdb", "--version"]