Mogo: a lightweight browser-based logs analytics and logs search platform for some datasource(ClickHouse, MySQL, etc.)

Related tags

Database tools mogo
Overview

mogo

Go Report Card Release GitHub license

Mogo is a lightweight browser-based logs analytics and logs search platform for some datasource(ClickHouse, MySQL, etc.)

Live demo

  • log search page log-search

  • configuration page log-search

TODO.

Features

  • visual query dashboard, support query Histogram and raw logs for SQL.
  • shows percentage for specified fields.
  • vscode style configuration board, you can easily emit your fluent-bit configuration to Kubernetes ConfigMap.
  • Out of the box, easily deployment with kubectl.
  • Support for GitHub and GitLab Authentication.

Architecture

image

Installation

  • For host
# download release
# go to https://github.com/shimohq/mogo/releases and choose specific release to download.
latest=$(curl -sL https://api.github.com/repos/shimohq/mogo/releases/latest | grep  ".tag_name" | sed -E 's/.*"([^"]+)".*/\1/')
# for MacOS
wget https://github.com/shimohq/mogo/releases/download/${latest}/mogo_${latest}_darwin_x86_64.tar.gz -O mogo.tar.gz 
# for Linux
wget https://github.com/shimohq/mogo/releases/download/${latest}/mogo_${latest}_linux_x86_64.tar.gz -O mogo.tar.gz  

# extract zip file
tar xvf mogo.tar.gz -O 

# start api server


# configure nginx config
  • For Docker
git clone https://github.com/shimohq/mogo.git
docker-compose up

# then go to browser and visit http://localhost:9001
# username: admin
# password: admin
  • For helm

Main Tasks

-[x] task1

-[x] task2

Bugs or features

If you want to report a bug or request for a feature, create a issue here.

Contributors

Issues
  • 添加clickhouse实例失败

    添加clickhouse实例失败

    你好,在添加clickhouse的时候失败了,提示【 {"data":{"code":1,"msg":"DNS configuration exception, database connection failure: could not load time location: unknown time zone Asia/Shanghai","data":null}} 】 ,这个是什么原因?

    mogo尝试配置的数据库类型有mysql5.6、mysql5.7、tidb5.3; mogo运行的方式有二进制、docker、k8s 。

    bug 
    opened by 231bobo 11
  • Mac m1 使用docker-compose部署失败

    Mac m1 使用docker-compose部署失败

    用了docker-compose.m1.yml这个文件,启动之后报错如下:

    $ docker-compose up -d
    Traceback (most recent call last):
      File "urllib3/connectionpool.py", line 670, in urlopen
      File "urllib3/connectionpool.py", line 392, in _make_request
      File "http/client.py", line 1255, in request
      File "http/client.py", line 1301, in _send_request
      File "http/client.py", line 1250, in endheaders
      File "http/client.py", line 1010, in _send_output
      File "http/client.py", line 950, in send
      File "docker/transport/unixconn.py", line 43, in connect
    FileNotFoundError: [Errno 2] No such file or directory
    
    During handling of the above exception, another exception occurred:
    
    Traceback (most recent call last):
      File "requests/adapters.py", line 439, in send
      File "urllib3/connectionpool.py", line 726, in urlopen
      File "urllib3/util/retry.py", line 410, in increment
      File "urllib3/packages/six.py", line 734, in reraise
      File "urllib3/connectionpool.py", line 670, in urlopen
      File "urllib3/connectionpool.py", line 392, in _make_request
      File "http/client.py", line 1255, in request
      File "http/client.py", line 1301, in _send_request
      File "http/client.py", line 1250, in endheaders
      File "http/client.py", line 1010, in _send_output
      File "http/client.py", line 950, in send
      File "docker/transport/unixconn.py", line 43, in connect
    urllib3.exceptions.ProtocolError: ('Connection aborted.', FileNotFoundError(2, 'No such file or directory'))
    
    During handling of the above exception, another exception occurred:
    
    Traceback (most recent call last):
      File "docker/api/client.py", line 214, in _retrieve_server_version
      File "docker/api/daemon.py", line 181, in version
      File "docker/utils/decorators.py", line 46, in inner
      File "docker/api/client.py", line 237, in _get
      File "requests/sessions.py", line 543, in get
      File "requests/sessions.py", line 530, in request
      File "requests/sessions.py", line 643, in send
      File "requests/adapters.py", line 498, in send
    requests.exceptions.ConnectionError: ('Connection aborted.', FileNotFoundError(2, 'No such file or directory'))
    
    During handling of the above exception, another exception occurred:
    
    Traceback (most recent call last):
      File "docker-compose", line 3, in <module>
      File "compose/cli/main.py", line 81, in main
      File "compose/cli/main.py", line 200, in perform_command
      File "compose/cli/command.py", line 60, in project_from_options
      File "compose/cli/command.py", line 152, in get_project
      File "compose/cli/docker_client.py", line 41, in get_client
      File "compose/cli/docker_client.py", line 170, in docker_client
      File "docker/api/client.py", line 197, in __init__
      File "docker/api/client.py", line 221, in _retrieve_server_version
    docker.errors.DockerException: Error while fetching server API version: ('Connection aborted.', FileNotFoundError(2, 'No such file or directory'))
    [4947] Failed to execute script docker-compose
    
    opened by eryajf 3
  • 访问Mogo UI,输入账号密码后没有跳转仍是登录页面,刷新页面后进入Mogo页面;mogo_mock_1容器起不来

    访问Mogo UI,输入账号密码后没有跳转仍是登录页面,刷新页面后进入Mogo页面;mogo_mock_1容器起不来

    1、访问(http://192.168.9.203:19001/user/login),输入账号密码后没有跳转仍是登录页面,修改url为http://192.168.9.203:19001/query进入Mogo页面; image 2、docker-compose部署,mogo_mock_1容器起不来,实际mysql容器是起来的,数据库也初始化了; image image

    bug 
    opened by Zouxuejun 3
  • feat: timeField support unix timestamp

    feat: timeField support unix timestamp

    Feature

    • 新增日志库时,时间解析字段支持Int类型字段,需手动选择单位毫秒或秒。

    增加已有日志库场景中用户表中时间字段使用unix时间戳来存储的情况比较常见。修改表结构对用户来说可能是较大改动,所以mogo支持此类型字段很有必要。

    image

    Bugfix

    • 修复了实例管理模块显示错误。
    • 优化了日志库创建表单校验正则。
    • 删除日志库时清理url参数,避免携带已删除的tid到后端。
    opened by qingbozhang 2
  • cannot create directory '/bitnami/kafka/config': Permission denied

    cannot create directory '/bitnami/kafka/config': Permission denied

    docker-compose up fail

    kafka 15:23:22.71
    kafka 15:23:22.71 Welcome to the Bitnami kafka container
    kafka 15:23:22.71 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-kafka
    kafka 15:23:22.71 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-kafka/issues
    kafka 15:23:22.71
    kafka 15:23:22.72 INFO  ==> ** Starting Kafka setup **
    kafka 15:23:22.81 WARN  ==> You set the environment variable ALLOW_PLAINTEXT_LISTENER=yes. For safety reasons, do not use this flag in a production environment.
    mkdir: cannot create directory '/bitnami/kafka/config': Permission denied
    
    opened by ang00 2
  • Loading k8s configmap error

    Loading k8s configmap error

    添加k8s集群后能获取Configmaps但无法在面板展示内容,点击从k8s同步 error {"data":{"code":1,"msg":"sql: Scan error on column index 12, name "lock_at": converting driver.Value type time.Time ("0001-01-01 00:00:00 +0000 UTC") to a int64: invalid syntax","data":"sql: Scan error on column index 12, name "lock_at": converting driver.Value type time.Time ("0001-01-01 00:00:00 +0000 UTC") to a int64: invalid syntax"}}

    opened by MisachouLu 1
  •  change standalone.yml

    change standalone.yml

    That platform is not really need, I get an error if I run with this: ERROR: The Compose file './docker-compose.standalone.yml' is invalid because: Unsupported config option for services.mysql: 'platform' So I think need remove that

    opened by ArthurQiuys 1
  • 直接使用docker-compose 快速启动失败

    直接使用docker-compose 快速启动失败

    panic: msg: Casbin NewEnforcer panic loc: /clickvisual/api/internal/service/permission/pmsplugin/pms.go:37 error: open : no such file or directory {"lv":"panic","ts":1652324394,"msg":"Casbin NewEnforcer panic","lname":"default.log","error":"open : no such file or directory","stack":"github.com/gotomicro/ego/core/elog.(*Component).Panic\n\t/go/pkg/mod/github.com/gotomicro/[email protected]/core/elog/component.go:262\ngithub.com/gotomicro/ego/core/elog.Panic\n\t/go/pkg/mod/github.com/gotomicro/[email protected]/core/elog/elog_api.go:42\ngithub.com/clickvisual/clickvisual/api/internal/service/permission/pmsplugin.Invoker\n\t/clickvisual/api/internal/service/permission/pmsplugin/pms.go:37\ngithub.com/clickvisual/clickvisual/api/internal/service/permission.InitManager\n\t/clickvisual/api/internal/service/permission/pms.go:23\ngithub.com/clickvisual/clickvisual/api/internal/service.Init\n\t/clickvisual/api/internal/service/init.go:34\ngithub.com/gotomicro/ego.runSerialFuncReturnError\n\t/go/pkg/mod/github.com/gotomicro/[email protected]/ego_function.go:263\ngithub.com/gotomicro/ego.(*Ego).Invoker\n\t/go/pkg/mod/github.com/gotomicro/[email protected]/ego.go:133\nmain.main\n\t/clickvisual/api/main.go:16\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:255"} panic: Casbin NewEnforcer panic

    goroutine 1 [running]: go.uber.org/zap/zapcore.(*CheckedEntry).Write(0xc00066e600, {0xc0004ae1c0, 0x1, 0x1}) /go/pkg/mod/go.uber.org/[email protected]/zapcore/entry.go:232 +0x446 go.uber.org/zap.(*Logger).Panic(0x2030b44, {0x2030b44, 0xc0004ae1c0}, {0xc0004ae1c0, 0x1, 0x1}) /go/pkg/mod/go.uber.org/[email protected]/logger.go:230 +0x59 github.com/gotomicro/ego/core/elog.(*Component).Panic(0xc0001ecd40, {0x2030b44, 0x18}, {0xc0004ae1c0, 0x1, 0x1}) /go/pkg/mod/github.com/gotomicro/[email protected]/core/elog/component.go:262 +0xd0 github.com/gotomicro/ego/core/elog.Panic(...) /go/pkg/mod/github.com/gotomicro/[email protected]/core/elog/elog_api.go:42 github.com/clickvisual/clickvisual/api/internal/service/permission/pmsplugin.Invoker() /clickvisual/api/internal/service/permission/pmsplugin/pms.go:37 +0x365 github.com/clickvisual/clickvisual/api/internal/service/permission.InitManager(...) /clickvisual/api/internal/service/permission/pms.go:23 github.com/clickvisual/clickvisual/api/internal/service.Init() /clickvisual/api/internal/service/init.go:34 +0x1b9 github.com/gotomicro/ego.runSerialFuncReturnError({0xc0006ae640, 0x2, 0x3f448e8}) /go/pkg/mod/github.com/gotomicro/[email protected]/ego_function.go:263 +0x46 github.com/gotomicro/ego.(*Ego).Invoker(0xc0006ba3c0, {0xc0002f7f40, 0x2, 0x60}) /go/pkg/mod/github.com/gotomicro/[email protected]/ego.go:133 +0x165 main.main() /clickvisual/api/main.go:16 +0x65

    没有看到相关的设置问题

    opened by ArthurQiuys 1
  • 自建表,时间字段为DateTime64(3),查询报错

    自建表,时间字段为DateTime64(3),查询报错

    错误信息 {"data":{"code":1,"msg":"query failed: code: 53, message: Type mismatch in IN or VALUES section. Expected: DateTime64(3). Got: UInt64","data":null}}

    opened by amuluowin 5
  • Raw log trigger conditions and alarms

    Raw log trigger conditions and alarms

    hi team

    I followed clickvisual and did a simple test and trial

    In practical scenarios, fuzzy matching usually cannot filter logs accurately, and will cause a lot of spam, which will make us miss important content

    For example, those keywords contained in the log in the last minute need to be paid attention to The flexible matching method requires a certain SQL statement to describe the trigger condition

    Trigger conditions in the UI interface should support more flexible SQL, not just option

    for example

    The error log line for the error keyword contains identify Sku Stock Type error but not stockout.create and entryorder.update and [INFO]

    as follows

    error and "identify Sku Stock Type error" not "stockout.create" not "entryorder.update" not "[INFO]"
    
    1. Support raw log fuzzy matching trigger
    2. Support original log exact match and multi-condition nested triggers
    3. Support original log trigger suppression function --> In the same matching entry, only one matching entry will be sent and the number will be counted

    what do you think thanks

    enhancement 
    opened by marksugar 0
  • 按照文档使用 docker-compose 在本地快速启动 Mogo demo表不存在问题

    按照文档使用 docker-compose 在本地快速启动 Mogo demo表不存在问题

    /mogo/api/internal/service/configure/lock.go:80 Error 1146: Table 'mocro.mogo_configuration' doesn't exist /mogo/api/pkg/model/db/cluster.go:118 Error 1146: Table 'mocro.mogo_cluster' doesn't exist 基本上表都不存在~

    opened by insomniasary 2
Releases(v0.3.0-rc3)
  • v0.3.0-rc3(May 17, 2022)

    What's Changed

    • fix: Resolve alarm details jump by @m1666 in https://github.com/clickvisual/clickvisual/pull/250
    • fix: Int or float data may lost by @kl7sn in https://github.com/clickvisual/clickvisual/pull/251
    • feat: Add no data operator by @kl7sn in https://github.com/clickvisual/clickvisual/pull/252
    • fix: Add access type 'auth.proxy.cookie' by @kl7sn in https://github.com/clickvisual/clickvisual/pull/253
    • feat: Added no data alarm policy configuration by @m1666 in https://github.com/clickvisual/clickvisual/pull/254
    • fix: Optimize null data alarm policy configuration by @m1666 in https://github.com/clickvisual/clickvisual/pull/255
    • fix: Failed to configure alarms in cluster mode by @kl7sn in https://github.com/clickvisual/clickvisual/pull/256
    • fix: Fix check statistics editing errors by @m1666 in https://github.com/clickvisual/clickvisual/pull/257
    • feat: Added whether the cluster contains replica configuration by @kl7sn in https://github.com/clickvisual/clickvisual/pull/260
    • fix: Fixed a problem with data cleansing when editing instances by @m1666 in https://github.com/clickvisual/clickvisual/pull/261

    Full Changelog: https://github.com/clickvisual/clickvisual/compare/v0.3.0-rc2...v0.3.0-rc3

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(434 bytes)
    clickvisual-v0.3.0-rc3-darwin-amd64.tar.gz(18.39 MB)
    clickvisual-v0.3.0-rc3-darwin-arm64.tar.gz(18.29 MB)
    clickvisual-v0.3.0-rc3-linux-amd64.tar.gz(17.70 MB)
    clickvisual-v0.3.0-rc3-linux-arm64.tar.gz(16.33 MB)
  • v0.3.0-rc2(May 13, 2022)

    What's Changed

    • fix: Optimize the log chart experience by @m1666 in https://github.com/clickvisual/clickvisual/pull/235
    • fix: The log library is not displayed when the database is empty by @m1666 in https://github.com/clickvisual/clickvisual/pull/237
    • set docker/[email protected] by @kl7sn in https://github.com/clickvisual/clickvisual/pull/240
    • fix: Multi-platform image by @kl7sn in https://github.com/clickvisual/clickvisual/pull/242
    • change standalone.yml by @ArthurQiuys in https://github.com/clickvisual/clickvisual/pull/239
    • fix: yarn install by @kl7sn in https://github.com/clickvisual/clickvisual/pull/243
    • fix: Get config list error with same name by @kl7sn in https://github.com/clickvisual/clickvisual/pull/247
    • fix: Interface API /v1/ Configurations Adds the clusterId field by @m1666 in https://github.com/clickvisual/clickvisual/pull/248
    • fix: LockAt datetime to bigint by @kl7sn in https://github.com/clickvisual/clickvisual/pull/249

    New Contributors

    • @ArthurQiuys made their first contribution in https://github.com/clickvisual/clickvisual/pull/239

    Full Changelog: https://github.com/clickvisual/clickvisual/compare/v0.3.0-rc1...v0.3.0-rc2

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(434 bytes)
    clickvisual-v0.3.0-rc2-darwin-amd64.tar.gz(18.39 MB)
    clickvisual-v0.3.0-rc2-darwin-arm64.tar.gz(18.28 MB)
    clickvisual-v0.3.0-rc2-linux-amd64.tar.gz(17.70 MB)
    clickvisual-v0.3.0-rc2-linux-arm64.tar.gz(16.33 MB)
  • v0.3.0-rc1(May 12, 2022)

    What's Changed

    • The graph shows the error throw by @kl7sn in https://github.com/clickvisual/clickvisual/pull/176
    • feat(log data) by @m1666 in https://github.com/clickvisual/clickvisual/pull/177
    • feat: You can now add logs to the database list by @qianque7 in https://github.com/clickvisual/clickvisual/pull/178
    • feat: Optimize query speed by using hash functions by @kl7sn in https://github.com/clickvisual/clickvisual/pull/179
    • fix: Login out by @kl7sn in https://github.com/clickvisual/clickvisual/pull/180
    • fix(log data): Optimize the log display style by @m1666 in https://github.com/clickvisual/clickvisual/pull/181
    • fix(log data): Optimize the paging experience by @m1666 in https://github.com/clickvisual/clickvisual/pull/182
    • fix(log data): Fix the blank screen on the log page by @m1666 in https://github.com/clickvisual/clickvisual/pull/183
    • feat: String transfer hash function after conversion storage by @kl7sn in https://github.com/clickvisual/clickvisual/pull/184
    • feat(log library): Optimize the log library by @m1666 in https://github.com/clickvisual/clickvisual/pull/185
    • feat: Optimized the proxy authentication mode by @kl7sn in https://github.com/clickvisual/clickvisual/pull/186
    • feat(Avatar): Hide the profile picture of user 0 by @m1666 in https://github.com/clickvisual/clickvisual/pull/187
    • feat: pms by @kl7sn in https://github.com/clickvisual/clickvisual/pull/189
    • fix: Duplicate login problems caused by permission point access by @kl7sn in https://github.com/clickvisual/clickvisual/pull/190
    • fix: Modifying the UMI Version by @m1666 in https://github.com/clickvisual/clickvisual/pull/191
    • fix: yarn run start error by @kl7sn in https://github.com/clickvisual/clickvisual/pull/192
    • fix: yarn build by @kl7sn in https://github.com/clickvisual/clickvisual/pull/193
    • fix: yarn build by @kl7sn in https://github.com/clickvisual/clickvisual/pull/194
    • fix: fetch pms common info by @kl7sn in https://github.com/clickvisual/clickvisual/pull/195
    • feat: The self-built log library returns only internal fields by @kl7sn in https://github.com/clickvisual/clickvisual/pull/197
    • fix: Fix the root permission data update delay problem by @kl7sn in https://github.com/clickvisual/clickvisual/pull/198
    • fix: login 304 by @kl7sn in https://github.com/clickvisual/clickvisual/pull/199
    • fix: location.reload() by @kl7sn in https://github.com/clickvisual/clickvisual/pull/200
    • feat: The hash index of parameters is added by @qianque7 in https://github.com/clickvisual/clickvisual/pull/196
    • feat: mogo->clickvisual by @kl7sn in https://github.com/clickvisual/clickvisual/pull/201
    • fix: grant root users by proxy error by @kl7sn in https://github.com/clickvisual/clickvisual/pull/202
    • feat: Add statistical chart model by @m1666 in https://github.com/clickvisual/clickvisual/pull/203
    • fix: init QueryType by @m1666 in https://github.com/clickvisual/clickvisual/pull/204
    • Feature/fe by @qianque7 in https://github.com/clickvisual/clickvisual/pull/205
    • fix: Fixed query input box problem by @m1666 in https://github.com/clickvisual/clickvisual/pull/206
    • fix: limit complete 100 by @kl7sn in https://github.com/clickvisual/clickvisual/pull/207
    • fix: casbin sql struct by @kl7sn in https://github.com/clickvisual/clickvisual/pull/209
    • feat: Added statistics table function by @m1666 in https://github.com/clickvisual/clickvisual/pull/208
    • fix: Modify log display BUG by @m1666 in https://github.com/clickvisual/clickvisual/pull/210
    • feat: update user nickname info by @kl7sn in https://github.com/clickvisual/clickvisual/pull/211
    • fix: Modifying the project name by @m1666 in https://github.com/clickvisual/clickvisual/pull/213
    • Support warning statement editing by @qianque7 in https://github.com/clickvisual/clickvisual/pull/212
    • feat: Optimize the experience by @m1666 in https://github.com/clickvisual/clickvisual/pull/214
    • fix: The query statement automatically fills undefined by @qianque7 in https://github.com/clickvisual/clickvisual/pull/216
    • fix: Optimizing log list by @m1666 in https://github.com/clickvisual/clickvisual/pull/215
    • feat: Change the logo by @m1666 in https://github.com/clickvisual/clickvisual/pull/217
    • fix: Optimize page styles by @m1666 in https://github.com/clickvisual/clickvisual/pull/218
    • fix: empty data alert by @kl7sn in https://github.com/clickvisual/clickvisual/pull/220
    • fix: Jump path adds environment variables by @m1666 in https://github.com/clickvisual/clickvisual/pull/219
    • fix: on user info change mogo to clickvisual by @kl7sn in https://github.com/clickvisual/clickvisual/pull/221
    • fix: change table prefix mogo_ -> cv_ and auto rename when upgrading by @kl7sn in https://github.com/clickvisual/clickvisual/pull/222
    • feat: Add the default permission configuration by @kl7sn in https://github.com/clickvisual/clickvisual/pull/224
    • feat: Add instance desc field by @kl7sn in https://github.com/clickvisual/clickvisual/pull/225
    • fix: Fixed the inability to modify analysis fields in Share mode by @m1666 in https://github.com/clickvisual/clickvisual/pull/223
    • feat: remove alarm / by @m1666 in https://github.com/clickvisual/clickvisual/pull/226
    • fix: Add user info at proxy mode by @kl7sn in https://github.com/clickvisual/clickvisual/pull/227
    • fix: Temporarily annotate data for null judgment by @kl7sn in https://github.com/clickvisual/clickvisual/pull/229
    • change dockerhub user by @sevennt in https://github.com/clickvisual/clickvisual/pull/230
    • update docs by @sevennt in https://github.com/clickvisual/clickvisual/pull/233
    • fix: docker-compose standalone by @kl7sn in https://github.com/clickvisual/clickvisual/pull/234

    Full Changelog: https://github.com/clickvisual/clickvisual/compare/v0.2.2...v0.3.0-rc1

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(434 bytes)
    clickvisual-v0.3.0-rc1-darwin-amd64.tar.gz(18.39 MB)
    clickvisual-v0.3.0-rc1-darwin-arm64.tar.gz(18.28 MB)
    clickvisual-v0.3.0-rc1-linux-amd64.tar.gz(17.70 MB)
    clickvisual-v0.3.0-rc1-linux-arm64.tar.gz(16.33 MB)
  • v0.2.2(Apr 18, 2022)

    What's Changed

    • feat: timeField support unix timestamp by @qingbozhang in https://github.com/shimohq/mogo/pull/119
    • docs: add qingbozhang as a contributor for code by @allcontributors in https://github.com/shimohq/mogo/pull/120
    • Clickhouse clustering is supported by @kl7sn in https://github.com/shimohq/mogo/pull/121
    • fix: import mdp/pkg/model/db by @kl7sn in https://github.com/shimohq/mogo/pull/125
    • add helm charts by @sevennt in https://github.com/shimohq/mogo/pull/127
    • Cluster mode supports front-end completion by @kl7sn in https://github.com/shimohq/mogo/pull/128
    • update charts docs by @sevennt in https://github.com/shimohq/mogo/pull/129
    • fix: ./api/config->./config by @kl7sn in https://github.com/shimohq/mogo/pull/130
    • feat: Subpath configuration support by @kl7sn in https://github.com/shimohq/mogo/pull/131
    • fix: Cluster database create overtime by @kl7sn in https://github.com/shimohq/mogo/pull/132
    • fix: Cluster database create failure by @kl7sn in https://github.com/shimohq/mogo/pull/133
    • feat: Add demo mode by @kl7sn in https://github.com/shimohq/mogo/pull/134
    • feat: User operation event recording support by @kl7sn in https://github.com/shimohq/mogo/pull/135
    • chore(deps): bump url-parse from 1.5.3 to 1.5.10 in /ui by @dependabot in https://github.com/shimohq/mogo/pull/117
    • feat: Added the Event Center page by @qianque7 in https://github.com/shimohq/mogo/pull/137
    • fix: config directoy missing by @sevennt in https://github.com/shimohq/mogo/pull/138
    • docs: add qianque7 as a contributor for code by @allcontributors in https://github.com/shimohq/mogo/pull/139
    • fix: toDateTime64(parseDateTimeBestEffort(time), 3, 'Asia/Shanghai'… by @kl7sn in https://github.com/shimohq/mogo/pull/140
    • fix: instance not found by @m1666 in https://github.com/shimohq/mogo/pull/144
    • fix: Fixed paging logic issue in event center, added synchronous sear… by @qianque7 in https://github.com/shimohq/mogo/pull/143
    • feat: Record the database modification records by @kl7sn in https://github.com/shimohq/mogo/pull/150
    • fix: create log library button failure by @m1666 in https://github.com/shimohq/mogo/pull/146
    • fix: cycle by @m1666 in https://github.com/shimohq/mogo/pull/151
    • feat: The API for batch adding databases already exists by @kl7sn in https://github.com/shimohq/mogo/pull/152
    • refactor: Optimize the code by @m1666 in https://github.com/shimohq/mogo/pull/153
    • fix: Fix the table deletion failure in cluster mode by @kl7sn in https://github.com/shimohq/mogo/pull/155
    • fix: Kubeconfig by @kl7sn in https://github.com/shimohq/mogo/pull/156
    • refactor: Optimization of dynamic time interval calculation by @kl7sn in https://github.com/shimohq/mogo/pull/160
    • Use toDateTime form DateTime search by @kl7sn in https://github.com/shimohq/mogo/pull/162
    • fix: ReplicatedMergeTree grammar mistakes by @kl7sn in https://github.com/shimohq/mogo/pull/165
    • feat: Provides full SQL request support by @kl7sn in https://github.com/shimohq/mogo/pull/166
    • feat: Log libraries already support multiple selection commits by @qianque7 in https://github.com/shimohq/mogo/pull/167
    • fix(LogTab/UrlParams): by @m1666 in https://github.com/shimohq/mogo/pull/168
    • feat(logs count): update logs count by @m1666 in https://github.com/shimohq/mogo/pull/170
    • feat: The database can be displayed in the instance-database tree by @qianque7 in https://github.com/shimohq/mogo/pull/169
    • fix: logs count by @m1666 in https://github.com/shimohq/mogo/pull/171
    • refactor: Query efficiency optimization by @kl7sn in https://github.com/shimohq/mogo/pull/172
    • fix: Instance clusters update by @kl7sn in https://github.com/shimohq/mogo/pull/173

    New Contributors

    • @qingbozhang made their first contribution in https://github.com/shimohq/mogo/pull/119
    • @dependabot made their first contribution in https://github.com/shimohq/mogo/pull/117
    • @qianque7 made their first contribution in https://github.com/shimohq/mogo/pull/137
    • @m1666 made their first contribution in https://github.com/shimohq/mogo/pull/144

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.2.1...v0.2.2

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(390 bytes)
    mogo-v0.2.2-darwin-amd64.tar.gz(17.66 MB)
    mogo-v0.2.2-darwin-arm64.tar.gz(17.57 MB)
    mogo-v0.2.2-linux-amd64.tar.gz(16.98 MB)
    mogo-v0.2.2-linux-arm64.tar.gz(15.66 MB)
  • v0.2.2-rc2(Apr 7, 2022)

    What's Changed

    • feat: Added the Event Center page by @qianque7 in https://github.com/shimohq/mogo/pull/137
    • fix: config directoy missing by @sevennt in https://github.com/shimohq/mogo/pull/138

    New Contributors

    • @qianque7 made their first contribution in https://github.com/shimohq/mogo/pull/137

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.2.2-rc1...v0.2.2-rc2

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(406 bytes)
    mogo-v0.2.2-rc2-darwin-amd64.tar.gz(17.65 MB)
    mogo-v0.2.2-rc2-darwin-arm64.tar.gz(17.55 MB)
    mogo-v0.2.2-rc2-linux-amd64.tar.gz(16.97 MB)
    mogo-v0.2.2-rc2-linux-arm64.tar.gz(15.65 MB)
  • v0.2.2-rc1(Apr 6, 2022)

    What's Changed

    • feat: timeField support unix timestamp by @qingbozhang in https://github.com/shimohq/mogo/pull/119
    • docs: add qingbozhang as a contributor for code by @allcontributors in https://github.com/shimohq/mogo/pull/120
    • Clickhouse clustering is supported by @kl7sn in https://github.com/shimohq/mogo/pull/121
    • fix: import mdp/pkg/model/db by @kl7sn in https://github.com/shimohq/mogo/pull/125
    • add helm charts by @sevennt in https://github.com/shimohq/mogo/pull/127
    • Cluster mode supports front-end completion by @kl7sn in https://github.com/shimohq/mogo/pull/128
    • update charts docs by @sevennt in https://github.com/shimohq/mogo/pull/129
    • fix: ./api/config->./config by @kl7sn in https://github.com/shimohq/mogo/pull/130
    • feat: Subpath configuration support by @kl7sn in https://github.com/shimohq/mogo/pull/131
    • fix: Cluster database create overtime by @kl7sn in https://github.com/shimohq/mogo/pull/132
    • fix: Cluster database create failure by @kl7sn in https://github.com/shimohq/mogo/pull/133
    • feat: Add demo mode by @kl7sn in https://github.com/shimohq/mogo/pull/134
    • feat: User operation event recording support by @kl7sn in https://github.com/shimohq/mogo/pull/135
    • chore(deps): bump url-parse from 1.5.3 to 1.5.10 in /ui by @dependabot in https://github.com/shimohq/mogo/pull/117

    New Contributors

    • @qingbozhang made their first contribution in https://github.com/shimohq/mogo/pull/119
    • @dependabot made their first contribution in https://github.com/shimohq/mogo/pull/117

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.2.1...v0.2.2-rc1

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(406 bytes)
    mogo-v0.2.2-rc1-darwin-amd64.tar.gz(17.64 MB)
    mogo-v0.2.2-rc1-darwin-arm64.tar.gz(17.55 MB)
    mogo-v0.2.2-rc1-linux-amd64.tar.gz(16.96 MB)
    mogo-v0.2.2-rc1-linux-arm64.tar.gz(15.64 MB)
  • v0.2.1(Mar 28, 2022)

    What's Changed

    • modify comment and delete dtime operation by @sevennt in https://github.com/shimohq/mogo/pull/92
    • update comments in core by @sevennt in https://github.com/shimohq/mogo/pull/93
    • index field optimization to avoid conflicts in clickhouse by @kl7sn in https://github.com/shimohq/mogo/pull/94
    • fix: the request parameter contains an and by @kl7sn in https://github.com/shimohq/mogo/pull/97
    • feat: support "xx and aa" in query value by @kl7sn in https://github.com/shimohq/mogo/pull/98
    • feat: dingding alert link add timestamp by @kl7sn in https://github.com/shimohq/mogo/pull/99
    • fix: writer_timeou -> writer_timeout by @kl7sn in https://github.com/shimohq/mogo/pull/101
    • the alarm data storage policy adjustment is supported by @kl7sn in https://github.com/shimohq/mogo/pull/103
    • feat: added alarm details info by @kl7sn in https://github.com/shimohq/mogo/pull/104
    • fix: log.Fatal by @kl7sn in https://github.com/shimohq/mogo/pull/106
    • fix: windows embed 404 by @kl7sn in https://github.com/shimohq/mogo/pull/107
    • feat: builder model & add exist table with any engine by @kl7sn in https://github.com/shimohq/mogo/pull/108
    • could not load time location: unknown time zone Asia/Shanghai by @kl7sn in https://github.com/shimohq/mogo/pull/111
    • fix log time display disorder by @kl7sn in https://github.com/shimohq/mogo/pull/112
    • fix: delete ENV TZ Asia/Shanghai by @kl7sn in https://github.com/shimohq/mogo/pull/113
    • Fixed memory consumption problems by @kl7sn in https://github.com/shimohq/mogo/pull/114
    • change goproxy by @sevennt in https://github.com/shimohq/mogo/pull/115
    • mv goproxy arg by @sevennt in https://github.com/shimohq/mogo/pull/116

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.2.0...v0.2.1

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(390 bytes)
    mogo-v0.2.1-darwin-amd64.tar.gz(17.61 MB)
    mogo-v0.2.1-darwin-arm64.tar.gz(17.52 MB)
    mogo-v0.2.1-linux-amd64.tar.gz(16.94 MB)
    mogo-v0.2.1-linux-arm64.tar.gz(15.62 MB)
  • v0.2.0(Mar 21, 2022)

    What's Changed

    • fix: Docker compose supports the arm64 architecture of Mac M1 by @liangguifeng in https://github.com/shimohq/mogo/pull/53
    • update dockerfile by @sevennt in https://github.com/shimohq/mogo/pull/55
    • Update README.md by @link-duan in https://github.com/shimohq/mogo/pull/54
    • docs: add liangguifeng as a contributor for code by @allcontributors in https://github.com/shimohq/mogo/pull/56
    • chmod kafka/data path by @askuy in https://github.com/shimohq/mogo/pull/58
    • Alert by @kl7sn in https://github.com/shimohq/mogo/pull/59
    • docs: yaml by @kl7sn in https://github.com/shimohq/mogo/pull/61
    • Update README.md by @link-duan in https://github.com/shimohq/mogo/pull/60
    • Alarm Rules for local storage by @kl7sn in https://github.com/shimohq/mogo/pull/62
    • fix: alarm store error by @kl7sn in https://github.com/shimohq/mogo/pull/64
    • docker compose alertmanage by @askuy in https://github.com/shimohq/mogo/pull/65
    • rm docker sha push action by @sevennt in https://github.com/shimohq/mogo/pull/66
    • fix: auto create metrics.samples by @kl7sn in https://github.com/shimohq/mogo/pull/67
    • Feature/docker compose 02 28 by @askuy in https://github.com/shimohq/mogo/pull/68
    • docker alertmanage by @askuy in https://github.com/shimohq/mogo/pull/69
    • alarm update & dynamic index by @kl7sn in https://github.com/shimohq/mogo/pull/70
    • fix: config.d->conf.d by @kl7sn in https://github.com/shimohq/mogo/pull/72
    • fix some problem by @kl7sn in https://github.com/shimohq/mogo/pull/73
    • fix: type conversion by @kl7sn in https://github.com/shimohq/mogo/pull/75
    • support alarm history record by @kl7sn in https://github.com/shimohq/mogo/pull/77
    • the local test of the alarm module is complete by @kl7sn in https://github.com/shimohq/mogo/pull/78
    • db migration api & event record by @kl7sn in https://github.com/shimohq/mogo/pull/79
    • added secondary index verification by @kl7sn in https://github.com/shimohq/mogo/pull/82
    • feat: added system initialization by @kl7sn in https://github.com/shimohq/mogo/pull/83
    • fix: Modify the ALARM history URL by @kl7sn in https://github.com/shimohq/mogo/pull/84
    • fix alert rule delete failed in k8s by @kl7sn in https://github.com/shimohq/mogo/pull/86
    • feat: Internationalization of database initialization modules by @kl7sn in https://github.com/shimohq/mogo/pull/87
    • Documentation updates by @kl7sn in https://github.com/shimohq/mogo/pull/88
    • format docs by @sevennt in https://github.com/shimohq/mogo/pull/89
    • prometheus performs a periodic reload after alert open or close by @kl7sn in https://github.com/shimohq/mogo/pull/90

    New Contributors

    • @liangguifeng made their first contribution in https://github.com/shimohq/mogo/pull/53
    • @link-duan made their first contribution in https://github.com/shimohq/mogo/pull/54

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.1.0...v0.2.0

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(390 bytes)
    mogo-v0.2.0-darwin-amd64.tar.gz(17.57 MB)
    mogo-v0.2.0-darwin-arm64.tar.gz(17.48 MB)
    mogo-v0.2.0-linux-amd64.tar.gz(16.89 MB)
    mogo-v0.2.0-linux-arm64.tar.gz(15.58 MB)
  • v0.1.0(Feb 21, 2022)

    What's Changed

    • nginx logger docker-compose by @askuy in https://github.com/shimohq/mogo/pull/41
    • Optimized front-end compilation and fixed index configuration issues by @kl7sn in https://github.com/shimohq/mogo/pull/42
    • log->log by @kl7sn in https://github.com/shimohq/mogo/pull/43
    • fix: Fix log viewing error by @kl7sn in https://github.com/shimohq/mogo/pull/44
    • add tags on docker push by @sevennt in https://github.com/shimohq/mogo/pull/45
    • update docs by @sevennt in https://github.com/shimohq/mogo/pull/47
    • mogo docker-compose by @askuy in https://github.com/shimohq/mogo/pull/48
    • feat: added raw log field extraction by @kl7sn in https://github.com/shimohq/mogo/pull/49
    • Some front-end display optimizations by @kl7sn in https://github.com/shimohq/mogo/pull/50
    • mogo readme by @askuy in https://github.com/shimohq/mogo/pull/51
    • ignore tsx by @sevennt in https://github.com/shimohq/mogo/pull/52

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.0.1-rc2...v0.1.0

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(390 bytes)
    mogo-v0.1.0-darwin-amd64.tar.gz(18.54 MB)
    mogo-v0.1.0-darwin-arm64.tar.gz(18.47 MB)
    mogo-v0.1.0-linux-amd64.tar.gz(17.82 MB)
    mogo-v0.1.0-linux-arm64.tar.gz(16.46 MB)
  • v0.0.1-rc2(Feb 14, 2022)

    What's Changed

    • add all-contributors by @sevennt in https://github.com/shimohq/mogo/pull/17
    • fix .all-contributorsrc bug by @sevennt in https://github.com/shimohq/mogo/pull/18
    • docs: add lincolnzhou as a contributor for code by @allcontributors in https://github.com/shimohq/mogo/pull/19
    • update .all-contributorsrc template by @sevennt in https://github.com/shimohq/mogo/pull/20
    • docs: add link-duan as a contributor for code by @allcontributors in https://github.com/shimohq/mogo/pull/21
    • update readme by @sevennt in https://github.com/shimohq/mogo/pull/22
    • update arch image by @sevennt in https://github.com/shimohq/mogo/pull/23
    • Fuzzy Search and Custom Indexing by @kl7sn in https://github.com/shimohq/mogo/pull/25
    • style optimization and data synchronization capability enhancement by @kl7sn in https://github.com/shimohq/mogo/pull/26
    • Docs and FE Update by @kl7sn in https://github.com/shimohq/mogo/pull/27
    • Reduce the Size of QR Code by @kl7sn in https://github.com/shimohq/mogo/pull/28
    • support internationalization by @kl7sn in https://github.com/shimohq/mogo/pull/29
    • Feature/docker compose by @askuy in https://github.com/shimohq/mogo/pull/30
    • name->id and table detail by @kl7sn in https://github.com/shimohq/mogo/pull/31
    • Feature/docker compose by @askuy in https://github.com/shimohq/mogo/pull/32
    • docker-compose by @askuy in https://github.com/shimohq/mogo/pull/33
    • docker-compose by @askuy in https://github.com/shimohq/mogo/pull/34
    • string float by @kl7sn in https://github.com/shimohq/mogo/pull/35
    • docker-compose by @askuy in https://github.com/shimohq/mogo/pull/36
    • docker-compose by @askuy in https://github.com/shimohq/mogo/pull/37
    • fix: index query by @kl7sn in https://github.com/shimohq/mogo/pull/38
    • append extra build info by @sevennt in https://github.com/shimohq/mogo/pull/39
    • append extra build info by @sevennt in https://github.com/shimohq/mogo/pull/40

    New Contributors

    • @allcontributors made their first contribution in https://github.com/shimohq/mogo/pull/19

    Full Changelog: https://github.com/shimohq/mogo/compare/v0.0.1-rc1...v0.0.1-rc2

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(406 bytes)
    mogo-v0.0.1-rc2-darwin-amd64.tar.gz(18.57 MB)
    mogo-v0.0.1-rc2-darwin-arm64.tar.gz(18.50 MB)
    mogo-v0.0.1-rc2-linux-amd64.tar.gz(17.85 MB)
    mogo-v0.0.1-rc2-linux-arm64.tar.gz(16.48 MB)
  • v0.0.1-rc1(Jan 13, 2022)

    What's Changed

    • Code submission of v0.1.0 version by @kl7sn in https://github.com/shimohq/mogo/pull/1
    • update makefile and scripts by @sevennt in https://github.com/shimohq/mogo/pull/2
    • Functions related to configmap configuration distribution by @kl7sn in https://github.com/shimohq/mogo/pull/3
    • add docker build scripts by @sevennt in https://github.com/shimohq/mogo/pull/4
    • embed html by @askuy in https://github.com/shimohq/mogo/pull/5
    • go:embed test pass by @kl7sn in https://github.com/shimohq/mogo/pull/6
    • init clickhouse data with ego job by @sevennt in https://github.com/shimohq/mogo/pull/7
    • add demo images by @sevennt in https://github.com/shimohq/mogo/pull/8
    • MR by @kl7sn in https://github.com/shimohq/mogo/pull/9
    • add docker build to makefile by @sevennt in https://github.com/shimohq/mogo/pull/10
    • update README by @sevennt in https://github.com/shimohq/mogo/pull/11
    • Optimized by @kl7sn in https://github.com/shimohq/mogo/pull/12
    • add gorelease workflow by @sevennt in https://github.com/shimohq/mogo/pull/13
    • fix gorelease config bug && update docs by @sevennt in https://github.com/shimohq/mogo/pull/14
    • change token name by @sevennt in https://github.com/shimohq/mogo/pull/15
    • fix github workflow bugs by @sevennt in https://github.com/shimohq/mogo/pull/16

    Full Changelog: https://github.com/shimohq/mogo/commits/v0.0.1-rc1

    Source code(tar.gz)
    Source code(zip)
    checksums.txt(406 bytes)
    mogo-v0.0.1-rc1-darwin-amd64.tar.gz(17.92 MB)
    mogo-v0.0.1-rc1-darwin-arm64.tar.gz(17.84 MB)
    mogo-v0.0.1-rc1-linux-amd64.tar.gz(17.19 MB)
    mogo-v0.0.1-rc1-linux-arm64.tar.gz(15.84 MB)
Owner
Shimo HQ
💻 A cloud-based productivity suite that combines documents, spreadsheets, slides and more in a simple interface.
Shimo HQ
Go-clickhouse - ClickHouse client for Go

ClickHouse client for Go 1.18+ This client uses native protocol to communicate w

Uptrace 94 May 21, 2022
Bifrost ---- 面向生产环境的 MySQL 同步到Redis,MongoDB,ClickHouse,MySQL等服务的异构中间件

Bifrost ---- 面向生产环境的 MySQL 同步到Redis,ClickHouse等服务的异构中间件 English 漫威里的彩虹桥可以将 雷神 送到 阿斯加德 和 地球 而这个 Bifrost 可以将 你 MySQL 里的数据 全量 , 实时的同步到 : Redis MongoDB Cl

brokerCAP 1.1k May 19, 2022
ClickHouse http proxy and load balancer

chproxy English | 简体中文 Chproxy, is an http proxy and load balancer for ClickHouse database. It provides the following features: May proxy requests to

Vertamedia 893 May 18, 2022
Collects many small inserts to ClickHouse and send in big inserts

ClickHouse-Bulk Simple Yandex ClickHouse insert collector. It collect requests and send to ClickHouse servers. Installation Download binary for you pl

Nikolay Pavlovich 355 May 11, 2022
Distributed tracing using OpenTelemetry and ClickHouse

Distributed tracing backend using OpenTelemetry and ClickHouse Uptrace is a dist

Uptrace 679 May 19, 2022
support clickhouse

Remote storage adapter This is a write adapter that receives samples via Prometheus's remote write protocol and stores them in Graphite, InfluxDB, cli

weetime 24 May 10, 2022
Jaeger ClickHouse storage plugin implementation

Jaeger ClickHouse Jaeger ClickHouse gRPC storage plugin. This is WIP and it is based on https://github.com/bobrik/jaeger/tree/ivan/clickhouse/plugin/s

Pavol Loffay 1 Feb 15, 2022
Clickhouse support for GORM

clickhouse Clickhouse support for GORM Quick Start package main import ( "fmt" "github.com/sweetpotato0/clickhouse" "gorm.io/gorm" ) // User

null 1 Oct 24, 2021
mysql to mysql 轻量级多线程的库表数据同步

goMysqlSync golang mysql to mysql 轻量级多线程库表级数据同步 测试运行 设置当前binlog位置并且开始运行 go run main.go -position mysql-bin.000001 1 1619431429 查询当前binlog位置,参数n为秒数,查询结

null 12 May 6, 2022
BQB is a lightweight and easy to use query builder that works with sqlite, mysql, mariadb, postgres, and others.

Basic Query Builder Why Simple, lightweight, and fast Supports any and all syntax by the nature of how it works Doesn't require learning special synta

Aaron M 36 May 18, 2022
Zinc Search engine. A lightweight alternative to elasticsearch that requires minimal resources, written in Go.

Zinc Zinc is a search engine that does full text indexing. It is a lightweight alternative to elasticsearch and runs in less than 100 MB of RAM. It us

Prabhat Sharma 7.9k May 18, 2022
🐳 A most popular sql audit platform for mysql

?? A most popular sql audit platform for mysql

Henry Yee 6.5k May 21, 2022
Use SQL to query databases, logs and more from PlanetScale

Use SQL to instantly query PlanetScale databases, branches and more. Open source CLI. No DB required.

Turbot 1 Feb 13, 2022
WAL-G is an archival restoration tool for PostgreSQL, MySQL/MariaDB, and MS SQL Server (beta for MongoDB and Redis).

WAL-G is an archival restoration tool for PostgreSQL, MySQL/MariaDB, and MS SQL Server (beta for MongoDB and Redis).

null 2.1k May 17, 2022
A Go rest API project that is following solid and common principles and is connected to local MySQL database.

This is an intermediate-level go project that running with a project structure optimized RESTful API service in Go. API's of that project is designed based on solid and common principles and connected to the local MySQL database.

Kıvanç Aydoğmuş 19 Apr 26, 2022
Jobbuzz - Brunei job search database and alert notification

JobBuzz Brunei open source job search database and alert notification Developmen

null 0 Mar 23, 2022
MySQL replication topology management and HA

orchestrator [Documentation] orchestrator is a MySQL high availability and replication management tool, runs as a service and provides command line ac

null 4.5k May 18, 2022
Interactive client for PostgreSQL and MySQL

dblab Interactive client for PostgreSQL and MySQL. Overview dblab is a fast and lightweight interactive terminal based UI application for PostgreSQL a

Daniel Omar Vergara Pérez 185 Mar 29, 2022