Database Archives - Page 3 of 12 - ITFROMZERO

Development tutorial - IT technology blog

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

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

Database

Say Goodbye to Connection Limit Errors: Deploying Edge Databases with Turso and LibSQL

By IT From Zero July 12, 2026

Tired of connection timeout errors on Serverless? Discover Turso and LibSQL—the Edge Database duo that slashes latency and handles thousands of concurrent connections seamlessly.

MySQL

MySQL Error Log and General Query Log: Production Troubleshooting Techniques for Sysadmins

By IT From Zero July 11, 2026

Learn how to configure MySQL Error Log and General Query Log for rapid system diagnostics. Practical insights on log management and production debugging.

Database

Apache CouchDB: Installation, Multi-Directional Replication, and Real-World Offline-First Sync

By IT From Zero July 10, 2026

Install CouchDB on Ubuntu in 5 minutes, configure continuous replication between two servers, and handle post-sync conflicts with Python. Includes a guide to integrating PouchDB (~46KB) into your web app and when to choose CouchDB over PostgreSQL or MongoDB.