backend – Page 2 – ITFROMZERO

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.

Development

PocketBase: Build an “All-in-one” Backend at Lightning Speed with a Single File

By admin August 12, 2026

PocketBase is a powerful open-source Backend-as-a-Service solution that integrates Database, Auth, and File Storage into a single executable. It's the perfect tool for building MVPs and small projects at lightning speed.

Python

Litestar: A Fresh Alternative to FastAPI for High-Performance REST APIs

By admin August 11, 2026

Litestar is a modern, high-speed, and more structured Python framework than FastAPI. Discover how to build professional REST APIs with superior performance optimization.

Development

Goodbye ‘Ancient’ Swagger UI: A Guide to Integrating Scalar into Node.js Projects

By admin August 9, 2026

Forget Swagger UI; Scalar is the real deal for your Node.js projects. Modern interface, built-in API client, and lightning-fast search.

MySQL

Implementing Soft Delete in MySQL: Don’t Let Unique Constraints and Indexes Slow You Down

By admin August 8, 2026

Soft Delete is more than just adding a Boolean column. Discover how to handle Unique Constraints using Virtual Columns and optimize indexes for large databases based on real-world experience.