Skip to content

Instantly share code, notes, and snippets.

View v5tech's full-sized avatar
🎯
Focusing

v5tech

🎯
Focusing
  • Xi'an China
  • 17:18 (UTC +08:00)
View GitHub Profile
npx skills add anthropics/skills -g -y -s docx -s pdf -s pptx -s xlsx -s frontend-design -s mcp-builder -s skill-creator -a antigravity -a claude-code -a gemini-cli -a opencode
npx skills add expo/skills -g -y -s building-native-ui -s expo-dev-client -s expo-tailwind-setup -s native-data-fetching -s expo-deployment -s upgrading-expo -a antigravity -a claude-code -a gemini-cli -a opencode
npx skills add jeffallan/claude-skills -g -y -s react-native-expert -a antigravity -a claude-code -a gemini-cli -a opencode
npx skills add binhmuc/autobot-review -g -y -s mobile-development -a antigravity -a claude-code -a gemini-cli -a opencode
npx skills add v5tech/skills -g -y -s skill-advisor -s skill-exporter -a antigravity -a claude-code -a gemini-cli -a opencode
npx skills add vercel-labs/skills -g -y -s find-skills -a antigravity -a claude-code -a gemini-cli -a opencode
CREATE OR REPLACE TABLE trains AS
FROM "http://blobs.duckdb.org/train_services.parquet";
FROM trains;
COPY (FROM trains) TO "./trains.csv";
FROM "./trains.csv";
SELECT * FROM read_csv_auto('user.csv', header=true);
@v5tech
v5tech / linux-http-tcp.md
Last active May 11, 2025 23:10
linux下查看http 并发和 tcp连接数

linux查看httpd进程数

ps -ef | grep httpd | wc -l

查看Apache的并发请求数及其TCP连接状态

netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
@v5tech
v5tech / 知乎日报API.md
Last active May 7, 2025 05:59
知乎日报API
@v5tech
v5tech / gist:88c6a58aacec07dd7fd162a0beee789f
Created November 25, 2024 04:46
SVG Visualization Generation Expert
# SVG Visualization Generation Expert
You are an expert SVG visualization generator, specialized in creating detailed, balanced, and informative visual representations. You excel at transforming complex data and concepts into clear, engaging SVG visualizations.
## Role & Capabilities
- Create precise and visually appealing SVG visualizations
- Transform complex data into clear visual representations
- Ensure accessibility and readability in all visualizations
- Maintain consistent visual hierarchy and design principles
- Optimize SVG code for performance and compatibility
@v5tech
v5tech / ffmpeg.md
Last active October 14, 2024 19:57
ffmpeg视频合并、格式转换、截图

使用ffmpeg合并MP4文件

ffmpeg -i "Apache Sqoop Tutorial Part 1.mp4" -c copy -bsf:v h264_mp4toannexb -f mpegts intermediate1.ts
ffmpeg -i "Apache Sqoop Tutorial Part 2.mp4" -c copy -bsf:v h264_mp4toannexb -f mpegts intermediate2.ts
ffmpeg -i "Apache Sqoop Tutorial Part 3.mp4" -c copy -bsf:v h264_mp4toannexb -f mpegts intermediate3.ts
ffmpeg -i "Apache Sqoop Tutorial Part 4.mp4" -c copy -bsf:v h264_mp4toannexb -f mpegts intermediate4.ts
ffmpeg -i "concat:intermediate1.ts|intermediate2.ts|intermediate3.ts|intermediate4.ts" -c copy -bsf:a aac_adtstoasc "Apache Sqoop Tutorial.mp4"
@v5tech
v5tech / GoogleAuthenticationTool.java
Created May 15, 2024 05:54
Google Authenticator 验证工具类
import com.google.zxing.BarcodeFormat;
import com.google.zxing.MultiFormatWriter;
import com.google.zxing.WriterException;
import com.google.zxing.client.j2se.MatrixToImageWriter;
import com.google.zxing.common.BitMatrix;
import de.taimos.totp.TOTP;
import org.apache.commons.codec.binary.Base32;
import org.apache.commons.codec.binary.Hex;
import sun.misc.BASE64Encoder;
@v5tech
v5tech / HttpGetRequestWithBodyAppliaction.java
Created April 19, 2024 03:23
http get request with body
package net.aimeizi;
import cn.hutool.json.JSONObject;
import org.apache.commons.io.IOUtils;
import org.apache.http.HttpEntity;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpEntityEnclosingRequestBase;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
@v5tech
v5tech / jd.js
Last active February 6, 2024 03:25
JD自动评价
/**
浏览器打开www.jd.com登录账号,按F12点击Console->复制下列代码->粘贴回车键坐等即可
*/
document.body.innerHTML = "";$("html").css("overflow","hidden");$("body").append('<div id="topTitle" style="padding:20px;display:block;font-size:48px;color:#FFFFFF;background-color:#e2231a;width:100%;text-align:center">京东自动评价JS脚本 </div><iframe src="https://club.jd.com/myJdcomments/myJdcomment.action?sort=0" style="width:99%;height:800px" id="JDifr"></iframe>');$("#J-global-toolbar").remove();let isFiveStar = true;$("#topTitle").click(function(){(isFiveStar = !isFiveStar) ? $("#topTitle").css("background-color","#e2231a"):$("#topTitle").css("background-color","#8B0000");});let pendingNum = 1;let waitSubmitIds;let curId = 0;let maxCurId = 0;$("#JDifr").load(function(){if($("#JDifr").attr("src").indexOf("sort") > 0){pendingNum = ($("#JDifr").contents().find("a.text:first").siblings().length>0 && $("#JDifr").contents().find("a.text:first").attr("href")=="?sort=0")?parseInt($("#JDifr").contents().find("a.text:first").next().text()):0;waitSubmitIds = $("#
@v5tech
v5tech / getip
Created March 12, 2023 15:08
获取外网IP
https://tbip.alicdn.com/api/queryip
https://ip.cn/api/index?type=0
https://r.inews.qq.com/api/ip2city?otype=jsonp
http://mam.netease.com/api/config/getClientIp
https://api.live.bilibili.com/xlive/web-room/v1/index/getIpInfo