Database – Page 5 – ITFROMZERO

Artificial Intelligence tutorial - IT technology blog

Build Your Own Text-to-SQL System with Vanna.ai: Let AI Handle 80% of Mundane Reporting Tasks

By admin May 8, 2026

Learn to build a professional Text-to-SQL system with Vanna.ai and Python. This article shares real-world experiences to help reduce mundane reporting tasks for tech teams by 70%.

MySQL

MySQL Clone Plugin: How to Copy Hundreds of GBs in a Flash Instead of Waiting for mysqldump

By admin May 6, 2026

Forget mysqldump! A detailed guide on using MySQL Clone Plugin to copy data directly between servers at ultra-high speeds, safe for databases of hundreds of GBs.

Database

Database Encryption: Don’t Leave Your Data Exposed with pgcrypto and AES_ENCRYPT

By admin May 5, 2026

Don't let user data leak in plain-text. Learn how to use pgcrypto and AES_ENCRYPT to encrypt sensitive data according to modern security standards.

Database

Mastering CockroachDB: When a ‘Resilient’ SQL Database Helps You Sleep Better

By admin May 1, 2026

A 2 AM system crash is every developer's nightmare. Discover how to deploy CockroachDB—a distributed SQL database with self-healing capabilities for absolute uptime.

Database

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.