Database – Page 2 – ITFROMZERO

How to Dockerize SQL Server on Linux: Configuring Volumes, Users, and Practical Backup/Restore

By admin August 21, 2026

Forget manual SQL Server installations that take hours. This guide helps you Dockerize SQL Server on Linux accurately, ensuring data safety and optimizing your workflow.

MySQL

MySQL SQL Mode: A Shield Against Junk Data and Silent Logic Errors

By admin August 18, 2026

Stop MySQL from silently truncating your data. Learn how to configure SQL Mode to enable Strict Mode, prevent silent logic errors, and protect your system's data integrity.

Database

Mastering Redis OM: When Redis Becomes More Than Just a Caching Layer

By admin August 18, 2026

Redis OM helps you manage complex JSON data and perform Full-text search on Redis with lightning speed. Detailed guide for Python and Node.js.

Development

Using sqlc for Database Management in Go: Real-world Performance and Absolute Type-safety

By admin August 18, 2026

Why does sqlc outperform traditional ORMs in Go? Discover how sqlc boosts system performance and minimizes runtime errors by generating code from raw SQL.

MySQL

Handling MySQL Hangs Due to Metadata Locking: Don’t Let an ALTER Command Crash Your System

By admin August 16, 2026

Is ALTER TABLE hanging your MySQL? Explore the Metadata Locking (MDL) mechanism, how to use Performance Schema to find blocking threads, and tips for safe migrations on large databases.

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.

Docker

Docker Compose: Pro Tips for Automating Database Migrations and Schema Updates

By admin August 14, 2026

Don't let your app crash because the database isn't ready. Explore 3 methods for automating database migrations in Docker Compose, from basic to advanced.

MySQL

Is MySQL COUNT(*) Slow? Don’t Let Your Dashboard Freeze When Data Hits Millions of Rows

By admin July 30, 2026

Why does MySQL COUNT(*) slow down on large InnoDB datasets? This article analyzes the impact of MVCC and provides 4 optimization techniques using Counter Tables, Metadata, and Redis.

Python

MongoDB + Python: From Basic CRUD to Advanced Aggregation with PyMongo

By admin July 22, 2026

Learn how to connect Python with MongoDB efficiently. This guide covers optimizing CRUD with insert_many, using Aggregation Pipelines, and indexing techniques for big data.

Python

SQLModel: The ‘2-in-1’ Solution for Cleaning Up the Mess Between SQLAlchemy and Pydantic

By admin July 15, 2026

Tired of writing duplicate code for Database and API? SQLModel merges SQLAlchemy and Pydantic, cutting boilerplate by 50% and preventing sync errors.