Git Product home page Git Product logo

archery's Introduction

SQL 审核查询平台

功能清单

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

快速开始

系统体验

在线体验

账号 密码
archer archer

Docker

准备运行配置

具体可参考:https://github.com/hhyo/Archery/tree/master/src/docker-compose

启动

下载 Releases文件,解压后进入docker-compose文件夹

#启动
docker-compose -f docker-compose.yml up -d

#表结构初始化
docker exec -ti archery /bin/bash
cd /opt/archery
source /opt/venv4archery/bin/activate
python3 manage.py makemigrations sql
python3 manage.py migrate

#数据初始化
python3 manage.py dbshell<sql/fixtures/auth_group.sql
python3 manage.py dbshell<src/init_sql/mysql_slow_query_review.sql

#创建管理用户
python3 manage.py createsuperuser

#重启服务
docker restart archery

#日志查看和问题排查
docker logs archery -f --tail=10
logs/archery.log

访问

http://127.0.0.1:9123/

手动安装

部署说明

运行测试

python manage.py test -v 3

依赖清单

框架

前端组件

服务端

功能依赖

贡献代码

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

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

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

交流反馈

致谢

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

archery's People

Contributors

hhyo avatar leoquote avatar jly8866 avatar nick2wang avatar weideguo avatar aceattorney avatar johnliu2008 avatar jan-song avatar kjilupin avatar yzypals avatar flyingonthebed avatar dependabot[bot] avatar unknowissue avatar lvhejin avatar honor100 avatar cpzt avatar boomballa avatar sunnywalden avatar czxin788 avatar dongqianzheng avatar xxlrr avatar ocpeng avatar deng-tr avatar woshihaoren avatar magmongoing avatar ericruan-cn avatar thcoffee avatar chenyu1st avatar learn0208 avatar crusm avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.