SQL CROSS JOIN LATERAL:把它理解成「左边每一行,都执行一次右边查询」
用程序员的 for-each 心智模型,逐步理解 PostgreSQL CROSS JOIN LATERAL、LEFT JOIN LATERAL、ON TRUE、Top 1 per parent,以及 ERP SQL 中最常见的使用场景与性能注意事项。
Continue readingNotes on AI, agents, and building things that work.
用程序员的 for-each 心智模型,逐步理解 PostgreSQL CROSS JOIN LATERAL、LEFT JOIN LATERAL、ON TRUE、Top 1 per parent,以及 ERP SQL 中最常见的使用场景与性能注意事项。
Continue readingA practical role-by-role guide to GPT-5.6 Sol, Terra, and Luna: current API pricing, where each model fits across business functions, and how to design a cost-efficient AI routing and permission architecture.
Continue reading深入比较 Qwen3.8-Max、Gemini 3.1 Pro、GPT-5.6 Sol 与 Claude Fable 5 的综合能力、编程表现、上下文窗口、API 成本、Agent 工具生态及企业数据隐私风险,并给出适合 ERP 与 AI Agent 系统的多模型路由建议。
Continue readingA practical August 2026 comparison of four frontier AI models, covering human-preference capability, coding and agent strengths, context windows, API pricing, multimodal support, and the best model-routing strategy for enterprise and ERP AI systems.
Continue readingOpenAI has confirmed Astra as its next major model, but it is not yet a public GPT-6 product. This deep dive separates confirmed facts from speculation, explains Astra’s ten mathematical advances, Lean verification, long-horizon reasoning, safety risks, and its implications for coding agents, MCP, RAG, IDP, and AI-native ERP.
Continue reading深入分析 Claude Fable 5、Opus 5、Sonnet 5 与 Haiku 4.5 的能力、价格、Claude Code、MCP、PDF/IDP、企业应用、隐私限制,以及开发者应该如何选择模型。
Continue readingGPT‑5.6 的真正升级,不只是更会写代码,而是更擅长理解大型代码库、操作终端与工具、持续调试、验证结果,并完成端到端工程任务。本文加入 Coding Agent Index、SWE-Bench Pro、DeepSWE 与 Terminal-Bench 分数图表,分析它在 JavaScript、SQL、ERP、MCP、RAG 和 Coding Agent 场景中的实际价值与限制。
Continue readingWhat Anthropic's “Map vs Territory” mindset teaches us about building better AI systems, stronger engineering workflows, and safer enterprise implementation.
Continue readingAn in-depth technical analysis of Google’s Gemma 3 27B IT, exploring its multimodal capabilities, 128K context window, and strategic value for enterprise deployment and local AI infrastructure.
Continue reading