kubeapps:基于helm仓库快速部署应用的WebUI
octosql:跨数据库查询分析工具,当前支持JSON、CSV、PostgreSQL、MySQL、Redis 配置文件如下:
dataSources:
- name: cats
type: csv
config:
path: "~/Documents/cats.csv"
- name: people
type: redis
config:
address: "localhost:6379"
password: ""
databaseIndex: 0
databaseKeyName: "id"
sql:
octosql "SELECT p.city, FIRST(c.name), COUNT(DISTINCT c.name) cats, SUM(c.livesleft) catlives
FROM cats c JOIN people p ON c.ownerid = p.id
GROUP BY p.city
ORDER BY catlives DESC
LIMIT 9"
输出:
+---------+--------------+------+----------+
| p.city | c.name_first | cats | catlives |
+---------+--------------+------+----------+
| Warren | Zoey | 68 | 570 |
| Gadsden | Snickers | 52 | 388 |
| Staples | Harley | 54 | 383 |
| Buxton | Lucky | 45 | 373 |
| Bethany | Princess | 46 | 366 |
| Noxen | Sheba | 49 | 361 |
| Yorklyn | Scooter | 45 | 359 |
| Tuttle | Toby | 57 | 356 |
| Ada | Jasmine | 49 | 351 |
+---------+--------------+------+----------+
comments powered by Disqus