PostgreSQL Archives - ITFROMZERO

Mastering Drizzle ORM with TypeScript and PostgreSQL: Type-Safe, Ultra-Lightweight, and High-Performance

By IT From Zero October 9, 2026

A practical guide to Drizzle ORM with TypeScript and PostgreSQL: designing type-safe schemas, configuring migrations with Drizzle Kit, and optimizing query performance.

Python

Optimizing PostgreSQL Performance in Python with asyncpg: Resolving I/O Bottlenecks and Ingesting 100k Records/s

By IT From Zero October 9, 2026

Real-world lessons from a production I/O bottleneck: A complete guide to migrating to asyncpg, configuring connection pools properly, and bulk-ingesting 100k records in 0.8s via PostgreSQL binary protocol.

Docker

Deploying n8n with Docker Compose and PostgreSQL: A Guide to Self-Hosted Automation

By IT From Zero October 7, 2026

Compare n8n deployment models and follow a step-by-step guide to set up a robust n8n + PostgreSQL cluster ready to handle production-scale internal automations.

Security

Securing PostgreSQL Server on Linux: Hands-on with pg_hba.conf, pgcrypto, and pgaudit

By IT From Zero October 6, 2026

Protect PostgreSQL on Linux across 3 layers: restrict IPs with pg_hba.conf, encrypt sensitive columns with pgcrypto, and audit logs for SOC2/PCI-DSS with pgaudit.

Fedora

How to Install and Configure Keycloak on Fedora Server: Building Single Sign-On (SSO) and OAuth2/OIDC Systems

By IT From Zero October 4, 2026

A comprehensive guide to installing and configuring Keycloak on Fedora Server: from OpenJDK and PostgreSQL setup to Systemd optimization, Nginx reverse proxy, and OAuth2/OIDC SSO integration.

Development

Building an Asynchronous REST API with FastAPI and Async SQLAlchemy 2.0: Connection Pool Optimization & Alembic Migrations

By IT From Zero October 4, 2026

A practical guide to building asynchronous REST APIs with FastAPI and Async SQLAlchemy 2.0. Learn connection pool optimization, Alembic migrations, and high-concurrency production practices.

Database

A Guide to pgBackRest for PostgreSQL: Parallel Backups, S3 Compression, and PITR

By IT From Zero October 2, 2026

Real-world incident response for accidental production data loss at midnight with pgBackRest: Multi-threaded S3 backups and precise Point-in-Time Recovery (PITR).

Database

Automating PostgreSQL Partitioning with pg_partman: A Lifesaver for Terabyte-Scale Tables

By IT From Zero September 26, 2026

Is your massive PostgreSQL table slowing down queries? Learn how to automate partitioning with pg_partman to manage billions of records and automate data cleanup.

MySQL

Migrating PostgreSQL to MySQL: Hard-won Lessons and a Real-world Workflow

By IT From Zero September 17, 2026

A step-by-step guide to the PostgreSQL to MySQL migration process, covering data type discrepancies and SQL syntax fixes to ensure data integrity.

Database

Odyssey: The Ultimate Solution to Save PostgreSQL from Bottlenecks at Scale

By IT From Zero September 17, 2026

Switch from PgBouncer to Odyssey to leverage multi-threaded power for PostgreSQL. A detailed guide on optimizing configurations to handle tens of thousands of concurrent connections in enterprise environments.