Database – ITFROMZERO – Share tobe shared!

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.

Database

ScyllaDB: Revolutionizing Write-Heavy System Performance as a Cassandra Alternative

By admin May 10, 2026

Tired of Cassandra's latency? ScyllaDB is a high-speed C++ rewrite that eliminates Garbage Collection overhead to achieve maximum write performance. Explore our setup and optimization guide.

Database

DuckDB: SQLite for Analytics – Master the Art of Processing Tens of GBs Smoothly on Your Laptop

By admin May 10, 2026

Discover DuckDB – the perfect alternative to Pandas for large-scale data processing on local machines. Learn how to query massive CSV/Parquet files directly and pick up practical performance optimization tips.

Database

Sysbench: How to Measure Real-World Load for MySQL and PostgreSQL (Not Just Theory)

By admin May 10, 2026

A detailed guide on using sysbench to benchmark MySQL and PostgreSQL performance through three stages: Prepare, Run, and Cleanup. Learn how to interpret TPS and Latency metrics to identify database bottlenecks.

Database

Free Your Hands with SchemaSpy: Automating ERD Diagrams and Database Documentation

By admin May 8, 2026

Stop drawing ERD diagrams by hand! A guide to using SchemaSpy for automated database scanning, generating HTML reports, and professional relationship diagrams in minutes.

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.