digoal/blog

★ 8,485HTMLAudience · dataComplexity · 1/5Setup · easy

Mindmap

mindmap
  root((digoal-blog))
    Topics
      Performance tuning
      High availability
      Backup and recovery
      Security and auditing
    Database tech
      PostgreSQL
      Greenplum
      DuckDB
      Oracle migration
    Format
      Markdown articles
      Video course links
      Chinese language
    Audience
      DB administrators
      DB developers

mindmap root((digoal-blog)) Topics Performance tuning High availability Backup and recovery Security and auditing Database tech PostgreSQL Greenplum DuckDB Oracle migration Format Markdown articles Video course links Chinese language Audience DB administrators DB developers

Click or tap to explore — scroll the page freely

Things people build with this

USE CASE 1

Browse Chinese-language deep-dive articles on PostgreSQL performance tuning, high availability, and maintenance

USE CASE 2

Access video course notes covering multi-day PostgreSQL and Greenplum training for database administrators

USE CASE 3

Find categorized guides for migrating from Oracle to PostgreSQL in a Chinese enterprise context

Tech stack

PostgreSQLGreenplumHTMLMarkdown

Getting it running

Difficulty · easy Time to first run · 5min

In plain English

This repository is a personal technical blog and knowledge archive maintained by a database expert who goes by the handle digoal. The content is written primarily in Chinese and covers PostgreSQL, Greenplum, and related database technologies in depth. Rather than being a software project you install or run, it is a large collection of articles, course notes, and study materials organized as files in a Git repository. The README itself functions as a table of contents, listing hundreds of articles grouped by topic. Categories include application development with PostgreSQL, daily database maintenance, monitoring, backup and recovery, high availability, security and auditing, performance tuning, replication, read/write splitting, horizontal sharding, analytics and parallel processing, database extensions and plugins, version upgrade guides, Oracle migration to PostgreSQL, GIS and spatial data, time-series data, graph search, and more. The repository also includes links to recorded video courses covering multi-day training sessions on PostgreSQL and Greenplum for database administrators and developers, as well as links to courses on AI-assisted database learning, OceanBase, DuckDB, Milvus, and other tools added in more recent entries. The articles appear to be written over many years, with entries organized by year and month in the file structure. The README lists thousands of individual article links. Some articles are philosophical or strategic, discussing how to choose between databases, the future of open-source databases, or how to build a technical community. This kind of repository is used as a long-form reference: someone learning PostgreSQL in a Chinese-speaking context would browse the categorized index to find articles matching a specific topic, then read the corresponding Markdown files. Contributions and corrections are welcomed via GitHub issues or direct contact. The full README is longer than what was shown.

Copy-paste prompts

Prompt 1

Based on the digoal blog archive, what are the recommended steps for setting up PostgreSQL high availability with streaming replication?

Prompt 2

Using topics from the digoal PostgreSQL blog, how do I implement horizontal sharding and read/write splitting in a production PostgreSQL cluster?

Prompt 3

Help me find and summarize the key points from digoal's articles about PostgreSQL backup and point-in-time recovery strategies

Open on GitHub → Explain another repo

← digoal on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.