Ophir LOJKINE
7bb11c16e8
* add a duckdb docker image * Add DuckDB ODBC driver installation and configuration Installs DuckDB ODBC driver and configures system-wide ODBC settings to enable DuckDB database connectivity for SQLPage. * add duckdb odbc info to readme * Fix CI digest artifact matching * Temporarily publish docker images on branch * Allow docker publish on branch (fix) * Temporarily run CI on branch pushes * Disable branch publish; fix duckdb inspect tag * Temporarily enable CI push on branch * Fix minimal tag suffix in docker_push * Disable temporary branch CI push
68 lines
2.0 KiB
Docker
68 lines
2.0 KiB
Docker
FROM --platform=$BUILDPLATFORM rust:1.91-slim AS builder
|
|
|
|
WORKDIR /usr/src/sqlpage
|
|
ARG TARGETARCH
|
|
ARG BUILDARCH
|
|
|
|
COPY scripts/ /usr/local/bin/
|
|
RUN cargo init .
|
|
|
|
RUN /usr/local/bin/setup-cross-compilation.sh "$TARGETARCH" "$BUILDARCH"
|
|
|
|
COPY Cargo.toml Cargo.lock ./
|
|
RUN /usr/local/bin/build-dependencies.sh
|
|
|
|
COPY . .
|
|
RUN /usr/local/bin/build-project.sh
|
|
|
|
# Default minimal image (busybox-based)
|
|
FROM busybox:glibc AS minimal
|
|
RUN addgroup --gid 1000 --system sqlpage && \
|
|
adduser --uid 1000 --system --no-create-home --ingroup sqlpage sqlpage && \
|
|
mkdir -p /etc/sqlpage && \
|
|
touch /etc/sqlpage/sqlpage.db && \
|
|
chown -R sqlpage:sqlpage /etc/sqlpage/sqlpage.db
|
|
ENV SQLPAGE_WEB_ROOT=/var/www
|
|
ENV SQLPAGE_CONFIGURATION_DIRECTORY=/etc/sqlpage
|
|
WORKDIR /var/www
|
|
COPY --from=builder /usr/src/sqlpage/sqlpage.bin /usr/local/bin/sqlpage
|
|
# Provide runtime helper libs in system lib directory for the glibc busybox base
|
|
COPY --from=builder /tmp/sqlpage-libs/* /lib/
|
|
USER sqlpage
|
|
COPY --from=builder --chown=sqlpage:sqlpage /usr/src/sqlpage/sqlpage/sqlpage.db sqlpage/sqlpage.db
|
|
EXPOSE 8080
|
|
CMD ["/usr/local/bin/sqlpage"]
|
|
|
|
# DuckDB ODBC image (debian-based with DuckDB ODBC driver)
|
|
FROM debian:trixie-slim AS duckdb
|
|
|
|
ARG TARGETARCH
|
|
ENV SQLPAGE_WEB_ROOT=/var/www
|
|
ENV SQLPAGE_CONFIGURATION_DIRECTORY=/etc/sqlpage
|
|
ENV DATABASE_URL="Driver=/opt/duckdb_odbc/libduckdb_odbc.so;Database=/var/lib/sqlpage/duckdb.db"
|
|
|
|
COPY scripts/install-duckdb-odbc.sh scripts/setup-sqlpage-user.sh /usr/local/bin/
|
|
|
|
RUN apt-get update && apt-get install -y --no-install-recommends \
|
|
ca-certificates \
|
|
curl \
|
|
unzip \
|
|
adduser \
|
|
odbcinst \
|
|
unixodbc \
|
|
&& /usr/local/bin/install-duckdb-odbc.sh "$TARGETARCH" \
|
|
&& apt-get purge -y --auto-remove curl unzip \
|
|
&& rm -rf /var/lib/apt/lists/*
|
|
|
|
RUN /usr/local/bin/setup-sqlpage-user.sh
|
|
|
|
COPY --from=builder /usr/src/sqlpage/sqlpage.bin /usr/local/bin/sqlpage
|
|
|
|
USER sqlpage
|
|
WORKDIR /var/www
|
|
EXPOSE 8080
|
|
CMD ["/usr/local/bin/sqlpage"]
|
|
|
|
# Default stage
|
|
FROM minimal
|