一个快速和高效的数据接口:stickshift
jopen
10年前
Stickshift 是一个快速和高效的接口,帮助你分析在SQL查询结果的数据。数据可以导出成JSON、CSV和图表。
Stickshift能够让你保存SQL查询并在你的团队中进行共享。查询使用Hubdb存储在一个 GitHub仓库中,并基于GitHub API提供了一个封装。
架构
stickshiftis 使用 React, Flux, 和 React-Router 构建。 It's written in CommonJS & ES6 and cross-compiled with browserify & 6to5. Query storage is powered by hubdb.
Structure:
- src/components: UI components, like the chart, table, and query interface
- src/stores: Flux stores for saved queries & transient table information
- src/constants: Constants for actions, like 'received table results'
- lib/d3 & vega, for now, until vega builds are sorted
- Export query results to JSON & CSV
- Visualize some query results automatically
- Share and save queries
- Responsive on lil' screens