An essay about visiting elderly grandparents in their hometown — observations on daily life in a mining community, elderly dependence on medication, the technology gap, and reflections on intergenerational bonds
2023 Year-End Summary: A year of comprehensive PostgreSQL learning, including extracurricular reading rankings, reflections on writing and WeChat official account operations, and thoughts on active learning methodology
In-depth analysis of Oracle index split contention wait event enq: TX - index contention, its root causes, and six solutions including reverse indexes, hash-partitioned indexes, and partition table scattering.
A sharing at the PostgreSQL Technology Summit Chengdu stop, covering the history of transactions, flaws in the ANSI SQL-92 standard, and the implementation of SSI (Serializable Snapshot Isolation) in PostgreSQL
A primer on HikariCP connection pooling: decoding core parameters, connection pool sizing formulas, and analyzing the impact of database connection count on performance with best practices.
A mid-2023 rundown of American TV shows I've watched, centered around the Yellowstone series, 1923, 1883, and others — with impressions, personal ratings, and recommendations.