Posted inDatabase
Dragonfly: A Redis Alternative for Systems with Millions of Requests
Is single-threaded Redis slowing down your system? Discover Dragonfly - a multi-threaded in-memory database fully compatible with Redis but 25x faster.
Posted inDatabase
PostgreSQL Anonymizer: The Ultimate Trick to Mask Production Data for Staging Without PII Leaks
No more worrying about PII leaks during Production dumps. A detailed guide on using PostgreSQL Anonymizer to automatically anonymize emails and phone numbers for Staging/Dev.
Posted inDatabase
Analyzing MySQL Slow Query Log with pt-query-digest: Pinpointing the Real Culprit Behind Database Slowdowns
pt-query-digest from Percona Toolkit analyzes MySQL Slow Query Log by grouping and ranking queries by their performance impact. A step-by-step guide: enable logging, install the tool, read the report, and optimize real-world queries.
Posted inDatabase
Professional Database Schema Management with Bytebase: GitOps Workflow and SQL Review for Dev Teams
A detailed guide on using Bytebase to manage Database Schema Changes following GitOps standards. Help dev teams automate SQL reviews for safer and more professional deployments.
Posted inDatabase
pg_cron: Schedule Automated Jobs Inside PostgreSQL Without System Cron
pg_cron is an extension that lets you schedule recurring jobs directly inside PostgreSQL without needing system cron or pgAgent. This article walks through installation, creating jobs for log cleanup and materialized view refreshes, and practical tips for managing jobs effectively.
Posted inDatabase
MongoDB Change Streams in Node.js: Real-Time Data Change Tracking
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.
Posted inDatabase
Setting Up Milvus Vector Database with Docker: Building a Knowledge Store for RAG and AI
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.
Posted inDatabase
ArangoDB: The All-in-One Solution Replacing MongoDB, Redis, and Neo4j
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.
Posted inDatabase
pg_stat_statements in PostgreSQL: Find and Optimize Resource-Hungry SQL Queries
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.
Posted inDatabase
SQLite in Production: Effortless Real-time Backup with Litestream
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.