Database Administration

PostgreSQL 17 Logical Replication: A Production-Ready Setup Walkthrough

PostgreSQL 17 brings the most significant logical replication improvements since the feature was introduced — failover slots, bidirectional replication scaffolding, and dramatically better DDL handling. This is a production-ready walkthrough: publication and subscription setup, conflict handling that does not surprise you, monitoring that catches replication lag before it cascades, and the failover and switchover patterns that work in real environments....

May 11, 2026 10 min

Meet Julien Moreau: The Database and Backend Engineering Expert

Get to know Julien Moreau, Dargslan's database and backend engineering author. Learn about his experience managing petabyte-scale databases and his practical approach to database education....

Apr 29, 2026 10 min

Book of the Week: PostgreSQL Database Setup — The Complete Guide to Production Databases

Discover PostgreSQL Database Setup: The Complete Guide. Learn how to install, configure, optimize, and secure PostgreSQL for production workloads with this comprehensive database administration guide....

Apr 24, 2026 11 min

Redis Caching: Setup and Best Practices for Application Performance

Implement Redis caching to boost your application performance. Learn installation, configuration, caching strategies, data structures, eviction policies, and monitoring....

Apr 21, 2026 12 min

MariaDB vs MySQL in 2026: Which Database Fork Should You Use?

A practical comparison of MariaDB and MySQL in 2026. Understand the differences in features, performance, licensing, and compatibility to make the right database choice....

Apr 21, 2026 12 min

How to Migrate from MySQL to PostgreSQL: A Complete Step-by-Step Guide

Complete practical guide to migrating your database from MySQL to PostgreSQL. Covers schema conversion, data migration, application code changes, and testing strategies....

Apr 20, 2026 14 min

10 SQL Queries Every Database Administrator Should Master

Essential SQL queries for daily database administration. From performance monitoring to data analysis, these 10 queries will make you a more effective DBA....

Apr 20, 2026 11 min

Redis Caching Strategies: Speed Up Your Applications with In-Memory Data

Implement effective Redis caching patterns to speed up your applications....

Mar 26, 2026 11 min

PostgreSQL vs MySQL: Which Database Should You Choose in 2026?

PostgreSQL vs MySQL comparison for 2026. Features, performance, SQL standards, JSON support, replication, and use case recommendations....

Mar 25, 2026 5 min