Database Archives - ITFROMZERO - Share tobe shared!

Optimizing Redis RAM with HyperLogLog and Bloom Filter: Counting and Deduplicating at Scale

By IT From Zero October 26, 2026

Learn how to use Redis HyperLogLog and Bloom Filter to count unique visitors and deduplicate large-scale data, slashing RAM usage by over 95% compared to traditional Sets.

Database

Diagnosing and Resolving Deadlocks in PostgreSQL: Inspecting Lock Trees and Configuring Proper Timeouts

By IT From Zero October 26, 2026

An in-depth look at the root causes of PostgreSQL deadlocks, step-by-step reproduction, Lock Tree query techniques to locate root blockers, and timeout tuning to safeguard your system.

Database

MySQL Group Replication Tutorial: Building an Auto-Failover InnoDB Cluster

By IT From Zero October 25, 2026

A step-by-step guide to setting up a MySQL InnoDB Cluster with Group Replication and MySQL Shell, enabling automated detection and failover in 2–3 seconds.

Database

How to Install and Use VictoriaMetrics: An Optimized Time-Series DB to Replace Prometheus

By IT From Zero October 19, 2026

Compare monitoring scaling strategies and learn how to deploy VictoriaMetrics with Docker, cutting RAM usage by 4x and saving up to 7x disk space compared to Prometheus.

Database

Configuring MySQL Read/Write Splitting with ProxySQL: Offload Read Queries Without Touching Application Code

By IT From Zero October 18, 2026

MySQL Master hitting 100% CPU while replicas sit idle? A step-by-step guide to configuring automatic Read/Write Splitting with ProxySQL to save production without touching application code.

Database

How to Install and Configure pgRouting on PostgreSQL: Build Your Own Shortest Path Routing Engine

By IT From Zero October 17, 2026

A hands-on guide to resolving logistics dispatch bottlenecks: installing pgRouting on PostgreSQL, building graph topologies, and computing optimal shortest paths.

Database

Deploying Qdrant with Docker: Optimizing the Rust-Powered Vector Search Engine for Production RAG

By IT From Zero October 16, 2026

Battle-tested guide to deploying Qdrant Vector Search Engine with Docker for RAG. Learn how Rust-powered mmap cuts RAM usage by 70%, prevents OOM errors, and handles production disk full issues.

Database

Real-Time Without a Message Broker: Leveraging PostgreSQL LISTEN and NOTIFY with WebSockets

By IT From Zero October 15, 2026

Is your infrastructure overwhelmed by relentless polling and bulky message brokers? Leverage PostgreSQL's built-in LISTEN/NOTIFY alongside WebSockets to build a sleek, transaction-safe, and resource-efficient real-time notification system.

Database

Getting Started with LanceDB: A Lightweight Embedded Vector Database for AI and Multimodal Search

By IT From Zero October 12, 2026

Struggling with high RAM usage and the operational overhead of complex vector database clusters? Discover LanceDB: an embedded, in-process, zero-server vector database that enables resource-efficient AI applications and multimodal search.

Database

Mastering Drizzle ORM with TypeScript and PostgreSQL: Type-Safe, Ultra-Lightweight, and High-Performance

By IT From Zero October 9, 2026

A practical guide to Drizzle ORM with TypeScript and PostgreSQL: designing type-safe schemas, configuring migrations with Drizzle Kit, and optimizing query performance.