PostgreSQL – ITFROMZERO – Share tobe shared!

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.

Database

PostgreSQL Row Level Security (RLS): Securing Multi-tenant Data at the Core

By admin April 27, 2026

Learn how to configure PostgreSQL Row Level Security (RLS) for fine-grained data protection. An optimal solution for Multi-tenant/SaaS applications with real-world performance optimization tips.

Database

Mastering Logical Replication in PostgreSQL: Flexible and Practical Data Sync

By admin April 23, 2026

PostgreSQL Logical Replication enables selective data sync and minimizes downtime. This guide covers configuration steps and fixes for Primary Key and Sequence issues based on real-world experience.