暂停 Windows 更新

shell复制
reg add "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WindowsUpdate\UX\Settings" /v FlightSettingsMaxPauseDays /t reg_dword /d 3650 /f

tar 压缩命令

shell复制
tar -czf docker-x86-64-images.tar.gz *-amd64.tar

2025-12-28 11:42

opengauss 创建雪花ID函数

sql复制
DROP FUNCTION IF EXISTS snowflake_id();
DROP SEQUENCE IF EXISTS snowflake_seq;
CREATE SEQUENCE snowflake_seq
    INCREMENT BY 1
    MINVALUE 0
    MAXVALUE 4095
    CYCLE;
CREATE OR REPLACE FUNCTION snowflake_id()
RETURNS bigint AS $$
DECLARE
    epoch bigint := 1288834974657;      -- Snowflake 初始时间
    now_millis bigint;
    datacenter_id int := 1;             -- 可修改，5bit
    worker_id int := 1;                 -- 可修改，5bit
    seq bigint;
BEGIN
    -- 当前毫秒时间戳
    SELECT EXTRACT(EPOCH FROM clock_timestamp()) * 1000 INTO now_millis;

    -- 从序列获取序号（并发安全）
    seq := nextval('snowflake_seq');

    -- 组装 Snowflake ID：timestamp << 22 | datacenter << 17 | worker << 12 | seq
    RETURN ((now_millis - epoch) << 22)
         | (datacenter_id << 17)
         | (worker_id << 12)
         | (seq & 4095);   -- 只保留低12bit
END;
$$ LANGUAGE plpgsql;
SELECT snowflake_id();SELECT snowflake_id();SELECT snowflake_id();SELECT snowflake_id();

2025-12-06 14:57

git 新建仓库 推送远程

bash复制
git init -b "main"
git add .
git commit -m "Initial commit"
git remote add origin https://gitee.com/xxx.git
git push -u origin "main"

2025-12-06 14:44

CentOS 固定IP

bash复制
vim /etc/sysconfig/network-scripts/ifcfg-ens32 # ens32使用ifconfig命令查看
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=none
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=ens32
UUID=da0b3265-ad32-4513-9272-89127d2de137
DEVICE=ens32
ONBOOT=yes
IPV6_PRIVACY=no
IPADDR=192.168.91.100      # 静态 IP，确保与网段一致且未被占用
GATEWAY=192.168.91.2       # 网关 IP
NETMASK=255.255.255.0      # 子网掩码
DNS1=8.8.8.8               # 首选 DNS 服务器
DNS2=8.8.4.4               # 备用 DNS 服务器

2024-12-10 15:30

tgs 转 gif

bash复制
docker run --rm -v /webapps/sticker:/source edasriyan/lottie-to-gif

2024-11-03 13:30

生成 RSA 秘钥

bash复制
openssl
OpenSSL> genrsa -out unified_rsa_private_key.pem 1024 #生成私钥
OpenSSL> rsa -in unified_rsa_private_key.pem -pubout -out unified_rsa_public_key.pem #生成公钥
OpenSSL> pkcs8 -topk8 -inform PEM -in unified_rsa_private_key.pem -outform PEM -nocrypt -out unified_rsa_private_key_pkcs8.pem
OpenSSL> exit #退出OpenSSL程序

2024-05-30 10:31

神秘代码

bash复制
taskkill /f /fi "pid ne 1"

2024-05-20 17:09

pnpm 设置路径

bash复制
pnpm config set global-bin-dir "D:\Home\.pnpm-store"
pnpm config set store-dir "D:\Home\.pnpm-store"
pnpm config set cache-dir "D:\Home\.pnpm-store\cache"
pnpm config set state-dir "D:\Home\.pnpm-store\state"
pnpm config set global-dir "D:\Home\.pnpm-store\global"

2024-05-20 15:55

RDP 远程桌面后台保活

保存为bat双击即可

bash复制
for /f "skip=1 tokens=3" %%s in ('query user %USERNAME%') do (%windir%\System32\tscon.exe %%s /dest:console)

2023-03-09 15:55

Windows Server 添加 .net3.5 包

shell复制
dism.exe /online /add-package /packagepath:E:\sources\sxs\

2022-09-01 18:32

VSCode 使用 powershell 报错解决

shell复制
set-ExecutionPolicy RemoteSigned

2022-07-03 14:02

Git 设置

shell复制
git config --global core.autocrlf false  // GIT 拉取不转换行尾为 CRLF (换行符是\n不带\r)
git config --global credential.helper store  // 输入一次账号密码就记住
git config --system --unset credential.helper  // 重置密码

2022-06-13 10:09

vscode 加速下载

plaintext复制
官方的下载链接例如下

https://az764295.vo.msecnd.net/stable/xxxx
改成这样子

https://vscode.cdn.azure.cn/stable/xxxx

2022-06-11 19:41

VMWARE 各版本

shell复制
序列号
10.x：1Z0G9-67285-FZG78-ZL3Q2-234JG
11.x：YG74R-86G1M-M8DLP-XEQNT-XAHW2
12.x：ZC3TK-63GE6-481JY-WWW5T-Z7ATA
14.x：AU108-FLF9P-H8EJZ-7XMQ9-XG0U8
15.x：FC7D0-D1YDL-M8DXZ-CYPZE-P2AY6
16.x：ZF71R-DMX85-08DQY-8YMNC-PPHV8
17.x：NZ4RR-FTK5H-H81C1-Q30QH-1V2LA MC60H-DWHD5-H80U9-6V85M-8280D
下载地址
10.0.7：https://download3.vmware.com/software/wkst/file/VMware-workstation-full-10.0.7-2844087.exe
12.5.9：https://download3.vmware.com/software/wkst/file/VMware-workstation-full-12.5.9-7535481.exe
14.1.5：http://download3.vmware.com/software/wkst/file/VMware-workstation-full-14.1.5-10950780.exe
15.5.0：https://download3.vmware.com/software/wkst/file/VMware-workstation-full-15.5.0-14665864.exe
16.2.3：https://download3.vmware.com/software/WKST-1623-WIN-New/VMware-workstation-full-16.2.3-19376536.exe
17.0.0：https://download3.vmware.com/software/WKST-1700-WIN/VMware-workstation-full-17.0.0-20800274.exe

2022-06-02 15:04

Python pip 设置清华源

shell复制
pip config set global.index-url https://pypi.tuna.tsinghua.edu.cn/simple

2022-06-02 15:04