Discover @digoal Open Source projects

Digoal.zhou (@digoal)

digoal

Stars
7,903
Global Rank 3,015 (Top 0.2 %)
Followers 2,922
Following 97
Registered over 12 years ago
Most used languages

Shell
50.0 %

C
25.0 %

Ruby
8.3 %

Makefile 8.3 %

PLpgSQL 8.3 %
Location 🇨🇳 China
Country Total Rank 610
Country Ranking

PLpgSQL 1

Shell
193

Makefile 278

Ruby
514

C
3,581

blog

OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog

pgsql_admin_script

常用管理脚本

PostgreSQL_HA_with_primary_standby_2vip

A HA script for PostgreSQL with 2 HOST (one for primary, one for standby), Primary with one VIP, Standby with another VIP. Auto failover and failback.

postgres_exam_lib

PostgreSQL 开放式题库, 搜集自stackoverflow , 社区 , bbs , 微信 , QQ等群体. 帮助大家了解PostgreSQL

sky_postgresql_cluster

PostgreSQL HA via three host, include two postgresql (primary and stream replication standby) and one vote host.

linux_performance_analyze

Linux's system activity information from sar, this project will use postgresql manage bulk Linux hosts. These hosts registed in postgresql, and every day load it's sar info into postgresql, and use postgresql's SQL analyze the hosts performance, like performance's system activity information and TOP resource consume's hosts, and so on.

gp_tpch

digoal.github.io

sysbench

sysbench for pg,mysql,oracle, support parallel load & prepared test & tablespace & UDF

database_performance_tuning_cases

This project collect Database performance tuning cases from SKY-MOBI DBA Team. Contain mongoDB, PostgreSQL, Oracle, Redis, and so on... Created by Digoal zhou.

sky_monitor_api_by_postgresql

Use PostgreSQL function provide unique Application monitor interface. applications call postgresql function, send status message to it. nagios read the message from postgresql.

oracle_monitor

When we manage many oracle database, the database's status

postgresql_archive_cloud

When we have many and many PostgreSQL Databases, these database's wal archive manage will much complex. We must has a simple manage tool to do it, and it can help us find these databases archive history, analyze which database will use more and which database use few storage to record the wal files. And this tool must can manage these infomation and use storage properly.

postgresql_cloud_database

This project use BIND and PostgreSQL and WEB management TOOL create a large database cloud with PostgreSQL. It's not use OS's Virtual Machine, but Use PostgreSQL's Stream replication failover, so this cloud not depend on Shared Storage and storage's high availability. So it's really a PostgreSQL's cloud system.

postgres_finetuning_kb

PostgreSQL's knowledge base for LLM fine tuning.

VecDB-Exp

mongo_fdw

fork and modified by citusdb's mongo_fdw to support unix sock connection.

postgresql_docker_builder

Build PostgreSQL (with 200+ extenstions and tools) DuckDB MySQL and so on into One docker image. It used for learn database easily only.