Database Archives - Page 9 of 18

PostgreSQL as a Graph Database: 6 Months with Apache AGE

June 13, 2026

Ditch the complex recursive CTEs. Discover how to use Apache AGE to run openCypher graph queries directly inside your PostgreSQL database for better performance and cleaner code.

Database

Scaling Real-time Leaderboards to 10M+ Users with Redis Sorted Sets

June 13, 2026

Is your database struggling with ranking millions of users? Learn how we migrated to Redis Sorted Sets to achieve sub-millisecond leaderboard updates at scale.

Database

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.

Database

Offline-First is a Philosophy, Not a Feature: A 6-Month SQLite Sync Review

June 8, 2026

A deep dive into building resilient offline-first apps. Based on six months in production, we analyze sync strategies, ULID implementation, and conflict resolution using SQLite and PostgreSQL.

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

Native MySQL High Availability: A Practical Guide to InnoDB Cluster and Router

June 4, 2026

Ditch the complex third-party HA tools. This guide shows you how to deploy a native MySQL InnoDB Cluster with MySQL Router for automated failover and zero data loss.

Database

Valkey: Install, Configure, and Migrate from Redis After the License Change

June 2, 2026

After Redis Ltd. changed its license to SSPL in 2024, our team migrated three environments to Valkey — the Linux Foundation-backed BSD fork. Six months in, here's the full guide: installation, configuration, and proven zero-downtime migration strategies from Redis to Valkey.

Database

Scaling Beyond Redis: A Hands-On Guide to DragonflyDB

June 2, 2026

Redis is fast, but its single-threaded nature wastes modern multi-core power. This guide shows you how to migrate to Dragonfly to achieve significantly higher throughput with less architectural complexity.

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.