logical delete | BestHub

Java Tech Enthusiast

May 5, 2025 · Backend Development

Advanced MyBatis-Plus Features: Batch Insert, Logical Delete, Auto Field Fill, Type Handlers, Dynamic Table Names, Multi-Tenant

The article demonstrates advanced MyBatis‑Plus techniques—including high‑speed batch inserts with rewriteBatchedStatements, logical deletes via global config, automatic timestamp and user fields through MetaObjectHandler, JSON serialization with JacksonTypeHandler, dynamic table naming via an interceptor, and a brief multi‑tenant overview—to streamline development and reduce boilerplate code.

Dynamic TableJavaMyBatis-Plus

0 likes · 16 min read

Advanced MyBatis-Plus Features: Batch Insert, Logical Delete, Auto Field Fill, Type Handlers, Dynamic Table Names, Multi-Tenant

Top Architect

Feb 23, 2023 · Backend Development

Comprehensive Guide to Using MyBatis‑Plus with Spring Boot

This tutorial walks through integrating MyBatis‑Plus into a Spring Boot project, covering dependency setup, configuration of data sources, entity annotations, service and mapper layers, pagination, logical deletion, enum handling, automatic field filling, multi‑datasource support, and testing with full code examples.

CRUDEnumMyBatis-Plus

0 likes · 18 min read

Comprehensive Guide to Using MyBatis‑Plus with Spring Boot

Selected Java Interview Questions

Nov 1, 2022 · Databases

Understanding MySQL Unique Index Pitfalls and Practical Solutions

This article examines why a MySQL InnoDB table with a unique index can still store duplicate rows—especially when indexed columns contain NULL values or when logical deletion is used—and presents several practical strategies such as adjusting delete status, adding timestamp or auxiliary ID fields, using hash columns, and leveraging proper bulk‑insert techniques to enforce uniqueness effectively.

Database DesignMySQLNull Handling

0 likes · 13 min read

Understanding MySQL Unique Index Pitfalls and Practical Solutions

macrozheng

Aug 16, 2022 · Databases

Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them

This article explores a common MySQL InnoDB pitfall where unique indexes fail to prevent duplicate rows, explains how NULL values and logical deletion affect uniqueness, and presents practical strategies—including composite keys, delete status counters, timestamps, hash fields, and Redis locks—to enforce true uniqueness.

Database DesignMySQLNull Handling

0 likes · 14 min read

Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them

YunZhu Net Technology Team

Mar 10, 2022 · Backend Development

Elegant Solution for MyBatis Single‑Table Operations with MyBatis‑Pro Framework

The article introduces MyBatis‑Pro, a Spring‑Boot starter that eliminates manual single‑table SQL by generating CRUD methods through naming conventions, explains quick integration, core features, configuration options, entity annotations, logical‑delete strategies, generic services, and provides extensive code examples for developers.

Backend DevelopmentCode GenerationJava

0 likes · 17 min read

Elegant Solution for MyBatis Single‑Table Operations with MyBatis‑Pro Framework