OpenTelemetry SideCar 是獨立的 sidecar proxy,無需修改程式碼即可匯出 metrics 與 traces,適合監控 legacy 或封閉原始碼應用
AI-Powered PostgreSQL Performance Tuning with MCP - Introducing pgtuner_mcp
Symbols count in article: 12k Reading time ≈ 11 mins.
pgtuner_mcp is an MCP server for AI-driven PostgreSQL performance analysis, tuning advice, and health checks from your development workflow
Building Safe PostgreSQL Extensions with Rust - Introducing pg_where_guard
Symbols count in article: 7.6k Reading time ≈ 7 mins.
pg_where_guard is a Rust/pgrx PostgreSQL extension that blocks unsafe UPDATE and DELETE without WHERE clauses, preventing accidental data loss
Understand TLS/SSL networking flow
圖解 TLS/SSL 握手流程:從 ClientHello 到 Session Key 生成,完整解析 TLS 1.2 憑證驗證與加密建立過程
C language implement foreach
Symbols count in article: 3.7k Reading time ≈ 3 mins.
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
How can we use vscode debug PostgreSQL running process by source code?
Symbols count in article: 5.8k Reading time ≈ 5 mins.
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
Symbols count in article: 3.6k Reading time ≈ 3 mins.
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
postgresql source code install
手把手教學如何從 PostgreSQL 原始碼編譯安裝,在 Ubuntu 環境下載指定版本 source code 並進行 build、install 與 debug,適合想深入了解 PostgreSQL 內部運作的開發者
AWS Certified Solutions Architect - Associate (SAA-C02) 考試重點與心得
AWS SAA-C02 認證考試完整指南:涵蓋 S3 儲存類型、EC2 執行個體、EBS、Route53、SnowBall 等核心服務重點整理,包含服務比較、最佳實踐案例與考試準備建議
Serverless + CloudFormation 撰寫 lambda
使用 Serverless Framework 搭配 AWS CloudFormation (IaC) 撰寫與部署 Lambda 函式,介紹 serverless.yml 設定與 .NET Core Lambda 部署流程