Long-form English write-ups, mostly on PostgreSQL internals and the Rust tooling built around them. Each post accompanies an open-source project — source links are in the posts.
PostgreSQL Extensions in Rust (pgrx)
Building and debugging PostgreSQL extensions with Rust and the pgrx framework.
- Building a PostgreSQL Foreign Data Wrapper (FDW) in Rust with pgrx (2025-06-30)
Learn how to build a PostgreSQL Foreign Data Wrapper (FDW) in Rust using pgrx — query external data sources as regular PostgreSQL tables - Building Safe PostgreSQL Extensions with Rust - Introducing pg_where_guard (2025-01-02)
pg_where_guard is a Rust/pgrx PostgreSQL extension that blocks unsafe UPDATE and DELETE without WHERE clauses, preventing accidental data loss
PostgreSQL Replication, WAL and CDC
Streaming the write-ahead log, logical replication and change data capture.
- pg_dbmigrator: Near-Zero-Downtime PostgreSQL Migration with Online Mode (2026-05-03)
A hands-on guide to pg_dbmigrator, a Rust CLI for migrating PostgreSQL databases — covering offline dump/restore and the online logical-replication mode for near-zero-downtime cutovers. - pg-walstream: High-Performance PostgreSQL WAL Streaming in Rust (2026-04-21)
A high-performance Rust library for parsing and streaming PostgreSQL WAL messages via logical replication — with load testing results showing 200K+ events/sec. - pg2any: A Rust CDC Library for Streaming PostgreSQL Changes to Any Database (2025-09-09)
pg2any is a Rust CDC library that streams PostgreSQL changes via logical replication to MySQL, SQL Server, or SQLite with crash-safe persistence
PostgreSQL Monitoring and Performance
Per-backend monitoring, tuning and source-level debugging.
- pg_pidstat: Real-Time Per-Backend CPU, Memory, and I/O Monitoring for PostgreSQL (2026-04-27)
pg_pidstat is a Rust-based PostgreSQL extension that adds real-time per-backend CPU, memory, I/O, and context switch monitoring via a single SQL view. - AI-Powered PostgreSQL Performance Tuning with MCP - Introducing pgtuner_mcp (2025-01-13)
pgtuner_mcp is an MCP server for AI-driven PostgreSQL performance analysis, tuning advice, and health checks from your development workflow - How can we use vscode debug PostgreSQL running process by source code? (2023-06-02)
Step-by-step guide to debug a running PostgreSQL process with VSCode on Linux — build from source with debug symbols and set breakpoints - Azure PostgreSQL Flexible long term backup with Managed Identity (2022-12-25)
Step-by-step guide to configure long-term backup (beyond 35 days) on Azure PostgreSQL Flexible Server using Managed Identity, pg_dump, and Azure Blob Storage
Systems and Infrastructure
Container runtimes, observability and networking internals.
- RustBox - Docker-Lite Sandbox for Hackers and Learners (2025-06-01)
RustBox is a Docker-like container runtime written in Rust, built on Linux namespaces, cgroups and OverlayFS, with multi-container orchestration and a full CLI. - Instrument Any App Instantly Using OpenTelemetry_SideCar (2025-06-01)
OpenTelemetry SideCar is a standalone sidecar proxy that exports metrics and traces without code changes, making it a good fit for monitoring legacy or closed-source applications. - Understand TLS/SSL networking flow (2024-11-11)
An illustrated walkthrough of the TLS/SSL handshake, from ClientHello to session key generation, covering TLS 1.2 certificate verification and how encryption is established. - C language implement foreach (2024-04-17)
In PostgreSQL, there isn't a native foreach loop construct in C, because C itself doesn't have a foreach loop as you might find in higher-level languages like
Feeds
- PostgreSQL-only Atom feed — English PostgreSQL posts only.
- Full site Atom feed — all posts, mostly Traditional Chinese.