GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — GitHub - hhyo/Archery: SQL 审核查询平台

BranchesTags
Open more actions menu

Latest commit

 

History

2,116 Commits
2,116 Commits

Folders and files

NameName
Last commit message
Last commit date
.agents/skills
.agents/skills
 
 
.github
.github
 
 
.specify
.specify
 
 
archery
archery
 
 
common
common
 
 
docs
docs
 
 
downloads
downloads
 
 
logs
logs
 
 
scripts
scripts
 
 
specs
specs
 
 
sql
sql
 
 
sql_api
sql_api
 
 
src
src
 
 
.dockerignore
.dockerignore
 
 
.env.list
.env.list
 
 
.gitattributes
.gitattributes
 
 
.gitignore
.gitignore
 
 
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
 
 
CONTRIBUTING.md
CONTRIBUTING.md
 
 
LICENSE
LICENSE
 
 
README.md
README.md
 
 
admin.sh
admin.sh
 
 
conftest.py
conftest.py
 
 
debug.sh
debug.sh
 
 
dev-requirements.txt
dev-requirements.txt
 
 
manage.py
manage.py
 
 
masking.sh
masking.sh
 
 
pyproject.toml
pyproject.toml
 
 
requirements.txt
requirements.txt
 
 
startup.sh
startup.sh
 
 
supervisord.conf
supervisord.conf
 
 

Repository files navigation

Archery

SQL 审核查询平台

Django CI Release codecov version version Publish Docker image docker_pulls License Code style: black

文档 | FAQ | Releases

功能清单

数据库 查询 审核 执行 备份 数据字典 慢日志 会话管理 账号管理 参数管理 数据归档
MySQL √ √ √ √ √ √ √ √ √ √
MariaDB √ √ √ √ √ √ √ √ √ √
MsSQL √ × √ × √ × × × × ×
Redis √ × √ × × × × × × ×
PgSQL √ × √ × × × × × × ×
Oracle √ √ √ √ √ × √ × × ×
MongoDB √ √ √ × × × √ √ × ×
Phoenix √ × √ × × × × × × ×
ODPS √ × × × × × × × × ×
ClickHouse √ √ √ × × × × × × ×
Cassandra √ × √ × × × × × × ×
Doris √ × √ × × × √ × × ×
Elasticsearch √ × √ × × × × × × ×
OpenSearch √ × √ × × × × × × ×
Memcached √ × √ × × × × × × ×
TDengine √ √ √ × × × √ × × ×

快速开始

系统体验

在线体验

账号 密码
archer archer

Docker

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

手动安装

部署说明

运行测试

pytest -q
# 或按模块执行
pytest -q sql common sql_api

依赖清单

框架

  • Django
  • Bootstrap
  • jQuery

前端组件

  • 菜单栏 metisMenu
  • 主题 sb-admin-2
  • 编辑器 ace
  • SQL美化 sql-formatter
  • 表格 bootstrap-table
  • 表格编辑 bootstrap-editable
  • 下拉菜单 bootstrap-select
  • 文件上传 bootstrap-fileinput
  • 时间选择 bootstrap-datetimepicker
  • 日期选择 daterangepicker
  • 开关 bootstrap-switch
  • Markdown展示 marked

服务端

  • 队列任务 django-q
  • MySQL Connector mysqlclient-python
  • MsSQL Connector pyodbc
  • Redis Connector redis-py
  • PostgreSQL Connector psycopg2
  • Oracle Connector cx_Oracle
  • MongoDB Connector pymongo
  • Phoenix Connector phoenixdb
  • ODPS Connector pyodps
  • ClickHouse Connector clickhouse-driver
  • TDengine Connector tdengine-driver
  • SQL解析/切分/类型判断 sqlparse
  • MySQL Binlog解析/回滚 python-mysql-replication
  • LDAP django-auth-ldap
  • 序列化 simplejson
  • 时间处理 python-dateutil

功能依赖

  • 可视化 pyecharts
  • MySQL审核/执行/备份 goInception|inception
  • MySQL索引优化 SQLAdvisor
  • SQL优化/压缩 SOAR
  • My2SQL my2sql
  • 表结构同步 SchemaSync
  • 慢日志解析展示 pt-query-digest|aquila_v2
  • 大表DDL gh-ost|pt-online-schema-change
  • MyBatis XML解析 mybatis-mapper2sql
  • RDS管理 aliyun-openapi-python-sdk
  • 数据加密 django-mirage-field

贡献代码

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

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

  • Wiki文档(开放编辑)
  • Bug修复
  • 新功能提交
  • 代码优化
  • 测试用例完善

交流反馈

  • 使用咨询、需求沟通:Discussions
  • Bug提交:Issues

致谢

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

About

SQL 审核查询平台

archerydms.com

Topics

archerybinlog2sqlclickhousedata-maskingdatabase-schemaddldmlgh-ostinceptionmysqloraclesql-auditsql-query

Resources

Readme
Apache-2.0 license

Code of conduct

Code of conduct

Contributing

Contributing
Activity

Stars

7.1k stars

Watchers

124 watching

Forks

1.9k forks
Report repository

Releases

Packages

Used by

Contributors

Languages

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.