BestHub
Sign in
Tag

logical delete

1 views collected around this technical thread.

Java Tech Enthusiast
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
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.

CRUDMyBatis-PlusORM
0 likes · 18 min read
Comprehensive Guide to Using MyBatis‑Plus with Spring Boot
Selected Java Interview Questions
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
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
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 DevelopmentJavaMyBatis
0 likes · 17 min read
Elegant Solution for MyBatis Single‑Table Operations with MyBatis‑Pro Framework