BestHub
Sign in
Tagged articles
2675 articles
Page 2 of 27
DeWu Technology
DeWu Technology
Nov 19, 2025 · Databases

How Our Self‑Built Redis Evolved: Architecture, SDK, and Performance Gains

This article details the three‑year evolution of a self‑built Redis service, covering its massive scale, architectural redesign, migration from LB to a custom DRedis SDK, same‑city active‑active near‑read support, Redis‑server version upgrades, instance specifications, proxy rate‑limiting, and extensive automation that together boost performance while cutting costs.

CacheDatabasePerformance
0 likes · 17 min read
How Our Self‑Built Redis Evolved: Architecture, SDK, and Performance Gains
Zhuanzhuan Tech
Zhuanzhuan Tech
Nov 17, 2025 · Backend Development

How to Eliminate Duplicate and Missing Data in Backend Pagination

This article explains why offset‑based pagination can cause duplicate or missing records when data changes, compares three practical solutions—including cursor pagination with timestamps and IDs, fixed‑window timestamp filtering, and Elasticsearch search_after—and provides concrete SQL and code examples along with their trade‑offs and suitable scenarios.

CursorDatabaseElasticsearch
0 likes · 12 min read
How to Eliminate Duplicate and Missing Data in Backend Pagination
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Nov 16, 2025 · Databases

Elasticsearch vs Open Distro vs OpenSearch vs Easysearch: A Complete Comparison

This article systematically compares Elasticsearch, Open Distro, OpenSearch, and Easysearch, covering their origins, licensing, feature sets, performance benchmarks, Chinese‑language support, deployment and operational considerations, and provides guidance on which solution fits different business and compliance scenarios.

DatabaseEasysearchElasticsearch
0 likes · 17 min read
Elasticsearch vs Open Distro vs OpenSearch vs Easysearch: A Complete Comparison
DevOps Coach
DevOps Coach
Nov 13, 2025 · Databases

Explore ClickHouse 25.10: 20 JOIN Boosts, Vector Search & New SQL

ClickHouse 25.10 introduces a suite of enhancements—including 20 JOIN performance upgrades, lazy column replication, Bloom filter runtime filters, disjunction push‑down, automatic column statistics, the QBit vector type, expanded SQL operators, negative LIMIT/OFFSET, Arrow Flight support, and delayed secondary index materialization—backed by detailed benchmarks and contributor acknowledgments.

ClickHouseDatabaseJOIN optimization
0 likes · 23 min read
Explore ClickHouse 25.10: 20 JOIN Boosts, Vector Search & New SQL
dbaplus Community
dbaplus Community
Nov 5, 2025 · Databases

Why KEYS Is Dangerous in Redis and How SCAN or Indexing Solves It

The article explains why using the KEYS command in Redis is a blocking operation that can cripple production systems, demonstrates the safe, incremental SCAN approach, and proposes an index‑based architecture or replica scans for high‑frequency or offline key‑lookup scenarios.

DatabaseKEYSPerformance
0 likes · 8 min read
Why KEYS Is Dangerous in Redis and How SCAN or Indexing Solves It
Architect's Guide
Architect's Guide
Nov 5, 2025 · Databases

25 Essential SQL Query Optimization Tips to Avoid Full Table Scans

This article presents a comprehensive set of SQL performance guidelines, covering index creation, avoiding costly operators, rewriting predicates, using proper joins, limiting temporary objects, and best practices for query design to prevent full table scans and improve overall database efficiency.

DatabaseIndexesPerformance
0 likes · 9 min read
25 Essential SQL Query Optimization Tips to Avoid Full Table Scans
Architect-Kip
Architect-Kip
Nov 4, 2025 · Backend Development

How to Optimize Batch Jobs for Better System and Database Performance

This article explains why batch tasks significantly affect system and database performance, and outlines three key strategies—task simplification, resource and performance tuning, and proactive monitoring with fault recovery—to design and optimize batch jobs effectively in enterprise development.

Batch ProcessingDatabaseResource Isolation
0 likes · 4 min read
How to Optimize Batch Jobs for Better System and Database Performance
Python Programming Learning Circle
Python Programming Learning Circle
Nov 1, 2025 · Databases

Master MongoDB with PyMongo: Essential CRUD Operations in Python

Learn how to connect to MongoDB using PyMongo, create databases and collections, and perform essential CRUD operations—including inserting single or multiple documents, querying with filters and regex, updating records with update_one and update_many, counting, sorting, pagination, and deleting—complete with Python code examples.

CRUDDatabaseMongoDB
0 likes · 13 min read
Master MongoDB with PyMongo: Essential CRUD Operations in Python
Xiao Liu Lab
Xiao Liu Lab
Oct 31, 2025 · Databases

Why Redis Exits on ARM64: Fix the THP COW Bug and Prevent Data Loss

Redis on ARM64 platforms may abort startup with a warning about a kernel COW bug when Transparent Huge Pages are enabled, risking RDB corruption; this guide explains the underlying issue, when it’s safe to ignore the warning, and provides two solutions—disabling THP or configuring ignore‑warnings—to ensure safe operation.

ARM64COW bugDatabase
0 likes · 7 min read
Why Redis Exits on ARM64: Fix the THP COW Bug and Prevent Data Loss
Architect
Architect
Oct 30, 2025 · Databases

When MySQL Auto‑Increment IDs Hit Their Limit: Diagnosis and Fixes

A massive MySQL table ran out of INT auto‑increment IDs due to high concurrency, leading to insert failures; the article analyzes the root cause, evaluates three remediation strategies, and details the eventual migration to BIGINT with performance monitoring and code snippets.

BIGINTDatabaseauto_increment
0 likes · 9 min read
When MySQL Auto‑Increment IDs Hit Their Limit: Diagnosis and Fixes
Data STUDIO
Data STUDIO
Oct 30, 2025 · Databases

From Table‑Centric to Object‑Centric: How DQL Redefines Join Queries

The article explains how Dimensional Query Language (DQL) replaces traditional multi‑table JOIN syntax with object‑dot notation and dimension‑alignment concepts, offering simpler, more business‑focused queries for BI scenarios, and demonstrates its implementation through concrete SQL examples and a real‑world engine integration.

BIDQLDatabase
0 likes · 10 min read
From Table‑Centric to Object‑Centric: How DQL Redefines Join Queries
Data STUDIO
Data STUDIO
Oct 30, 2025 · Databases

Master MongoDB with Python: Complete Guide to CRUD Operations

This tutorial walks through installing MongoDB and PyMongo, establishing a connection, selecting databases and collections, and demonstrates how to insert, query, count, sort, skip, limit, update, and delete documents using both legacy and modern PyMongo methods, complete with code examples and operator references.

CRUDDatabaseMongoDB
0 likes · 14 min read
Master MongoDB with Python: Complete Guide to CRUD Operations
Sohu Tech Products
Sohu Tech Products
Oct 29, 2025 · Databases

Understanding MySQL InnoDB Deadlocks: Causes, Lock Types & Prevention

This article examines MySQL InnoDB deadlocks by analyzing error logs, explaining the two‑phase locking protocol and various lock types, demonstrates how to reproduce a deadlock scenario, categorizes lock behaviors, and offers practical strategies to prevent and monitor deadlocks in database applications.

DatabaseInnoDBmysql
0 likes · 19 min read
Understanding MySQL InnoDB Deadlocks: Causes, Lock Types & Prevention
ITPUB
ITPUB
Oct 28, 2025 · Operations

50 Powerful IT Ops Projects to Supercharge Your Resume

This article compiles 50 detailed IT operations projects across infrastructure, cloud, containers, automation, monitoring, security, databases, networking, disaster recovery and DevOps, each with scenario, tech stack, implementation steps and quantifiable results to help you craft standout résumé entries.

DatabaseIT OperationsInfrastructure
0 likes · 30 min read
50 Powerful IT Ops Projects to Supercharge Your Resume
Code Ape Tech Column
Code Ape Tech Column
Oct 27, 2025 · Backend Development

Why MyBatis-Flex Outperforms MyBatis-Plus: Features, Benchmarks, and Quick Start

MyBatis-Flex is a lightweight, high‑performance MyBatis enhancement offering flexible query building, extensive database support, and features like multi‑table joins, logical deletion, and data auditing; the article compares it with MyBatis‑Plus, presents benchmark results, lists supported databases, and provides a step‑by‑step Spring Boot integration guide.

DatabaseJavaMybatis-Flex
0 likes · 13 min read
Why MyBatis-Flex Outperforms MyBatis-Plus: Features, Benchmarks, and Quick Start
php Courses
php Courses
Oct 24, 2025 · Backend Development

How to Supercharge Laravel Performance: A Step‑by‑Step Optimization Guide

This guide walks you through a systematic Laravel performance optimization process—from diagnosing bottlenecks with Debugbar and logs, through database query tuning, caching strategies, code-level refinements, to server‑level tweaks—ensuring faster response times for growing PHP applications.

CachingDatabaseLaravel
0 likes · 7 min read
How to Supercharge Laravel Performance: A Step‑by‑Step Optimization Guide
Architect's Guide
Architect's Guide
Oct 18, 2025 · Databases

Mastering Distributed Transactions: From Fundamentals to Advanced Solutions

This comprehensive guide explains the core concepts of transactions, local and distributed transaction models, the CAP theorem, various distributed transaction solutions such as 2PC, TCC, reliable messaging, and maximum effort notifications, and compares their trade‑offs for modern microservice architectures.

2PCCAP theoremDatabase
0 likes · 44 min read
Mastering Distributed Transactions: From Fundamentals to Advanced Solutions
Architecture Digest
Architecture Digest
Oct 14, 2025 · Information Security

How to Perform Fuzzy Searches on Encrypted Data: Methods, Pros & Cons

This article explores the challenges of fuzzy searching encrypted data, categorizes three implementation approaches—naïve, conventional, and advanced—examines their trade‑offs, provides practical examples and performance calculations, and offers recommendations for secure and efficient query solutions.

DatabasePerformanceencryption
0 likes · 10 min read
How to Perform Fuzzy Searches on Encrypted Data: Methods, Pros & Cons
php Courses
php Courses
Oct 14, 2025 · Backend Development

How to Count Rows in a MySQL Result Set with PHP’s mysqli_num_rows

Learn how to use PHP’s mysqli_num_rows function to retrieve the number of rows returned by a MySQL query, with a complete example that shows connecting to the database, executing a SELECT statement, handling errors, and outputting the row count.

DatabaseMySQLiRow Count
0 likes · 3 min read
How to Count Rows in a MySQL Result Set with PHP’s mysqli_num_rows
php Courses
php Courses
Oct 10, 2025 · Backend Development

Master PHP Database Connections: MySQL with mysqli and PDO

This tutorial walks you through establishing MySQL connections in PHP using both the mysqli extension and PDO, covering procedural and object‑oriented code, prepared statements, error handling, and proper connection closure for robust backend development.

DatabaseMySQLiPDO
0 likes · 4 min read
Master PHP Database Connections: MySQL with mysqli and PDO
Raymond Ops
Raymond Ops
Oct 8, 2025 · Databases

Step-by-Step Guide: Installing MySQL via RPM on Rocky, AlmaLinux, CentOS and More

This article provides a comprehensive, cross‑platform tutorial for downloading MySQL RPM bundles, installing required dependencies, using rpm or yum to install MySQL on various RHEL‑compatible distributions, starting the service, retrieving the temporary root password, and securely changing it to a permanent one.

DatabaseLinuxRPM
0 likes · 39 min read
Step-by-Step Guide: Installing MySQL via RPM on Rocky, AlmaLinux, CentOS and More
Senior Brother's Insights
Senior Brother's Insights
Oct 5, 2025 · Databases

Master MySQL JSON: From Basics to Advanced CRUD Operations

This article explains MySQL’s native JSON data type introduced in 5.7, covering its binary storage format, built‑in functions, generated‑column indexing, performance advantages over string storage, and detailed CRUD examples with SQL syntax and practical code snippets.

CRUDDatabaseJSON
0 likes · 14 min read
Master MySQL JSON: From Basics to Advanced CRUD Operations
Ops Community
Ops Community
Oct 5, 2025 · Databases

Master MySQL Slow Query Optimization: Proven Methods & Pitfall Guide

This comprehensive guide walks you through a systematic methodology for diagnosing and fixing MySQL slow queries, covering proper log configuration, EXPLAIN analysis, index design, query rewriting, table restructuring, and practical caching techniques, while highlighting common misconceptions and real‑world case studies.

DatabaseIndex OptimizationPerformance tuning
0 likes · 35 min read
Master MySQL Slow Query Optimization: Proven Methods & Pitfall Guide
Su San Talks Tech
Su San Talks Tech
Sep 30, 2025 · Databases

Mastering Sharded Pagination: 3 Proven Techniques to Avoid Performance Pitfalls

This article explains why using traditional LIMIT pagination on sharded databases can cause full‑shard scans and memory‑intensive sorting, and introduces three practical alternatives—anchor pagination, shard‑mark pagination, and reverse pagination—detailing their implementation steps, performance benefits, and common pitfalls to avoid.

DatabaseSQLpagination
0 likes · 10 min read
Mastering Sharded Pagination: 3 Proven Techniques to Avoid Performance Pitfalls
macrozheng
macrozheng
Sep 29, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

SQLite, often dismissed as a toy, proves its robustness by adding powerful SQL capabilities in 2018—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—making it a viable choice for production workloads despite lacking a network layer.

DatabaseNew FeaturesSQL
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Architect
Architect
Sep 28, 2025 · Information Security

How to Perform Fuzzy Searches on Encrypted Data: Practical Approaches

This article examines three categories of techniques—naïve, conventional, and advanced—for enabling fuzzy queries on encrypted data, evaluates their pros and cons, provides implementation details, performance considerations, and references to real‑world solutions, guiding developers toward secure and efficient search strategies.

DatabaseInformation Securityencrypted data
0 likes · 12 min read
How to Perform Fuzzy Searches on Encrypted Data: Practical Approaches
Senior Brother's Insights
Senior Brother's Insights
Sep 28, 2025 · Databases

Understanding MySQL’s Three Index Processing Stages: Key, Filter, and Table

MySQL query optimization involves three distinct index processing stages—Index Key, Index Filter, and Table Filter—each handling different parts of condition matching and data retrieval, and mastering their roles and execution flow can dramatically improve query performance, especially with index condition pushdown.

Databaseindex condition pushdownmysql
0 likes · 8 min read
Understanding MySQL’s Three Index Processing Stages: Key, Filter, and Table
JD Tech
JD Tech
Sep 26, 2025 · Operations

Avoiding High‑Availability Pitfalls: Real‑World JD Lessons and Solutions

This article examines common high‑availability challenges across applications, databases, caches, message queues, containers, and GC, presenting real JD engineering cases, root‑cause analyses, and practical mitigation strategies to help engineers design more resilient systems.

DatabaseMessage QueueRedis
0 likes · 37 min read
Avoiding High‑Availability Pitfalls: Real‑World JD Lessons and Solutions
Linux Cloud Computing Practice
Linux Cloud Computing Practice
Sep 26, 2025 · Databases

Master MongoDB: From Basics to Advanced Practices

This comprehensive MongoDB tutorial covers its core concepts, suitable scenarios, basic CRUD operations, document structure, query syntax, indexing, aggregation framework, advanced features like MapReduce and transactions, Python integration, real‑world case studies, and provides command summaries with practice exercises for beginners to intermediate users.

DatabaseMongoDBNoSQL
0 likes · 5 min read
Master MongoDB: From Basics to Advanced Practices
Architect
Architect
Sep 24, 2025 · Databases

How Indexes Can Speed Up MySQL Queries by 30,000×: A Practical Guide

This article walks through a MySQL 5.6 scenario with three tables, demonstrates why a sub‑query that scans millions of rows runs for hours, and shows step‑by‑step how adding single‑column, composite, and covering indexes, as well as rewriting the query as a join, reduces execution time from over eight hours to a few milliseconds.

DatabaseSQL optimizationindexing
0 likes · 12 min read
How Indexes Can Speed Up MySQL Queries by 30,000×: A Practical Guide
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Sep 24, 2025 · Databases

Unlock MySQL Performance: How Optimistic Locking Works

This article explains MySQL's optimistic locking strategy, detailing how a version column enables conflict detection during updates, provides step‑by‑step SQL examples, compares it with pessimistic locking, and shows why it improves performance in read‑heavy, low‑conflict environments.

Concurrency ControlDatabaseOptimistic Lock
0 likes · 3 min read
Unlock MySQL Performance: How Optimistic Locking Works
Ray's Galactic Tech
Ray's Galactic Tech
Sep 23, 2025 · Databases

Master PostgreSQL: Installation, Configuration, and Performance Tuning Guide

This comprehensive guide walks you through installing PostgreSQL on Linux, Windows, macOS, and Docker, configuring users, databases, and remote access, using daily psql commands, performing backups, applying advanced features like tablespaces and replication, and optimizing performance with key tuning parameters.

DatabaseInstallationPerformance tuning
0 likes · 7 min read
Master PostgreSQL: Installation, Configuration, and Performance Tuning Guide
Architecture Digest
Architecture Digest
Sep 22, 2025 · Databases

From Single Node to Distributed Cluster: Mastering Redis Evolution

This article walks through Redis's journey from a simple single‑instance cache to a robust, highly available, and horizontally scalable distributed system, covering persistence mechanisms, master‑slave replication, Sentinel automatic failover, and sharding clusters for real‑world high‑traffic applications.

DatabasePersistenceclustering
0 likes · 12 min read
From Single Node to Distributed Cluster: Mastering Redis Evolution
Java Tech Enthusiast
Java Tech Enthusiast
Sep 20, 2025 · Databases

Why Running MySQL in Docker Is a Bad Idea (And When It Might Work)

This article examines the fundamental mismatch between MySQL’s stateful nature and Docker’s container model, detailing performance penalties, data‑persistence risks, resource‑management challenges, security concerns, and operational complexity, while also outlining scenarios where Docker can be acceptable for development or limited production use.

DatabaseDockerPerformance
0 likes · 12 min read
Why Running MySQL in Docker Is a Bad Idea (And When It Might Work)
Su San Talks Tech
Su San Talks Tech
Sep 18, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert syntax, column renaming, and related API changes, with code examples and comparisons to other databases, highlighting its reliability and suitability for production use.

Boolean LiteralsDatabaseSQL
0 likes · 11 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Architect
Architect
Sep 17, 2025 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article explores the latest SQLite SQL enhancements introduced between versions 3.22.0 and 3.26.0 in 2018, covering boolean literals, window functions, FILTER clauses, upsert syntax, column renaming, and related API changes, with code examples and practical usage notes.

DatabaseSQLSQLite
0 likes · 10 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
Java Tech Enthusiast
Java Tech Enthusiast
Sep 16, 2025 · Backend Development

Master Java Concurrency & Redis: Thread Safety, Pools, and Data Consistency

This article explains Java thread‑safety concepts, how to use and configure ThreadPoolExecutor, Redis performance tricks, Zset internal structures, memory‑eviction policies, node‑failure handling, cache‑DB consistency patterns, and MySQL transaction ACID properties with MVCC differences, providing practical code examples throughout.

DatabaseJavaRedis
0 likes · 25 min read
Master Java Concurrency & Redis: Thread Safety, Pools, and Data Consistency
Raymond Ops
Raymond Ops
Sep 15, 2025 · Databases

Step-by-Step Guide to Installing and Understanding MariaDB

This comprehensive tutorial introduces MariaDB, explains its origins and key features, and provides detailed, cross‑platform installation and configuration instructions for Rocky Linux, Ubuntu, openSUSE and other distributions, including network setup, repository configuration, package installation, service management, and security hardening.

DatabaseInstallationLinux
0 likes · 50 min read
Step-by-Step Guide to Installing and Understanding MariaDB
Architecture Digest
Architecture Digest
Sep 15, 2025 · Databases

When to Choose SQLite Over MySQL? Pros, Cons, and Ideal Use Cases

This article examines SQLite's lightweight nature, cross‑platform support, and easy backup, while discussing its limitations in high‑concurrency scenarios, and provides guidance on when SQLite is appropriate for prototyping or low‑resource environments versus when to avoid it.

DatabasePerformanceSQLite
0 likes · 4 min read
When to Choose SQLite Over MySQL? Pros, Cons, and Ideal Use Cases
dbaplus Community
dbaplus Community
Sep 14, 2025 · Databases

Why MySQL Updates Sometimes Disappear: InnoDB Read View Explained

A nighttime incident revealed that a MySQL transaction updated a row but subsequent reads returned the old value, prompting a deep investigation that uncovered InnoDB’s repeatable‑read snapshot behavior, concurrent updates, and how MySQL may skip updates when data appears unchanged, along with reproducible steps and mitigation advice.

DatabaseInnoDBRead View
0 likes · 16 min read
Why MySQL Updates Sometimes Disappear: InnoDB Read View Explained
MaGe Linux Operations
MaGe Linux Operations
Sep 14, 2025 · Databases

Mastering Redis Persistence: RDB vs AOF Deep Dive and Real‑World Optimizations

After a midnight outage that erased 6 GB of cache, this comprehensive guide explores Redis persistence mechanisms—RDB snapshots and AOF logs—detailing their trade‑offs, configuration nuances, performance impacts, and practical optimization techniques to ensure data safety, fast recovery, and compliance in production environments.

AOFDatabasePersistence
0 likes · 22 min read
Mastering Redis Persistence: RDB vs AOF Deep Dive and Real‑World Optimizations
Architecture Digest
Architecture Digest
Sep 14, 2025 · Databases

Should You Replace MySQL with SQLite? Pros, Cons, and When to Use It

This article examines SQLite’s tiny footprint and embedded nature, compares it with MySQL, outlines its advantages such as cross‑platform support and easy backup, discusses its drawbacks like poor high‑concurrency handling and lack of remote access, and advises when SQLite is a suitable choice.

DatabaseSQLiteUse Cases
0 likes · 4 min read
Should You Replace MySQL with SQLite? Pros, Cons, and When to Use It
Su San Talks Tech
Su San Talks Tech
Sep 14, 2025 · Databases

Should You Run MySQL in Docker? Risks, Performance & Best Practices

This article examines why running MySQL in Docker is generally discouraged, covering container‑state mismatches, I/O and network performance penalties, data persistence challenges, resource limits, security concerns, monitoring difficulties, and finally outlines scenarios where Docker may be acceptable and recommended production alternatives.

ContainersData PersistenceDatabase
0 likes · 12 min read
Should You Run MySQL in Docker? Risks, Performance & Best Practices
Liangxu Linux
Liangxu Linux
Sep 12, 2025 · Artificial Intelligence

Explore 6 Cutting-Edge Open-Source AI Tools and Visual Guides

This article introduces six open‑source projects—including a visual guide for large‑model reinforcement learning, Alibaba's WebAgent suite, a 12‑factor AI‑agent handbook, Google’s MCP database toolbox, the Graphiti knowledge‑graph engine, and a Rust‑based distributed object store—each with key features and GitHub links.

AIAgentDatabase
0 likes · 6 min read
Explore 6 Cutting-Edge Open-Source AI Tools and Visual Guides
Raymond Ops
Raymond Ops
Sep 12, 2025 · Databases

Step-by-Step Guide to Installing MySQL 8.x Binary Packages on Linux

This comprehensive tutorial explains how to install MySQL 8.0 and 8.4 binary packages on various Linux distributions, covering user creation, package download, environment setup, configuration, initialization, dependency handling, service script creation, password setting, and verification of the installation.

BinaryDatabaseInstallation
0 likes · 72 min read
Step-by-Step Guide to Installing MySQL 8.x Binary Packages on Linux
Raymond Ops
Raymond Ops
Sep 11, 2025 · Databases

Master MySQL: Installation Guide Across Linux Distros & Key Features

This comprehensive guide introduces MySQL’s core concepts, architecture, and features, then walks you through step‑by‑step installation and configuration on popular Linux distributions—including Rocky, AlmaLinux, CentOS, Ubuntu, Debian, and openSUSE—covering network setup, repository configuration, and post‑install security tweaks.

DatabaseInstallationLinux
0 likes · 69 min read
Master MySQL: Installation Guide Across Linux Distros & Key Features
php Courses
php Courses
Sep 11, 2025 · Databases

How to Efficiently Store and Manage JSON Data in Relational and NoSQL Databases

JSON has become the de‑facto format for data exchange, and modern relational databases like PostgreSQL and MySQL now support native JSON types alongside NoSQL solutions such as MongoDB, offering developers flexible storage, indexing, and query capabilities while balancing schema rigidity, performance, and scalability.

DatabaseJSONNoSQL
0 likes · 7 min read
How to Efficiently Store and Manage JSON Data in Relational and NoSQL Databases
Architect's Tech Stack
Architect's Tech Stack
Sep 11, 2025 · Backend Development

Master MyBatis Streaming Queries: Reduce Memory Usage with Cursors

This article explains MyBatis streaming queries, introduces the Cursor interface and its methods, demonstrates common pitfalls, and provides three practical solutions—using SqlSessionFactory, TransactionTemplate, or @Transactional—to keep database connections open while processing large result sets efficiently.

CursorDatabaseJava
0 likes · 7 min read
Master MyBatis Streaming Queries: Reduce Memory Usage with Cursors
Architect's Tech Stack
Architect's Tech Stack
Sep 11, 2025 · Backend Development

Master MyBatis Streaming Queries: Keep DB Connections Open Efficiently

This article explains MyBatis streaming queries using the Cursor interface, demonstrates common pitfalls such as closed connections, and provides three practical solutions—including SqlSessionFactory, TransactionTemplate, and @Transactional—to reliably process large result sets with minimal memory usage.

CursorDatabaseJava
0 likes · 6 min read
Master MyBatis Streaming Queries: Keep DB Connections Open Efficiently
dbaplus Community
dbaplus Community
Sep 10, 2025 · Databases

Inside Redis: How Commands Are Processed by Its Event‑Driven Engine

Redis, the high‑performance in‑memory key‑value store, uses a single‑threaded event‑driven architecture that handles client connections, command parsing, execution, and reply transmission; this article explains its deployment modes, core modules, and step‑by‑step command processing flow, including code snippets and key data structures.

Command ExecutionDatabaseEvent-driven
0 likes · 14 min read
Inside Redis: How Commands Are Processed by Its Event‑Driven Engine
Java Captain
Java Captain
Sep 5, 2025 · Backend Development

When "null" Becomes a Real Username: Hidden Bugs and How to Prevent Them

Developers often mistake the string "null" for an actual null value, leading to unexpected bugs such as phantom users, logging chaos, database contamination, and security risks; this article explains why this happens and provides practical backend, frontend, and database validation strategies to avoid the pitfalls.

DatabaseNULLbackend
0 likes · 5 min read
When "null" Becomes a Real Username: Hidden Bugs and How to Prevent Them
ITPUB
ITPUB
Sep 4, 2025 · Operations

100‑Point IT Operations Checklist: From Server Health to Data Center Safety

A comprehensive 100‑item checklist guides IT operations engineers through daily inspections of servers, network gear, storage, operating systems, databases, virtualization, backup, security devices, and data‑center infrastructure, ensuring reliable performance, proactive issue detection, and adherence to best‑practice standards.

Data CenterDatabaseIT Operations
0 likes · 27 min read
100‑Point IT Operations Checklist: From Server Health to Data Center Safety
Tencent Cloud Developer
Tencent Cloud Developer
Sep 3, 2025 · Databases

Deep Dive into GORM: Architecture, Internals, and Common Pitfalls

This article provides a comprehensive overview of Go's powerful GORM ORM library, covering its core concepts, architecture, internal logic, common pitfalls, practical tips, and advanced features such as soft deletes, transaction handling, batch operations, and integration with trpc-go, helping developers master GORM's inner workings.

Batch InsertDatabaseGORM
0 likes · 26 min read
Deep Dive into GORM: Architecture, Internals, and Common Pitfalls
php Courses
php Courses
Sep 1, 2025 · Backend Development

How to Migrate Complex PHP Data Safely While Minimizing Downtime

This guide outlines essential strategies for PHP developers to execute complex data migrations—covering thorough planning, incremental migration, transaction safety, dual‑write architectures, feature‑flag rollouts, real‑time syncing, and comprehensive monitoring—to ensure data integrity and keep system downtime to a minimum.

Backend DevelopmentData MigrationDatabase
0 likes · 7 min read
How to Migrate Complex PHP Data Safely While Minimizing Downtime
Code Mala Tang
Code Mala Tang
Sep 1, 2025 · Databases

Boost SQL Query Performance: Practical Tips and Code Examples

This article presents a collection of practical techniques—such as using SELECT TOP, avoiding DISTINCT, preferring IN over OR, indexing key columns, and leveraging stored procedures—to dramatically improve SQL query speed and reduce database load.

DatabaseIndexesSQL
0 likes · 10 min read
Boost SQL Query Performance: Practical Tips and Code Examples
IT Services Circle
IT Services Circle
Aug 30, 2025 · Operations

Why Does My System Freeze? 9 Common Causes and How to Diagnose Them

This article explains why systems suddenly become unresponsive, outlines nine typical root causes ranging from frontend request spikes to backend thread‑pool exhaustion and missing timeout settings, and walks through a real‑world investigation that reveals how to pinpoint and resolve such blockages.

DatabaseJavaThread Pool
0 likes · 11 min read
Why Does My System Freeze? 9 Common Causes and How to Diagnose Them
Linux Tech Enthusiast
Linux Tech Enthusiast
Aug 28, 2025 · Databases

Can Weak Backup & Recovery Skills Cost You Your Probation?

The article explains why mastering database backup and recovery—including failure types, logical vs. physical backups, flashback, full and partial restores, a weekly backup strategy, RMAN configuration, shell scripts, and monitoring queries—is essential for avoiding costly mistakes and passing a new‑job probation.

DatabaseOracleRMAN
0 likes · 7 min read
Can Weak Backup & Recovery Skills Cost You Your Probation?
Su San Talks Tech
Su San Talks Tech
Aug 25, 2025 · Databases

Master Database Indexes: 10 Essential Questions Every Developer Should Know

This article explains the fundamentals of database indexes, how they work, common pitfalls such as slow queries and index misuse, and provides practical solutions, best‑practice design principles, and differences between MySQL and PostgreSQL, all illustrated with clear SQL examples and diagrams.

DatabasePerformancePostgreSQL
0 likes · 13 min read
Master Database Indexes: 10 Essential Questions Every Developer Should Know
dbaplus Community
dbaplus Community
Aug 24, 2025 · Databases

Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level

This article explains the differences between MySQL’s default REPEATABLE READ (RR) and READ COMMITTED (RC) isolation levels, why large internet firms switch to RC, the mechanics of master‑slave replication, the three binlog formats, and how gap locks affect consistency and performance.

DatabaseIsolation LevelRC
0 likes · 10 min read
Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level
dbaplus Community
dbaplus Community
Aug 17, 2025 · Databases

Rescuing Crashing Databases: Real‑World Bad SQL Cases and How to Fix Them

This article walks through four real‑world SQL performance disasters—chaotic joins, NULL‑value scans, LOB full‑table scans, and massive batch deletions—explaining why they cripple databases and providing concrete, step‑by‑step rewrite and indexing solutions to restore stability and speed.

DBADatabaseOptimization
0 likes · 7 min read
Rescuing Crashing Databases: Real‑World Bad SQL Cases and How to Fix Them
Open Source Tech Hub
Open Source Tech Hub
Aug 17, 2025 · Backend Development

Boost Your PHP Web App Performance with Proven Optimization Techniques

This guide outlines key factors that affect PHP web application performance and provides practical steps—including PHP environment tuning, disabling debug mode, caching strategies, session and database optimizations, Composer autoload improvements, and offline processing—to significantly speed up your app.

ComposerDatabasePHP
0 likes · 8 min read
Boost Your PHP Web App Performance with Proven Optimization Techniques
Tech Freedom Circle
Tech Freedom Circle
Aug 14, 2025 · Backend Development

10 Proven Techniques to Optimize API Latency from 11 s to 170 ms – A Meituan Interview Case

The article presents a step‑by‑step analysis of how to shrink a 11‑second API response to 170 ms by applying batch database writes, Redis pipeline, asynchronous processing, thread‑pool design, local‑memory buffering, MQ integration, and other performance‑tuning patterns, backed by real‑world benchmarks and code samples.

API optimizationAsyncDatabase
0 likes · 48 min read
10 Proven Techniques to Optimize API Latency from 11 s to 170 ms – A Meituan Interview Case
Liangxu Linux
Liangxu Linux
Aug 13, 2025 · Databases

Unlock MySQL Mastery: A Complete Theory & Hands‑On Guide

This comprehensive guide walks you through MySQL fundamentals and advanced features, covering database architecture, storage engines, data types, CRUD operations, complex queries, transactions, indexing, performance tuning, replication, JSON handling, full‑text search, and best practices for security and backup.

CRUDDatabaseSQL
0 likes · 27 min read
Unlock MySQL Mastery: A Complete Theory & Hands‑On Guide
Code Ape Tech Column
Code Ape Tech Column
Aug 13, 2025 · Databases

Master 10 Essential Advanced SQL Concepts Every Data Professional Needs

This article outlines ten crucial intermediate‑to‑advanced SQL techniques—including common table expressions, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, cumulative sums, and date‑time manipulation—providing explanations and practical query examples for data professionals.

CTEDatabasequery optimization
0 likes · 11 min read
Master 10 Essential Advanced SQL Concepts Every Data Professional Needs
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Aug 10, 2025 · Databases

How Single-Leader Replication Handles Write Conflicts: Strategies and Insights

This article examines write conflicts in single-leader replication, comparing exclusive and shared data, exploring uniqueness constraints, async replication delays, and various conflict‑resolution techniques such as unique indexes, bitmap mapping, LWW ordering, and multi‑version control for collaborative editing.

ConsistencyDatabaseDistributed Systems
0 likes · 9 min read
How Single-Leader Replication Handles Write Conflicts: Strategies and Insights
Liangxu Linux
Liangxu Linux
Aug 10, 2025 · Databases

Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection

This comprehensive guide explains MySQL data backup and recovery strategies, covering backup types, planning principles, built‑in tools like mysqldump and mysqlpump, third‑party solutions such as Percona XtraBackup, scripting for automated schedules, storage options, encryption, monitoring, troubleshooting, and best‑practice recommendations to ensure data safety and business continuity.

DatabaseMonitoringRecovery
0 likes · 22 min read
Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Aug 8, 2025 · Databases

Master SQL Execution Order, Joins, CTEs & Window Functions

This article provides a comprehensive guide to essential SQL concepts for backend developers and data engineers, covering query execution order, core commands, various join types, common table expressions (including recursive CTEs), window functions, and performance optimization techniques such as table scans and indexing, complete with practical code examples and visual illustrations.

CTEDatabaseJoins
0 likes · 10 min read
Master SQL Execution Order, Joins, CTEs & Window Functions
macrozheng
macrozheng
Jul 28, 2025 · Databases

Why MySQL Pagination Slows Down at Scale and How to Speed It Up

This article examines how MySQL pagination performance degrades as table size grows, presents benchmark results for various offsets, defines slow SQL thresholds, and offers three optimization strategies—including selecting only primary keys, ID‑based filtering, and leveraging Elasticsearch—to dramatically improve query speed.

DatabaseElasticsearchmysql
0 likes · 10 min read
Why MySQL Pagination Slows Down at Scale and How to Speed It Up