sql Archives - ITFROMZERO - Share tobe shared!

Optimizing MySQL Queries with Covering Indexes: The Secret to Eliminating Table Lookups

By IT From Zero October 18, 2026

Table Lookups are the primary cause of I/O bottlenecks on large datasets, even when queries use an index. Master Covering Indexes and Deferred Joins to slash query latency from seconds down to milliseconds.

Development

Kysely: A Query Builder Alternative to Prisma and TypeORM for TypeScript Projects

By IT From Zero September 21, 2026

Kysely is the perfect alternative to Prisma and TypeORM. Learn how to build a high-performance Type-safe SQL Query Builder, reduce server RAM, and optimize your Node.js development workflow.

Database

Designing Polymorphic Relationships in SQL: 3 Architectures from Production Experience

By IT From Zero September 21, 2026

Learn how to design efficient Polymorphic relationships in SQL. Compare 3 common methods and discover index optimization tips for high-scale systems.

Database

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

By IT From Zero 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.

Database

Mastering dbt Core with PostgreSQL: From Fragmented SQL to Standardized Data Workflows

By IT From Zero September 9, 2026

Eliminate the headache of manual SQL management. A detailed guide on using dbt Core with PostgreSQL to automate data transformations, data testing, and documentation.

Database

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

By IT From Zero 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

JSON_TABLE() in MySQL 8: Converting Nested JSON Data into Relational Tables

By IT From Zero July 6, 2026

JSON_TABLE() in MySQL 8 converts JSON arrays into relational rows, enabling standard GROUP BY, JOIN, and aggregate operations. This guide compares it with JSON_EXTRACT and application-side processing, analyzes when to use each approach, with real-world examples including NESTED PATH and inconsistent data handling.

MySQL

Optimizing MySQL Storage: Choosing the Right Data Types to Speed Up I/O and Save RAM

By IT From Zero June 26, 2026

Choosing the wrong MySQL data types causes unnecessarily bloated databases, high I/O, and wasted RAM. This article shares real-world experience from a 50GB production database: how to choose correctly between INT/BIGINT, VARCHAR/TEXT, ENUM, and TIMESTAMP to optimize performance right from schema design.

MySQL

MySQL Query Rewrite Plugin: Optimize and Fix SQL Queries Without Touching Your Application Code

By IT From Zero May 21, 2026

MySQL Query Rewrite Plugin lets you intercept and modify SQL statements at the database layer without changing any application source code. This guide covers installation, configuration, and practical use cases for production environments.

Database

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

By IT From Zero 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.