BestHub
Sign in
Tagged articles
2675 articles
Page 7 of 27
Java Architect Essentials
Java Architect Essentials
Jun 18, 2024 · Backend Development

Resolving MyBatis‑Plus LocalDateTime Conversion Errors by Upgrading MySQL Connector

This article explains why replacing MyBatis with MyBatis‑Plus caused a LocalDateTime conversion exception, identifies the root cause as an outdated mysql‑connector‑java version, and shows how upgrading the connector (to 5.1.37 or later) resolves the issue while providing code examples and debugging steps.

Backend DevelopmentDatabaseJava
0 likes · 16 min read
Resolving MyBatis‑Plus LocalDateTime Conversion Errors by Upgrading MySQL Connector
21CTO
21CTO
Jun 13, 2024 · Databases

Is Oracle Killing MySQL? A Deep Dive into MySQL’s Future Under Oracle

The article examines Peter Zaitsev’s critique of Oracle’s stewardship of MySQL, debunks long‑standing myths, evaluates recent MySQL Heatwave features and performance gaps, and compares MySQL’s trajectory with PostgreSQL and other open‑source databases.

DatabaseOpen SourceOracle
0 likes · 8 min read
Is Oracle Killing MySQL? A Deep Dive into MySQL’s Future Under Oracle
Java Tech Enthusiast
Java Tech Enthusiast
Jun 10, 2024 · Databases

Common MySQL String Functions

MySQL offers a comprehensive set of string functions—including lower, upper, concat, substring/substr, length, char_length, instr, lpad, rpad, trim (with leading, trailing, both options), replace, repeat, reverse, and format—that enable case conversion, concatenation, extraction, padding, trimming, substitution, repetition, reversal, and numeric formatting of textual data.

DatabaseSQLString Functions
0 likes · 6 min read
Common MySQL String Functions
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jun 7, 2024 · Backend Development

Building a Fish Knowledge Quiz Bot and a Nostalgic Chess Game with Coze: Workflow, Database, and Node.js Image Generation

This article explains how to create two interactive Coze bots—a fish‑knowledge quiz and a nostalgic 147‑258‑369 chess game—by designing workflows, integrating large language models, using databases, and implementing Node.js code for canvas drawing and GIF generation, complete with deployment tips.

AIBot DevelopmentCoze
0 likes · 10 min read
Building a Fish Knowledge Quiz Bot and a Nostalgic Chess Game with Coze: Workflow, Database, and Node.js Image Generation
Java Tech Enthusiast
Java Tech Enthusiast
Jun 6, 2024 · Backend Development

MyBatis Dynamic SQL and Tag Usage Guide

MyBatis dynamic SQL lets developers construct conditional queries at runtime using tags like if, where, trim, choose, set, foreach, sql, include, and bind, simplifying complex statements, avoiding manual string concatenation, supporting batch operations, reusable fragments, and one‑to‑many mappings while improving flexibility and maintainability.

DatabaseDynamic SQLJava
0 likes · 16 min read
MyBatis Dynamic SQL and Tag Usage Guide
Lobster Programming
Lobster Programming
Jun 3, 2024 · Backend Development

How to Ensure API Idempotency: Prevent Duplicate Requests in Backend Systems

Ensuring API idempotency is crucial to avoid duplicate operations like double crediting points or double payments, and this article examines common causes of repeated calls—such as rapid user clicks, retries, and message queues—and presents practical backend solutions including frontend controls, Redis setnx, token validation, unique indexes, counting, and state machines.

APIDatabaseRedis
0 likes · 7 min read
How to Ensure API Idempotency: Prevent Duplicate Requests in Backend Systems
DevOps Cloud Academy
DevOps Cloud Academy
Jun 3, 2024 · Fundamentals

Understanding NULL: The Silent Killer in Code and How to Mitigate Its Risks

NULL, the ubiquitous placeholder for missing values, can silently introduce bugs, crashes, and data inconsistencies across languages and databases, but by understanding its pitfalls and applying strategies like optional types, default values, Null Object patterns, and proper database constraints, developers can significantly improve code reliability.

Best PracticesDatabaseError Handling
0 likes · 10 min read
Understanding NULL: The Silent Killer in Code and How to Mitigate Its Risks
ITPUB
ITPUB
Jun 2, 2024 · Databases

How to Diagnose and Fix Unusable Oracle Indexes in Production

This article walks through a real‑world Oracle index failure, explains why indexes become UNUSABLE, shows how to clean residual metadata, rebuild the index safely, outlines common causes for both regular and partitioned tables, and provides SQL scripts for monitoring invalid indexes.

DBADatabaseOracle
0 likes · 7 min read
How to Diagnose and Fix Unusable Oracle Indexes in Production
Ops Development & AI Practice
Ops Development & AI Practice
May 31, 2024 · Backend Development

Build a Go CLI to Connect and Query Oracle DB in Minutes

Learn how to create a Go-based command-line tool that accepts user-supplied parameters to connect to an Oracle database using the loginWithServiceName function, execute arbitrary SQL queries, and display results, complete with full source code, flag parsing, and error handling.

CLIDatabaseGo
0 likes · 5 min read
Build a Go CLI to Connect and Query Oracle DB in Minutes
FunTester
FunTester
May 29, 2024 · Databases

How Fast Can MySQL Write? Comparing Single-Row, Batch, and Multi-Row Inserts

This article evaluates MySQL single‑thread write performance by testing three insertion methods—continuous while‑loop inserts, JDBC batch processing, and multi‑row INSERT statements—detailing setup, code examples, and measured rows per minute to reveal their relative throughput and stability.

Batch InsertDatabaseJDBC
0 likes · 10 min read
How Fast Can MySQL Write? Comparing Single-Row, Batch, and Multi-Row Inserts
360 Smart Cloud
360 Smart Cloud
May 27, 2024 · Databases

Deployment, Optimization, and Management of TiDB Service in 360 Zhihui Cloud

This article details the product models, usage scenarios, and a series of performance and operational optimizations—including query plan health checks, space reclamation, resource isolation, cloud‑native deployment, cross‑region high availability, and unified monitoring—implemented for the TiDB service operated by 360 Zhihui Cloud since its launch in April 2023.

Cloud NativeDatabaseKubernetes
0 likes · 17 min read
Deployment, Optimization, and Management of TiDB Service in 360 Zhihui Cloud
MaGe Linux Operations
MaGe Linux Operations
May 25, 2024 · Databases

Redis Cluster Mastery: Step‑by‑Step Setup, Scaling, and Management Guide

This tutorial explains how Redis Cluster automatically shards data across multiple nodes, covering required TCP ports, hash‑slot sharding, master‑slave replication, consistency trade‑offs, essential configuration parameters, and step‑by‑step commands for creating, expanding, resharding, and managing a production‑grade Redis cluster.

ClusterDatabaseRedis
0 likes · 18 min read
Redis Cluster Mastery: Step‑by‑Step Setup, Scaling, and Management Guide
Architect
Architect
May 24, 2024 · Backend Development

How to Build a MySQL‑Based Fuzzy Company Name Matcher with Regex and IKAnalyzer

This article walks through a real‑world approval workflow where a business user adds a company, explains why MySQL REGEXP is chosen over Elasticsearch for fuzzy matching, and details the step‑by‑step implementation—including name preprocessing, tokenization with IKAnalyzer, and a custom SQL query that ranks results by match degree.

Backend DevelopmentDatabaseIKAnalyzer
0 likes · 13 min read
How to Build a MySQL‑Based Fuzzy Company Name Matcher with Regex and IKAnalyzer
ITPUB
ITPUB
May 24, 2024 · Databases

Master PostgreSQL High Availability with Pacemaker & Corosync: A Step‑by‑Step Guide

This tutorial walks through building a PostgreSQL high‑availability cluster using Pacemaker and Corosync, covering architecture overview, component installation, cluster status checks, data synchronization verification, failover handling, and common maintenance commands with concrete commands and screenshots.

ClusterCorosyncDatabase
0 likes · 7 min read
Master PostgreSQL High Availability with Pacemaker & Corosync: A Step‑by‑Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
May 23, 2024 · Databases

Troubleshooting SQL Exception Retries in OceanBase Using Logs and gv$sql_audit

This article demonstrates how to diagnose and resolve repeated UPDATE failures in OceanBase by extracting information from Top SQL, log files, and the gv$sql_audit view, identifying error codes such as 6005, 6003, and 6212, and applying corrective actions like adjusting timeout settings, killing lock‑holding sessions, and checking lock statistics.

DatabaseErrorCodesOceanBase
0 likes · 12 min read
Troubleshooting SQL Exception Retries in OceanBase Using Logs and gv$sql_audit
Wukong Talks Architecture
Wukong Talks Architecture
May 23, 2024 · Backend Development

Key Design Principles for High‑Concurrency Architecture and Read/Write Separation

This article explains the essential conditions, metrics, and scenario classifications for building high‑concurrency systems, then details common solutions such as database read/write separation, local and distributed caching, cache‑eviction policies, handling master‑slave lag, preventing cache penetration and avalanche, and applying CQRS to achieve scalable, high‑performance back‑end services.

CQRSCachingDatabase
0 likes · 21 min read
Key Design Principles for High‑Concurrency Architecture and Read/Write Separation
Laravel Tech Community
Laravel Tech Community
May 21, 2024 · Databases

MongoDB Replication Set and Sharding Configuration Guide

This article provides a comprehensive step‑by‑step guide to setting up MongoDB replica sets and sharded clusters, explaining the architecture, member roles, configuration files, initialization commands, and operational procedures for ensuring data redundancy, high availability, and horizontal scaling.

ClusterDatabaseMongoDB
0 likes · 29 min read
MongoDB Replication Set and Sharding Configuration Guide
JD Cloud Developers
JD Cloud Developers
May 21, 2024 · Databases

How to Refactor Complex SQL Like Java Code: A Real‑World Case Study

This article demonstrates how to refactor a complex, production‑level SQL query used in a routing system by formatting, decomposing into layers, merging temporary tables, pushing predicates, optimizing joins, and validating performance, ultimately reducing nesting from four levels to one and cutting execution time from 4.75 s to 0.6 s.

DatabaseJoinOptimization
0 likes · 15 min read
How to Refactor Complex SQL Like Java Code: A Real‑World Case Study
ITPUB
ITPUB
May 19, 2024 · Databases

Why Redis Can Slow Down Your App and How to Fix It

This article explains common Redis performance pitfalls—including per‑command network latency, expensive commands like SUNION and KEYS, mass key expiration spikes, and big‑key deletions—and provides practical techniques such as MSET batching, randomizing expirations, and using UNLINK to keep your backend fast.

DatabaseOptimizationPerformance
0 likes · 8 min read
Why Redis Can Slow Down Your App and How to Fix It
vivo Internet Technology
vivo Internet Technology
May 15, 2024 · Databases

Challenges and New Technology Exploration in Vivo Database Operations Platform

At the 2024 XCOPS Intelligent Operations Management Annual Meeting in Guangzhou, Vivo’s Deng Song will discuss building a robust database operations platform, addressing availability threats, efficiency levers, 0‑to‑1 development strategies, and considerations of reliability, cost, and data privacy amid emerging AI and large‑model technologies.

DatabasePlatformReliability
0 likes · 3 min read
Challenges and New Technology Exploration in Vivo Database Operations Platform
macrozheng
macrozheng
May 11, 2024 · Backend Development

When Does @Transactional Commit? Before or After Unlock?

This article explains the timing of Spring's @Transactional commit relative to lock release, analyzes why committing after unlock can cause overselling, shows how to trace the transaction lifecycle in the source code, and offers practical solutions to ensure atomicity in high‑concurrency scenarios.

DatabaseJavaLock
0 likes · 19 min read
When Does @Transactional Commit? Before or After Unlock?
MaGe Linux Operations
MaGe Linux Operations
May 10, 2024 · Databases

MongoDB Config Guide: System Log, Network, Security, and Storage Settings

This article provides a comprehensive walkthrough of MongoDB's configuration file, detailing system log options, process management, network parameters, security settings, storage engine configurations, slow query profiling, replication, sharding, and mongos parameters, along with explanations of each option and recommended defaults.

DatabaseMongoDBconfiguration
0 likes · 12 min read
MongoDB Config Guide: System Log, Network, Security, and Storage Settings
ITPUB
ITPUB
May 10, 2024 · Databases

Choosing Low‑Risk Strategies for Critical DBA Outages

When a major operations incident strikes, the safest approach is to prioritize simple, low‑risk actions and accept limited responsibility, as illustrated by real DBA lessons from Oracle RAC failures and a data‑center power‑loss disaster.

DBADatabaseIncident Management
0 likes · 7 min read
Choosing Low‑Risk Strategies for Critical DBA Outages
Java Captain
Java Captain
May 8, 2024 · Databases

Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration

A real‑world MySQL case study shows how using INSERT INTO SELECT for large‑scale data migration without proper indexing caused full‑table scans, lock contention, and data loss, highlighting the need for careful query planning and performance testing.

Data MigrationDatabaseINSERT INTO SELECT
0 likes · 6 min read
Lessons Learned from Misusing INSERT INTO SELECT in MySQL Data Migration
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
May 8, 2024 · Databases

How GaussDB’s Fine‑Grained Resource Control Optimizes Multi‑Tenant Performance

GaussDB provides a fine‑grained resource control solution that lets administrators define CPU, memory, I/O, connection, concurrency, and storage limits at user, session, and statement levels, using resource pools, control groups, and GUC parameters to ensure multi‑tenant isolation, SLA compliance, and optimal cluster utilization.

CPUDatabaseGaussDB
0 likes · 16 min read
How GaussDB’s Fine‑Grained Resource Control Optimizes Multi‑Tenant Performance
21CTO
21CTO
May 6, 2024 · Databases

How Oracle’s New 23ai Database Brings AI-Powered Vector Search to Enterprises

Oracle’s latest release, Database 23ai, upgrades its 23c platform with AI-driven vector search, RAG capabilities, and enhanced JSON and graph querying, positioning the database as a unified, secure, and scalable solution for handling structured, semi‑structured, and unstructured data across cloud and on‑premises environments.

AIDatabaseOracle
0 likes · 7 min read
How Oracle’s New 23ai Database Brings AI-Powered Vector Search to Enterprises
dbaplus Community
dbaplus Community
May 1, 2024 · Databases

8 Compelling Reasons SQL Still Dominates After 50 Years

This article outlines eight key reasons why SQL and relational databases remain the dominant data management solution half a century after their invention, covering processing power, proven reliability, community support, simplicity, widespread adoption, open‑source growth, practical query power, and their role alongside NoSQL technologies.

CommunityData ManagementDatabase
0 likes · 9 min read
8 Compelling Reasons SQL Still Dominates After 50 Years
macrozheng
macrozheng
Apr 29, 2024 · Databases

How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide

This guide explains how to answer MySQL accidental deletion interview questions and outlines practical recovery methods—including backup restoration, binlog usage, third‑party tools—and essential preventive practices such as regular backups, transaction handling, and permission management.

Data RecoveryDatabasebackup
0 likes · 5 min read
How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 25, 2024 · Databases

Redis Cluster: Architecture, Setup, Testing, and High Availability

This article explains Redis Cluster's sharding architecture, demonstrates how to configure multiple Redis nodes on different ports, shows commands for creating and testing the cluster, and illustrates failover behavior, highlighting its scalability and high‑availability advantages over Sentinel mode for large‑scale data workloads.

ClusterDatabaseRedis
0 likes · 11 min read
Redis Cluster: Architecture, Setup, Testing, and High Availability
Selected Java Interview Questions
Selected Java Interview Questions
Apr 25, 2024 · Information Security

Techniques for Fuzzy Search on Encrypted Data: Approaches, Trade‑offs, and Practical Implementations

The article examines why encrypted sensitive fields such as passwords, phone numbers, and bank details need special handling, categorises three families of fuzzy‑search solutions for encrypted data, evaluates their security, performance and storage costs, and recommends a balanced conventional method for production use.

Data ProtectionDatabaseInformation Security
0 likes · 10 min read
Techniques for Fuzzy Search on Encrypted Data: Approaches, Trade‑offs, and Practical Implementations
Architect's Guide
Architect's Guide
Apr 24, 2024 · Databases

Redis Overview: Features, Data Types, Caching Strategies, Performance, Eviction Policies, Persistence, Replication, and Sentinel

This article provides a comprehensive introduction to Redis, covering its core features, supported data types, common caching use cases in Spring Boot, typical cache‑related problems such as consistency, avalanche, penetration and breakdown, as well as performance reasons, eviction policies, persistence mechanisms, master‑slave replication, and Sentinel high‑availability architecture.

CachingDatabasePerformance
0 likes · 12 min read
Redis Overview: Features, Data Types, Caching Strategies, Performance, Eviction Policies, Persistence, Replication, and Sentinel
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2024 · Databases

Summary of the MySQL Transaction Module Series

This article reviews the 14-part series on MySQL's transaction module, covering initialization, transaction types, two‑phase commit, binlog handling, savepoints, and full rollback, and provides links to each detailed post, including discussions on BEGIN statements, read‑only transactions, and the internal mechanisms of InnoDB.

DatabaseInnoDBSavepoint
0 likes · 5 min read
Summary of the MySQL Transaction Module Series
Architecture Digest
Architecture Digest
Apr 22, 2024 · Backend Development

Migrating from MyBatis to MyBatis-Plus: Resolving LocalDateTime Conversion Errors and Lessons Learned

This article walks through replacing MyBatis with MyBatis‑Plus in a legacy Java project, demonstrates the LocalDateTime conversion error caused by MySQL‑connector‑java version incompatibility, shows how upgrading the driver resolves the issue, and shares a cautionary tale about unintended bugs after component upgrades.

DatabaseJavaLocalDateTime
0 likes · 15 min read
Migrating from MyBatis to MyBatis-Plus: Resolving LocalDateTime Conversion Errors and Lessons Learned
Top Architect
Top Architect
Apr 19, 2024 · Databases

Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives

This article explains why using OFFSET and LIMIT for pagination becomes inefficient on large tables, illustrates the performance impact with examples, and proposes a cursor‑based pagination alternative that leverages indexed primary keys to achieve faster, scalable queries.

CursorDatabaseLIMIT
0 likes · 8 min read
Problems with OFFSET/LIMIT Pagination and Cursor‑Based Alternatives
21CTO
21CTO
Apr 18, 2024 · Artificial Intelligence

GPT‑6, VAR Models, and the Latest AI Breakthroughs Shaping Tech

The article surveys recent AI and tech developments, from Sam Altman's claim that GPT‑6 will become a universal tool and Baidu's new intelligent computing OS, to Peking University and ByteDance's VAR model outperforming diffusion models, plus updates on Boston Dynamics' Atlas robot, Linux kernel Kconfig, AMD Ryzen Pro CPUs, and SQLite 3.45.3.

Artificial IntelligenceDatabaseLinux kernel
0 likes · 11 min read
GPT‑6, VAR Models, and the Latest AI Breakthroughs Shaping Tech
IT Services Circle
IT Services Circle
Apr 17, 2024 · Databases

Comprehensive Didi Interview Review: Redis Persistence, Data Types, Memory Issues, and System Concepts

This article summarizes a Didi second‑round interview covering Redis persistence mechanisms, data structures, memory overflow and leak concepts, thread safety, process vs thread differences, deadlock prevention, TCP/UDP distinctions, and a couple of hand‑written algorithm problems, providing detailed explanations and code examples.

Data StructuresDatabaseInterview
0 likes · 19 min read
Comprehensive Didi Interview Review: Redis Persistence, Data Types, Memory Issues, and System Concepts
Tencent Cloud Developer
Tencent Cloud Developer
Apr 16, 2024 · Databases

Major Updates and New Features of WCDB 2: Multi‑language Support, SQL Builder, Backup & Recovery, Data Migration, Compression, and Performance Optimizations

WCDB 2 introduces multi-language support (C++, Java, Kotlin), a rewritten SQL builder, fast backup and recovery with sub‑second times, incremental WAL‑based backup, automatic data migration, Zstandard compression, on‑the‑fly column addition, and performance enhancements such as an FTS5 optimizer and interruptible transactions, delivering a robust high‑performance mobile database solution.

Data MigrationDatabaseSQL Builder
0 likes · 47 min read
Major Updates and New Features of WCDB 2: Multi‑language Support, SQL Builder, Backup & Recovery, Data Migration, Compression, and Performance Optimizations
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Apr 13, 2024 · Databases

Comprehensive Guide to MySQL String Functions

This article provides an in‑depth overview of MySQL string functions, covering concatenation, length, position, replacement, conversion, encryption, comparison, generation, and their syntax and usage examples, helping developers manipulate textual data efficiently in database operations.

DatabaseString Functionsdata manipulation
0 likes · 18 min read
Comprehensive Guide to MySQL String Functions
Test Development Learning Exchange
Test Development Learning Exchange
Apr 12, 2024 · Operations

Python Data Backup Scripts and Tools Overview

This article introduces various Python-based data backup techniques, covering standard library modules such as shutil, zipfile, and tarfile, as well as database dump tools like pg_dump and mysqldump, and cloud storage options using awscli or boto3, with example code snippets for each method.

DatabaseOperationsPython
0 likes · 4 min read
Python Data Backup Scripts and Tools Overview
Code Ape Tech Column
Code Ape Tech Column
Apr 12, 2024 · Databases

Understanding Full-Text Search and Inverted Indexes in MySQL InnoDB

This article explains MySQL InnoDB full-text search, covering inverted index structures, creation and usage of full-text indexes, query modes such as natural language, boolean, and query expansion, and provides practical SQL examples and considerations for effective text searching.

DatabaseFull-Text SearchSQL
0 likes · 11 min read
Understanding Full-Text Search and Inverted Indexes in MySQL InnoDB
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Apr 11, 2024 · Databases

Mastering Redis Sentinel: Ensuring Automatic High Availability

This article explains Redis Sentinel’s role in providing monitoring, notifications, automatic failover, and configuration updates to achieve high availability, detailing its heartbeat mechanism, master‑down detection, leader election, failover selection criteria, and the trade‑offs of using this solution.

DatabaseMonitoringRedis
0 likes · 6 min read
Mastering Redis Sentinel: Ensuring Automatic High Availability
21CTO
21CTO
Apr 11, 2024 · Databases

Why PostgreSQL Is Becoming the Dominant Database Framework

This article traces PostgreSQL’s evolution from an academic project to a versatile data‑management framework, highlights its extensive extensions, performance benchmarks, and the shifting landscape of OLTP/OLAP, showing how its open‑source extensibility is reshaping the entire database world.

DatabaseOLAPOpen Source
0 likes · 18 min read
Why PostgreSQL Is Becoming the Dominant Database Framework
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 8, 2024 · Databases

How I Rescued a MySQL Table After Massive Bad Data Insertion

When a user reported errors, I discovered a MySQL table flooded with millions of bad rows from a new group, causing slow queries and crashes; I detail the step‑by‑step investigation, failed attempts with DELETE and lock‑free changes, and the final successful rebuild using temporary tables, DROP, TRUNCATE, and index reconstruction.

DDLDatabaseSQL
0 likes · 13 min read
How I Rescued a MySQL Table After Massive Bad Data Insertion
Efficient Ops
Efficient Ops
Apr 6, 2024 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT usage and implicit type conversion to subquery joins, mixed ordering, EXISTS clauses, condition pushdown, early result limiting, and intermediate result set optimization—offering concrete rewrites and execution plan analyses to dramatically speed up queries.

DatabasePerformance tuningSQL optimization
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
Java Tech Enthusiast
Java Tech Enthusiast
Apr 5, 2024 · Databases

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

The article shows how to efficiently load 300,000 MySQL rows in Java by comparing MyBatis and plain-JDBC batch inserts, demonstrating that batching 1,000‑5,000 records per transaction with proper transaction control, connection pooling, and MySQL tuning reduces insertion time from hours to seconds.

Batch InsertDatabaseJDBC
0 likes · 13 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
Java Architect Essentials
Java Architect Essentials
Apr 3, 2024 · Databases

MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Condition Pushdown, Early Limiting, and Intermediate Result Pushdown

This article presents a series of MySQL performance‑enhancing techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting UPDATE/DELETE with JOINs, mixed‑order sorting tricks, replacing EXISTS with JOINs, condition push‑down, early result limiting, and intermediate result push‑down—to dramatically reduce query execution time.

DatabaseIndexesmysql
0 likes · 13 min read
MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Updates, Mixed Sorting, EXISTS, Condition Pushdown, Early Limiting, and Intermediate Result Pushdown
Top Architect
Top Architect
Apr 2, 2024 · Databases

Ten Advanced SQL Concepts Every Data‑Science Interview Candidate Should Master

This article explains ten advanced SQL techniques—including common table expressions, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative sums, and date‑time manipulation—providing clear explanations and complete query examples to help readers ace data‑science interview questions.

CTEData Science InterviewsDatabase
0 likes · 14 min read
Ten Advanced SQL Concepts Every Data‑Science Interview Candidate Should Master
php Courses
php Courses
Apr 1, 2024 · Databases

Creating SQLite Database Tables with PHP: A Step-by-Step Guide

This tutorial walks through connecting to an SQLite database with PHP, creating a 'users' table using SQL, and verifying the table’s structure through PRAGMA queries, providing complete code examples for each step to help developers understand SQLite integration in web projects.

DatabasePHPSQL
0 likes · 4 min read
Creating SQLite Database Tables with PHP: A Step-by-Step Guide
21CTO
21CTO
Mar 31, 2024 · Databases

Why Redis Is Changing Licenses and What It Means for the Database Ecosystem

The article examines Redis's shift to a source‑available license, traces its history, analyzes the impact on cloud providers and open‑source communities, and evaluates emerging forks and alternatives such as Valkey, KeyDB, and Redict as potential replacements.

DatabaseLicensingOpen Source
0 likes · 13 min read
Why Redis Is Changing Licenses and What It Means for the Database Ecosystem
DevOps Operations Practice
DevOps Operations Practice
Mar 30, 2024 · Cloud Native

How to Deploy MySQL with Docker: A Step-by-Step Guide

This guide explains how to install Docker, pull the official MySQL image, run a MySQL container with persistent storage, connect to it, perform basic SQL operations, and finally stop and remove the container, demonstrating a complete end‑to‑end deployment using Docker.

Cloud NativeContainerizationDatabase
0 likes · 5 min read
How to Deploy MySQL with Docker: A Step-by-Step Guide
JD Tech
JD Tech
Mar 29, 2024 · Databases

Root Cause Analysis and Optimization of a Slow MySQL Query Using Index Selection and Force Index

This article examines a MySQL slow‑query incident caused by the optimizer using the primary clustered index instead of an appropriate secondary index, explains the underlying index structures, and presents solutions such as FORCE INDEX and migrating complex queries to Elasticsearch for long‑term performance improvement.

DatabaseElasticsearchFORCE INDEX
0 likes · 9 min read
Root Cause Analysis and Optimization of a Slow MySQL Query Using Index Selection and Force Index
dbaplus Community
dbaplus Community
Mar 27, 2024 · Databases

How Redis Handles Full Cache: Memory Eviction Policies Explained

When Redis memory reaches its configured maxmemory limit, it triggers a set of eviction policies—such as noeviction, allkeys‑lru, volatile‑lfu, and others—to decide which keys to discard, and this article explains how to view, configure, and understand each strategy.

DatabaseLFULRU
0 likes · 9 min read
How Redis Handles Full Cache: Memory Eviction Policies Explained
Python Programming Learning Circle
Python Programming Learning Circle
Mar 27, 2024 · Operations

9 Practical Python Automation Scenarios with Sample Scripts

This article presents nine practical Python automation scenarios—including file management, web scraping, text processing, email handling, Excel manipulation, database interaction, social media posting, system task scheduling, and image editing—each accompanied by clear script examples and explanations to help readers streamline repetitive tasks efficiently.

DatabaseEmailPython
0 likes · 19 min read
9 Practical Python Automation Scenarios with Sample Scripts
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 26, 2024 · Databases

MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions

This article explains the MySQL 8.0.22 READ ONLY option for individual databases, demonstrates how to enable and verify the read‑only state with ALTER DATABASE and SHOW CREATE DATABASE commands, shows the impact on DDL/DML operations, lists usage restrictions, and notes exceptional cases and backup considerations.

ALTER DATABASEDatabaseInformation Schema
0 likes · 11 min read
MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions
php Courses
php Courses
Mar 26, 2024 · Backend Development

ThinkPHP 8.x Framework Course Overview and Curriculum

This course provides a comprehensive tutorial on configuring PHP environments and mastering the ThinkPHP 8.x framework, covering installation, coding standards, routing, controllers, database operations, model management, middleware, caching, validation, and deployment techniques for robust backend web development.

DatabaseFrameworkPHP
0 likes · 6 min read
ThinkPHP 8.x Framework Course Overview and Curriculum
Java Tech Enthusiast
Java Tech Enthusiast
Mar 24, 2024 · Databases

Redis Announces Shift to Source‑Available Dual Licensing

Redis announced it will replace its BSD‑3‑Clause license with a source‑available dual licensing model—SSPLv1 and RSALv2—starting with Redis 7.4, keeping the community edition free for developers while requiring cloud providers to secure commercial agreements, yet leaving existing enterprise users and client‑library developers under unchanged, permissive terms.

DatabaseLicenseRSAL
0 likes · 3 min read
Redis Announces Shift to Source‑Available Dual Licensing
Ops Development & AI Practice
Ops Development & AI Practice
Mar 22, 2024 · Databases

How to Use SQLite3 in Go: A Step‑by‑Step Guide

This guide walks you through installing the Go SQLite3 driver, opening a database connection, creating tables, inserting records, querying data, and provides a complete runnable example, helping developers integrate lightweight SQLite storage into Go applications efficiently.

DatabaseGoSQL
0 likes · 6 min read
How to Use SQLite3 in Go: A Step‑by‑Step Guide
Python Programming Learning Circle
Python Programming Learning Circle
Mar 21, 2024 · Databases

Comprehensive Guide to Using PyMySQL for MySQL Interaction in Python

This article provides a detailed tutorial on the PyMySQL library, covering installation, connection setup, cursor operations, executing queries, transaction handling, advanced features like batch processing and connection pooling, as well as best practices for error handling and performance optimization in Python‑MySQL applications.

DatabasePythonSQL
0 likes · 9 min read
Comprehensive Guide to Using PyMySQL for MySQL Interaction in Python
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 18, 2024 · Databases

Apache Doris 2.1.0 Release: Major Performance Boosts, New Data Types, Optimizer Enhancements and Operational Features

The Apache Doris 2.1.0 release introduces over 100% query performance improvements on TPC‑DS, up to 230% gains on ARM platforms, new Variant and IP data types, async materialized views, auto‑increment columns, auto‑partitioning, group commit, hardened workload groups, TopSQL monitoring, a built‑in job scheduler, and several behavior changes, all aimed at delivering faster, more flexible and more reliable OLAP processing.

ARM OptimizationApache DorisDatabase
0 likes · 42 min read
Apache Doris 2.1.0 Release: Major Performance Boosts, New Data Types, Optimizer Enhancements and Operational Features
dbaplus Community
dbaplus Community
Mar 17, 2024 · Databases

Why IN/NOT IN Slow Down SQL Queries and Safer Alternatives

This article explains why using IN and NOT IN in SQL can lead to poor performance and incorrect results, demonstrates common pitfalls with examples, and shows how to replace them with EXISTS, NOT EXISTS, or JOIN constructs for reliable and faster queries.

DatabaseEXISTSIN
0 likes · 5 min read
Why IN/NOT IN Slow Down SQL Queries and Safer Alternatives
Architect
Architect
Mar 15, 2024 · Databases

How to Diagnose and Optimize Redis Memory Usage: Real‑World Cases

This article dissects Redis's memory architecture, explains each memory component, walks through object encoding rules, buffer handling, fragmentation, and child‑process memory, then presents two production incidents with step‑by‑step analysis and concrete optimization actions to prevent future memory alarms.

DatabaseMemory ManagementPerformance Optimization
0 likes · 27 min read
How to Diagnose and Optimize Redis Memory Usage: Real‑World Cases
Su San Talks Tech
Su San Talks Tech
Mar 7, 2024 · Databases

Master MySQL Locks: Types, Mechanisms, and How to Avoid Deadlocks

This article explains why MySQL uses locks, categorizes lock types from global to row level, details their implementation and commands, and shows how intention, metadata, and auto‑increment locks work while offering strategies to prevent deadlocks and lock contention.

DatabaseInnoDBLocks
0 likes · 13 min read
Master MySQL Locks: Types, Mechanisms, and How to Avoid Deadlocks
php Courses
php Courses
Mar 6, 2024 · Databases

MySQL 8 New Features and Network Communication Course Overview

This course introduces MySQL 8's latest features, deep dives into its network communication mechanisms, and teaches advanced performance optimization techniques such as connection pooling, compression, and SSL encryption through hands‑on projects to enhance database efficiency and security.

DatabasePerformance Optimizationmysql
0 likes · 2 min read
MySQL 8 New Features and Network Communication Course Overview
Architect
Architect
Mar 1, 2024 · Backend Development

Distributed ID Generation: Requirements, Common Solutions, and Implementation Details

This article explains what a distributed ID is, outlines its essential requirements such as global uniqueness, high performance, high availability, and ease of use, and then reviews common generation strategies—including database auto‑increment, segment mode, NoSQL approaches, UUID, Snowflake, and several open‑source frameworks—providing code examples and practical trade‑offs.

DatabaseRedisUID generator
0 likes · 23 min read
Distributed ID Generation: Requirements, Common Solutions, and Implementation Details
Architecture Digest
Architecture Digest
Mar 1, 2024 · Databases

SQL Performance Optimization and Index Tuning in MySQL

This article walks through a MySQL 5.6 scenario with course, student, and score tables, demonstrates why a naïve sub‑query is extremely slow, and shows step‑by‑step how adding single‑column, composite, and covering indexes, as well as rewriting the query to joins, can reduce execution time from hours to milliseconds.

DatabaseIndex TuningSQL optimization
0 likes · 10 min read
SQL Performance Optimization and Index Tuning in MySQL
php Courses
php Courses
Mar 1, 2024 · Backend Development

Implementing Logistics Tracking and Delivery Management in PHP for E-commerce

This tutorial explains how to build essential logistics tracking and delivery management features for an e‑commerce system using PHP, covering database schema design, code for inserting, updating, and querying tracking and delivery records, and providing complete example snippets.

DatabaseDelivery ManagementLogistics
0 likes · 6 min read
Implementing Logistics Tracking and Delivery Management in PHP for E-commerce
JD Tech
JD Tech
Feb 28, 2024 · Databases

Detecting and Monitoring Database Deadlocks with EasyBI: A Practical Case Study

This article recounts how a production database deadlock was uncovered during testing, explains the use of the EasyBI monitoring tool to collect and visualize error and claim statistics, and shares the step‑by‑step configuration, analysis, and lessons learned for preventing similar issues in future systems.

DatabaseEasyBIError Handling
0 likes · 8 min read
Detecting and Monitoring Database Deadlocks with EasyBI: A Practical Case Study
Architects' Tech Alliance
Architects' Tech Alliance
Feb 28, 2024 · Industry Insights

What Drives China’s “Xinchuang” IT Industry? Deep Dive into Hardware, OS, Middleware & Databases

This article provides an overview of China’s Xinchuang (information technology innovation) ecosystem, explaining the concepts and classifications of operating systems, middleware, databases, and firmware, presenting market share statistics, and highlighting the key components that shape the industry’s autonomous and secure IT landscape.

DatabaseIT industryXinchuang
0 likes · 7 min read
What Drives China’s “Xinchuang” IT Industry? Deep Dive into Hardware, OS, Middleware & Databases
Su San Talks Tech
Su San Talks Tech
Feb 25, 2024 · Databases

Why MySQL Indexes Fail: B+ Tree Mechanics and Common Pitfalls

This article explains how InnoDB stores data pages and builds B+‑tree indexes, illustrates the structure of clustered, secondary and composite indexes, and enumerates typical scenarios—such as left‑most prefix violations, LIKE patterns, and function use—that cause index loss and full‑table scans.

B+TreeDatabaseInnoDB
0 likes · 16 min read
Why MySQL Indexes Fail: B+ Tree Mechanics and Common Pitfalls