PostgreSQL – Page 2 – ITFROMZERO

Atlas (Ariga): Database Schema Management as Code and Migration Automation

By admin May 21, 2026

Atlas (Ariga) enables IaC-style database schema management: describe your desired state, auto-generate migrations, lint destructive changes, and detect drift between code and your live database. This article compares Atlas with Flyway/Liquibase and walks through a real-world PostgreSQL setup.

Database

Using Debezium for Change Data Capture (CDC) from MySQL and PostgreSQL: Real-Time Sync to Kafka Without Touching Your Application

By admin May 21, 2026

A practical guide to setting up Debezium for real-time Change Data Capture (CDC) from MySQL and PostgreSQL, streaming events to Kafka — no application changes required, just reading the transaction log. Covers Docker Compose setup, connector registration, and common troubleshooting.

Database

PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch

By admin May 19, 2026

Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.

Database

Sysbench: How to Measure Real-World Load for MySQL and PostgreSQL (Not Just Theory)

By admin May 10, 2026

A detailed guide on using sysbench to benchmark MySQL and PostgreSQL performance through three stages: Prepare, Run, and Cleanup. Learn how to interpret TPS and Latency metrics to identify database bottlenecks.

Database

Free Your Hands with SchemaSpy: Automating ERD Diagrams and Database Documentation

By admin May 8, 2026

Stop drawing ERD diagrams by hand! A guide to using SchemaSpy for automated database scanning, generating HTML reports, and professional relationship diagrams in minutes.

Database

Database Encryption: Don’t Leave Your Data Exposed with pgcrypto and AES_ENCRYPT

By admin May 5, 2026

Don't let user data leak in plain-text. Learn how to use pgcrypto and AES_ENCRYPT to encrypt sensitive data according to modern security standards.

Development

Why I Chose Drizzle ORM Over Prisma for a Real-World TypeScript Project

By admin May 5, 2026

Drizzle ORM is becoming a top choice for high-performance TypeScript projects. This article shares real-world experiences, compares it with Prisma, and provides an A-Z setup guide.

Database

Build Your Own Backend-as-a-Service with Self-hosted Supabase via Docker

By admin May 5, 2026

A guide to setting up self-hosted Supabase using Docker as a Firebase alternative. Includes tips on configuring PostgreSQL, SMTP, and RAM optimization for VPS.

Database

Deploying Patroni: The ‘Sleep Better’ Solution for PostgreSQL Administrators

By admin May 3, 2026

Database outages in the middle of the night are no longer a concern. A detailed guide on deploying Patroni to automate PostgreSQL Failover and ensure 24/7 availability.

Database

PostgreSQL FDW: The Ultimate Trick to Query MySQL, MongoDB, and CSV Directly Without ETL

By admin April 28, 2026

Forget complex ETL! A detailed guide on using PostgreSQL FDW to query MySQL, MongoDB, and CSV directly. Speed up multi-source data processing with just a few SQL lines.