Tagged articles

bitmask

4 articles · Page 1 of 1
Programmer1970
Programmer1970
Sep 2, 2026 · Backend Development

One TINYINT Field, Four Notification Switches: Bitmask Pattern in Practice

This article demonstrates how to store four independent notification channel switches (SMS, email, in-app, WeChat) in a single MySQL TINYINT column using bitwise operations, covering schema design, SQL queries, Java enum and utility classes, service and controller layers, MyBatis mapper, extensibility to N channels, and key considerations like indexing, concurrency, and readability.

JavaMyBatisMySQL
0 likes · 14 min read
One TINYINT Field, Four Notification Switches: Bitmask Pattern in Practice
Code Ape Tech Column
Code Ape Tech Column
Apr 6, 2023 · Backend Development

Applying the Open‑Closed Principle and Bitmask Design for Extensible System Architecture

The article explains the six SOLID design principles, emphasizes the importance of the Open‑Closed principle, and demonstrates how to achieve extensible database schemas and APIs using type fields, extendable JSON columns, bitmap role encoding, and strategy/template patterns with concrete Java code examples.

Design PatternsOpen/Closed PrincipleStrategy Pattern
0 likes · 15 min read
Applying the Open‑Closed Principle and Bitmask Design for Extensible System Architecture
dbaplus Community
dbaplus Community
Oct 2, 2022 · Backend Development

Cutting Invalid Data: How Zhaunzhuan Optimized Its Product Service for 3× Faster Performance

This article examines how Zhaunzhuan's product service, a core component of its e‑commerce platform, was optimized by reducing unnecessary data transmission, applying cache‑aside patterns, redesigning Redis storage, and introducing a field‑marking approach, resulting in dramatically lower GC overhead, network traffic, and response times.

GraphQLbitmaskdata optimization
0 likes · 14 min read
Cutting Invalid Data: How Zhaunzhuan Optimized Its Product Service for 3× Faster Performance