Author

Programmer1970

Formerly called 'Code to 35'. Add our main WeChat ID to access a wealth of shared resources (algorithms, interview prep, tech stacks: Java, Python, Go, big data). We mainly share serious development techniques, focusing on output-driven input. Occasionally we post life snippets and gossip. Our aim is to attract precise traffic and test advertising opportunities.

120

Articles

Likes

Views

Comments

Latest from Programmer1970

100 recent articles max

Programmer1970

Nov 25, 2025 · Databases

10 Essential MySQL Interview Queries (Part 3) – Solutions and Explanations

This article presents ten practical MySQL interview questions covering consecutive‑login detection, efficient pagination, top‑salary per department, customers without orders, cumulative sales, recursive cycle detection, pivoting rows to columns, duplicate removal, and user retention, each with complete SQL statements, underlying principles, and performance considerations.

CTEDatabaseInterview Questions

0 likes · 11 min read

10 Essential MySQL Interview Queries (Part 3) – Solutions and Explanations

Programmer1970

Nov 23, 2025 · Databases

MySQL Core Concepts Interview Q&A: 10 Essential Topics (Part 2)

This article provides detailed explanations of ten core MySQL topics—including InnoDB lock upgrades, redo log mechanics, MVCC version chains, tablespace types, page splitting, optimizer plan selection, crash recovery, binlog vs redo log, adaptive hash index, and memory management—along with practical tips for avoiding pitfalls and tuning performance.

Adaptive Hash IndexBinlogCrash Recovery

0 likes · 22 min read

MySQL Core Concepts Interview Q&A: 10 Essential Topics (Part 2)

Programmer1970

Nov 21, 2025 · Databases

10 Core MySQL InnoDB Interview Questions Explained

This article walks through ten essential MySQL InnoDB interview questions, covering why InnoDB uses B+ trees, MVCC isolation levels, two‑phase commit, gap locks, buffer‑pool LRU design, undo‑log mechanics, binlog formats, lock‑upgrade behavior, double‑write buffering, and the differences between clustered and non‑clustered indexes.

2PCB+TreeBinlog Formats

0 likes · 17 min read

10 Core MySQL InnoDB Interview Questions Explained

Programmer1970

Nov 20, 2025 · Backend Development

Essential Linux Commands Every Backend Engineer Needs: Network, Process, and Server Resource Management

This guide lists the most useful Linux command‑line tools for backend developers, covering network diagnostics (ping, netstat, curl, traceroute, ss), process handling (ps, top, kill, nohup, jps), and server resource monitoring (df, du, free, vmstat, iostat, lsof, systemctl) with concrete examples and typical use cases.

Command LineLinuxNetworking

0 likes · 9 min read

Essential Linux Commands Every Backend Engineer Needs: Network, Process, and Server Resource Management

Programmer1970

Nov 13, 2025 · Industry Insights

Inside Shenzhen IT Companies: Hiring Demands, Overtime, and Tech Stacks

A detailed overview of 40 Shenzhen IT firms shows massive R&D teams, intense hiring requirements such as AI model expertise, long monthly overtime, distinct work cultures, and diverse technology stacks ranging from Java and Go to AI and cloud‑native platforms.

IT hiringShenzhenindustry insight

0 likes · 12 min read

Inside Shenzhen IT Companies: Hiring Demands, Overtime, and Tech Stacks

Programmer1970

Nov 11, 2025 · Fundamentals

From Maven to Gradle: A Comprehensive Migration and Mastery Guide

This article explains why Gradle has become the de‑facto build tool for modern Java/Kotlin projects, showcases prominent projects that use it, compares core differences with Maven, outlines Gradle’s underlying principles, and provides a step‑by‑step learning roadmap for developers transitioning from Maven.

Build ToolsCI/CDGradle

0 likes · 6 min read

From Maven to Gradle: A Comprehensive Migration and Mastery Guide

Programmer1970

Nov 5, 2025 · Backend Development

How to Ensure MySQL‑Redis Cache Consistency: Problems, Scenarios, and Solutions

This article analyses why cache consistency between MySQL and Redis breaks under high concurrency, explains the CAP perspective, walks through five typical failure scenarios, and presents concrete solutions such as delayed double‑delete, retry with MQ, binlog listening, expiration fallback, and mutex locks, ending with a decision guide for selecting the most suitable strategy.

BackendCache ConsistencyMySQL

0 likes · 13 min read

How to Ensure MySQL‑Redis Cache Consistency: Problems, Scenarios, and Solutions

Programmer1970

Oct 31, 2025 · Interview Experience

Are Standard Interview Questions a Trap? From Memorizing to Real-World Bugs

The article argues that while memorizing standard interview questions can help you pass screenings, it often leaves you unprepared for real production issues, and suggests turning rote knowledge into practical problem‑solving skills through scenario‑based practice and deeper understanding.

AOPInterviewSpring

0 likes · 6 min read

Are Standard Interview Questions a Trap? From Memorizing to Real-World Bugs

Programmer1970

Oct 29, 2025 · Backend Development

Getting Started with Flowable Workflow Engine in Spring Boot – Part 4

This guide walks through setting up Flowable 6.8.0 with Spring Boot 2.7.x, configuring MySQL, defining and deploying BPMN processes, managing runtime tasks, handling dynamic assignments, querying history, adding extensions like multi‑instance approvals and email notifications, and finally containerizing the application with Docker.

BPMNDockerJava

0 likes · 8 min read

Getting Started with Flowable Workflow Engine in Spring Boot – Part 4

Programmer1970

Oct 27, 2025 · Databases

Flowable Workflow Engine: Deep Dive into Core Table Schemas (Part 3)

This article details the modular design of Flowable's core database tables, dividing them into five categories—Repository, Runtime, History, Identity, and General Data—and explains each table’s fields, types, and inter‑table relationships, including multi‑tenant support and optimistic‑locking mechanisms.

BPMNMulti‑TenantOptimistic Locking

0 likes · 17 min read

Flowable Workflow Engine: Deep Dive into Core Table Schemas (Part 3)