postgresql Archives - Page 3 of 8

Scaling PostgreSQL: A Practical Guide to Pgpool-II Load Balancing and HA

June 8, 2026

Build a resilient PostgreSQL cluster with Pgpool-II. This guide walks through configuring Load Balancing, Watchdog HA, and automated failover to handle traffic spikes without downtime.

Database

Scalable ELT: How We Replaced 2,500 Lines of SQL with dbt and Postgres

June 8, 2026

Ditch the broken stored procedures. Learn how we used dbt and PostgreSQL to turn a 2,500-line SQL nightmare into a modular, tested, and high-performance ELT pipeline.

Programming

Building a Production-Ready REST API with Spring Boot, Spring Security, JPA, and Docker

June 5, 2026

A step-by-step guide to building a secure, production-ready REST API with Spring Boot 3, Spring Security, Spring Data JPA, and Docker. Covers project setup, entity modeling, authentication configuration, Dockerization with multi-stage builds, and production monitoring with Actuator — drawn from real migration experience.

Database

Deploy FerretDB on Docker: MongoDB-Compatible Open Source Database Built on PostgreSQL

June 5, 2026

FerretDB is an open-source proxy that lets you use MongoDB drivers and tooling while storing data in PostgreSQL — Apache 2.0 licensed, no SSPL. This guide covers deploying FerretDB with Docker Compose, connecting via mongosh and PyMongo, and knowing when it's the right fit for your stack.

Database

SQL Joins in Production: How We Fixed Our 10-Second Query Problem

June 1, 2026

A production-focused guide to SQL Joins. Learn the differences between INNER, LEFT, and FULL OUTER joins, and discover how to optimize query performance using indexing and CTEs based on real-world experience.

Database

Scaling PostgreSQL: A Hands-on Guide to YugabyteDB Architecture and Setup

June 1, 2026

PostgreSQL scaling hitting a limit? This guide walks you through setting up YugabyteDB for horizontal scalability and high availability without losing SQL compatibility.

Database

Hardening Multi-tenant Apps: Why You Need PostgreSQL Row Level Security

May 28, 2026

Discover how PostgreSQL Row Level Security (RLS) provides a native, foolproof layer of protection for multi-tenant apps. Stop relying on manual filters and secure your data at the source.

Database

PostgreSQL WAL: Production Lessons on Performance and Recovery

May 27, 2026

PostgreSQL WAL is more than just a log; it's the key to performance and data safety. Explore production-tested configurations, PITR setups, and monitoring tips.

Database

PostgreSQL Performance Analysis with pg_stat_statements: Find and Fix Slow Queries

May 25, 2026

pg_stat_statements is a built-in PostgreSQL extension that tracks aggregated execution statistics for every query — total time, call count, cache hit rate, and more. This guide walks through enabling it, querying the data to find your worst bottlenecks, and turning those stats into concrete index and query optimizations for production.

Database

Scaling Database Performance: A Practical Guide to Read Replicas in PostgreSQL and MySQL

May 24, 2026

Is your database hitting 100% CPU? This guide shows you how to implement Read Replicas in PostgreSQL and MySQL to offload traffic and keep your app fast.