基于 v1.0.1 版本
Dockerfile: https://code.aliyun.com/wangdong/docker-redash/raw/master/Dockerfile
docker pull registry.cn-hangzhou.aliyuncs.com/wangdong/redash
docker run --name redash -p 5000:5000 registry.cn-hangzhou.aliyuncs.com/wangdong/redash start
浏览器访问 http://127.0.0.1:5000/setup 进行设置
默认先初始化数据库
docker run --name redash -p 5000:5000 \
-e REDASH_HOST=http://127.0.0.1:5000 \
-e REDASH_DATABASE_URL=postgresql://postgres:postgres@127.0.0.1:5432/postgres \
-e REDASH_REDIS_URL=redis://127.0.0.1:6379/0 \
registry.cn-hangzhou.aliyuncs.com/wangdong/redash start
不初始化数据库
docker run --name redash -p 5000:5000 \
-e REDASH_HOST=http://127.0.0.1:5000 \
-e REDASH_DATABASE_URL=postgresql://postgres:postgres@127.0.0.1:5432/postgres \
-e REDASH_REDIS_URL=redis://127.0.0.1:6379/0 \
registry.cn-hangzhou.aliyuncs.com/wangdong/redash run
docker run --name redash -p 5000:5000 \
-e REDASH_HOST=http://127.0.0.1:5000 \
-e REDASH_MAIL_SERVER=smtp-mail.outlook.com \
-e REDASH_MAIL_PORT=587 \
-e REDASH_MAIL_USE_TLS=true \
-e REDASH_MAIL_USE_SSL=false \
-e REDASH_MAIL_USERNAME=yourname@outlook.com \
-e REDASH_MAIL_PASSWORD=123456 \
-e REDASH_MAIL_DEFAULT_SENDER=yourname@outlook.com \
registry.cn-hangzhou.aliyuncs.com/wangdong/redash start
字段 | 说明 |
---|---|
::filter | 单选框筛选 |
::multiFilter | 多选框筛选 |
::keywordFilter | 关键字模糊筛选(独有功能) |
::betweenFilter | 字段范围筛选(独有功能) |
使用方法
SELECT count(1) AS `人数::betweenFilter` FROM users