duckdb-share.sh

set -e

DB_FILE_FULL_PATHG=$1
DB_FILE_PARENT_FOLDER=$(dirname $DB_FILE_FULL_PATHG)
DB_FILE_NAME=$(basename $DB_FILE_FULL_PATHG)

ngrok http file://$DB_FILE_PARENT_FOLDER --log=stdout >/dev/null &

sleep 1

PUBLIC_URL=$(curl -sS http://localhost:4040/api/tunnels | jq -r '.tunnels[0].public_url')
NGROK_URL="$PUBLIC_URL/$DB_FILE_NAME"

echo "Database file $DB_FILE_NAME is now being shared, to connect in DuckDB execute:"
echo "> load httpfs; attach '$NGROK_URL';"

echo "To kill the share, execute:"
echo "> kill -9 $(ps aux | grep ngrok | grep -v grep | awk '{print $2}')"

./duckdb-share.sh path/to/duck.db

Database file test.db is shared, to connect in DuckDB execute:
> load httpfs; attach 'https://d3a0-209-35-224-123.ngrok-free.app/duck.db';

To kill ngrok, execute:
> kill -9 42114