一个关于技术、代码和一切之间事情的个人博客。
文章
57
索引不是越多越好。本文从一次真实的慢查询出发，带你读懂 EXPLAIN 执行计划，掌握 B-tree、GIN、复合索引、覆盖索引的选型逻辑，以及索引失效的常见陷阱。
RSC, island architecture, edge computing, signals, unified meta-frameworks — a comprehensive look at where web frameworks are heading in 2026 and beyond.
From AI-assisted coding to AI-driven architecture decisions and autonomous agent workflows — how software development is being fundamentally reshaped by AI in 2026.
How to say no to stakeholders, customers, and your own team — a strategic framework for ruthless prioritization without burning bridges.
A deep dive into product discovery frameworks — JTBD, outcome-driven development, and continuous discovery — with real patterns from teams that ship products users genuinely love.
从写测试、写正则、写 SQL 到代码审查、重构、写文档，12 个让 AI 帮你干活的高效姿势。附送偷懒底线指南。
A deep dive into the world's major AI governance frameworks — NIST AI RMF, ISO/IEC 42001, the EU AI Act, OECD principles, and China's regulatory system — covering their structure, binding force, and how enterprises should combine them in practice.
以 NIST AI RMF 为核心，系统梳理全球主要 AI 治理框架（ISO/IEC 42001、欧盟 AI 法、OECD 原则、中国监管体系等）的结构、约束力与相互关系，并给出企业选型与落地实施建议。
结合真实的前端项目安全加固案例，探讨开源软件中容易被忽视的安全盲点，包括安全响应头配置、robots.txt信息泄露、环境变量管理、前端密钥暴露、服务端代理架构以及HTTP方法限制等六个维度，提供可落地的防护建议。
A practical tour of the four caching layers in a modern web stack — HTTP cache headers, CDN edge caching, application-level Redis caching, and database buffers — with invalidation strategies that keep data fresh.
从零开始掌握Supabase，深入了解PostgreSQL数据库、RLS安全策略、实时订阅和Edge Functions，构建安全可靠的现代全栈应用。