Stephen Li - TechInsights

Git

Git Clone 太慢？揭秘 git clone 的默认行为与 3 种提速技巧

你是否疑惑过 `git clone` 到底下载了什么？为什么大仓库克隆这么慢？本文将解释 Git 的分布式原理，并提供 3 种实用的命令参数，助你秒下大仓库。

GitLab

GitLab 诡异问题排查：“Fingerprint has already been taken” 与幽灵 SSH Key

当 GitLab 提示“Project not found”但你明明有权限，且添加 SSH Key 时报错“指纹已存在”，该如何通过 Rails Console 彻底定位并清除“幽灵”密钥？本文记录一次完整的排查过程。

MacOS

Mac 屏幕“常亮不睡”？一行代码揪出阻止休眠的后台应用

你的 Mac 是否明明设置了 1 分钟自动熄屏，但却一整天都亮着？本文教你如何通过系统终端的一行命令，快速定位并解决导致屏幕常亮的“幕后黑手”。

Solutions

Antigravity 配置MCP

在Antigravity中配置MCP

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.

Solutions

DbGate本地启动

从源代码运行DbGate脚本。