Database – ITFROMZERO – Share tobe shared!

Odyssey: The Ultimate Solution to Save PostgreSQL from Bottlenecks at Scale

By admin September 17, 2026

Switch from PgBouncer to Odyssey to leverage multi-threaded power for PostgreSQL. A detailed guide on optimizing configurations to handle tens of thousands of concurrent connections in enterprise environments.

Database

Unit Testing for PostgreSQL with pgTAP: Don’t Let the Database Be a ‘Blind Spot’ During Deployment

By admin September 13, 2026

Don't let database errors ruin your project. Learn how to use pgTAP to professionally automate schema, function, and trigger testing for PostgreSQL.

Database

Dolt: When Databases Marry Git – An A-Z Guide to Data Version Control

By admin September 13, 2026

Dolt is the first SQL database that lets you commit, branch, and merge data just like Git. Learn how Dolt solves data versioning and safety challenges in this article.

MySQL

MySQL Savepoint: Don’t Let a Small Error Ruin a Major Transaction

By admin September 5, 2026

Don't let a small error ruin your entire transaction chain. Learn how to use SAVEPOINT and ROLLBACK TO in MySQL for precise data control and optimized system performance.

Docker

Deploying a MongoDB Sharded Cluster with Docker Compose: Data Sharding for Large-Scale Applications

By admin September 3, 2026

A guide to deploying a MongoDB Sharded Cluster with Docker Compose, covering config servers, shard replica sets, and a mongos router. Based on real production experience with 10 million documents, including how to choose a shard key, verify data distribution, and monitor the cluster.

MySQL

Manage MySQL Like a Pro: Boost Performance 200% with the mycli and mytop Duo

By admin September 3, 2026

Speed up MySQL administration with mycli and mytop. A detailed guide on installation, smart autocomplete, and real-time database performance monitoring directly in your terminal.

MySQL

Protecting MySQL from Brute-force Attacks with Connection Control Plugin

By admin August 28, 2026

Protect MySQL from brute-force attacks using the Connection Control Plugin. A detailed guide on setting failed login thresholds and delay mechanisms for optimal security.

MySQL

MySQL Timezone Handling: Don’t Let Your App Get Lost Across Time Zones

By admin August 23, 2026

Eliminate MySQL timezone offsets with expert guidance. Learn the difference between TIMESTAMP and DATETIME, loading timezone tables, and optimizing indexes for millions of records.

Database

Installing and Mastering EdgeDB on Linux: A Powerful SQL Alternative

By admin August 22, 2026

Learn how to install EdgeDB on Linux and use EdgeQL to replace traditional SQL. Detailed guide from schema definition to safe migration management.

MySQL

MySQL Replication Filters: Pro Tips to Filter Databases and Tables to ‘Rescue’ Your Slave

By admin August 22, 2026

Learn how to use MySQL Replication Filters to optimize data synchronization. Save up to 80% disk space on your Slave and effectively reduce replication lag.