Skip to content

Instantly share code, notes, and snippets.

@mebaysan
Last active June 20, 2022 11:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mebaysan/d0caf6093dc4ab4c5d58f6d65bbedc19 to your computer and use it in GitHub Desktop.
Save mebaysan/d0caf6093dc4ab4c5d58f6d65bbedc19 to your computer and use it in GitHub Desktop.
A script file to start SQLPad on local machine by using Docker
#! /bin/bash
sudo docker run \
-v /home/mebaysan/Desktop/NorthwindDB.sqlite:/databases/NorthwindDB.sqlite \
--net=host \
--env SQLPAD_PORT=8000 \
--env SQLPAD_USERPASS_AUTH_DISABLED="false" \
--env SQLPAD_ADMIN="admin@admin.com" \
--env SQLPAD_ADMIN_PASSWORD="123." \
--env SQLPAD_CONNECTIONS__defaultcon__name="Nortwhind Conn" \
--env SQLPAD_CONNECTIONS__defaultcon__driver="sqlite" \
--env SQLPAD_CONNECTIONS__defaultcon__multiStatementTransactionEnabled="true" \
--env SQLPAD_CONNECTIONS__defaultcon__idleTimeoutSeconds=1 \
--env SQLPAD_CONNECTIONS__defaultcon__filename="/databases/NorthwindDB.sqlite" \
--env SQLPAD_CONNECTIONS__defaultcon__readonly="true" \
sqlpad/sqlpad
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment