Database – ITFROMZERO – Share tobe shared!

Getting Started with ClickHouse: A High-Performance OLAP Database for Large-Scale Analytics

By admin April 28, 2026

ClickHouse is a columnar OLAP database that lets you analyze hundreds of millions of rows in seconds. This guide covers installation on Linux, choosing the right table engine, importing real-world data, and production deployment tips for DevOps teams.

Database

PostgreSQL FDW: The Ultimate Trick to Query MySQL, MongoDB, and CSV Directly Without ETL

By admin April 28, 2026

Forget complex ETL! A detailed guide on using PostgreSQL FDW to query MySQL, MongoDB, and CSV directly. Speed up multi-source data processing with just a few SQL lines.

MySQL

MySQL GTID Replication Setup Guide: Advanced Data Synchronization and Automatic Failover

By admin April 27, 2026

A step-by-step guide to configuring MySQL GTID Replication on Ubuntu: set up Master and Slave, verify data synchronization, and handle automatic failover without manually tracking binlog positions.

MySQL

MySQL: Don’t Let utf8 Deceive You – The Ultimate Guide to Fixing Emojis and Font Issues with utf8mb4

By admin April 24, 2026

Don't let MySQL's 'utf8' mislead you. A detailed guide on configuring utf8mb4 to support Emojis and Vietnamese, plus how to handle the 767-byte index error based on real-world experience.

Database

Mastering Logical Replication in PostgreSQL: Flexible and Practical Data Sync

By admin April 23, 2026

PostgreSQL Logical Replication enables selective data sync and minimizes downtime. This guide covers configuration steps and fixes for Primary Key and Sequence issues based on real-world experience.

MySQL

MySQL 8 CTE: A Professional Solution for Hierarchical Data and Recursive Queries

By admin April 21, 2026

A detailed guide on using CTE and Recursive CTE in MySQL 8 to efficiently handle hierarchical data, replace complex Self-joins, and optimize query performance.

Database

Mastering MongoDB Aggregation Framework: Building Real-World Data Pipelines

By admin April 20, 2026

Learn to build optimized MongoDB Aggregation Pipelines through real-world examples. Explore $match, $group, $lookup, and how to handle the 100MB RAM limit for Big Data.

Artificial Intelligence tutorial - IT technology blog

What is an MCP Server? How to Connect Claude to a Database in Seconds

By admin April 20, 2026

A detailed guide on building an MCP Server to connect Claude AI with databases (SQLite, PostgreSQL). Enable AI to query data directly, safely, and professionally.

Database

Installing and Using Neo4j: When SQL “Gives Up” on Complex Relationships

By admin April 19, 2026

Stop struggling with complex SQL JOINs. Learn how to install Neo4j with Docker, optimize RAM, and use Python to build a friend recommendation system in just a few lines of code.

Database

PostgreSQL Indexing: Don’t Just Use B-Tree for Millions of Rows

By admin April 19, 2026

Stop overusing B-Tree for everything. This article shares practical experience on using GIN for JSONB, BRIN for Big Data, and how to create indexes without locking your production database.