// Popular Articles
pg_jsonschema: enforce JSON Schema on jsonb columns at 15x the speed of PL/pgSQL
Postgres' jsonb is great until someone inserts garbage. pg_jsonschema bolts JSON Schema validation onto json/jsonb columns via CHECK constraints — written in Rust, ~10–15x faster than the PL/pgSQL alternative, and now ships a compiled-schema mode for another 1.8x on hot paths.
Database Replication: How Production Systems Stay Fast and Available When One DB Fails
One database is fine — until traffic grows or it crashes. Replication is the first real step in scaling: copy writes from a Primary to Replicas so reads scale, failover gets safe, and one machine stops being a single point of failure. Here's how it actually works, what breaks, and the tradeoffs nobody mentions.
PostgREST: Biến PostgreSQL thành REST API trong vài phút (không cần viết backend)
PostgREST là web server viết bằng Haskell, tự động sinh REST API đầy đủ từ schema PostgreSQL của bạn. 27k+ sao GitHub, MIT, ~2000 req/s, dùng JWT + RLS để phân quyền. Đây là công cụ làm nền REST cho cả Supabase, Neon và Aiven.
DBcooper: database client mã nguồn mở cho Postgres, Redis, ClickHouse — có AI viết SQL
DBcooper là GUI database client miễn phí, MIT license, gộp Postgres, SQLite, Redis và ClickHouse vào một app Tauri v2. Tính năng nổi bật: AI sinh SQL biết schema, ER diagram, command palette, SSH tunnel. Hiện chỉ chạy macOS.
Misconfigured PostgreSQL is a hacker's front door — here's Canonical's hardening playbook
Canonical's free PostgreSQL security guide turns defaults into a breach surface. Five pillars — sandboxing, supply chain, storage, logging, install — map to PCI-DSS, CIS, DISA-STIG. Here's what actually matters.