UI Server option in duckdb CLI- To dockerize it

[g-kannan]

Hi Team,

I'm trying to dockerize duckdb UI but getting error xdg-open not found. Please suggest if there is an option like duckdb -uiserver? or other ways to dockerize this.

If possible, this could bring in a whole lot of possibilities. Thanks for building this.

 docker run -p 4213:4213 duckdb-ui
sh: 1: xdg-open: not found
┌────────────────────────────────────────────┐
│                   result                   │
│                  varchar                   │
├────────────────────────────────────────────┤
│ Navigate browser to http://localhost:4213/ │
└────────────────────────────────────────────┘

FROM debian:bullseye

# Install required dependencies
RUN apt-get update && apt-get install -y \
    wget unzip \
    && rm -rf /var/lib/apt/lists/*

# Download and install DuckDB using wget
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 \
    && chmod +x /usr/local/bin/duckdb

EXPOSE 4213

# Set DuckDB as the entrypoint
CMD ["duckdb", "-ui"]

[jraymakers]

You could try running duckdb without the -ui argument, and instead running call start_ui_server() to just start the server without trying to launch the browser. Then you could navigate your browser to http://localhost:4213.

[g-kannan]

Thanks @jraymakers , i changed to below but the docker exists while running it, could you please suggest how not to exit and keep it running.

CMD ["duckdb", "-c","CALL start_ui_server()"]

[jraymakers]

You can use -cmd instead of -c to keep it running.

[g-kannan]

Sorry i tried both but it didn't work

CMD ["duckdb", "-cmd","CALL start_ui_server()"] --docker exited
CMD ["sh", "-c", "duckdb -cmd 'CALL start_ui_server()' && tail -f /dev/null"] -- ui not working

[vcolmenar]

I resorted to using screen, gave up trying to persist it running in the container.

screen -dmS duckdb_ui /root/.duckdb/cli/latest/duckdb -ui

You can probably do the above combined with sleep infinity to keep the container running:

screen -dmS duckdb_ui /root/.duckdb/cli/latest/duckdb -ui && sleep infinity

I have it working here:
https://github.com/skyscopetech/duckdb-ui-remote-docker

[geoashis]

@vcolmenar Is it possible to deploy DuckDB UI in Google cloud with multi-user session mode?