# Use an official Python runtime as a parent image
FROM python:3.9-slim

# Set the working directory in the container
WORKDIR /app

# Install system dependencies
RUN apt-get update && apt-get install -y \
    libuv1-dev \
    && rm -rf /var/lib/apt/lists/*

# Install duckdb-server using pip
RUN pip install duckdb-server

# Create a non-root user and switch to it
RUN useradd -m duckdb
USER duckdb

# Make port 3000 available to the world outside this container
EXPOSE 3000

# Run duckdb-server
CMD ["duckdb-server"]