Digoal.zhou

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

A large personal knowledge archive in Chinese covering PostgreSQL, Greenplum, and related databases, with hundreds of articles on performance tuning, replication, backup, GIS, sharding, Oracle migration, and AI-assisted database learning.

常用管理脚本

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.

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

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

PostgreSQL SKILLs for AI Agent

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

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.

TPC-H like benchmark for PostgreSQL

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

No description.

blog

PostgreSQL's knowledge base for LLM fine tuning.

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

No description.

No description.

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

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

Open-source vector similarity search for Postgres

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

数据可视化笔记

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

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

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

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

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

This is the Zabbix monitoring template for PostgreSQL Database.

MonetDB/Postgres-Comparision

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

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.

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.

达尔文.skill —— 一个让你的Skill无限进化的系统：评估→改进→测试→保留或回滚 | Autoresearch-inspired autonomous skill optimization for Claude Code. Evaluate, improve, test, keep or revert.

DuckDB Foreign Data Wrapper for PostgreSQL

IPV4/IPV6 TVBOX 电视直播点播源收集

MySQL Analytics, Reimagined

Sync MySQL data into elasticsearch or postgresql

No description.

No description.

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

Postgres extension and service for automated failover and high-availability

List of Golang books

PostgreSQL ORM for Golang with focus on PostgreSQL features and performance

Postgresql full-text search extension for chinese

Making Postgres and Elasticsearch work together like it's 2017

SQL Firewall Extension for PostgreSQL

No description.

Tool for resynchronizing a Postgres database after failover

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

No description.

Universal memory layer for AI Agents

Huashu Design · HTML-native design skill for Claude Code · Claude Code 里 HTML 原生的设计 skill · 高保真原型 / 幻灯片 / 动画 + 20 设计哲学 + 5 维评审 + MP4 导出 · Agent-agnostic

你想蒸馏的下一个员工，何必是同事。蒸馏任何人的思维方式——心智模型、决策启发式、表达DNA。Distill how anyone thinks.

Tools for Oracle to PostgreSQL migration

VibeVoice: Expressive, longform conversational speech synthesis. (Community fork)

Claude Code is an agentic coding tool that lives in your terminal, understands your codebase, and helps you code faster by executing routine tasks, explaining complex code, and handling git workflows - all through natural language commands.

No description.

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

Windows Loader by Daz v2.2.2

High-performance connection pool for PostgreSQL

SymmetricDS is a database and file synchronization solution that is platform-independent, web-enabled, and database agnostic. SymmetricDS was built to make data replication across two to tens of thousands of databases and file systems fast, easy and resilient. We specialize in near real time, bi-directional data replication across large node networks over the WAN or LAN.

Metl is a simple, web-based integration platform that allows for several different styles of data integration including messaging, file based Extract/Transform/Load (ETL), and remote procedure invocation via Web Services. Read more at www.jumpmind.com/products/metl/overview

A list papers of learning how to building database system

RAG based pipeline for automated research paper summarization using Llamaindex, Mistral AI, and Hugging Face embeddings. This tool parses and summarizes academic documents with customizable chunking and asynchronous tree-based summarization.

TPC-H benchmark data generation in pure Rust

Papers for database systems powered by artificial intelligence (machine learning for database)

a text-based terminal client for Ollama

A CLI host application that enables Large Language Models (LLMs) to interact with external tools through the Model Context Protocol (MCP).

A substitute of SwitchOmega for Manifest v3

No description.

使用sentencepiece中BPE训练中文词表，并在transformers中进行使用。

Mac compatible Ollama Voice

No description.

Postgres read replica optimized for analytics

No description.

Protocol Buffer extension for PostgreSQL

High speed data loading utility for PostgreSQL

📺IPTV电视直播源更新工具🚀：包含💰央视、📡卫视、☘️广东及各省份地方台、🌊港·澳·台、🎬电影、🎥咪咕、🏀体育、🪁动画、🎮游戏、🎵音乐、🏛经典剧场；支持自定义增加频道；支持组播源、酒店源、订阅源、关键字搜索；每天自动更新两次，结果可用于TVBox等播放软件；支持工作流、Docker(amd64/arm64)、命令行、GUI运行方式 | IPTV live TV source update tool

An efficient storage and compute engine for both on-prem and cloud-native data analytics.

In-memory Table Access Method based on Arrow Array format

No description.

SuperPrompt is an attempt to engineer prompts that might help us understand AI agents.

🔍️ All-in-one tracing toolkit for Postgres

A postgres extension to avoid accidental mistakes

中文LLaMA-2 & Alpaca-2大模型二期项目 + 64K超长上下文模型 (Chinese LLaMA-2 & Alpaca-2 LLMs with 64K long context models)

Grok open release

DuckDB-Web - Source code of duckdb.org

set of functions and operators for executing similarity queries

[CVPR 2023] SadTalker：Learning Realistic 3D Motion Coefficients for Stylized Audio-Driven Single Image Talking Face Animation

vits2 backbone with multilingual-bert

Convert parquet to lance.

Apache Arrow is a multi-language toolbox for accelerated data interchange and in-memory processing

PostgreSQL for Search

No description.

PostgresML is an AI application database. Download open source models from Huggingface, or train your own, to create and index LLM embeddings, generate text, or make online predictions using only SQL.

A plugin that enables standard PG to have the operation and maintenance capabilities of enterprise level databases.

Citus shard migration tool

amazonriver 是一个将postgresql的实时数据同步到es或kafka的服务

Oracle-style global temporary tables for PostgreSQL

Transport coordinate between earth(WGS-84) and mars in china(GCJ-02).

a forked project from dbt2, can do a standard TPC-C test.

3D City Database - The Open Source CityGML Database

Database engine which is either RDBMS or GraphDB

Performance analysis tools based on Linux perf_events (aka perf) and ftrace

Similar images search for PostgreSQL

Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.

No description.

PostgreSQL Ultra-High-Dimensional Approximate Nearest Neighbor Search Extension

A production-ready, scalable Indexer for the Jina neural search framework, based on HNSW and PSQL

Writing a sqlite clone from scratch in C

pgsphere provides spherical data types, functions, and operators for PostgreSQL

B站录播姬 | BiliBili Stream Recorder | 哔哩哔哩直播录制

C library for accessing the PostgreSQL parser outside of the server environment

SnappyData - The Spark Database. Stream, Transact, Analyze, Predict in one cluster

Geohashing library for HAWQ, Greenplum DB, PostgreSQL

Undo storage implementation

PosgreSQL 9.4.1 with O_DIRECT(DirectIO) support

YugaByte DB is the open source, high-performance SQL database for building internet-scale, globally-distributed apps.

A JDBC driver for shard databases and tables

Scriptable database and system performance benchmark

This extension provides cheat (but useful) functions on PostgreSQL.

Version of PostgreSQL with built-in connection pooling

PG-Strom - Master development repository

No description.

No description.

A compact binary encoding for geographic data.

filter statements by their execution plans.

Various experiments with PostgreSQL clustering

PostgreSQL extension adding HyperLogLog data structures as a native data type

a curated list of awesome streaming frameworks, applications, etc

openBarter extends the mechanism of a CLOB - the central part of regular markets - and implements a multilateral barter.

A SymmetricDS data loader extension for elasticsearch

PostgreSQL proxy server.

Give PostgreSQL ability to manually force some decisions in execution plans.

PostgreSQL extension which implements a Foreign Data Wrapper (FDW) for ORC files.

Jupyter Notebooks for the Python Data Science Handbook

RoaringBitmap extension for greenplum-db

Point Cloud Library (PCL)

SQL on streams, backed by PostgreSQL

ZSON is a PostgreSQL extension for transparent JSONB compression

Fastsocket is a highly scalable socket and its underlying networking implementation of Linux kernel. With the straight linear scalability, Fastsocket can provide extremely good performance in multicore machines. In addition, it is very easy to use and maintain. As a result, it has been deployed in the production environment of SINA.

A TCP performance profiling tool.

PgSphere provides spherical data types, functions, operators, and indexing for PostgreSQL.

PostgreSQL extension for spatial indexing on a sphere

Vectorized executor to speed up PostgreSQL

PostgreSQL metrics monitor/dashboard

Automatic SQL injection and database takeover tool

The official sources for the RDKit library

pgAFIS - Automated Fingerprint Identification System support for PostgreSQL

Java Stored Procedure Wrapper: Calling PostgreSQL stored procedures from Java

No description.

Extension and scripts to run analogue of sysbench OLTP test using pgbench

This is a modified version of PostgreSQL with just-in-time compiler for expressions. Current base version is 9.6.1.

Facebook Graph Benchmark

No description.

OLTP Benchmark Framework

Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout

pgbouncer multhread version.

Another High Perofrmance Redis Proxy, Replacement of Twemproxy

FlashCache is a general purpose writeback block cache for Linux.

Compiled sysbench Tools for MySQL, PostgreSQL, Oracle

sysbench lua script for MySQL、PostgreSQL、Oracle, base on sysbench0.5

clone from sysbench0.5 and add some new feature.

Change data capture from PostgreSQL into Kafka

Kaa open-source middleware platform for building, managing, and integrating connected products with the Internet of Everything.

No description.

No description.

MySQL Binary Log connector

Scalable PostgreSQL

Main gperftools repository

A PostgreSQL foreign data wrapper for Redis

PostgreSQL data type for efficient storage of monetary values

High performance chinese tokenizer with both GBK and UTF-8 charset support developed by ANSI C

No description.

A better compressed bitset in Java

An open-source graph database

A list of cool features of Git and GitHub.

Postgresql full-text search extension for chinese

PostgreSQL Transparent Data Encryption tool development

Database takeover UDF repository

HAWQ and Greenplum TPC-DS benchmark

No description.

PgBouncer development

博客

结巴中文分词

No description.

zhparser is a PostgreSQL extension for full-text search of Chinese

开源免费的简易中文分词系统，PHP分词的上乘之选！

Repository of user-contributed Gmond Python DSO metric modules

An experimental PostgreSQL foreign data wrapper for MySQL

This Repository used to store <Hands-On PostgreSQL> video's PPT.

High-Availability JDBC