好项目记录

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