Stephen Li - TechInsights

Git

别让本地配置弄乱你的代码库：Git 忽略已追踪文件的终极指南

本文针对“如何在 Git 中忽略已被追踪的配置文件”这一痛点，详细对比了 skip-worktree、assume-unchanged 以及“配置模板法”三种解决方案，助你彻底解决本地数据库配置误提交的烦恼。

Using Cursor + GitHub MCP to Fix Issues with Just a Number

Cursor + GitHub MCP: add the GitHub server in Cursor settings, drop in a PAT with repo scope, then just reference an issue number with org/repo. Cursor fetches the details, so I can summarize and fix without pasting issue text.

AI

LLM高质量输出激活词汇表

Solutions

Restoring Your MySQL/Percona Server with a Full XtraBackup

Restoring a full database backup can seem daunting, but with Percona XtraBackup, it's a straightforward process. This guide walks you through the essential steps to get your MySQL/Percona Server data back up and running from a full backup, ensuring data integrity and a smooth recovery.

使用FFmpeg 修改视频的默认音轨

还在为视频默认播放的不是你想要的音轨而烦恼吗？每次都手动切换太麻烦了。本文是你的终极解决方案。我们将带你深入了解如何使用强大的多-媒体工具 FFmpeg，仅需一行命令，就能无损、快速地永久修改视频文件（如 MKV、MP4）的默认音轨。无需复杂软件，告别繁琐操作，让你彻底掌控自己的影音体验。

Solutions

Fixing Go Module Authentication Errors with Private GitHub Repositories

Struggling with "Authentication failed" errors when running `go mod tidy` on private GitHub repositories, even though your SSH keys are perfectly configured? You're not alone. The issue stems from Go modules defaulting to HTTPS while your SSH configuration only applies to SSH connections.

Solutions

How to Simplify Pushing New Branches in Git

Tired of the lengthy git push --set-upstream command for new branches? Learn how a simple configuration tweak or a custom alias can let you use git push for everything, saving you time on every feature you build.