sql – ITFROMZERO – Share tobe shared!

Development tutorial - IT technology blog

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

By admin 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 admin 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 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.

Database

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

By admin 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 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

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

By admin 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 admin 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 admin 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 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

Mastering CockroachDB: When a ‘Resilient’ SQL Database Helps You Sleep Better

By admin May 1, 2026

A 2 AM system crash is every developer's nightmare. Discover how to deploy CockroachDB—a distributed SQL database with self-healing capabilities for absolute uptime.