FROM debian:bullseye

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 /usr/local/bin \
    && rm duckdb_cli-linux-amd64.zip

RUN useradd -m -u 1000 user
USER user
ENV HOME=/home/user
WORKDIR $HOME
RUN duckdb -c "INSTALL httpfs;"

CMD [ "duckdb", "-c", "LOAD httpfs; SELECT 'ready'"]