Database – Page 4 – ITFROMZERO

Barman: Professional PostgreSQL Production Backup Solution – From WAL Archive to PITR

By admin May 27, 2026

Don't let pg_dump keep you up at night. Detailed guide on using Barman for professional PostgreSQL backup management with second-precision data recovery (PITR).

Database

Microservices Configuration Management: Why etcd is the Top Choice?

By admin May 24, 2026

Don't let microservices configuration management become a nightmare. Learn how to use etcd to effectively automate configurations and service discovery.

Database

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.