Lobster Programming
Author

Lobster Programming

Sharing insights on technical analysis and exchange, making life better through technology.

150
Articles
0
Likes
440
Views
0
Comments
Recent Articles

Latest from Lobster Programming

100 recent articles max
Lobster Programming
Lobster Programming
Nov 3, 2025 · Fundamentals

The Rise and Fall of Mid‑Platform Architecture: What Modern Enterprises Can Learn

Mid‑platform (中台) architecture, inspired by Supercell’s rapid‑development model and popularized by Alibaba in 2015, evolved from a flexible business‑centric approach to a complex, sometimes cumbersome structure, offering reusable services but also introducing blurred responsibilities and scalability challenges for fast‑changing enterprises.

Enterprise ITReusabilitybusiness integration
0 likes · 7 min read
The Rise and Fall of Mid‑Platform Architecture: What Modern Enterprises Can Learn
Lobster Programming
Lobster Programming
Sep 28, 2025 · Databases

Mastering Pagination in Sharded Databases: Global Query and No‑Skip Strategies

With massive data growth, sharding databases introduces pagination challenges; this article explains the root cause of pagination issues in sharded environments, presents the global query method, its pros and cons, and introduces the no‑skip optimization to improve performance while maintaining data accuracy.

Paginationdistributed databasesglobal query
0 likes · 7 min read
Mastering Pagination in Sharded Databases: Global Query and No‑Skip Strategies
Lobster Programming
Lobster Programming
Sep 22, 2025 · Backend Development

Mastering Spring State Machine: Efficient Order Workflow Management

This article explains how to use Spring State Machine to model and control order lifecycle transitions in an e‑commerce system, covering core concepts, configuration, listeners, service integration, controller endpoints, and visual results for robust backend state management.

Java BackendOrder WorkflowSpring Boot
0 likes · 10 min read
Mastering Spring State Machine: Efficient Order Workflow Management
Lobster Programming
Lobster Programming
Sep 18, 2025 · Databases

Master MySQL Ranking: row_number, rank, and dense_rank Explained

Learn how MySQL window functions—row_number, rank, and dense_rank—can efficiently rank and rank‑tie data such as class scores or sales amounts, with clear syntax examples, differences in handling duplicate values, and practical SQL queries illustrated with real‑world scenarios.

MySQLROW_NUMBERRanking
0 likes · 6 min read
Master MySQL Ranking: row_number, rank, and dense_rank Explained
Lobster Programming
Lobster Programming
Sep 13, 2025 · Information Security

Mobile SMS Verification Login: How It Works and How to Secure It

This article explains the workflow of mobile SMS verification login, outlines its main security risks such as code leakage, SMS bombing, and replay attacks, and provides practical mitigation strategies for developers and platform operators to protect user accounts.

AuthenticationInformation SecuritySMS Verification
0 likes · 6 min read
Mobile SMS Verification Login: How It Works and How to Secure It