backend – Page 3 – ITFROMZERO

Mastering OPTIMIZER_TRACE: The Pro Technique for Dissecting MySQL Index Selection Logic

By admin September 1, 2026

A guide to using OPTIMIZER_TRACE for deep analysis of MySQL index selection. Resolve SQL performance issues effectively based on actual execution costs.

Development

Go Generics in Practice: From 2 AM Runtime Errors to Clean Microservices Architecture

By admin August 31, 2026

Discover how to apply Go Generics to optimize Microservices. A detailed guide on Type Parameters, Constraints, and reducing boilerplate by 70% while ensuring Type Safety.

Development

Integrating PayOS with Node.js: Clean Webhook Handling to Never Lose an Order

By admin August 31, 2026

Learn how to professionally integrate PayOS with Node.js: From creating VietQR payment links to secure webhook handling, order deduplication, and real-world debugging tips.

Python

Handling Time in Python: Why You Should Use Pendulum Instead of Datetime?

By admin August 24, 2026

Handling timezones and dates in Python has never been easier. Discover why Pendulum has become the perfect alternative to the traditional datetime module.

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.

Database

Database Schema Design for Chat Apps: From Zero to Scaling for Millions of Users

By admin August 17, 2026

Learn how to design database schemas for chat applications from basic to advanced levels. Optimize performance with Redis, handle millions of messages, and implement cursor-based pagination.

MySQL

Managing Hierarchical Data in MySQL: Don’t Let ‘Category Trees’ Crash Your Server

By admin August 16, 2026

An analysis of three hierarchical data management models in MySQL: Adjacency List, Nested Set, and Closure Table. Choose the right structure to avoid database overload during scaling.

Database

PostgreSQL Optimization: Using Partial and Covering Indexes to Reduce Storage by 90% and Speed Up Queries

By admin August 16, 2026

Don't let indexes slow down your system. Discover how to combine Partial and Covering Indexes in PostgreSQL to optimize performance and save storage space effectively.

MySQL

MySQL Shell for VS Code: Manage Databases and Create ‘Pro’ ERDs Like Workbench Directly in Your Editor

By admin August 15, 2026

Stop letting MySQL Workbench slow down your machine. Discover how to use MySQL Shell for VS Code to manage databases, draw ERDs, and use Notebooks seamlessly inside your editor.