Dockerfile

# Use the official PostgreSQL image from the Docker Hub
FROM postgres:latest

# Install necessary build tools and dependencies
RUN apt-get update && \
    apt-get install -y \
    build-essential \
    postgresql-server-dev-all \
    cmake \
    git \
    curl

# Install vcpkg for managing dependencies
RUN git clone https://github.com/Microsoft/vcpkg.git /vcpkg && \
    /vcpkg/bootstrap-vcpkg.sh && \
    /vcpkg/vcpkg integrate install && \
    /vcpkg/vcpkg install json-c

# Set environment variables for vcpkg
ENV VCPKG_ROOT=/vcpkg
ENV VCPKG_TRIPLET=x64-linux
ENV VCPKG_INSTALLED=$VCPKG_ROOT/installed/$VCPKG_TRIPLET

# Copy the extension source code to the container
COPY . /usr/src/nostrpgx
WORKDIR /usr/src/nostrpgx

# Build the extension
RUN make

# Add the extension to the PostgreSQL configuration
RUN echo "shared_preload_libraries = 'nostrpgx'" >> /usr/share/postgresql/postgresql.conf.sample

# Expose the default PostgreSQL port
EXPOSE 5432

# Start PostgreSQL server
CMD ["postgres"]