Database – Page 5 – ITFROMZERO

MongoDB Change Streams in Node.js: Real-Time Data Change Tracking

By IT From Zero June 18, 2026

MongoDB Change Streams let your Node.js application listen for data changes in real time instead of polling. This article covers practical implementation, resume token handling, and safe reconnect strategies for production environments.

Database

Setting Up Milvus Vector Database with Docker: Building a Knowledge Store for RAG and AI

By IT From Zero June 18, 2026

A guide to installing Milvus Vector Database with Docker Compose, creating collections, storing vector embeddings, and building a complete RAG pipeline. Includes tips on choosing index types, chunking strategies, and production optimization from real-world experience.

Database

ArangoDB: The All-in-One Solution Replacing MongoDB, Redis, and Neo4j

By IT From Zero June 18, 2026

ArangoDB is a Native Multi-model solution that replaces MongoDB, Redis, and Neo4j with a single engine. Check out our guide to installing and optimizing RocksDB to speed up your system.

Database

pg_stat_statements in PostgreSQL: Find and Optimize Resource-Hungry SQL Queries

By IT From Zero June 16, 2026

pg_stat_statements is a PostgreSQL extension that runs in the background and continuously accumulates execution statistics for every SQL statement, letting you pinpoint exactly which queries are consuming the most CPU, I/O, and time. This guide walks through installation, configuration, and practical analysis queries to track down performance bottlenecks in PostgreSQL.

Database

SQLite in Production: Effortless Real-time Backup with Litestream

By IT From Zero June 15, 2026

Stop worrying about data loss with SQLite. Learn how to use Litestream to automatically back up your database to Cloudflare R2/S3 in real time, giving your production application rock-solid data protection.

Database

Getting Started with ChromaDB: The Open-Source Vector Database for Building AI Agent Knowledge Systems

By IT From Zero June 13, 2026

ChromaDB is an open-source vector database for semantic storage and search — lightweight enough to run locally, powerful enough to serve as the foundation for RAG systems and AI Agents. This guide walks through installation, document indexing, semantic search queries, and Docker deployment with practical, step-by-step examples.

Database

Database Version Control with Liquibase: Automating CI/CD and ‘Painless’ Rollbacks

By IT From Zero June 9, 2026

Manual database management is the fastest route to a deployment disaster. Discover how to use Liquibase to automate migrations and secure your data just like you manage code with Git.

Database

Memcached: When to Choose This ‘Veteran’ Over Redis?

By IT From Zero June 8, 2026

Memcached remains a top choice for systems requiring massive throughput. Explore installation guides, real-world comparisons with Redis, and security tips to keep your system safe.

Database

KeyDB: The Multi-Threaded Fork That Supercharges Redis on Multi-Core Servers

By IT From Zero June 1, 2026

Is your Redis CPU-bound? Discover KeyDB—a multi-threaded fork that boosts performance 5x and offers powerful Active Replication for large-scale systems.

Database

PostgreSQL Dynamic Data Masking: Stop Leaking Customer Data in Dev/Test

By IT From Zero May 31, 2026

Forget manual UPDATE scripts! Learn how to use postgresql_anonymizer to professionally and safely mask sensitive data in PostgreSQL for Dev/Test environments.