sqlite-web Docker & Self-Hosted Deployment

GitHub

Web-based SQLite database browser written in Python

4,173 stars Python Python 1 file · ~1,569 tokens #database#flask#python#sqlite
1. Pull Image (DOCKERHUB) docker pull coleifer/sqlite-web:latest
2. Docker Run (1-Click Launch) docker run -d --name sqlite-web -p 8080:8080 --restart always coleifer/sqlite-web:latest
3. Podman Run podman run -d --name sqlite-web -p 8080:8080 --restart always coleifer/sqlite-web:latest
4. Skopeo Inspect (Zero-Pull Manifest) skopeo inspect docker://docker.io/coleifer/sqlite-web:latest
5. ORAS Pull (OCI Artifact) oras pull coleifer/sqlite-web:latest
docker/Dockerfile 
FROM python:3-alpine3.23
ENV CFLAGS="-DSQLITE_DEFAULT_CACHE_SIZE=-8000 \
            -DSQLITE_DEFAULT_FOREIGN_KEYS=1 \
            -DSQLITE_DEFAULT_MEMSTATUS=0 \
            -DSQLITE_DEFAULT_PAGE_SIZE=4096 \
            -DSQLITE_DEFAULT_SYNCHRONOUS=0 \
            -DSQLITE_DEFAULT_WAL_SYNCHRONOUS=0 \
            -DSQLITE_DISABLE_DIRSYNC \
            -DSQLITE_ENABLE_COLUMN_METADATA \
            -DSQLITE_ENABLE_DESERIALIZE \
            -DSQLITE_ENABLE_FTS3 \
            -DSQLITE_ENABLE_FTS3_PARENTHESIS \
            -DSQLITE_ENABLE_FTS4 \
            -DSQLITE_ENABLE_FTS5 \
            -DSQLITE_ENABLE_JSON1 \
            -DSQLITE_ENABLE_MEMDB \
            -DSQLITE_ENABLE_STAT4 \
            -DSQLITE_ENABLE_STMTVTAB \
            -DSQLITE_ENABLE_UNLOCK_NOTIFY \
            -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
            -DSQLITE_LIKE_DOESNT_MATCH_BLOBS \
            -DSQLITE_MAX_EXPR_DEPTH=0 \
            -DSQLITE_SOUNDEX \
            -DSQLITE_STMTJRNL_SPILL=-1 \
            -DSQLITE_TEMP_STORE=3 \
            -DSQLITE_USE_ALLOCA \
            -DSQLITE_USE_URI \
            -DSQLITE_DEFAULT_WAL_AUTOCHECKPOINT=512 \
            -DHAVE_USLEEP \
            -O2 -fPIC"
RUN apk update \
      && apk add --no-cache --virtual .build-deps build-base libressl coreutils gcc libc-dev linux-headers make tar wget tcl tcl-dev dpkg dpkg-dev \
      && wget https://www.sqlite.org/src/tarball/sqlite.tar.gz?r=release -O sqlite.tar.gz -q \
      && tar xzf sqlite.tar.gz \
      && cd sqlite \
      && buildArch="$(dpkg-architecture --query DEB_BUILD_GNU_TYPE)" \
      && LIBS="-lm" PREFIX="/usr/local" ./configure --build="$buildArch" --disable-tcl --enable-shared --enable-static --prefix="/usr/local" \
      && make -j4 \
      && make install \
      && cd ../ \
      && rm -rf ./sqlite/ ./sqlite.tar.gz \
      && pip install --upgrade pip \
      && pip install --no-cache-dir cython gevent \
      && pip install --no-cache-dir flask peewee pygments \
      && apk del .build-deps
COPY . /src
RUN pip install --no-cache-dir /src && rm -rf /src
EXPOSE 8080
VOLUME /data
WORKDIR /data
ENTRYPOINT ["sqlite_wsgi", "-H", "0.0.0.0"]