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.

128

Articles

Likes

606

Views

Comments

Latest from Programmer1970

100 recent articles max

Programmer1970

Dec 11, 2024 · Databases

How MySQL 8’s Transactional Data Dictionary Transforms Metadata Management

The article explains why MySQL 8 replaces fragmented, non‑transactional metadata files with a unified, InnoDB‑backed transactional data dictionary, details the information_schema views that expose it, and enumerates the resulting benefits such as atomicity, consistency, crash recovery, performance gains, simplified administration, reduced lock contention, smoother upgrades, improved DDL handling, and enhanced security.

InnoDBMetadata ManagementMySQL

0 likes · 13 min read

How MySQL 8’s Transactional Data Dictionary Transforms Metadata Management

Programmer1970

Dec 10, 2024 · Backend Development

Mastering Elasticsearch post_filter: Fine‑tune Results Without Sacrificing Performance

This article explains Elasticsearch's post_filter mechanism, outlines scenarios where post‑query filtering is beneficial, provides DSL examples for filtering search hits and aggregations, and offers optimization tips to balance precision and query performance.

Elasticsearchaggregationperformance optimization

0 likes · 9 min read

Mastering Elasticsearch post_filter: Fine‑tune Results Without Sacrificing Performance

Programmer1970

Dec 9, 2024 · Databases

Understanding Elasticsearch’s Inverted Index: Core Structure and Search Process

The article explains how Elasticsearch implements efficient search using an inverted index, detailing its components—posting list, term dictionary, and term index—illustrating the query flow with concrete examples, compression techniques, and the role of Lucene.

ElasticsearchLuceneTerm Index

0 likes · 11 min read

Understanding Elasticsearch’s Inverted Index: Core Structure and Search Process

Programmer1970

Dec 8, 2024 · Backend Development

Advanced Spring Interview Questions: Bean Lifecycle, AOP, Transactions, ApplicationContext vs BeanFactory, Type Conversion

This article compiles twelve advanced Spring interview questions covering bean initialization and lifecycle, AOP implementation, transaction management, the differences between ApplicationContext and BeanFactory, type conversion mechanisms, dependency injection, circular dependency resolution with three‑level caches, the event system, @Transactional and @Async annotations, and the inner workings of DispatcherServlet.

AOPBean LifecycleDependency Injection

0 likes · 21 min read

Advanced Spring Interview Questions: Bean Lifecycle, AOP, Transactions, ApplicationContext vs BeanFactory, Type Conversion

Programmer1970

Dec 6, 2024 · Backend Development

Comparing API Protocol Styles: SOAP, REST, GraphQL, and RPC

The article systematically compares four major API styles—SOAP, REST, GraphQL, and RPC—detailing each one's core characteristics, advantages, limitations, and suitable use‑cases, and concludes with guidance on selecting the most appropriate protocol based on security, performance, complexity, and team expertise.

APIGraphQLREST

0 likes · 13 min read

Comparing API Protocol Styles: SOAP, REST, GraphQL, and RPC

Programmer1970

Dec 5, 2024 · Information Security

Understanding MD5: How It Works, Where It’s Used, and Why It’s Insecure

This article explains MD5’s history, the four‑step algorithm that produces a 128‑bit hash, common uses such as data integrity and password storage, the critical security flaws like collisions, and why modern systems should switch to stronger hashes like SHA‑256 or SHA‑3.

MD5SHA-256SHA-3

0 likes · 11 min read

Understanding MD5: How It Works, Where It’s Used, and Why It’s Insecure

Programmer1970

Dec 4, 2024 · Backend Development

How Elasticsearch’s Doc Values Boost Sorting and Aggregation Performance

The article explains Elasticsearch’s internal Doc Values column‑store structure, why it outperforms the inverted index for sorting and aggregation, how it is generated, stored, compressed, and used in queries, and provides practical mapping examples.

Column StoreElasticsearchPerformance

0 likes · 14 min read

How Elasticsearch’s Doc Values Boost Sorting and Aggregation Performance

Programmer1970

Dec 3, 2024 · Databases

RocksDB: An Introductory Look at a High‑Performance Key‑Value Store

RocksDB, an open‑source key‑value storage engine created by Facebook in 2012, delivers high performance, durability, and tunable configurations for flash and SSDs; the article details its core features, internal components such as MemTable and Bloom filters, and real‑world uses in TiDB and Apache Flink.

Database EngineFlinkLSM Tree

0 likes · 10 min read

RocksDB: An Introductory Look at a High‑Performance Key‑Value Store

Programmer1970

Dec 2, 2024 · Backend Development

Unlock Efficient Search and Storage with Elasticsearch Index Mapping

This article explains Elasticsearch index mapping fundamentals, covering field types such as text, keyword, numeric and date, key index options like analyzer, doc_values, null_value, and multi‑field strategies, and provides concrete code examples and optimization tips for efficient search and storage.

AnalyzersElasticsearchField Types

0 likes · 19 min read

Unlock Efficient Search and Storage with Elasticsearch Index Mapping

Programmer1970

Nov 29, 2024 · Databases

40 Essential MySQL Interview Questions and Answers

This article compiles 40 core MySQL interview questions covering ACID properties, lock types, views, stored procedures, JOINs, storage engines, query optimization, buffer pools, write buffers, transaction mechanisms, MVCC, isolation levels, gap locks, metadata locks, thread model, row formats, and more, providing concise answers for each.

DatabaseMVCCMySQL

0 likes · 57 min read

40 Essential MySQL Interview Questions and Answers