Digoal.zhou

blog. Opensource,Database,AI,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

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.

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.

pg_tpch. TPC-H like benchmark for PostgreSQL

sysbench-tpcc. Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL

gp_tpch. C

digoal.github.io. blog

postgres_finetuning_kb. PostgreSQL's knowledge base for LLM fine tuning.

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

R. HTML

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.

gcoord. :round_pushpin: 地理坐标系转换工具，支持WGS84/GCJ02/BD09等常用坐标系互转

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.

v-note. 数据可视化笔记

Llama-Chinese. Llama中文社区，最好的中文Llama大模型，完全开源可商用

postgis_LayerTransform. 一个在postgis中结合中国国情，批量对数据进行加偏到百度坐标，高德谷歌的火星坐标，或者逆向纠偏

PolarDB-for-PostgreSQL. A cloud-native database based on PostgreSQL developed by Alibaba Cloud.

awesome-postgres. A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

ChineseTone. 将汉字转换为拼音， 支持多音字，拼音 -> pin yin

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.

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

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.

monetdb-postgres-compare. MonetDB/Postgres-Comparision

pg_monz. This is the Zabbix monitoring template for PostgreSQL Database.

VecDB-Exp. C

GoBooks. List of Golang books

Frontend-Learning-Record. 本仓库会记录下我学习前端的经历，会有我学习过程中记录下的各式笔记

gevel. C

ora_migrator. Tools for Oracle to PostgreSQL migration

pg_auto_failover. Postgres extension and service for automated failover and high-availability

myduckserver. MySQL Analytics, Reimagined

go-mysql-elasticsearch. Sync MySQL data into elasticsearch or postgresql

duckdb_fdw. DuckDB Foreign Data Wrapper for PostgreSQL

pg_rewind. Tool for resynchronizing a Postgres database after failover

pg_jieba. Postgresql full-text search extension for chinese

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

sql_firewall. SQL Firewall Extension for PostgreSQL

Pinyin2Hanzi. 拼音转汉字， 拼音输入法引擎， pin yin -> 拼音

vops. C