Database – Page 5 – ITFROMZERO

Scaling PostgreSQL ‘Unlimited’ with Citus: From 1 Billion to Tens of Billions of Records

By admin May 22, 2026

Citus is the leading solution for Horizontal Sharding in PostgreSQL. Learn how to set up a cluster, choose a Shard Key, and optimize performance for systems with billions of records.

Database

QuestDB: Handling 4 Million Records/Sec and Ending Midnight Database Crash Anxiety

By admin May 22, 2026

Set up and optimize QuestDB to process millions of records per second. A detailed guide on replacing traditional databases with high-performance time-series solutions for IoT.

Database

Atlas (Ariga): Database Schema Management as Code and Migration Automation

By admin May 21, 2026

Atlas (Ariga) enables IaC-style database schema management: describe your desired state, auto-generate migrations, lint destructive changes, and detect drift between code and your live database. This article compares Atlas with Flyway/Liquibase and walks through a real-world PostgreSQL setup.

Database

Using Debezium for Change Data Capture (CDC) from MySQL and PostgreSQL: Real-Time Sync to Kafka Without Touching Your Application

By admin May 21, 2026

A practical guide to setting up Debezium for real-time Change Data Capture (CDC) from MySQL and PostgreSQL, streaming events to Kafka — no application changes required, just reading the transaction log. Covers Docker Compose setup, connector registration, and common troubleshooting.

Database

SurrealDB Tutorial: A Database to Replace PostgreSQL, Redis, and Neo4j?

By admin May 20, 2026

Forget about installing Postgres, Redis, and Neo4j all at once. Discover SurrealDB - a Multi-model database written in Rust that optimizes real-time applications and simplifies backend architecture.

Database

PostgreSQL Full-Text Search: High-Performance Vietnamese Search Without Elasticsearch

By admin May 19, 2026

Don't rush to install Elasticsearch! A detailed guide on building high-speed, accurate Vietnamese search directly in PostgreSQL using only tsvector and GIN Index.

Database

Deploying MariaDB Galera Cluster: A Multi-master High Availability Solution for Production

By admin May 16, 2026

A detailed guide on setting up a 3-node MariaDB Galera Cluster. This synchronous multi-master solution ensures your database system stays online and secure against hardware failures.

Database

Meilisearch: A “Lightning-Fast” Search Engine to Replace Elasticsearch for Small and Mid-sized Projects

By admin May 16, 2026

Meilisearch is a high-speed search solution and a perfect alternative to Elasticsearch for small to medium websites. This article covers setup, configuration, and practical insights from 6 months of production use.

Database

Valkey Installation Guide: The Perfect Open Source Redis Alternative

By admin May 16, 2026

Valkey is a fully open-source fork of Redis created after its license change. Here is a detailed guide to installing Valkey on Docker and Ubuntu for developers.

Database

Horizontal MySQL Sharding with Vitess: Scaling Billions of Records with Zero Downtime

By admin May 13, 2026

Learn how to shard MySQL with Vitess to scale your system to billions of records with zero downtime. Practical insights on Vindex, resharding, and performance optimization for DevOps.