Database Archives - Page 3 of 13

Stop Drawing ER Diagrams: How to Automate Database Documentation with SchemaSpy and dbdocs

June 17, 2026

Stop wasting hours manually drawing ER diagrams that go out of date instantly. Learn how to use SchemaSpy and dbdocs to automate your database documentation directly from your code.

Database

SQLFluff on Linux: Automate SQL Linting and Code Standards in Your CI/CD Pipeline

June 15, 2026

SQLFluff is a SQL linter and auto-formatter for Linux that catches style inconsistencies, enforces keyword casing, and integrates cleanly into GitHub Actions and GitLab CI pipelines. This guide walks through installation, configuration for MySQL/PostgreSQL dialects, CI/CD setup, and practical tips for rolling it out to an existing codebase.

Database

PostgreSQL Data Tiering: Moving Cold Data to S3 to Slash Costs

June 15, 2026

Is historical data clogging your PostgreSQL instance? Discover how to use Data Tiering with S3 and Foreign Data Wrappers to reduce costs and maintain high performance.

Database

Postgres Without the Server: Running PGlite in the Browser and Node.js

June 15, 2026

Run a full PostgreSQL engine inside your browser or Node.js with PGlite. No server, no Docker, and sub-100ms startup times for local-first apps and testing.

Database

PostgreSQL Database Design Patterns: Polymorphic Association vs EAV vs JSONB for Flexible Schema

June 13, 2026

Comparing Polymorphic Association, EAV, and JSONB in PostgreSQL for flexible schema design — from a real 2 AM production incident. Includes migration guide from EAV to JSONB and practical code examples.

Database

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.