A Rust/pgrx PostgreSQL extension that blocks unsafe UPDATE/DELETE statements without WHERE clauses.
Understand TLS/SSL networking flow
TLS (Transport Layer Security) is a cryptographic protocol that provides secure communication over a network, commonly used to secure HTTP traffic (i.e.,
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.
Using gdb for command-line debugging still feels inconvenient. I initially wanted to find a simpler way to directly debug the PostgreSQL source code under
Azure PostgreSQL Flexible long term backup with Managed Identity
Symbols count in article: 3.6k Reading time ≈ 3 mins.
This ariticle will guide us how to do long-term backup (more than 35 days) on Azure PostgreSQL Flexible.
postgresql source code install
因為工作需要最近在研究 postgresql DB,postgresql DB 是一個 Open Source RDBMS,所以有任何問題疑問都可以把 source code 下載並 debug 了解原因,本篇希望可以快速幫助想要透過 source code 安裝 postgresql DB 的人
AWS Certified Solutions Architect - Associate (SAA-C02) 考試重點與心得
AWS SAA-C02 認證考試完整指南:涵蓋 S3 儲存類型、EC2 執行個體、EBS、Route53、SnowBall 等核心服務重點整理,包含服務比較、最佳實踐案例與考試準備建議,助您順利通過 AWS 解決方案架構師認證考試
Serverless + CloudFormation 撰寫 lambda
AWS lambda 作為 serverless 服務,之前有介紹過 AWS Lambda 初體驗 by .net core,本次要介紹 serverless 框架搭配 AWS CloudFormation (IaC)
Postgresql AutoVacuum 介紹
Symbols count in article: 7.3k Reading time ≈ 7 mins.