Database – ITFROMZERO – Share tobe shared!

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.

Database

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

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

MySQL

MySQL Connections in Python with PyMySQL and mysql-connector-python: Connection Pooling, Prepared Statements, and Safe Transactions to Prevent SQL Injection

By admin July 10, 2026

A practical guide to connecting MySQL in Python using PyMySQL and mysql-connector-python: setting up Connection Pooling to reuse connections, using Prepared Statements to prevent SQL Injection, and handling Transactions safely with a context manager — complete code examples from quick start to production.

Database

PostGIS & PostgreSQL: The ‘Heavy Artillery’ for Geospatial Data Processing

By admin July 10, 2026

Master PostGIS installation and spatial query optimization. Discover why GiST Indexes are the key to processing millions of coordinates in just milliseconds.

Database

Apache Pinot: A Step-by-Step Guide to Setting Up a Real-Time OLAP Database for Sub-100ms Analytics Dashboards

By admin July 8, 2026

Apache Pinot is a distributed OLAP datastore that enables analytics queries across billions of rows with sub-100ms latency, used by LinkedIn and Uber for user-facing dashboards. This guide walks you through step-by-step installation with Docker, configuring schemas and star-tree indexes, loading CSV data, and monitoring cluster health.

MySQL

gh-ost: Zero-Downtime MySQL Schema Changes — GitHub’s Answer to pt-osc

By admin July 8, 2026

gh-ost is a tool developed by GitHub for making MySQL schema changes on tables with tens of millions of rows without any downtime. Unlike pt-osc which uses triggers, gh-ost reads the binlog directly — safer, with the ability to pause/resume and adjust speed in realtime throughout the migration.