Database Archives - Page 5 of 18

Multi-language Database Design: 3 Proven Strategies for PostgreSQL and MySQL

August 21, 2026

Don't let your database become a bottleneck as you scale globally. Explore the pros and cons of column-based, relational, and JSONB strategies for multi-language support.

Database

Mastering the MySQL Slow Query Log: Stop Guessing and Start Fixing Production Bottlenecks

August 21, 2026

Is your MySQL database dragging? Learn how to use the Slow Query Log to identify hidden performance bottlenecks, configure logging for production, and use tools like pt-query-digest to speed up your app.

Database

Beyond the Redis Hype: When Memcached is the Right Choice for High-Scale Caching

August 21, 2026

A real-world look at solving database bottlenecks using Memcached. Learn why its multithreaded architecture often outperforms Redis for simple, high-volume key-value caching.

Database

Deploying Milvus on Docker: A Production Guide for Enterprise AI and RAG Applications

August 19, 2026

A hands-on guide to deploying Milvus vector database on Docker, based on six months of production experience running a 50-million-vector RAG pipeline. Covers Standalone setup, configuration tuning for performance, index selection, and monitoring with Attu and Prometheus.

Database

Deploy Airbyte on Docker: Automate ELT Data Sync Across Databases and Warehouses

August 19, 2026

Manual data pipelines between databases and warehouses break down fast as your stack grows. Airbyte on Docker gives you a self-hosted ELT platform with 300+ connectors — this guide walks through deployment, configuring a PostgreSQL source, choosing the right sync mode, and monitoring jobs from day one.

Database

PocketBase Tutorial: Build a Real-Time Database and Backend with a Single Executable File

August 19, 2026

PocketBase bundles a SQLite database, REST API, authentication, file storage, and real-time subscriptions into a single executable file. This tutorial walks you through getting it running in minutes, building collections, handling auth, and deploying to production.

Database

Real-Time Notifications: Stop Polling and Start Using Postgres LISTEN/NOTIFY

August 3, 2026

Stop hammering your database with constant polling. Use Postgres LISTEN/NOTIFY and Node.js to build a sub-millisecond notification system that scales without the overhead of a dedicated message broker.

Database

Deploying QuestDB on Docker: A Guide to High-Velocity Time-Series Data

August 2, 2026

Scale your IoT or Fintech data with QuestDB on Docker. This guide covers high-speed ingestion, SQL optimization, and a direct comparison with InfluxDB and TimescaleDB.

Database

PostgreSQL Indexing: When B-Tree Isn’t Enough

August 2, 2026

PostgreSQL indexing goes far beyond B-Tree. Discover how GIN, GiST, and BRIN can slash query times and save gigabytes of disk space on large-scale databases.

Database

GitOps for Databases: Using Bytebase to Automate SQL Reviews and Prevent Downtime

August 1, 2026

Stop risking production downtime with manual SQL scripts. Learn how to implement a GitOps workflow using Bytebase to automate database reviews, linting, and deployments.