Archery

SQL 审核查询平台

功能清单

快速开始

系统体验

在线体验

Docker

参考 https://github.com/hhyo/archery/wiki/docker

手动安装

https://github.com/hhyo/archery/wiki/manual

运行测试

python manage.py test -v 3

依赖清单

框架

• https://github.com/django/django
• https://github.com/twbs/bootstrap
• https://github.com/jquery/jquery

前端组件

• 菜单栏 https://github.com/onokumus/metismenu
• 主题 https://github.com/BlackrockDigital/startbootstrap-sb-admin-2
• 编辑器 https://github.com/ajaxorg/ace
• SQL美化 https://github.com/zeroturnaround/sql-formatter
• 表格 https://github.com/wenzhixin/bootstrap-table
• 表格编辑 https://github.com/vitalets/x-editable
• 下拉菜单 https://github.com/snapappointments/bootstrap-select
• 文件上传 https://github.com/kartik-v/bootstrap-fileinput
• 时间选择 https://github.com/smalot/bootstrap-datetimepicker
• 日期选择 https://github.com/dangrossman/daterangepicker
• 开关 https://github.com/Bttstrp/bootstrap-switch
• Markdown展示 https://github.com/markedjs/marked

服务端

• 队列任务 https://github.com/Koed00/django-q
• MySQL Connector https://github.com/PyMySQL/mysqlclient-python
• MsSQL Connector https://github.com/mkleehammer/pyodbc
• Redis Connector https://github.com/andymccurdy/redis-py
• PostgreSQL Connector https://github.com/psycopg/psycopg2
• Oracle Connector https://github.com/oracle/python-cx_Oracle
• MongoDB Connector https://github.com/mongodb/mongo-python-driver
• Phoenix Connector https://github.com/lalinsky/python-phoenixdb
• ODPS Connector https://github.com/aliyun/aliyun-odps-python-sdk
• ClickHouse Connector https://github.com/mymarilyn/clickhouse-driver
• TDengine Connector https://github.com/taosdata/taos-connector-python
• SQL解析/切分/类型判断 https://github.com/andialbrecht/sqlparse
• MySQL Binlog解析/回滚 https://github.com/noplay/python-mysql-replication
• LDAP https://github.com/django-auth-ldap/django-auth-ldap
• 序列化 https://github.com/simplejson/simplejson
• 时间处理 https://github.com/paxan/python-dateutil

功能依赖

• 可视化 https://github.com/pyecharts/pyecharts
• MySQL审核/执行/备份 https://github.com/hanchuanchuan/goInception%7Chttps://github.com/hhyo/inception
• MySQL索引优化 https://github.com/Meituan-Dianping/SQLAdvisor
• SQL优化/压缩 https://github.com/XiaoMi/soar
• My2SQL https://github.com/liuhr/my2sql
• 表结构同步 https://github.com/hhyo/SchemaSync
• 慢日志解析展示 pt-query-digest|https://github.com/thinkdb/aquila_v2
• 大表DDL https://github.com/github/gh-ost%7Cpt-online-schema-change
• MyBatis XML解析 https://github.com/hhyo/mybatis-mapper2sql
• RDS管理 https://github.com/aliyun/aliyun-openapi-python-sdk
• 数据加密 https://github.com/luojilab/django-mirage-field

贡献代码

可查阅主页的开发计划以及依赖清单，在对应Issues中回复认领，或者直接提交PR，感谢你对Archery的贡献

贡献包括但不限于以下方式：

• https://github.com/hhyo/Archery/wiki%EF%BC%88%E5%BC%80%E6%94%BE%E7%BC%96%E8%BE%91%EF%BC%89
• Bug修复
• 新功能提交
• 代码优化
• 测试用例完善

交流反馈

• 使用咨询、需求沟通：https://github.com/hhyo/Archery/discussions
• Bug提交：https://github.com/hhyo/archery/issues

致谢

• https://github.com/jly8866/archer Archery 项目是基于 archer 二次开发而来
• https://github.com/hanchuanchuan/goInception 一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
• JetBrains Open Source 为项目提供免费的 IDE 授权