Official ITPUB account sharing technical insights, community news, and exciting events.
Vivo database lead Wang Le shares a decade of experience spanning Oracle-to-MySQL migration, domestic database replacement, gh-ost bug fixes, and building automation platforms, revealing how DBAs can evolve into technical leaders through continuous learning and long-term thinking.
This article analyzes the root causes of programmer overtime, arguing it stems from management skipping software engineering practices — requirements analysis, technical design, process discipline, and realistic resource allocation — rather than actual workload, and shows how overtime fails to boost productivity due to efficiency decay.
Scott reflects on 17 years and six DTCC talks, tracing his evolution from database user to builder to data-centric innovator, sharing a career framework (I→T→π) and four self-assessment questions to align skills with market shifts like cloud, AI, and semantic storage.
This article explains InnoDB's checkpoint mechanism, contrasting synchronous and fuzzy checkpoints, detailing the pre-MySQL 8.0 fuzzy checkpoint implementation using flush lists and page cleaners, and describing two principles for detecting abnormal shutdowns plus four post-restart crash scenarios with their recovery requirements.
WeChat avoids server crashes during midnight step-count resets for 1 billion users by using logical time-based versioning instead of physical updates, a custom PaxosStore for atomic increments, delayed double-write buffers for clock skew, Redis ZSet sharding for rankings, and asynchronous cold-data archival during low-traffic hours.
An AI copyright enforcement firm hired by Microsoft filed a vague DMCA takedown against the open-source voxel engine Luanti, leading Google to remove it from the Play Store despite no evidence of copied code or assets, exposing systemic flaws in automated copyright enforcement.
This article presents a complete Python workflow for Sentinel-2 L2A imagery, covering automated download, preprocessing, 47 remote sensing indices calculation, index applications, and GB/T 21010-2017 compliant 8-class land cover classification with a PySide6 visualization interface.
This article explains Java callback mechanisms — synchronous and asynchronous — through interfaces, anonymous classes, lambdas, and CompletableFuture, demonstrates their use in Spring's BeanFactory and a payment integration, and shows how functional interfaces enable flexible data transformation for multi-bank integration.
A sweeping narrative chronicles four decades of China's database development, detailing how engineers fought foreign lock‑downs, built home‑grown systems, pioneered theoretical frameworks, and reshaped data sovereignty through real‑world events like TPC‑C records, 301 investigations, and the "去IOE" movement.
The article argues that, unlike many professions where seniority adds value, programmers often see their experience de‑valued because software development is largely B2B, technology rapidly commoditises, cloud services replace senior architecture skills, and market cycles flood the talent pool, turning programming into a low‑skill, high‑supply job.
